Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dEGJO-0004Go-Hc for pgsql-performance@arkaria.postgresql.org; Fri, 26 May 2017 14:33:54 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dEGJO-0001fg-4D for pgsql-performance@arkaria.postgresql.org; Fri, 26 May 2017 14:33:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dEGHZ-0003Ao-VX for pgsql-performance@postgresql.org; Fri, 26 May 2017 14:32:02 +0000 Received: from mail-io0-x22d.google.com ([2607:f8b0:4001:c06::22d]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dEGHU-0007pi-Rx for pgsql-performance@postgresql.org; Fri, 26 May 2017 14:32:01 +0000 Received: by mail-io0-x22d.google.com with SMTP id k91so10458607ioi.1 for ; Fri, 26 May 2017 07:31:56 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enova.com; s=google; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=2z4Zn6LJXlbjtDeIoNxgWECi6vFYzDgy/3X/VEBrg3o=; b=Ya2RWgRAciwrVrDO/cH7mh43XjdSH8tohBKoQ/NWf+5H6NYlAj/CdzQsFIwWEMcxuu x0x17rnzAUW9wSEXGsLOutkBb7jpMELehwdsgma5hQXl7CB9uhwLbCSnM4NHpHeWc4LY mpqBH9wFcVWxRYuy8gUOMDYY+NKre5M0lHFlI= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=2z4Zn6LJXlbjtDeIoNxgWECi6vFYzDgy/3X/VEBrg3o=; b=K+VYX+1l64/4spzIzG55g/KkIjZ+Da2XUpQvEfWXQfjIi6OhowNv/egp1hDMXAkJon UNXonO5si6T9wSBEqUHEdKZGQv7AKlf2c9qzzvmxrq1OI9V8i6wMus7DOzI3XV9ZhCUm JyvLBer4QlanFu8l65zskiq+lU2rrDuQ5jgeABeP+Xr2CP3TWFZiiU+3B6B2dnU2bRTU l2JRHizN+royhv/5trxZT/pHLU4ueyH+rLcc6A8xcOmFFb8pn6VKyJgOo/epv0dtrMxh 1PKdcKoRNdmQ6AoHDpP/OmY0QCuIDZvNS7vDj+IVQSNG+cBD+5ijfeyR/0ABkGxMKq68 UmUQ== X-Gm-Message-State: AODbwcBR8O6HNhh7PKKdWS+KZd8jxbEUX/bZR2Lfy+bzHhuqJl3f4yEl +apmLNpMTl1mxLgSljU= X-Received: by 10.107.15.198 with SMTP id 67mr2004642iop.128.1495809114548; Fri, 26 May 2017 07:31:54 -0700 (PDT) Received: from orthomyxoviridae.enova.com ([12.187.116.132]) by smtp.gmail.com with ESMTPSA id m4sm826436ith.5.2017.05.26.07.31.53 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 26 May 2017 07:31:54 -0700 (PDT) Subject: Re: Monitoring tool for Postgres Database To: pgsql-performance@postgresql.org References: From: gevans Message-ID: Date: Fri, 26 May 2017 09:31:48 -0500 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:52.0) Gecko/20100101 Thunderbird/52.1.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------0AB7B0F1B74E586EFE97533E" Content-Language: en-US X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org This is a multi-part message in MIME format. --------------0AB7B0F1B74E586EFE97533E Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 7bit +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 > > 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. > --------------0AB7B0F1B74E586EFE97533E Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

+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> 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.


--------------0AB7B0F1B74E586EFE97533E--