10 lines
293 B
SQL
10 lines
293 B
SQL
SELECT
|
|
n.nspname || '.' || c.relname AS name,
|
|
pg_size_pretty(sum(c.relpages::bigint*8192)::bigint) AS size
|
|
FROM pg_class c
|
|
LEFT JOIN pg_namespace n ON (n.oid = c.relnamespace)
|
|
WHERE NOT n.nspname LIKE ANY($1)
|
|
AND c.relkind = 'i'
|
|
GROUP BY n.nspname, c.relname
|
|
ORDER BY sum(c.relpages) DESC
|