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 (commit 6f97457e).

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 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