Mastering PostgreSQL 12 - Third Edition

Tracking VACUUM and CREATE INDEX progress

In PostgreSQL 9.6, the community introduced a system view that many people have been waiting for. For many years, people have wanted to track the progress of a vacuum process to see how long things may take.

Due to this, pg_stat_progress_vacuum was invented to address this issue:

test=# \d pg_stat_progress_vacuum            View "pg_catalog.pg_stat_progress_vacuum"       Column       |  Type   | Collation | Nullable | Default --------------------+---------+-----------+----------+--------- pid                | integer |           |          |  datid              | oid     |           |          |  datname            | name    |           |          |  relid              | oid     |           |          |  phase              | text    |           |          |  heap_blks_total    | bigint  |           |          |  heap_blks_scanned  | bigint  |           |          |  heap_blks_vacuumed | bigint  |           |          |  index_vacuum_count | bigint | | |  ...