<\/P>
SELECT
schema_name,
relname,
pg_size_pretty(table_size) ALS Größe,
table_size<\/P>
FROM (
SELECT
pg_catalog.pg_namespace.nspname ALS schema_name,
relname,
pg_relation_size(pg_catalog.pg_class.oid) ALS table_size<\/P>
FROM pg_catalog.pg_class
JOIN pg_catalog.pg_namespace ON relnamespace = pg_catalog.pg_namespace.oid
) t
WHERE schema_name NICHT WIE 'pg_%'
ORDER BY table_size DESC;<\/P>
