<\/P>
SÉLECTIONNER
schema_name,
relname,
pg_size_pretty(table_size) AS taille,
table_size<\/P>
DE (
SÉLECTIONNER
pg_catalog.pg_namespace.nspname AS schema_name,
relname,
pg_relation_size(pg_catalog.pg_class.oid) AS table_size<\/P>
DE pg_catalog.pg_class
JOINDRE pg_catalog.pg_namespace SUR relnamespace = pg_catalog.pg_namespace.oid
) t
OÙ schema_name NOT LIKE 'pg_%'
ORDONNER PAR table_size DESC;<\/P>
