Minimim PostgreSQL logging features

Description

This check provides feedback on enabled logging features and is strictly recommended to help identify potential issues when reviewing the database cluster and log files. 

Resolution

Enabling the following logging parameters helps troubleshoot database performance issues.

Logging_collector

Enables the logging collector which captures log messages sent to the stderr and redirects them into log files.

log_temp_files

Enables logging of temporary file creation and the queries generating them. This is useful when trying to size work_mem or other related parameters.  It is extremely useful when parsing log files with a tool such as pg_badger.

Note: If your running cluster is generating large amounts of temporary files, this could consume disk space rapidly. Consider setting a value which will log temporary files of x size.

log_check_points

Logs statistics about checkpoints and information about when they occur. 

log_min_duration_statement

This is useful for determining slow-running queries. Set a value in milliseconds to log queries that take either the set value or a longer time to complete.

Need more support from Percona?

Percona experts bring years of experience in tackling tough database performance issues and design challenges.