Slide 29
Slide 29 text
# SELECT index_relid::regclass, phase, blocks_done, blocks_total
FROM pg_stat_progress_create_index;
index_relid | phase | blocks_done | blocks_total
------------------+--------------------------------+-------------+--------------
index_tab_pkey | building index: scanning table | 27719 | 44248
(1 row)
pg_stat_progress_create_index
Measure CREATE INDEX Progress
Postgres 12+