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 <andr...@visena.com> 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 <rrpraveenr...@live.com<mailto: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())); -- Andreas Joseph Krogh
