| From: | Michael Paquier <michael(at)paquier(dot)xyz> |
|---|---|
| To: | "R(dot)R(dot) PRAVEEN RAJA" <rrpraveenraja(at)live(dot)com> |
| Cc: | 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 09:06:35 |
| Message-ID: | 20181129090635.GG9004@paquier.xyz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Nov 29, 2018 at 08:15:10AM +0000, 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 in oracle.
Why not running a cron job which stores periodically the result of
pg_database_size with a timestamp (simply now())? Then you have as much
data as you want for growth comparison.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Condor | 2018-11-29 09:31:34 | Re: Reg: Query for DB growth size |
| Previous Message | Achilleas Mantzios | 2018-11-29 08:29:21 | Re: Reg: Query for DB growth size |