Pasted

SELECT relname, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze  
FROM pg_stat_all_tables  
WHERE schemaname = 'public';
 
SELECT relname, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze, n_tup_upd, n_tup_del,  n_dead_tup
FROM pg_stat_all_tables  
WHERE schemaname = 'public'
ORDER BY relname ASC;
 
VACUUM ANALYZE dw.fct_encounter;