↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Wiki / Statistics & Metrics

pg_stat_all_tables.last_vacuum

Last time at which this table was manually vacuumed (not counting VACUUM FULL)

Reading PG 18·Select a recorded version

View
pg_stat_all_tables
Field
last_vacuum
SQL type
timestamp with time zone
Units named in the field definition
Not specified
Reset observation
No stats_reset field is documented for this view
documented
true
field
last_vacuum
manual path
/docs/18/monitoring-stats.html
signature
SELECT last_vacuum FROM pg_catalog.pg_stat_all_tables;
source only
false
sql type
timestamp with time zone
units mentioned
Unknown
view
pg_stat_all_tables

Definition PG 18

Last time at which this table was manually vacuumed (not counting VACUUM FULL)

Compare versions

Source references

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f

Text language: en · 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f