Handy PostgreSQL maintenance queries

relation_sizes_desc.sql

-- Lists the size of all relations in the current 'public' schema in descending order
SELECT
    nspname||'.'||relname AS relation,
    pg_size_pretty(pg_total_relation_size(nspname||'.'||relname)) as pretty_size,
    pg_total_relation_size(nspname||'.'||relname) as raw_size
FROM
    pg_class, pg_namespace
WHERE
    relnamespace = pg_namespace.oid
AND
    nspname = 'public'
ORDER BY
    raw_size DESC
;