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.
Definition by PostgreSQL version
pg_stat_progress_create_index (PostgreSQL 14)
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 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
- PostgreSQL 12
- added (commit ab0dfc96)
References
- PostgreSQL documentation: CREATE INDEX Progress Reporting