SYSTEM CATALOGS / STATISTICS VIEWS
pg_stat_checkpointer
Read PG 18 manual ↗The pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster.
- Kind
- Statistics views
- Columns in this snapshot
- 11
- Definition source
- English manual
Columns 11
| 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
| Column | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
num_timed | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● |
num_requested | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● |
restartpoints_timed | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● |
restartpoints_req | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● |
restartpoints_done | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● |
write_time | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● |
sync_time | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● |
buffers_written | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● |
stats_reset | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● |
num_done | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
slru_written | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● | ● |
Version history 2
- PG 17 → 18changed
- PG 16 → 17added
Definition snapshot: english-manuals:c4284b26b0c25377de64d3de2e8… · English manual source