Log each checkpoint with timing and buffer stats.
At a glance
| Property | Value |
|---|---|
| Parameter | log_checkpoints |
| Category | Logging |
| Default | on |
| Value type | boolean / enum / numeric |
| Change scope | Reload (no restart) |
What it does
Logs checkpoint activity, including buffers written and sync time. Default changed to on in PG15.
How to apply a change
Takes effect on configuration reload (sighup context). Run SELECT pg_reload_conf(); or send SIGHUP — no restart needed.
Inspect the current value and source with SHOW log_checkpoints; or SELECT name, setting, unit, context, source FROM pg_settings WHERE name = 'log_checkpoints';.
Tuning guidance
Keep on — checkpoint logs are essential for diagnosing I/O spikes and tuning max_wal_size/checkpoint_timeout.