Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
Advertisement
Add Comment
Please, Sign In to add comment