Goal
Type Sofware measure (Numeric values (software measures) about the database)
License MIT (opens in new tab)
Data Source system catalog only
SQL Query 
SELECT pg_size_pretty(Sum(pg_table_size(c.oid))) AS total_index_size
FROM pg_class c INNER JOIN pg_namespace n ON (n.oid = c.relnamespace)
INNER JOIN pg_authid AS a ON n.nspowner=a.oid
WHERE (n.nspname='public' OR a.rolname<>'postgres')
AND c.relkind IN ('r');

Categories

This query is classified under the following categories:

Data at the database physical level

Queries of this category provide information about the disk usage.

NameDescription
Data at the database physical levelQueries of this category provide information about the disk usage.