pg_stat_checkpointer — PostgreSQL statistics view

Summary

The pg_stat_checkpointer view will always have a single row, containing data about the checkpointer process of the cluster.

(Description quoted from the official PostgreSQL documentation.)

Columns

The pg_stat_checkpointer statistics view exposes the following columns (names, types and descriptions are taken verbatim from the PostgreSQL documentation):

• 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

Version applicability

Present in PostgreSQL 17, 18, 19 (verified against each release’s documentation). This is a long-standing system object that also exists in earlier PostgreSQL releases.

Related & references

• PostgreSQL system catalog & view index
• Built-in function reference

Reference: PostgreSQL documentation — pg_stat_checkpointer.