| Query goal: | |
| Query type: | Sofware measure (Numeric values (software measures) about the database) |
| Query license: | MIT License |
| Data source: | system catalog only |
| SQL query: | Click on query to copy it
SELECT pg_size_pretty(Sum(pg_indexes_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'); |
| Category name | Category description |
|---|---|
| Data at the database physical level | Queries of this category provide information about the disk usage. |