bookmark

How to find when Postgres tables were auto-vacuumed and auto-analyzed?

https://www.heatware.net/databases/postgres-tables-auto-vacuum-analyze/

Description

select relname,last_vacuum, last_autovacuum, last_analyze, last_autoanalyze from pg_stat_user_tables;

Preview

Tags

Users

Comments and Reviewsshow / hide

Please log in to take part in the discussion (add own reviews or comments).