postgres taille schémas

gistfile1.txt

SELECT schemaname, pg_size_pretty(t.taille::bigint) AS taille_table,pg_size_pretty(t.taille_index::bigint) AS taille_index, pg_size_pretty(t.taille_totale::bigint) AS taille_totale_table
  FROM (SELECT schemaname,          
               sum(pg_relation_size(schemaname || '.' || tablename)) AS taille, 
               sum(pg_indexes_size(schemaname || '.' || tablename)) AS taille_index,
               sum(pg_total_relation_size(schemaname || '.' || tablename)) AS taille_totale
          FROM pg_tables
           WHERE schemaname != 'my_schema'
 
GROUP BY schemaname) as t ORDER BY taille_totale DESC