使用pg獾生成数据库的每日报表,但报告是空的?ANy的想法为什么?
谢谢
log_min_duration_statement = -1
log_duration = on
log_line_prefix = '%t [%p]: user=%u,db=%d,app=%a,client=%h'
log_checkpoints = 'on'
log_lock_waits = 'on'
log_temp_files = 0
log_autovacuum_min_duration = 0
log_error_verbosity = 'default'
lc_messages='en_US.UTF-8'-bash-4.2$ pgbadger -f stderr -d dbdev /var/lib/pgsql/13/data/log/postgresql-*.log -x html -o ========================>解析23526878字节23526878 (100.00%),查询: 0,events: 0 LOG: Ok,生成html报告.
发布于 2022-06-18 00:29:46
pgBadger文档指出:
您必须首先启用SQL查询日志来解析以下内容:
log_min_duration_statement = 0
https://stackoverflow.com/questions/72662333
复制相似问题