Get sizes of materialized views, indexes and tables
SELECT relname AS objectname , relkind AS objecttype , reltuples AS entries , pg_size_pretty(pg_table_size(oid)) AS SIZE FROM pg_class WHERE relkind IN ('r', 'i', 'm') ORDER BY pg_table_size(oid) DESC; Relkinds: r = ordinary TABLE, i = INDEX, S = SEQUENCE, v = VIEW, m = materialized VIEW, c = composite TYPE, t = TOAST TABLE, f = FOREIGN TABLE