View source | Discuss this page | Page history | Printable version   

PostgreSQL Logs Monitoring

Overview

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

pgBadger is a log analyzer which facilitates reading PostgreSQL logs.

Logs configuration

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.

Bulbgraph.png   pgBadger documentation recommends to set log_min_duration_statement to 0, this generates too much log, it is prefeareably to increase this setting to, at least, 1000.

Note these settings can be useful even when not using pgBadger, just to add extra information to PostgreSQL logs.

Retrieved from "http://wiki.openbravo.com/wiki/PostgreSQL_Logs_Monitoring"

This page has been accessed 3,547 times. This page was last modified on 20 September 2016, at 08:44. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.