how-to · database · postgresql

How to get database size on PostgreSQL?

Problem

You'd like to know how big is your PostgreSQL database.

Solution

Just run this query:

SELECT pg_size_pretty(pg_database_size('database'))  

where:
* database - your database name

Read also

PostgreSQL Disk Usage

Published:
comments powered by Disqus