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