SYSTEM CATALOGS / PROGRESS REPORTING
pg_stat_progress_repack
Read PG 20 devel manual ↗Whenever REPACK, CLUSTER, or VACUUM FULL is running, the pg_stat_progress_repack view will contain a row for each backend that is currently running one of these commands.
Development snapshot. These definitions may change before release.
- Kind
- Progress reporting
- Columns in this snapshot
- 14
- Definition source
- English manual
Columns 14
| 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 processed. |
command | text | The command that is running. One of CLUSTER, REPACK, or VACUUM FULL. |
phase | text | Current processing phase. See Table 27.50. |
repack_index_relid | oid | OID of the index defining the order of the rewritten table, or zero if no index ordering is requested. |
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_inserted | bigint | Number of heap tuples inserted. This counter only advances when the phase is seq scanning heap, index scanning heap, writing new heap or catch-up. |
heap_tuples_updated | bigint | Number of heap tuples updated. This counter only advances when the phase is catch-up. |
heap_tuples_deleted | bigint | Number of heap tuples deleted. This counter only advances when the phase is catch-up. |
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 | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
repack_index_relid | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
heap_tuples_scanned | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
heap_tuples_inserted | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
heap_tuples_updated | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
heap_tuples_deleted | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
heap_blks_total | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
heap_blks_scanned | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
index_rebuild_count | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | · | ● | ● |
Version history 2
- PG 19 → 20changed
- PG 18 → 19added
Definition snapshot: english-manuals:68d9a7c973dccc0c4c6063010e1… · English manual source