pg_stat_progress_repack — PostgreSQL statistics view

The PostgreSQL pg_stat_progress_repack statistics view: full column reference (names, types, descriptions), catalog relationships and version support.

The Sev-1 Admin
The Sev-1 Admin  ·  2 min read

Summary

Whenever REPACK is running, the pg_stat_progress_repack view will contain a row for each backend that is currently running the command. The tables below describe the information that will be reported and provide information about how to interpret it.

(Description quoted from the official PostgreSQL documentation.)

Columns

The pg_stat_progress_repack statistics view exposes the following columns (names, types and descriptions are taken verbatim from the PostgreSQL documentation):

  • pid integer
    Process ID of backend.
  • 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 being repacked.
  • command text
    The command that is running. Either REPACK or VACUUM FULL, or CLUSTER.
  • phase text
    Current processing phase. See repack_phases.
  • repack_index_relid oid
    If the table is being scanned using an index, this is the OID of the index being used; otherwise, it is zero.
  • heap_tuples_scanned bigint
    Number of heap tuples scanned. This counter only advances when the phase is seq scanning heap, index scanning heap or writing new heap.
  • heap_tuples_inserted bigint
    Number of heap tuples inserted. This counter only advances when the phase is seq scanning heap, index scanning heap, writing new heap or catch-up.
  • heap_tuples_updated bigint
    Number of heap tuples updated. This counter only advances when the phase is catch-up.
  • heap_tuples_deleted bigint
    Number of heap tuples deleted. This counter only advances when the phase is catch-up.
  • heap_blks_total bigint
    Total number of heap blocks in the table. This number is reported as of the beginning of seq scanning heap.
  • heap_blks_scanned bigint
    Number of heap blocks scanned. This counter only advances when the phase is seq scanning heap.
  • index_rebuild_count bigint
    Number of indexes rebuilt. This counter only advances when the phase is rebuilding index.

Version applicability

Present in PostgreSQL 19 (verified against each release’s documentation). This object was introduced in PostgreSQL 19.

Related & references

Reference: PostgreSQL documentation — pg_stat_progress_repack.