Re: Monitoring tool for Postgres Database

gevans <gevans@xxxxxxxxx> · Fri, 26 May 2017 09:31:48 -0500



    +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@xxxxxxxxx

    
    On 5/26/17 5:19 AM, Rick Otten wrote:

    
          On Thu, May 25, 2017 at 3:48 PM, Ravi
            Tammineni <rtammineni@xxxxxxxxxxxxxxxxxxxxx>
            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.