If you have connect access to a PostgreSQL database, you can use the
pg_database_size()
function to get the size of a database in bytes.
> select pg_database_size('hr_hotels');
pg_database_size
------------------
8249516
Just give it the name of the database and it will tell you how much disk space that database is taking up.
Checkout the Postgres docs for more details.