postgres get size of all tables code example
Example 1: postgres check size table
SELECT pg_size_pretty( pg_total_relation_size('tablename') );
Example 2: show size of all tables postgres
select table_name, pg_relation_size(quote_ident(table_name))
from information_schema.tables
where table_schema = 'public'
order by 2