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';