Re: Reg: Query for DB growth size

["R.R. PRAVEEN RAJA" <rrpraveenraja@xxxxxxxx>]

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@xxxxxxxxxx>
Sent: Thursday, November 29, 2018 1:10 PM
To: pgsql-general@xxxxxxxxxxxxxxxxxxxx
Subject: Sv: Reg: Query for DB growth size

 

På torsdag 29. november 2018 kl. 07:41:24, skrev R.R. PRAVEEN RAJA <rrpraveenraja@xxxxxxxx>:

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