Goal Get overview of disk usage.
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_total_relation_size(c.oid))) AS total_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 ('i','I');

Collections

This query belongs to the following collections:

Find problems by overview

Queries that results point to different aspects of database that might have problems. A human reviewer has to decide based on the results as to whether there are problems or not .

NameDescription
Find problems by overviewQueries that results point to different aspects of database that might have problems. A human reviewer has to decide based on the results as to whether there are problems or not .

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.

Performance

Queries of this category provide information about indexes in a database.

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