]>
gitweb.pimeys.fr Git - scripts-20-100.git/blob - pg_size_of_indexes.sql
1 SELECT nspname ||
'.' || relname
AS "relation",
2 pg_size_pretty(pg_total_relation_size(C.oid
)) AS "total_size"
4 LEFT JOIN pg_namespace N
ON (N.oid
= C.relnamespace
)
5 WHERE nspname
NOT IN ('pg_catalog', 'information_schema')
7 AND nspname
!~
'^pg_toast'
8 ORDER BY pg_total_relation_size(C.oid
) DESC;