From: gevans <gevans@enova.com>
To: pgsql-performance@postgresql.org
Subject: Re: Monitoring tool for Postgres Database
Date: Fri, 26 May 2017 09:31:48 -0500
Message-ID: <d6b05da8-f038-244e-85ef-b83f4bd3dc83@enova.com> (raw)
In-Reply-To: <CAMAYy4LpBpXGN2xMSbSShbtjp4fgDEsaVpVMpuY7bsCy6_oheA@mail.gmail.com>
References: <DM5PR02MB2651EEE74D84F7F1AD07413F80FF0@DM5PR02MB2651.namprd02.prod.outlook.com>
<CAMAYy4LpBpXGN2xMSbSShbtjp4fgDEsaVpVMpuY7bsCy6_oheA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
+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.
gevans@enova.com
On 5/26/17 5:19 AM, Rick Otten wrote:
> On Thu, May 25, 2017 at 3:48 PM, Ravi Tammineni
> <rtammineni@partner.aligntech.com
> <mailto:rtammineni@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 both configuration and performance issues
>
> Deadlocks, Long running queries etc.,
>
> Monitoring of overall system performance
>
> General performance tuning
>
> Storage/Disk latencies
>
> Thanks
>
> ravi
>
>
> We use Datadog. Their PostgreSQL plugin covers most of the most
> relevant stats. It is easy to configure and not very expensive at
> all. They have an easy GUI based configuration for monitors and
> alerts, and you can link it with something like Victorops and Slack
> for additional pager escalation policies. We have all of our batch
> processing tied into Datadog as well, so we can get a picture of
> events, systems, and database internals all in one dashboard.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gevans@enova.com, pgsql-performance@postgresql.org
Subject: Re: Monitoring tool for Postgres Database
In-Reply-To: <d6b05da8-f038-244e-85ef-b83f4bd3dc83@enova.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox