pg_stat_progress_vacuum.heap_blks_vacuumed
Number of heap blocks vacuumed. Unless the table has no indexes, this counter only advances when the phase is vacuuming heap. Blocks that contain no dead tuples are skipped, so the counter may sometimes skip forward in large increments.
Reading PG 18·Select a recorded version
- View
- pg_stat_progress_vacuum
- Field
- heap_blks_vacuumed
- SQL type
- bigint
- Units named in the field definition
- blocks, Blocks, tuples
- Reset observation
- No stats_reset field is documented for this view
- documented
- true
- field
- heap_blks_vacuumed
- manual path
- /docs/18/progress-reporting.html
- signature
- SELECT heap_blks_vacuumed FROM pg_catalog.pg_stat_progress_vacuum;
- source only
- false
- sql type
- bigint
- units mentioned
- blocks, Blocks, tuples
- view
- pg_stat_progress_vacuum
Definition PG 18
Number of heap blocks vacuumed. Unless the table has no indexes, this counter only advances when the phase is vacuuming heap. Blocks that contain no dead tuples are skipped, so the counter may sometimes skip forward in large increments.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f