DB Index Size report

SELECT
    i.schemaname AS schema_name,
    i.tablename AS table_name,
    i.indexname AS index_name,
    pg_size_pretty(pg_relation_size(quote_ident(i.schemaname) || '.' || quote_ident(i.indexname))) AS index_size,
    pg_size_pretty(pg_total_relation_size(quote_ident(i.schemaname) || '.' || quote_ident(i.tablename))) AS table_total_size,
    pg_relation_size(quote_ident(i.schemaname) || '.' || quote_ident(i.indexname)) AS index_size_bytes,
    i.indexdef
FROM
    pg_indexes i
ORDER BY
    pg_relation_size(quote_ident(i.schemaname) || '.' || quote_ident(i.indexname)) DESC;