get table and index sizes in postgresql

table_size.sql

SELECT
  nspname,
  relname,
  relkind,
  to_char(round(reltuples::numeric, -2), '999,999,999,999,999') as est_row_count,
  pg_size_pretty(pg_indexes_size(c.oid)) index_size,
  pg_size_pretty(pg_relation_size(c.oid)) table_size
FROM pg_class c
  LEFT JOIN pg_namespace n ON c.relnamespace = n.oid
WHERE (nspname <> ALL (ARRAY['pg_catalog', 'information_schema']::name[]))
  AND n.nspname !~ '^pg_toast'
  AND c.relkind = 'r';