log_checkpoints

A GUC parameter determining whether to log checkpoint activity

log_checkpoints is a GUC 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: off.

Change history

Examples

Executing CHECKPOINT with log_checkpoints set to off (the default):

[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

Categories

Logging, WAL

See also

checkpoint, CHECKPOINT