pg_stat_progress_cluster

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.

Reading PG 18current·documented in 9 of 24 versions, 12 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

Kind: Progress reporting
Columns in this snapshot: 12
Definition source: English manual
Metadata snapshot: 18.6

Columns 12

As listed in the PostgreSQL 18 manual.

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.