pg_stat_progress_create_index
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. The tables below describe the information that will be reported and provide information about how to interpret it.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- progress
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- 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
- runtime verified
- false
- source
- english-manual
Definition PG 18
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. The tables below describe the information that will be reported and provide information about how to interpret it.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| pid | integer | Nullable | Process ID of the backend creating indexes. |
| datid | oid | Nullable | OID of the database to which this backend is connected. |
| datname | name | Nullable | Name of the database to which this backend is connected. |
| relid | oid | Nullable | OID of the table on which the index is being created. |
| index_relid | oid | Nullable | OID of the index being created or reindexed. During a non-concurrent CREATE INDEX, this is 0. |
| command | text | Nullable | Specific command type: CREATE INDEX, CREATE INDEX CONCURRENTLY, REINDEX, or REINDEX CONCURRENTLY. |
| phase | text | Nullable | Current processing phase of index creation. See Table 27.44. |
| lockers_total | bigint | Nullable | Total number of lockers to wait for, when applicable. |
| lockers_done | bigint | Nullable | Number of lockers already waited for. |
| current_locker_pid | bigint | Nullable | Process ID of the locker currently being waited for. |
| blocks_total | bigint | Nullable | Total number of blocks to be processed in the current phase. |
| blocks_done | bigint | Nullable | Number of blocks already processed in the current phase. |
| tuples_total | bigint | Nullable | Total number of tuples to be processed in the current phase. |
| tuples_done | bigint | Nullable | Number of tuples already processed in the current phase. |
| partitions_total | bigint | Nullable | 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 | Nullable | 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. |
Compare versions
Complete source facts
documentation revision
{"inputs":[{"file":"progress-reporting.html","kind":"same-version-reviewed-manual","locale":"en","sha256":"4a6cdd8228f2d858318f2056687ac4e2467e2c58e5fed10bdb583ba8eb66fec5","version":"18.7"},{"file":"progress-reporting.html","kind":"same-version-reviewed-manual","locale":"zh-Hans","sha256":"0ab33caa1959f857312f1a866b2b0f0afde18c3fd85db5d957eefa1b7a2e441f","version":"18.7"}],"release":"18.7","runtime_remeasured":false,"source_revision":"pgdoc:b9f0e7232f60f380d642ac9b99226606c254b552"}Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:59c2a769b76a56312b2c967c8850803e785db7689217f0eb4f9298db309f2826
Text language: en · catalog-bilingual-repair:59c2a769b76a56312b2c967c8850803e785db7689217f0eb4f9298db309f2826