Technologies/PostgreSQL/checkpoint_write_time
PostgreSQLPostgreSQLMetric

checkpoint_write_time

Checkpoint write time
Dimensions:None
Available on:Native (1)
Interface Metrics (1)
Native
Time spent writing checkpoint files (ms)
Dimensions:None
Sources
checkpoint_write_timegithub.com

Technical Annotations (5)

Configuration Parameters (3)
checkpoint_timeout
controls time-based checkpoint frequency
max_wal_size
controls size-based checkpoint triggering
checkpoint_completion_target
spreads checkpoint I/O over time
Technical References (2)
checkpointconceptWALcomponent
Related Insights (3)
Checkpoint frequency and duration impact write performancewarning
▸
Checkpoint and WAL configuration mismatches cause I/O spikeswarning
▸
Checkpoint frequency exceeds sustainable ratewarning

Frequent checkpoints cause I/O spikes and performance hiccups. When requested checkpoints (checkpoint_req) significantly exceed timed checkpoints (checkpoint_timed), it indicates max_wal_size is too low or write workload is too high.

▸