Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Postgres tablespace is cluster-wide. Therefore, how do I caculated how much space allocated by each database in postgres tablespace ?

share|improve this question

migrated from stackoverflow.com Mar 8 '12 at 6:47

This question came from our site for professional and enthusiast programmers.

1 Answer 1

To get the disk space occupied by a database (nicely formatted):

SELECT pg_size_pretty(pg_database_size('mydb'))

Disk space occupied by a tablespace:

SELECT pg_size_pretty(pg_tablespace_size('mytblspace'))

Find out more about database object size functions in the manual:

share|improve this answer
2  
One could very usefully combine this with a SELECT on the system tables: SELECT spcname, pg_size_pretty(pg_tablespace_size(spcname)) FROM pg_tablespace; and SELECT datname, pg_size_pretty(pg_database_size(datname)) FROM pg_database;. –  jpmc26 May 27 at 20:59

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.