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. When enabling data checksums, the view will also contain one row for each worker process which is currently calculating and writing checksums for the data pages in a database. The launcher provides an overview of the overall progress, such as how many databases have been processed and how many remain, while the workers track progress for currently processed databases.

首次收录 PG 19最近收录 PG 19当前字段 10

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

已与 PostgreSQL 19beta3 实例逐字段核对 · 原始实测记录 ↗

字段结构 PostgreSQL 19

pg_stat_progress_data_checksums

字段 / COLUMN	类型 / TYPE	说明 / DESCRIPTION
`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.55 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 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 which have been processed. The launcher process has this set to NULL.

标记“隐式列”的字段不包含在 SELECT * 中；部分早期统计视图由同版本源码补全，额外来源会显示在字段说明中。

字段演化矩阵

悬停查看字段类型

存在新增 / 类型或属性变化移除

字段 / COLUMN	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18
`pid`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`datid`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`datname`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`phase`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`databases_total`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`databases_done`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`relations_total`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`relations_done`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`blocks_total`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–
`blocks_done`	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–	–

9.0 是收录基线；基线中已存在的字段不标记为新增。矩阵按字段名称对齐，重命名显示为旧字段移除与新字段新增。

演化时间线

相邻大版本的变化

PostgreSQL 19 ← 18新增目录

+ pid+ datid+ datname+ phase+ databases_total+ databases_done+ relations_total+ relations_done+ blocks_total+ blocks_done

比较任意两个版本

起始版本 / FROM目标版本 / TO包含描述更新

选择两个版本，查看字段的新增、移除与类型变化。交互比较需要 JavaScript；演化时间线可直接阅读。