Calculating PostgreSql DB size in python

Question

I want to write a cron job to calculate PosgreSql database size in python. Is there any API's in python. Cron job will find all the databases & calculate sizes for all of them daily.

Frank Heikens · Accepted Answer · 2010-03-04 11:08:54Z

7

Just a query:

SELECT
    pg_size_pretty(pg_database_size(current_database())) AS dbsize;

Fetch the result and you're done.

And for all databases in a cluster:

SELECT
    pg_size_pretty(pg_database_size(datname))
FROM 
    pg_database;

answered Mar 4, 2010 at 11:08

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Calculating PostgreSql DB size in python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related