PostgreSQL Last Vacuum

This query will return the last_vacuum and last_autovacuum timestamps for all user tables.

select relname, last_vacuum, last_autovacuum from pg_stat_user_tables;