pg_stat_progress_cluster
A progress reporting view providing information on the progress of CLUSTER commands
pg_stat_progress_cluster
is a progress reporting view providing information on the progress of CLUSTER
and VACUUM FULL
commands.
pg_stat_progress_cluster
was added in PostgreSQL 12.
This view (rather than pg_stat_progress_vacuum
) reports progress for VACUUM FULL
as both CLUSTER
and VACUUM FULL
involve table rewrites.
Definition by PostgreSQL version
pg_stat_progress_cluster (PostgreSQL 15)
View "pg_catalog.pg_stat_progress_cluster" Column | Type | Collation | Nullable | Default ---------------------+---------+-----------+----------+--------- pid | integer | | | datid | oid | | | datname | name | | | relid | oid | | | command | text | | | phase | text | | | cluster_index_relid | oid | | | heap_tuples_scanned | bigint | | | heap_tuples_written | bigint | | | heap_blks_total | bigint | | | heap_blks_scanned | bigint | | | index_rebuild_count | bigint | | |
Documentation: pg_stat_progress_cluster
pg_stat_progress_cluster (PostgreSQL 14)
View "pg_catalog.pg_stat_progress_cluster" Column | Type | Collation | Nullable | Default ---------------------+---------+-----------+----------+--------- pid | integer | | | datid | oid | | | datname | name | | | relid | oid | | | command | text | | | phase | text | | | cluster_index_relid | oid | | | heap_tuples_scanned | bigint | | | heap_tuples_written | bigint | | | heap_blks_total | bigint | | | heap_blks_scanned | bigint | | | index_rebuild_count | bigint | | |
Documentation: pg_stat_progress_cluster
pg_stat_progress_cluster (PostgreSQL 13)
View "pg_catalog.pg_stat_progress_cluster" Column | Type | Collation | Nullable | Default ---------------------+---------+-----------+----------+--------- pid | integer | | | datid | oid | | | datname | name | | | relid | oid | | | command | text | | | phase | text | | | cluster_index_relid | oid | | | heap_tuples_scanned | bigint | | | heap_tuples_written | bigint | | | heap_blks_total | bigint | | | heap_blks_scanned | bigint | | | index_rebuild_count | bigint | | |
Documentation: pg_stat_progress_cluster
pg_stat_progress_cluster (PostgreSQL 12)
View "pg_catalog.pg_stat_progress_cluster" Column | Type | Collation | Nullable | Default ---------------------+---------+-----------+----------+--------- pid | integer | | | datid | oid | | | datname | name | | | relid | oid | | | command | text | | | phase | text | | | cluster_index_relid | oid | | | heap_tuples_scanned | bigint | | | heap_tuples_written | bigint | | | heap_blks_total | bigint | | | heap_blks_scanned | bigint | | | index_rebuild_count | bigint | | |
Documentation: pg_stat_progress_cluster
Change history
- PostgreSQL 12
- added (commit 6f97457e)
References
- PostgreSQL documentation: CLUSTER Progress Reporting