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@visena.com>
Sent: Thursday, November 29, 2018 1:10 PM
To: pgsql-general@lists.postgresql.org
Subject: Sv: Reg: Query for DB growth size
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()));