Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dECLj-0003y7-GK for pgsql-performance@arkaria.postgresql.org; Fri, 26 May 2017 10:20:03 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dECLi-0000AB-MP for pgsql-performance@arkaria.postgresql.org; Fri, 26 May 2017 10:20:02 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dECLh-00008z-Fv for pgsql-performance@postgresql.org; Fri, 26 May 2017 10:20:01 +0000 Received: from mail-qk0-x22b.google.com ([2607:f8b0:400d:c09::22b]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dECLe-0007I9-Vg for pgsql-performance@postgresql.org; Fri, 26 May 2017 10:20:00 +0000 Received: by mail-qk0-x22b.google.com with SMTP id a72so3901917qkj.2 for ; Fri, 26 May 2017 03:19:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=/WsN1XxptEy7pe5asZImnJs7Sa5efzWteVQWjNhFkA4=; b=a2GxMAtDmjzzou1/k8GzmJv6W6zAo+pzyJM0+N17NJF9Uq81Cp1YKCoFHrQK6HBWg9 h4vAEOfwDuZCWqEloZiu2bBLRPfU6T52D80SimmLsOxXjb9evAeDNELY4btJlGaPGqSo QZWJlUT/gLK5ybx4w09iMiOGJRoOWtM/dwTh8P6ctdeSszHzDz6VUWF4QsJA6aK3TH6J jP1dSoBYTI408VhzBPDRtS0g1isIwT8FzkHGarR6ncKrtdNVTTl4NMYfN8zsh4v+2lNY VeP0fNeuEH4oyuS2ZznIQpaUtKq9QXsYDIS3HbX3VzMOR1c9IsdEroZO5SCKKyvHhBwL 1+HQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=/WsN1XxptEy7pe5asZImnJs7Sa5efzWteVQWjNhFkA4=; b=BSpeb6NhxJ/f5XSDmKtImm8eVQqFXPojxa80IA9o9/3p3xQfQxjTRBgj8JvFejlf4k Y18WxQ8Mwmc/ICBsczIyZHqKl5u3AQFPOkqbzteCDFXqqfayBMtR2D2zWcvPFt+c8w0v keCmmnn+fBT5S7q/XpU54DEsoilwQUeNP1Fe+vo1KK9JGCn/T15Z++JgkniG+EptgBOS giCx1ZfjctAWrMiPhr5RW/Sr3wvWyGpMRtyRXvkvWXKzozBOZGeJXHgkzgGVufToD+yn G3gzMQ/NzAVcPoReg0j3a5GAXJzDhbnDbR0LM5twBSIQl+gq7TQIz2KU7A/33iSJCXbP wHrQ== X-Gm-Message-State: AODbwcDL09tjd5P0JBm/kBlDjc5+CaTFn5AJqJV2aq8fd+CA3AJ74mCa ZPW+0LWnirLvQ8cIfRkZHLPg+/WG0Q== X-Received: by 10.55.165.196 with SMTP id o187mr1117241qke.88.1495793997128; Fri, 26 May 2017 03:19:57 -0700 (PDT) MIME-Version: 1.0 Received: by 10.12.164.228 with HTTP; Fri, 26 May 2017 03:19:56 -0700 (PDT) In-Reply-To: References: From: Rick Otten Date: Fri, 26 May 2017 06:19:56 -0400 Message-ID: Subject: Re: Monitoring tool for Postgres Database To: "pgsql-performance@postgresql.org" Content-Type: multipart/alternative; boundary="94eb2c063c88db299e05506aadd9" 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 --94eb2c063c88db299e05506aadd9 Content-Type: text/plain; charset="UTF-8" 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. --94eb2c063c88db299e05506aadd9 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On T= hu, May 25, 2017 at 3:48 PM, Ravi Tammineni <rtammineni@p= artner.aligntech.com> wrote:

Hi,

=C2=A0

What is the best monitoring tool for Postgres databa= se? Something like Oracle Enterprise Manager.

=C2=A0

Specifically I am interested in tools to help:

=C2=A0

Alert DBAs to problems with both configuration and p= erformance issues

Deadlocks, Long running queries etc.,<= /p>

Monitoring of overall system performance

General performance tuning

Storage/Disk latencies

=C2=A0

=C2=A0

Thanks

ravi


We use Datadog.=C2= =A0 Their PostgreSQL plugin covers most of the most relevant stats.=C2=A0 I= t is easy to configure and not very expensive at all.=C2=A0 They have an ea= sy GUI based configuration for monitors and alerts, and you can link it wit= h something like Victorops and Slack for additional pager escalation polici= es.=C2=A0 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.

--94eb2c063c88db299e05506aadd9--