SELECT oid::regclass::text as table, 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) ) AS tx_before_wraparound_vacuum, pg_size_pretty(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;