The total storage size of the database (the system catalog included)

Back to Catalog
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 License
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:

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:

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