56.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 56.33. pg_stats_vacuum_tables Columns
Column Type Description |
|---|
OID of a table |
Name of the schema this table is in |
Name of this table |
Number of database blocks read by vacuum operations performed on this table |
Number of times database blocks were found in the buffer cache by vacuum operations performed on this table |
Number of database blocks dirtied by vacuum operations performed on this table |
Number of database blocks written by vacuum operations performed on this table |
Number of blocks vacuum operations read from this table |
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) |
Number of pages examined by vacuum operations performed on this table |
Number of pages removed from the physical storage by vacuum operations performed on this table |
Number of times vacuum operations marked pages of this table as all-frozen in the visibility map |
Number of times vacuum operations marked pages of this table as all-visible in the visibility map |
Number of dead tuples vacuum operations deleted from this table |
Number of tuples of this table that vacuum operations marked as frozen |
Number of dead tuples vacuum operations left in this table due to their visibility in transactions |
Number of times indexes on this table were vacuumed |
Number of times the all-frozen mark in the visibility map was removed for pages of this table |
Number of times the all-visible mark in the visibility map was removed for pages of this table |
Total number of WAL records generated by vacuum operations performed on this table |
Total number of WAL full page images generated by vacuum operations performed on this table |
Total amount of WAL bytes generated by vacuum operations performed on this table |
Time spent reading database blocks by vacuum operations performed on this table, in milliseconds (if track_io_timing is enabled, otherwise zero) |
Time spent writing database blocks by vacuum operations performed on this table, in milliseconds (if track_io_timing is enabled, otherwise zero) |
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 CPU time of vacuuming this table, in milliseconds |
User CPU time of vacuuming this table, in milliseconds |
Total time of vacuuming this table, in milliseconds |
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.