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.
