Using a Postgres log analyzer (pgBadger)

Mark Wong
Mark Wong
  • Updated

To get the most out of a log analyzer, such as pgBadger, the log_line_prefix should be extended to capture additional information than typical default settings.

One suggestion is to use the following:

log_line_prefix = '%t [%p]: [%l] db=%d,user=%u,app=%a,client=%h '

Complete statement data will only be available if log_min_duration_statement=0 is set. This may be prohibitive on busy systems due to the log volumes produced.

Users should also consider enabling pg_stat_statements and the auto_explain module for better visibility into database system activity.

Related to

Was this article helpful?

0 out of 0 found this helpful