Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dE1oo-00049y-3F for pgsql-admin@arkaria.postgresql.org; Thu, 25 May 2017 23:05:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dE1om-0002od-Qq for pgsql-admin@arkaria.postgresql.org; Thu, 25 May 2017 23:05:20 +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 1dE1ol-0002lW-9d; Thu, 25 May 2017 23:05:19 +0000 Received: from mail-oi0-x22d.google.com ([2607:f8b0:4003:c06::22d]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1dE1oj-00029Y-0a; Thu, 25 May 2017 23:05:18 +0000 Received: by mail-oi0-x22d.google.com with SMTP id l18so298446591oig.2; Thu, 25 May 2017 16:05:16 -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=FgbBlG7zqgNuuWFpssfP5qziENbQTKQiXJWccbw3Cv8=; b=bamN/YTUcfTevio+kigVOUQgUpyo/nZfYBevmQwdqsmEhy8IiNa2Po0y1+Dwrv41YY i7+Xy+uwT+IturYzoc+v4KJhwztQwenL/q6VrU4rEz4A2ditqKZi13d5bhijewaioAhp qRAKNbsKLHrL1eO4WbaoLl/3IkHtWjgPJJcW/+tOmvnTLXvg4Yk8vnKnWFAhsCwTnq93 Z/bg2sJk1GqYifTvJGTpSzd42QeNtQrRIr+1jiThB9+tYkSIMrE/ZocfuuOf2ndp/rvl ZTs4wXwCaRAtMak6DXSDx6qOZbccKkDZ7nAnHzdjDY15RGpmbJgvb5JiomNSwhXHqC2D oYRA== 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=FgbBlG7zqgNuuWFpssfP5qziENbQTKQiXJWccbw3Cv8=; b=X1dbtOqecWThgl2S32GhLjzUJ94T0W9kirX8PvEr+K/dc4fyM+UrYw5kfwdeDFPMGu uaS1IZetOy6wcYlRJMdGG0KpDM9boEIA5UxRUMlEw/EiBisxcmvPPxZ5pG/0wefcR2Sq VR4XdyMcw+2og4Dro191El5Qc+LfO8wInAjPEb7oGLim7lNi4rMIMXcuWqik/pZO8oCS bXgD3KdYz9kCQaglmeRe3OM5K44eq6/Mm9UuOadkRxNcKMDzV06uEH3FS1K2ogj3Utw4 7ZkhR9iejc8F8nGZEvh3YqYXOq9qQotMxOgul7IFigmMKP0ws63g4zSoL3kWeGxkUOIE LdSw== X-Gm-Message-State: AODbwcBp/nrbYppxGf7lzuJDMq34oNg8h0AkJ8CWu/7eU83xJGUKWGro 8iKNp/xP2ouILKy3/bX2pwtKS3loog== X-Received: by 10.157.89.213 with SMTP id u21mr7994307otg.95.1495753516433; Thu, 25 May 2017 16:05:16 -0700 (PDT) MIME-Version: 1.0 Received: by 10.157.60.243 with HTTP; Thu, 25 May 2017 16:05:15 -0700 (PDT) In-Reply-To: References: From: Gary Evans Date: Fri, 26 May 2017 09:05:15 +1000 Message-ID: Subject: Re: [PERFORM] Monitoring tool for Postgres Database To: Ravi Tammineni Cc: "pgsql-admin@postgresql.org" , "pgsql-performance@postgresql.org" Content-Type: multipart/alternative; boundary="f4030435c02004c8820550614153" X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --f4030435c02004c8820550614153 Content-Type: text/plain; charset="UTF-8" Hi Ravi, > What is the best monitoring tool for Postgres database? Something like > Oracle Enterprise Manager. > If you're an existing user of OEM, there is a PostgreSQL plugin for it by Blue Medora (believe it is commercial). You might like to have a look at it. > > > 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 > Cheers Gary --f4030435c02004c8820550614153 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Hi Ravi,=C2=A0
=C2=A0

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

<= div>
If you're an existing user of OEM, there is a Postgr= eSQL plugin for it by Blue Medora (believe it is commercial).=C2=A0 You mig= ht like to have a look at it.=C2=A0

=

=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


Cheers
Gary
--f4030435c02004c8820550614153--