Technologies/PostgreSQL/checkpointer_write_time
PostgreSQLPostgreSQLMetric

checkpointer_write_time

Checkpointer write time
Dimensions:None
Available on:PrometheusPrometheus (1)
Interface Metrics (1)
PrometheusPrometheus
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

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
Related Insights (1)
Checkpoint spikes cause I/O contention and query latencywarning