DB Size - How much is growing - PostgreSQL 9.2

From: "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: DB Size - How much is growing - PostgreSQL 9.2
Date: 2016-04-18 22:46:25
Message-ID: CAE_gQfU6EEufX1R9btK7m=hArwwOasaFc+GA65MDfpCZGDo_ig@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2016-04-18 23:03:12 Re: DB Size - How much is growing - PostgreSQL 9.2
Previous Message David G. Johnston 2016-04-18 20:42:54 Re: processing openssl-encrypted files through pgdump and pgrestore