pg_database_size

AI Rumman wrote:

What does pg_database_size resturs?
Bytes or KB?

those functions all return size in bytes. you can use
pg_size_pretty(pg_database_size('dbname')) to pretty print it as MB or
whatever is most appropriate.