Logging and monitoring

PostgreSQL instance with ‘log_checkpoints’ flag disabled

Description

Enabling log_checkpoints causes checkpoints and restart points to be logged in the server log. Some statistics are included in the log messages, including the number of buffers written and the time spent writing them. This parameter can only be set in the postgresql.conf file or on the server command line.
  • Recommended Mitigation

    Add the following database flag: 'log_checkpoints=on'.