STATISTICS VIEW · Statistics view

pg_stat_checkpointer

PostgreSQL documentation ↗Source definition ↗

The pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster. Checkpoints may be skipped if the server has been idle since the last one. num_timed and num_requested count both completed and skipped checkpoints, while num_done tracks only the completed ones. Similarly, restartpoints may be skipped if the last replayed checkpoint record is already the last restartpoint. restartpoints_timed and restartpoints_req count both completed and skipped restartpoints, while restartpoints_done tracks only the completed ones.

First seen PG 17Last seen PG 19Columns 11

9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19^β3

Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗

Columns PostgreSQL 18

pg_stat_checkpointer

COLUMN	TYPE	DESCRIPTION
`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

Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.

Column evolution matrix

Hover a cell for the column type

PresentAdded / type or attribute changeRemoved

COLUMN	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17
`num_timed`	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`num_requested`	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`restartpoints_timed`	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`restartpoints_req`	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`restartpoints_done`	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`write_time`	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`sync_time`	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`buffers_written`	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`stats_reset`	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`num_done`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`slru_written`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–

9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.

Evolution timeline

Changes between adjacent majors

PostgreSQL 18 ← 17

+ num_done+ slru_written3 column description updatesCatalog description updated

PostgreSQL 17 ← 16Catalog added

+ num_timed+ num_requested+ restartpoints_timed+ restartpoints_req+ restartpoints_done+ write_time+ sync_time+ buffers_written+ stats_reset

Compare any two versions

FROMTOInclude description updates

Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.