SYSTEM CATALOGS / PROGRESS REPORTING
pg_stat_progress_create_index
Read PG 18 manual ↗Whenever CREATE INDEX or REINDEX is running, the pg_stat_progress_create_index view will contain one row for each backend that is currently creating indexes.
- Kind
- Progress reporting
- Columns in this snapshot
- 16
- Definition source
- English manual
Columns 16
| Column | Type | Description / reference |
|---|---|---|
pid | integer | Process ID of the backend creating indexes. |
datid | oid | OID of the database to which this backend is connected. |
datname | name | Name of the database to which this backend is connected. |
relid | oid | OID of the table on which the index is being created. |
index_relid | oid | OID of the index being created or reindexed. During a non-concurrent CREATE INDEX, this is 0. |
command | text | Specific command type: CREATE INDEX, CREATE INDEX CONCURRENTLY, REINDEX, or REINDEX CONCURRENTLY. |
phase | text | Current processing phase of index creation. See Table 27.44. |
lockers_total | bigint | Total number of lockers to wait for, when applicable. |
lockers_done | bigint | Number of lockers already waited for. |
current_locker_pid | bigint | Process ID of the locker currently being waited for. |
blocks_total | bigint | Total number of blocks to be processed in the current phase. |
blocks_done | bigint | Number of blocks already processed in the current phase. |
tuples_total | bigint | Total number of tuples to be processed in the current phase. |
tuples_done | bigint | Number of tuples already processed in the current phase. |
partitions_total | bigint | Total number of partitions on which the index is to be created or attached, including both direct and indirect partitions. 0 during a REINDEX, or when the index is not partitioned. |
partitions_done | bigint | Number of partitions on which the index has already been created or attached, including both direct and indirect partitions. 0 during a REINDEX, or when the index is not partitioned. |
Column history across versions
| Column | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
pid | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
datid | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
datname | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
relid | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
index_relid | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
command | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
phase | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
lockers_total | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
lockers_done | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
current_locker_pid | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
blocks_total | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
blocks_done | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
tuples_total | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
tuples_done | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
partitions_total | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
partitions_done | · | · | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● |
Version history 8
- PG 19 → 20changed
- PG 18 → 19changed
- PG 16 → 17changed
- PG 15 → 16changed
- PG 14 → 15changed
- PG 13 → 14changed
- PG 12 → 13changed
- PG 11 → 12added
Definition snapshot: english-manuals:98d0751ee8f5b545e23629bdde1… · English manual source