Technologies/PostgreSQL/postgresql.bgwriter.checkpoint.count
PostgreSQLPostgreSQLMetric

postgresql.bgwriter.checkpoint.count

Checkpoints performed
Dimensions:None
Available on:Native (2)DatadogDatadog (2)PrometheusPrometheus (2)OpenTelemetryOpenTelemetry (1)
Interface Metrics (7)
Native
Number of requested checkpoints
Dimensions:None
DatadogDatadog
The number of requested checkpoints that were performed.
Dimensions:None
PrometheusPrometheus
Number of requested checkpoints that have been performed
Dimensions:None
OpenTelemetryOpenTelemetry
The number of checkpoints performed.
Dimensions:None
Native
Number of scheduled checkpoints
Dimensions:None
PrometheusPrometheus
Number of scheduled checkpoints that have been performed
Dimensions:None
DatadogDatadog
The number of scheduled checkpoints that were performed.
Dimensions:None
Sources
checkpoints_reqgithub.com
postgresql.bgwriter.checkpoints_requestedgithub.com
stat_bgwriter_checkpoints_req_totalgithub.com
postgresql.bgwriter.checkpoint.countgithub.com
postgresql.bgwriter.checkpoints_timedgithub.com

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
▸