Find PostgreSQL database size using SQL ‘Select’
This article will show you a very simple way to find the size of a PostgreSQL database using a SQL SELECT statement. This will work on PostgreSQL version 8.3.3, but should work on older versions as well.
Query
SELECT pg_database.datname,pg_size_pretty(pg_database_size(pg_database.datname)) AS size FROM pg_database where datname='database_name';
Sample Result
datname | size
-----------------+-------
database_name | 15 MB
(1 row)
The result shows the name of the database, as well as the size which in this case is 15 MB