Get list of big objects (tables, indexes) in PostgreSQL database. The list is sorted by size descending.

pgsql_object_size.sql

SELECT
   relname AS objectname,
   relkind AS objecttype,
   reltuples AS "#entries", pg_size_pretty(relpages::bigint*8*1024) AS size
   FROM pg_class
   WHERE relpages >= 8
   ORDER BY relpages DESC;