Goal Get overview of disk usage.
Notes The query takes into account the size of system catalog.
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(pg_database_size(current_database())) AS database_total_size;

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.

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