SYSTEM CATALOGS / PROGRESS REPORTING
pg_stat_progress_data_checksums
Read PG 20 devel manual ↗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.
Development snapshot. These definitions may change before release.
- Kind
- Progress reporting
- Columns in this snapshot
- 10
- Definition source
- English manual
Columns 10
| 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 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. |
Column history across versions
| Column | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
pid | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
datid | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
datname | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
phase | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
databases_total | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
databases_done | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
relations_total | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
relations_done | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
blocks_total | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
blocks_done | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
Version history 2
- PG 19 → 20changed
- PG 18 → 19added
Definition snapshot: english-manuals:c1bdff7320a7792cfcc4d31ee88… · English manual source