blob: df94d6f1f1f5d220d4ad362934b0d82a21ed5482 [file]
SELECT oid::regclass::text AS objectname
, relkind AS objecttype
, reltuples AS entries
, pg_size_pretty(pg_table_size(oid)) AS size -- depending - see below
FROM pg_class
WHERE relkind IN ('r', 'i', 'm')
ORDER BY pg_table_size(oid) DESC;