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.

Reading PG 18current·documented in 9 of 24 versions, 12 to 20

7.4 8.0 8.1 8.2 8.3 8.4 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

Kind: Progress reporting
Columns in this snapshot: 16
Definition source: English manual
Metadata snapshot: 18.6

Columns 16

As listed in the PostgreSQL 18 manual.

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.