52.31. pg_stats_vacuum_indexes#
The viewpg_stats_vacuum_indexes will contain one row for each index in the current database (including TOAST table indexes), showing statistics about vacuuming that specific index.
Table 52.31. pg_stats_vacuum_indexes Columns
Column Type Description |
|---|
OID of an index |
Name of the schema this index is in |
Name of this index |
Number of database blocks read by vacuum operations performed on this index |
Number of times database blocks were found in the buffer cache by vacuum operations performed on this index |
Number of database blocks dirtied by vacuum operations performed on this index |
Number of database blocks written by vacuum operations performed on this index |
Number of blocks vacuum operations read from this index |
Number of times blocks of this index 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 deleted by vacuum operations performed on this index |
Number of dead tuples vacuum operations deleted from this index |
Total number of WAL records generated by vacuum operations performed on this index |
Total number of WAL full page images generated by vacuum operations performed on this index |
Total amount of WAL bytes generated by vacuum operations performed on this index |
Time spent reading database blocks by vacuum operations performed on this index, in milliseconds (iftrack_io_timing is enabled, otherwise zero) |
Time spent writing database blocks by vacuum operations performed on this index, in milliseconds (iftrack_io_timing is enabled, otherwise zero) |
Time spent sleeping in a vacuum delay point by vacuum operations performed on this index, in milliseconds (seeSection 18.4.4 for details) |
System CPU time of vacuuming this index, in milliseconds |
User CPU time of vacuuming this index, in milliseconds |
Total time of vacuuming this index, in milliseconds |
Number of times vacuum operations performed on this index were interrupted on any errors |