55.33. pg_stats_vacuum_tables #

The view pg_stats_vacuum_tables will contain one row for each table in the current database (including TOAST tables), showing statistics about vacuuming that specific table.

Table 55.33. pg_stats_vacuum_tables Columns

Column Type

Description

relid oid

OID of a table

schema name

Name of the schema this table is in

relname name

Name of this table

total_blks_read int8

Number of database blocks read by vacuum operations performed on this table

total_blks_hit int8

Number of times database blocks were found in the buffer cache by vacuum operations performed on this table

total_blks_dirtied int8

Number of database blocks dirtied by vacuum operations performed on this table

total_blks_written int8

Number of database blocks written by vacuum operations performed on this table

rel_blks_read int8

Number of blocks vacuum operations read from this table

rel_blks_hit int8

Number of times blocks of this table were already found in the buffer cache by vacuum operations, so that a read was not necessary (this only includes hits in the Postgres Pro buffer cache, not the operating system's file system cache)

pages_scanned int8

Number of pages examined by vacuum operations performed on this table

pages_removed int8

Number of pages removed from the physical storage by vacuum operations performed on this table

pages_frozen int8

Number of times vacuum operations marked pages of this table as all-frozen in the visibility map

pages_all_visible int8

Number of times vacuum operations marked pages of this table as all-visible in the visibility map

tuples_deleted int8

Number of dead tuples vacuum operations deleted from this table

tuples_frozen int8

Number of tuples of this table that vacuum operations marked as frozen

dead_tuples int8

Number of dead tuples vacuum operations left in this table due to their visibility in transactions

index_vacuum_count int8

Number of times indexes on this table were vacuumed

rev_all_frozen_pages int8

Number of times the all-frozen mark in the visibility map was removed for pages of this table

rev_all_visible_pages int8

Number of times the all-visible mark in the visibility map was removed for pages of this table

wal_records int8

Total number of WAL records generated by vacuum operations performed on this table

wal_fpi int8

Total number of WAL full page images generated by vacuum operations performed on this table

wal_bytes numeric

Total amount of WAL bytes generated by vacuum operations performed on this table

blk_read_time int8

Time spent reading database blocks by vacuum operations performed on this table, in milliseconds (if track_io_timing is enabled, otherwise zero)

blk_write_time int8

Time spent writing database blocks by vacuum operations performed on this table, in milliseconds (if track_io_timing is enabled, otherwise zero)

delay_time float8

Time spent sleeping in a vacuum delay point by vacuum operations performed on this table, in milliseconds (see Section 19.4.4 for details)

system_time float8

System CPU time of vacuuming this table, in milliseconds

user_time float8

User CPU time of vacuuming this table, in milliseconds

total_time float8

Total time of vacuuming this table, in milliseconds

interrupts float8

Number of times vacuum operations performed on this table were interrupted on any errors


Columns total_*, wal_* and blk_* include data on vacuuming indexes on this table, while columns system_time and user_time only include data on vacuuming the heap.