get table size of all tables in database psql code example

Example: 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