Re: [PERFORM] Monitoring tool for Postgres Database

2017-06-03 Thread Nikolay Samokhvalov
We use OKmeter.io, their Postgres monitoring is really good. On Thu, May 25, 2017 at 10:48 PM, Ravi Tammineni < rtammin...@partner.aligntech.com> wrote: > Hi, > > > > What is the best monitoring tool for Postgres database? >

Re: [PERFORM] Monitoring tool for Postgres Database

2017-05-27 Thread phb07
Hi Ravi, We, at Dalibo, are contributing to the postgres community mostly through open source administration tools development. Among them : - pgBadger, from Gilles Darold, extracts a lot of data from the postgres logs and restitutes them via a web interface (https://github.com/dalibo/pgbadg

Re: [PERFORM] Monitoring tool for Postgres Database

2017-05-26 Thread Dave Stibrany
We've found pghero to be a good first line of defence. It doesn't have alerting yet, but it's great for a quick high level healthcheck. Also +1 for Datadog. Extremely flexible and elegant UI + powerful alerting capabilities. On Fri, May 26, 2017 at 10:32 AM, Sunkara, Amrutha wrote: > We have be

Re: [PERFORM] Monitoring tool for Postgres Database

2017-05-26 Thread Sunkara, Amrutha
We have been using Nagios to monitor the system level stats. The database level stats that we gather are custom scripts that we have nagios poll to get the database health. You could use pg badger to generate reports against your database logs as well. Pg_badger reports are your bffs for performanc

Re: [PERFORM] Monitoring tool for Postgres Database

2017-05-26 Thread gevans
+1 for Datadog. It is highly configurable, but out of the box the postgres integration collects a good amount of useful stuff. Tech support is also good. http://docs.datadoghq.com/integrations/postgresql/ Grant Evans Enova Inc. gev...@enova.com On 5/26/17 5:19 AM, Rick Otten wrote: On Thu

Re: [PERFORM] Monitoring tool for Postgres Database

2017-05-26 Thread Rick Otten
On Thu, May 25, 2017 at 3:48 PM, Ravi Tammineni < rtammin...@partner.aligntech.com> wrote: > Hi, > > > > What is the best monitoring tool for Postgres database? Something like > Oracle Enterprise Manager. > > > > Specifically I am interested in tools to help: > > > > Alert DBAs to problems with bo

Re: [PERFORM] Monitoring tool for Postgres Database

2017-05-25 Thread Gary Evans
Hi Ravi, > What is the best monitoring tool for Postgres database? Something like > Oracle Enterprise Manager. > If you're an existing user of OEM, there is a PostgreSQL plugin for it by Blue Medora (believe it is commercial). You might like to have a look at it. > > > Specifically I am intere