log_checkpoints
A configuration parameter determining whether to log checkpoint activity
log_checkpoints is a configuration parameter| determining whether to log checkpoint activity in the PostgreSQL log.
log_checkpoints was added in PostgreSQL 8.3.
Default
The default value for log_checkpoints is:
on(PostgreSQL 15 ~)off(PostgreSQL 8.3 ~ PostgreSQL 14
Change history
- PostgreSQL 15
- default value changed to
on(commit 64da07c4)
- default value changed to
- PostgreSQL 8.3
- added (commit 9fc25c05)
Examples
Executing CHECKPOINT with log_checkpoints set to off (the default in PostgreSQL 14 and earlier):
[2020-11-16 13:59:53 CET] psql postgres postgres LOG: 00000: statement: CHECKPOINT;
Executing CHECKPOINT with log_checkpoints set to on:
[2020-11-16 14:00:21 CET] psql postgres postgres LOG: 00000: statement: CHECKPOINT ; [2020-11-16 14:00:21 CET] LOG: 00000: checkpoint starting: immediate force wait [2020-11-16 14:00:21 CET] LOG: 00000: checkpoint complete: wrote 5 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.017 s; sync files=0, longest=0.000 s, average=0.000 s; distance=16385 kB, estimate=16385 kB
References
- PostgreSQL documentation: log_checkpoints