Tamanho do banco pgsql

pgsql.sql

select
  -- table_name, 
  -- pg_size_pretty( pg_total_relation_size(quote_ident(table_name))), 
  -- pg_size_pretty(sum(pg_total_relation_size(quote_ident(table_name))))
  pg_size_pretty(sum(pg_total_relation_size(quote_ident(table_name))))
from information_schema.tables
where
  table_schema = 'public'
-- order by pg_total_relation_size(quote_ident(table_name)) desc