postgres indexes sorted by size

indexes_by_size.sql

SELECT
    relname AS name,
    pg_size_pretty(sum(relpages::bigint*current_setting('block_size')::bigint)::bigint) AS size
FROM
    pg_class
WHERE
    reltype=0
GROUP BY
    relname
ORDER BY
    sum(relpages)
    DESC LIMIT 20;