pg_stat_checkpointer
The pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- statistics
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- num_timed, num_requested, num_done, restartpoints_timed, restartpoints_req, restartpoints_done, write_time, sync_time, buffers_written, slru_written, stats_reset
- runtime verified
- false
- source
- english-manual
Definition PG 18
The pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| num_timed | bigint | Nullable | Number of scheduled checkpoints due to timeout |
| num_requested | bigint | Nullable | Number of requested checkpoints |
| num_done | bigint | Nullable | Number of checkpoints that have been performed |
| restartpoints_timed | bigint | Nullable | Number of scheduled restartpoints due to timeout or after a failed attempt to perform it |
| restartpoints_req | bigint | Nullable | Number of requested restartpoints |
| restartpoints_done | bigint | Nullable | Number of restartpoints that have been performed |
| write_time | double precision | Nullable | 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 | Nullable | 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 | Nullable | Number of shared buffers written during checkpoints and restartpoints |
| slru_written | bigint | Nullable | Number of SLRU buffers written during checkpoints and restartpoints |
| stats_reset | timestamp with time zone | Nullable | Time at which these statistics were last reset |
Compare versions
Complete source facts
documentation revision
{"inputs":[{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"a97e4aa05484b41cec1f4c9b0b9c5a083596a056982e5d5ba0db1dd8d49961fb","version":"18.7"},{"file":"monitoring-stats.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"1ddb6576fe569e029a1c776c82e7add6be8e4f41705bcd8f66f4347fe23372b6","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:035aa0d98ac27fa738c63871a1dbc4f45c08ec87d531be74a5145d107d8346ff
Text language: en · catalog-bilingual-repair:035aa0d98ac27fa738c63871a1dbc4f45c08ec87d531be74a5145d107d8346ff