Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dEGFw-00042u-M2 for pgsql-performance@arkaria.postgresql.org; Fri, 26 May 2017 14:30:20 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dEGFv-0002Lu-JK for pgsql-performance@arkaria.postgresql.org; Fri, 26 May 2017 14:30:19 +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 1dEGE7-0004Vv-Ea; Fri, 26 May 2017 14:28:27 +0000 Received: from mail-it0-x22b.google.com ([2607:f8b0:4001:c0b::22b]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dEGE3-0004Dh-Uv; Fri, 26 May 2017 14:28:26 +0000 Received: by mail-it0-x22b.google.com with SMTP id c15so74646357ith.0; Fri, 26 May 2017 07:28:23 -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 :cc; bh=SEpJp1EpFVf1l8JuD6NW8WslYmZQRph9SNtkFujgmRQ=; b=gLXVK9NkUljQKgdoFPfUz7BRtygGr6xPLspQICwYALEv012DEEWHbE5Lzn8otwhMDI 0IV6cccRQFZlnwVpQzkGF32HNtEaL9Dspbl45sk99FKyU9gLqXxg1T0hU84owosKJt79 YZSSEQmnyLsAKrsOBLUPh6SPm/hWbZBtb+mA7zMaNtqeAGsrBAZ6rKxuYeu6LmfHxcWP t2/bavVlzrIDDlI4DXQQtK9kDmHMl+6SxPHu6J52VD19pjb4Do+E6dDagJC8VqN4oBzZ Lc/Y359gm4dsX4sD5xCJnXQ1hhWExaddClA8xw/k96T3DubHUwpwuvKP3tulz7AbRLyO X4kw== 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:cc; bh=SEpJp1EpFVf1l8JuD6NW8WslYmZQRph9SNtkFujgmRQ=; b=AYncHpX+CGDdYV14yN9EY9rCmW0GrKYH6NLslLuRDWt+/JX8ndK77q4GgQGIUzTOw5 YLqOyjbBgqQqgYIo5R4kDdOQLjZD8zBwm08lsNNZil8tbZFNJWXD551MMeChvbYHsdt6 MfGg+tdNbsuzIdUp8b/db7yemxukb5xdVLVp+Yv7Ux6mi8rkQ/R2qVXsXAeDVaKWIso5 LX0muWAkvVA7NeuAS6/8iyoBLGY6E81I6WobPRtV1ZCw/fRRRbUt2/d7UDGkqaU8NjaH LT60DF8MrGuiorqfWkm9mAIgkLjH0GebflCBaLS1xxOB+1xt4qbRh6bcRzA0qkow/Cvx 0HsQ== X-Gm-Message-State: AODbwcAaoEpTch6L95IpeB9sGENr/gO8hoscW5Aw4ADkJgydqmdcY7JT ihtQQV0KmZv2FvMYJs+KK6OWYVqT8mXA X-Received: by 10.36.127.200 with SMTP id r191mr3068296itc.91.1495808902992; Fri, 26 May 2017 07:28:22 -0700 (PDT) MIME-Version: 1.0 Received: by 10.79.52.200 with HTTP; Fri, 26 May 2017 07:28:22 -0700 (PDT) Received: by 10.79.52.200 with HTTP; Fri, 26 May 2017 07:28:22 -0700 (PDT) In-Reply-To: References: From: Ashish Tiwari Date: Fri, 26 May 2017 19:58:22 +0530 Message-ID: Subject: Re: [ADMIN] Monitoring tool for Postgres Database To: Ravi Tammineni Cc: "pgsql-performance@postgresql.org" , pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary="001a1147c91e50991f05506e26a9" X-Pg-Spam-Score: -1.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 --001a1147c91e50991f05506e26a9 Content-Type: text/plain; charset="UTF-8" Hi Ravi, We use the nagios to monitor the Postgresql Database . Nagios provide the dedicated API for Postgresql and you can customize the same. Thanks. On May 26, 2017 1:19 AM, "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 > --001a1147c91e50991f05506e26a9 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Ravi,

We = use the nagios to monitor the Postgresql Database . Nagios provide the dedi= cated API for Postgresql and you can customize the same.

Thanks.

On May 26, 2017 1:19 AM, "Ravi Tamm= ineni" <rtammin= eni@partner.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

--001a1147c91e50991f05506e26a9--