pgconfigurator
pgconfigurator

log_checkpoints

No restart — takes effect on reloadtuned by pgconfiguratorboolean (on/off)

Logs each checkpoint with its timing and how many buffers it wrote.

What pgconfigurator would set
32 GB · 8 vCPU · NVMe · OLTP
Computing…
Tune for your exact server → /tunecomputed in your browser · nothing uploaded

What it does

With log_checkpoints on, every checkpoint records when it ran, how long it took, and how much it wrote. That's how you diagnose checkpoint pressure and confirm whether checkpoints are paced by time or by WAL volume.

How to tune it

Leave it on — it's low-volume and high-value (and is the default in PostgreSQL 15+). The output is what tells you to raise max_wal_size when you see 'checkpoints occurring too frequently'.

Related parameters