deeejay

psql - View vacuum statistics

Nov 30th, 2015
348
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT relname, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze  
  2. FROM pg_stat_all_tables  
  3. WHERE schemaname = 'public';
  4.  
  5. SELECT relname, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze, n_tup_upd, n_tup_del,  n_dead_tup
  6. FROM pg_stat_all_tables  
  7. WHERE schemaname = 'public'
  8. ORDER BY relname ASC;
  9.  
  10. VACUUM ANALYZE dw.fct_encounter;
Advertisement
Add Comment
Please, Sign In to add comment