Guest User

Untitled

a guest
Nov 14th, 2018
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. SELECT psut.relname AS table_name,
  2. to_char(psut.last_vacuum, 'YYYY-MM-DD HH24:MI') AS last_vacuum,
  3. to_char(psut.last_autovacuum, 'YYYY-MM-DD HH24:MI') AS last_autovacuum,
  4. to_char(pg_class.reltuples, '9G999G999G999') AS n_tup,
  5. to_char(psut.n_dead_tup, '9G999G999G999') AS dead_tup,
  6. to_char(CAST(current_setting('autovacuum_vacuum_threshold') AS bigint) + (CAST(current_setting('autovacuum_vacuum_scale_factor') AS numeric) * pg_class.reltuples), '9G999G999G999') AS av_threshold,
  7. CAST(current_setting('autovacuum_vacuum_threshold') AS bigint) + (CAST(current_setting('autovacuum_vacuum_scale_factor') AS numeric) * pg_class.reltuples) < psut.n_dead_tup AS expect_av
  8. FROM pg_stat_user_tables psut
  9. INNER JOIN pg_class
  10. ON psut.relid = pg_class.oid
  11. ORDER BY 1;
Add Comment
Please, Sign In to add comment