How to get actually allocated tablespace sizes?

Question

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

Erwin Brandstetter · Accepted Answer · 2021-12-21 10:36:05Z

20

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'));

answered Mar 8, 2012 at 6:18

182k28 gold badges457 silver badges620 bronze badges

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
Commented May 27, 2014 at 20:59

Add a comment |

1 Answer 1