How to obtain the database size of a PostgreSQL Server instance?
Database query
With this query you can check the size of each database.
1 2 3 4 | select datname AS DatabaseName,pg_size_pretty(pg_database_size(datname)) as Sizefrom pg_database order bypg_database_size(datname) desc; |
The units are shown in the query result (kB, MB, …).