In this article, we will see how to find database size in PostgreSQL server. We can find database size in PostgreSQL by using SQL Statement and size of the files that make up the PostgreSQL database server.
1. Find the size of current database in PostgreSQL server.
select pg_size_pretty(pg_database_size(current_database()));
2. Find the size of specific database size in PostgreSQL Server.
select pg_size_pretty(pg_database_size('r2schools'));
3. How to find all databases size in PostgreSQL Server.
SELECT database_name, pg_size_pretty(size) from (SELECT pg_database.datname as "database_name", pg_database_size(pg_database.datname) AS size FROM pg_database ORDER by size DESC) as ordered;
4. How to find sum of all databases size in PostgreSQL Server.
select pg_size_pretty(sum(pg_database_size(datname))) from pg_database;
Output for all databases examples:
5. Find the databases size in PostgreSQL server by using meta-command.
\l+
6. Find the database size in PostgreSQL server from pgAdmin tool.
