In postgresql:[1]
select schemaname as table_schema, relname as table_name, pg_size_pretty(pg_relation_size(relid)) as data_size from pg_catalog.pg_statio_user_tables order by pg_relation_size(relid) desc;
List tables by their size in PostgreSQL database - PostgreSQL Data Dictionary Queries ↩︎