pg_stat_progress_cluster

A progress reporting view providing information on the progress of CLUSTER and VACUUM FULL 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 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

Categories

Monitoring, Progress reporting view

See also

CLUSTER, Progress reporting, pg_stat_progress_vacuum