Postgresql find total disk space used by a database

SELECT pg_database_size('geekdb')

or

SELECT pg_size_pretty(pg_database_size('geekdb'))

15 Advanced PostgreSQL Commands with Examples