pg_stat_progress_data_checksums — PostgreSQL statistics view

The PostgreSQL pg_stat_progress_data_checksums statistics view: full column reference (names, types, descriptions), catalog relationships and version support.

The Sev-1 Admin
The Sev-1 Admin  ·  2 min read

Summary

When data checksums are being enabled on a running cluster, the pg_stat_progress_data_checksums view will contain a row for the launcher process, and one row for each worker process which is currently calculating and writing checksums for the data pages in a database. The launcher provides overview of the overall progress (how many databases have been processed, how many remain), while the workers track progress for currently processed databases.

(Description quoted from the official PostgreSQL documentation.)

Columns

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

  • pid integer
    Process ID of the data checksum process, launcher or worker.
  • datid oid
    OID of this database, or 0 for the launcher process.
  • datname name
    Name of this database, or NULL for the launcher process.
  • phase text
    Current processing phase, see datachecksum_phases for description of the phases.
  • databases_total integer
    The total number of databases which will be processed. Only the launcher process has this value set, the worker processes have this set to NULL.
  • databases_done integer
    The number of databases which have been processed. Only the launcher process has this value set, the worker processes have this set to NULL.
  • relations_total integer
    The total number of relations which will be processed, or NULL if the worker process hasn’t calculated the number of relations yet. The launcher process has this set to NULL since it isn’t responsible for processing relations, only launching worker processes.
  • relations_done integer
    The number of relations which have been processed. The launcher process has this set to NULL.
  • blocks_total integer
    The number of blocks in the current relation which will be processed, or NULL if the worker process hasn’t calculated the number of blocks yet. The launcher process has this set to NULL.
  • blocks_done integer
    The number of blocks in the current relation which have been processed. The launcher process has this set to NULL.

Version applicability

Present in PostgreSQL 19 (verified against each release’s documentation). This object was introduced in PostgreSQL 19.

Related & references

Reference: PostgreSQL documentation — pg_stat_progress_data_checksums.