Find out when a table was last analyzed or vacuumed
select relname as "table", last_vacuum as "last manual vacuum", last_autovacuum as "last auto vacuum", last_analyze as "last manual analyze", last_autoanalyze as "last auto analyze" from pg_stat_user_tables where relname = 'my_table';