Postgres Pro
Downloads
Home   >   mailing lists

DB Size - How much is growing - PostgreSQL 9.2 - Mailing list pgsql-admin

From drum.lucas@gmail.com
Subject DB Size - How much is growing - PostgreSQL 9.2
Date
Msg-id CAE_gQfU6EEufX1R9btK7m=hArwwOasaFc+GA65MDfpCZGDo_ig@mail.gmail.com
Whole thread Raw
Responses Re: DB Size - How much is growing - PostgreSQL 9.2
List pgsql-admin
Tree view
Hi all,

I'm using the following query to get the actual size of my DB:
select t1.datname AS db_name,  
       pg_size_pretty(pg_database_size(t1.datname)) as db_size
from pg_database t1
order by pg_database_size(t1.datname) desc;

However I need to know how big is the database over the last month...
Need to know how much has the DB grown up by month...

I did had a Munin and MRTG graphs but the server went down and we don't have access to it anymore...

Is there any way to me get those data?

cheers
lucas

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: processing openssl-encrypted files through pgdump and pgrestore
Next
From: "David G. Johnston"
Date:
Subject: Re: DB Size - How much is growing - PostgreSQL 9.2