DB Size - How much is growing - PostgreSQL 9.2

Поиск

Список

Период

Сортировка

От	drum.lucas@gmail.com
Тема	DB Size - How much is growing - PostgreSQL 9.2
Дата	19 апреля 2016 г. 01:47:10
Msg-id	CAE_gQfU6EEufX1R9btK7m=hArwwOasaFc+GA65MDfpCZGDo_ig@mail.gmail.com обсуждение исходный текст
Ответы	Re: DB Size - How much is growing - PostgreSQL 9.2 ("David G. Johnston" <david.g.johnston@gmail.com>)
Список	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

В списке pgsql-admin по дате отправления:

От: "David G. Johnston"
Дата: 18 апреля 2016 г., 23:43:04
Сообщение: Re: processing openssl-encrypted files through pgdump and pgrestore

От: "David G. Johnston"
Дата: 19 апреля 2016 г., 02:03:22
Сообщение: Re: DB Size - How much is growing - PostgreSQL 9.2