select oid::regclass::text as table_to_vacuum, age(relfrozenxid) xid_age, mxid_age(relminmxid) mxid_age, least( ( select setting::int from pg_settings where name = 'autovacuum_freeze_max_age') - age(relfrozenxid), ( select setting::int from pg_settings where name = 'autovacuum_multixact_freeze_max_age') - mxid_age(relminmxid) ) tx_before_wraparound_vacuum, -- pg_size_pretty(pg_total_relation_size(oid)) size, pg_total_relation_size(oid) size, pg_stat_get_last_autovacuum_time(oid) last_autovacuum from pg_class where not (relfrozenxid = 0) and oid > 16384 -- and pg_total_relation_size(oid) > pow(1024, 3) -- order by tx_before_wraparound_vacuum