SELECT c.oid, n.nspname as schema, c.relname as table, pg_stat_get_last_vacuum_time(c.oid) as last_vacuum, pg_stat_get_tuples_inserted(c.oid) as inserted, pg_stat_get_tuples_updated(c.oid) as updated, pg_stat_get_tuples_deleted(c.oid) as deleted FROM pg_class c JOIN pg_namespace n ON (n.oid = c.relnamespace) WHERE nspname NOT IN ('information_schema', 'pg_toast', 'pg_catalog') and relkind = 'r' ORDER BY 2, 3;