| Schema name | Table name | Last vacuum |
| public | actor | 2008-04-19 15:27:54.032995+02 |
SELECT schemaname, relname, max(greatest(last_vacuum, last_autovacuum)) as lastvac FROM pg_stat_all_tables WHERE last_vacuum IS NOT NULL OR last_autovacuum IS NOT NULL GROUP BY 1, 2 ORDER BY 3 DESC