Reg: Query for DB growth size

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Reg: Query for DB growth size

R.R. PRAVEEN RAJA
Hi All,

Can i get the query or steps for how to check the Database growth in postgres. Thanks in advance.

Regards,
Praveen
Reply | Threaded
Open this post in threaded view
|

Sv: Reg: Query for DB growth size

Andreas Joseph Krogh-2
På torsdag 29. november 2018 kl. 07:41:24, skrev R.R. PRAVEEN RAJA <[hidden email]>:
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
Reply | Threaded
Open this post in threaded view
|

Re: Reg: Query for DB growth size

R.R. PRAVEEN RAJA
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 <[hidden email]>
Sent: Thursday, November 29, 2018 1:10 PM
To: [hidden email]
Subject: Sv: Reg: Query for DB growth size
 
På torsdag 29. november 2018 kl. 07:41:24, skrev R.R. PRAVEEN RAJA <[hidden email]>:
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
Reply | Threaded
Open this post in threaded view
|

Re: Reg: Query for DB growth size

Achilleas Mantzios
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.


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 [hidden email]
Sent: Thursday, November 29, 2018 1:10 PM
To: [hidden email]
Subject: Sv: Reg: Query for DB growth size
 
På torsdag 29. november 2018 kl. 07:41:24, skrev R.R. PRAVEEN RAJA <[hidden email]>:
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
Reply | Threaded
Open this post in threaded view
|

Re: Reg: Query for DB growth size

Michael Paquier-2
In reply to this post by R.R. PRAVEEN RAJA
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

signature.asc (849 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Reg: Query for DB growth size

Condor
In reply to this post by R.R. PRAVEEN RAJA
On 29-11-2018 08:41, R.R. PRAVEEN RAJA wrote:
> Hi All,
>
>  Can i get the query or steps for how to check the Database growth in
> postgres. Thanks in advance.
>
>  Regards,
>  Praveen


No official thing that can do the job.
You need to DIY, start collecting data (database size, connections
count, index sizes or so) every day, hour, min or so and then make
software to analyze it after a while.

Regards,
HS