+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, May 25, 2017 at 3:48 PM, Ravi Tammineni
<rtammin...@partner.aligntech.com
<mailto: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 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.
