openpolitics.com

Postgres: pg_table_size function

SELECT
relname, age(relfrozenxid) as xid_age,
pg_size_pretty(pg_table_size(oid)) as table_size
FROM
pg_class
ORDER BY
pg_table_size(oid) DESC LIMIT 20;