List tables ordering by their size on postgresql

list-tables-order-by-size.sql

-- copied from https://dataedo.com/kb/query/postgresql/list-of-tables-by-their-size

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;