How big is PostgreSQL database size?

Posted on November 1, 2007
Filed Under PostgreSQL | Leave a Comment

Today found another very useful info from http://www.planetpostgresql.org/

tempdb=# SELECT pg_database.datname,
pg_size_pretty(pg_database_size(pg_database.datname)) AS size
FROM pg_database;

And this is what it shows:

     datname      |  size
——————+———
postgres         | 3480 kB
jasperserver  | 82 MB
testdb             | 3480 kB
template1      | 3537 kB
template0     | 3480 kB
tempdb          | 127 MB
(6 rows)

Time: 143.405 ms

Comments

Leave a Reply