Re: Reg: Query for DB growth size

From: "R(dot)R(dot) PRAVEEN RAJA" <rrpraveenraja(at)live(dot)com>
To: Andreas Joseph Krogh <andreas(at)visena(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Reg: Query for DB growth size
Date: 2018-11-29 08:15:10
Message-ID: DM5PR11MB1260045ACB51435E730699FCC0D20@DM5PR11MB1260.namprd11.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Andreas,

I hope you did not understand my question. I am not asking query for current database size. I am asking for database growth, i mean predicting the increase in database size over a period like a month just like its available in oracle. For oracle you can see the below link.

http://www.dba-oracle.com/t_database_growth_reports.htm

Thanks in advance.

Regards,
PraveenRaja

________________________________
From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
Sent: Thursday, November 29, 2018 1:10 PM
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Sv: Reg: Query for DB growth size

På torsdag 29. november 2018 kl. 07:41:24, skrev R.R. PRAVEEN RAJA <rrpraveenraja(at)live(dot)com<mailto:rrpraveenraja(at)live(dot)com>>:
Hi All,

Can i get the query or steps for how to check the Database growth in postgres. Thanks in advance.

select pg_size_pretty(pg_database_size(current_database()));

--
Andreas Joseph Krogh

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2018-11-29 08:29:21 Re: Reg: Query for DB growth size
Previous Message Andreas Joseph Krogh 2018-11-29 07:40:21 Sv: Reg: Query for DB growth size