SELECT name,setting,vartype,boot_val,reset_val FROM pg_settings

where name in('logging_collector','log_destination','log_directory','log_filename');

SELECT name,setting,vartype,boot_val,reset_val FROM pg_settings

where name like 'log_%';

SELECT name,setting,vartype,boot_val,reset_val FROM pg_settings

where name in ('log_statement','log_min_duration_statement');

conf文件添加。

log_statement = all #需设置跟踪所有语句，否则只能跟踪出错信息 最好别开all开了都记录了 log_min_duration_statement = 1000 #milliseconds,记录执行5秒及以上的语句

select pg_reload_conf()