pgbadger
lc_messages='C'
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_line_prefix = '%t [%p]: [%l-1] db=%d,user=%u,app=%a,client=%h '
log_statement = none
log_min_duration_statement = 0
log_duration = on
log_checkpoints = on
log_connections = on
log_disconnections = on
log_lock_waits = on
log_temp_files = 0
log_autovacuum_min_duration = 0
session_preload_libraries = 'auto_explain'
auto_explain.log_min_duration = 3s
auto_explain.log_verbose = on
auto_explain.log_nested_statements = on
auto_explain.log_analyze = off # Use EXPLAIN ANALYZE insted of EXPLAIN
auto_explain.log_buffers = off
auto_explain.log_triggers = off
auto_explain.log_timing = off
auto_explain.log_triggers = off