SYSTEM CATALOGS / PROGRESS REPORTING
pg_stat_progress_cluster
Read PG 18 manual ↗Whenever CLUSTER or VACUUM FULL is running, the pg_stat_progress_cluster view will contain a row for each backend that is currently running either command.
- Kind
- Progress reporting
- Columns in this snapshot
- 12
- Definition source
- English manual
Columns 12
| Column | Type | Description / reference |
|---|---|---|
pid | integer | Process ID of backend. |
datid | oid | OID of the database to which this backend is connected. |
datname | name | Name of the database to which this backend is connected. |
relid | oid | OID of the table being clustered. |
command | text | The command that is running. Either CLUSTER or VACUUM FULL. |
phase | text | Current processing phase. See Table 27.41. |
cluster_index_relid | oid | If the table is being scanned using an index, this is the OID of the index being used; otherwise, it is zero. |
heap_tuples_scanned | bigint | Number of heap tuples scanned. This counter only advances when the phase is seq scanning heap, index scanning heap or writing new heap. |
heap_tuples_written | bigint | Number of heap tuples written. This counter only advances when the phase is seq scanning heap, index scanning heap or writing new heap. |
heap_blks_total | bigint | Total number of heap blocks in the table. This number is reported as of the beginning of seq scanning heap. |
heap_blks_scanned | bigint | Number of heap blocks scanned. This counter only advances when the phase is seq scanning heap. |
index_rebuild_count | bigint | Number of indexes rebuilt. This counter only advances when the phase is rebuilding index. |
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 | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
relid | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
command | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
phase | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
cluster_index_relid | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
heap_tuples_scanned | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
heap_tuples_written | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
heap_blks_total | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
heap_blks_scanned | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
index_rebuild_count | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
Version history 8
- PG 19 → 20changed
- PG 18 → 19changed
- PG 16 → 17changed
- PG 15 → 16changed
- PG 14 → 15changed
- PG 13 → 14changed
- PG 12 → 13changed
- PG 11 → 12added
Definition snapshot: english-manuals:97f866c4563b248ae3a52e492fe… · English manual source