PostgreSQL Logs Monitoring
PostgreSQL generates log files which, depending on how logging is configured, can be very useful to understand performance issues at database level (such as slow queries, contention, locks, etc...).
pgBadger is a log analyzer which facilitates reading PostgreSQL logs.
In order to have data to parse, it requires to configure logs in a determined manner. Information about required settings can be found in pgBadger documentation.
|pgBadger documentation recommends to set |
Note these settings can be useful even when not using pgBadger, just to add extra information to PostgreSQL logs.