checkpointer_write_time

Checkpointer write time

Dimensions:None

Available on:

Prometheus

stat_checkpointer_write_time_total

Total amount of time that has been spent in the portion of processing checkpoints and restartpoints where files are written to disk, in milliseconds

Dimensions:None

Sources

Technical Annotations (10)

Configuration Parameters (5)

checkpoint_completion_targetrecommended: 0.9

spreads checkpoint I/O over 90% of interval

checkpoint_timeoutrecommended: 15min

maximum time between checkpoints

checkpoint_warningrecommended: 30s

log warning if checkpoints occur more frequently

bgwriter_delayrecommended: 200ms

background writer wake interval to spread writes

max_wal_sizerecommended: 2-4GB for high-write workloads

WAL size threshold for checkpoint trigger

CLI Commands (1)

SELECT * FROM pg_stat_bgwriter;diagnostic

Technical References (4)

checkpointconceptbgwritercomponentpg_stat_bgwritercomponentWALcomponent

Checkpoint spikes cause I/O contention and query latencywarning

▸