pg_stat_progress_vacuum.heap_blks_scanned
Number of heap blocks scanned. Because the visibility map is used to optimize scans, some blocks will be skipped without inspection; skipped blocks are included in this total, so that this number will eventually become equal to heap_blks_total when the vacuum is complete. This counter only advances when the phase is scanning heap.
Reading PG 18·Select a recorded version
- View
- pg_stat_progress_vacuum
- Field
- heap_blks_scanned
- SQL type
- bigint
- Units named in the field definition
- blocks
- Reset observation
- No stats_reset field is documented for this view
- documented
- true
- field
- heap_blks_scanned
- manual path
- /docs/18/progress-reporting.html
- signature
- SELECT heap_blks_scanned FROM pg_catalog.pg_stat_progress_vacuum;
- source only
- false
- sql type
- bigint
- units mentioned
- blocks
- view
- pg_stat_progress_vacuum
Definition PG 18
Number of heap blocks scanned. Because the visibility map is used to optimize scans, some blocks will be skipped without inspection; skipped blocks are included in this total, so that this number will eventually become equal to heap_blks_total when the vacuum is complete. This counter only advances when the phase is scanning heap.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f