pg_stat_progress_data_checksums

When data checksums are being enabled or disabled on a running cluster, the pg_stat_progress_data_checksums view will contain a row for the launcher process.

Reading PG 20devel·documented in 1 of 24 versions, 20 to 20

7.4 8.0 8.1 8.2 8.3 8.4 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

Development snapshot. These definitions may change before release.

Kind: Progress reporting
Columns in this snapshot: 10
Definition source: English manual

Columns 10

As listed in the PostgreSQL 20 devel manual.

Column	Type	Description / reference
`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 Table 27.56 for description of the phases.
`databases_total`	`bigint`	The total number of databases which will be processed. Only the launcher process has this value set when enabling data checksums; otherwise this is set to NULL.
`databases_done`	`bigint`	The number of databases which have been processed. Only the launcher process has this value set when enabling data checksums; otherwise this is set to NULL.
`relations_total`	`bigint`	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`	`bigint`	The number of relations which have been processed. The launcher process has this set to NULL.
`blocks_total`	`bigint`	The number of blocks in the current relation fork 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`	`bigint`	The number of blocks in the current relation fork which have been processed. The launcher process has this set to NULL.