select table_schema, pg_size_pretty(sum(pg_relation_size(table_schema || '.' || table_name)))
from information_schema.tables
where table_schema in ('public', '_timescaledb_internal') and table_type = 'BASE TABLE'
group by table_schema
order by 2 desc