System Catalogs / Statistics views
pg_stat_checkpointer
Read the PG 18 manualThe pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster.
Reading PG 18current·documented in 4 of 24 versions, 17 to 20
- Kind
- Statistics views
- Columns in this snapshot
- 11
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 11
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
num_timed | bigint | Number of scheduled checkpoints due to timeout |
num_requested | bigint | Number of requested checkpoints |
num_done | bigint | Number of checkpoints that have been performed |
restartpoints_timed | bigint | Number of scheduled restartpoints due to timeout or after a failed attempt to perform it |
restartpoints_req | bigint | Number of requested restartpoints |
restartpoints_done | bigint | Number of restartpoints that have been performed |
write_time | double precision | Total amount of time that has been spent in the portion of processing checkpoints and restartpoints where files are written to disk, in milliseconds |
sync_time | double precision | Total amount of time that has been spent in the portion of processing checkpoints and restartpoints where files are synchronized to disk, in milliseconds |
buffers_written | bigint | Number of shared buffers written during checkpoints and restartpoints |
slru_written | bigint | Number of SLRU buffers written during checkpoints and restartpoints |
stats_reset | timestamp with time zone | Time at which these statistics were last reset |
Column history across versions
Definition snapshot: english-manuals:ffaed59895c47852c39b0b818ec… · English manual source