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
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 |