PostgreSQL version:

log_checkpoints

Causes checkpoints and restartpoints 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. The default is off.

Recommendations

When doing performance analysis, it's often a good idea to turn on most of the logging options and log them to a CSVlog.

Comments