pg_stat_progress_create_index

A progress reporting view providing information on the progress of CREATE INDEX and REINDEX commands

pg_stat_progress_create_index is a progress reporting view providing information on the progress of CREATE INDEX and REINDEX commands

pg_stat_progress_create_index was added in PostgreSQL 12 (commit ab0dfc96).

Definition by PostgreSQL version

pg_stat_progress_create_index (PostgreSQL 13)

        View "pg_catalog.pg_stat_progress_create_index"
       Column       |  Type   | Collation | Nullable | Default
--------------------+---------+-----------+----------+---------
 pid                | integer |           |          |
 datid              | oid     |           |          |
 datname            | name    |           |          |
 relid              | oid     |           |          |
 index_relid        | oid     |           |          |
 command            | text    |           |          |
 phase              | text    |           |          |
 lockers_total      | bigint  |           |          |
 lockers_done       | bigint  |           |          |
 current_locker_pid | bigint  |           |          |
 blocks_total       | bigint  |           |          |
 blocks_done        | bigint  |           |          |
 tuples_total       | bigint  |           |          |
 tuples_done        | bigint  |           |          |
 partitions_total   | bigint  |           |          |
 partitions_done    | bigint  |           |          |
    

Documentation: pg_stat_progress_create_index

pg_stat_progress_create_index (PostgreSQL 12)

        View "pg_catalog.pg_stat_progress_create_index"
       Column       |  Type   | Collation | Nullable | Default
--------------------+---------+-----------+----------+---------
 pid                | integer |           |          |
 datid              | oid     |           |          |
 datname            | name    |           |          |
 relid              | oid     |           |          |
 index_relid        | oid     |           |          |
 command            | text    |           |          |
 phase              | text    |           |          |
 lockers_total      | bigint  |           |          |
 lockers_done       | bigint  |           |          |
 current_locker_pid | bigint  |           |          |
 blocks_total       | bigint  |           |          |
 blocks_done        | bigint  |           |          |
 tuples_total       | bigint  |           |          |
 tuples_done        | bigint  |           |          |
 partitions_total   | bigint  |           |          |
 partitions_done    | bigint  |           |          |
    

Documentation: pg_stat_progress_create_index

Change history

Categories

Indexing, Monitoring, Progress reporting view

See also

CREATE INDEX, REINDEX, Progress reporting,