Postgresql find total disk space used by a database
Solution 1:
SELECT pg_database_size('geekdb')
or
SELECT pg_size_pretty(pg_database_size('geekdb'))
http://www.thegeekstuff.com/2009/05/15-advanced-postgresql-commands-with-examples/
Solution 2:
You could use postgresql Meta-Commands:
-
\l
would list databases -
\l+
extends list with Size, Tablespace, Description.
Use \?
to get full list of meta-commands. Also see:
https://www.postgresql.org/docs/9.5/static/app-psql.html