SQL Queries - Common SQL Queries - How to check the table size and corresponding index sizes on a schema

select s.nspname schema_name,
t.relname table_name,
i.indexrelname,
pg_size_pretty(pg_table_size(t.oid)) table_size,
pg_size_pretty(pg_relation_size(i.index_oid)) index_size
from pg_catalog.pg_class t
join pg_catalog.pg_namespace s
on t.relnamespace = s.oid
left join (select ipg.oid index_oid, c.oid table_oid, ipg.relname indexrelname
from pg_index x
join pg_class c
on c.oid = x.indrelid
join pg_class ipg
on ipg.oid = x.indexrelid
) i
on i.table_oid = t.oid
where t.relkind in ('v', 'r', 'p')
and s.nspname in (<schema list>)
order by s.nspname, pg_relation_size(t.oid) desc;