How to check largest tables including indexes in PostgreSQL

select
  pg_size_pretty(relation_size) as relation_size,
  pg_size_pretty(total_relation_size) as total_relation_size,
  pg_size_pretty(sum(total_relation_size) over (order by total_relation_size desc)) as cumulative_size,
  schemaname,
  relname
from (
  select
    pg_total_relation_size(quote_ident(schemaname)||'.'||quote_ident(relname)) as total_relation_size,
    pg_relation_size(quote_ident(schemaname)||'.'||quote_ident(relname)) as relation_size,
    schemaname,
    relname
  from pg_stat_user_tables
  order by 2 desc
) as _;