Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT psut.relname AS table_name,
- to_char(psut.last_vacuum, 'YYYY-MM-DD HH24:MI') AS last_vacuum,
- to_char(psut.last_autovacuum, 'YYYY-MM-DD HH24:MI') AS last_autovacuum,
- to_char(pg_class.reltuples, '9G999G999G999') AS n_tup,
- to_char(psut.n_dead_tup, '9G999G999G999') AS dead_tup,
- 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,
- 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
- FROM pg_stat_user_tables psut
- INNER JOIN pg_class
- ON psut.relid = pg_class.oid
- ORDER BY 1;
Add Comment
Please, Sign In to add comment