From: | Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Reg: Query for DB growth size |
Date: | 2018-11-29 08:29:21 |
Message-ID: | 7a637b5b-5b0e-9eab-d2d9-b97b89d3558b@matrix.gatewaynet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
On 29/11/18 10:15 π.μ., R.R. PRAVEEN RAJA wrote:
> 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
A huge list of monitoring solutions for Unix/Linux/PostgreSQL. The hot new trend is Prometheus, also you could checkout nagios, icinga, munin, zabbix lots and lots of options there.
You might also try a commercial offering (like e.g. Several Nines), they have some pretty graphs, alarms, alerts of all kinds.
And last but not least, you could have your own monitoring table where you keep periodic snapshots of the live metrics.
You may read here for an overview : https://severalnines.com/blog/key-things-monitor-postgresql-analyzing-your-workload
>
>
> 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*
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2018-11-29 09:06:35 | Re: Reg: Query for DB growth size |
Previous Message | R.R. PRAVEEN RAJA | 2018-11-29 08:15:10 | Re: Reg: Query for DB growth size |