Re: Reg: Query for DB growth size

2018-11-29 Thread Condor
On 29-11-2018 08:41, R.R. PRAVEEN RAJA wrote: Hi All, Can i get the query or steps for how to check the Database growth in postgres. Thanks in advance. Regards, Praveen No official thing that can do the job. You need to DIY, start collecting data (database size, connections count, index

Re: Reg: Query for DB growth size

2018-11-29 Thread Michael Paquier
On Thu, Nov 29, 2018 at 08:15:10AM +, R.R. PRAVEEN RAJA wrote: > 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

Re: Reg: Query for DB growth size

2018-11-29 Thread Achilleas Mantzios
*From:* Andreas Joseph Krogh *Sent:* Thursday, November 29, 2018 1:10 PM *To:* pgsql-general@lists.postgresql.org *Subject:* Sv: Reg: Query for DB growth size På torsdag 29. november 2018 kl. 07:41:24, skrev R.R. PRAVEEN RAJA mailto:rrpraveenr...@live.com>>: Hi All, Can

Re: Reg: Query for DB growth size

2018-11-29 Thread R.R. PRAVEEN RAJA
://www.dba-oracle.com/t_database_growth_reports.htm Thanks in advance. Regards, PraveenRaja From: Andreas Joseph Krogh Sent: Thursday, November 29, 2018 1:10 PM To: pgsql-general@lists.postgresql.org Subject: Sv: Reg: Query for DB growth size På torsdag 29

Sv: Reg: Query for DB growth size

2018-11-28 Thread Andreas Joseph Krogh
På torsdag 29. november 2018 kl. 07:41:24, skrev R.R. PRAVEEN RAJA < rrpraveenr...@live.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()));

Reg: Query for DB growth size

2018-11-28 Thread R.R. PRAVEEN RAJA
Hi All, Can i get the query or steps for how to check the Database growth in postgres. Thanks in advance. Regards, Praveen