Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dDyke-0007hd-2a for pgsql-performance@arkaria.postgresql.org; Thu, 25 May 2017 19:48:52 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dDykd-0004dP-KE for pgsql-performance@arkaria.postgresql.org; Thu, 25 May 2017 19:48:51 +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 1dDykc-0004cZ-Lg; Thu, 25 May 2017 19:48:50 +0000 Received: from mail-by2nam01on0108.outbound.protection.outlook.com ([104.47.34.108] helo=NAM01-BY2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dDykZ-0006lr-0D; Thu, 25 May 2017 19:48:49 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aligntech.onmicrosoft.com; s=selector1-partner-aligntech-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=JpjAbxq5XJw5+OYLN1UThS9Bajd9pMFMy7bRN1vos7M=; b=aef8Gw90cvmhw2Uo16AwyvZwzs8ml2vEKW6AY55Du8GgQ6HVw/G0HwMV9nxx5JzYPYApgHtaRb5qHaGHyelYrkkbSXqst/WN1yrdGZYdhjQyUPi0ly2HO0Jd/msCteSauPGBrllB6p6Wfgxrwjsh40/etBcZlpNx7acKg0hAnIA= Received: from DM5PR02MB2651.namprd02.prod.outlook.com (10.168.196.17) by DM5PR02MB2650.namprd02.prod.outlook.com (10.168.196.16) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256_P256) id 15.1.1124.9; Thu, 25 May 2017 19:48:44 +0000 Received: from DM5PR02MB2651.namprd02.prod.outlook.com ([10.168.196.17]) by DM5PR02MB2651.namprd02.prod.outlook.com ([10.168.196.17]) with mapi id 15.01.1124.009; Thu, 25 May 2017 19:48:44 +0000 From: Ravi Tammineni To: "pgsql-admin@postgresql.org" , "pgsql-performance@postgresql.org" Subject: Monitoring tool for Postgres Database Thread-Topic: Monitoring tool for Postgres Database Thread-Index: AdLVj9FOfQRA9wtBS9ClTKVubuIL9Q== Date: Thu, 25 May 2017 19:48:43 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: postgresql.org; dkim=none (message not signed) header.d=none;postgresql.org; dmarc=none action=none header.from=partner.aligntech.com; x-originating-ip: [216.34.141.80] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;DM5PR02MB2650;7:y4eNXIdLhgDdpGgAGiAFoiC3nZ4D+dLbnBvoGUmpzq5an4tf0Cq/IBTzz+MEenPE0j8ut3UEnY7YxrP5E8IZVP8LH/70bkZkkBq1cFXQ+M0nKzOaCufIfWguZhbptB2HeaGSxiy+a/mwRkUbKvoO/zQ674pA8c+npcK8AhjyRi3OD+S5v0z9+yWaux9TfipNe2CuDdr70wDgal/hYuwPqmjm/GsmwEadLETVN3bR3B3Dn0rpHZ3UVwpsKImymu9hqfArl80u2HIQbQACI/M8K9z4ittX4FVpm5Mzt8uct4oQuxIq4RTWqx2zVDyZlTxJOq+ErPLQLANBw3Wi4wVIDw== x-ms-traffictypediagnostic: DM5PR02MB2650: x-ms-office365-filtering-correlation-id: 2b5dbea4-2a09-4519-ec53-08d4a3a70d20 x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001)(2017030254075)(201703131423075)(201703031133081);SRVR:DM5PR02MB2650; x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:(72170088055959)(21748063052155); x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(6040450)(601004)(2401047)(8121501046)(5005006)(10201501046)(3002001)(93006095)(93001095)(6041248)(20161123558100)(201703131423075)(201702281528075)(201703061421075)(201703061406153)(20161123560025)(20161123555025)(20161123562025)(20161123564025)(6072148);SRVR:DM5PR02MB2650;BCL:0;PCL:0;RULEID:;SRVR:DM5PR02MB2650; x-forefront-prvs: 0318501FAE x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(6009001)(39840400002)(39400400002)(39850400002)(39410400002)(39450400003)(77096006)(3280700002)(5660300001)(54896002)(55016002)(74316002)(8676002)(99286003)(6306002)(3660700001)(50986999)(450100002)(3846002)(8936002)(54356999)(38730400002)(81166006)(6506006)(86362001)(7736002)(2906002)(790700001)(122556002)(2900100001)(102836003)(42882006)(478600001)(9326002)(7696004)(66066001)(2501003)(9686003)(189998001)(53936002)(33656002)(25786009);DIR:OUT;SFP:1102;SCL:1;SRVR:DM5PR02MB2650;H:DM5PR02MB2651.namprd02.prod.outlook.com;FPR:;SPF:None;MLV:sfv;LANG:en; spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: multipart/alternative; boundary="_000_DM5PR02MB2651EEE74D84F7F1AD07413F80FF0DM5PR02MB2651namp_" MIME-Version: 1.0 X-OriginatorOrg: partner.aligntech.com X-MS-Exchange-CrossTenant-originalarrivaltime: 25 May 2017 19:48:43.8457 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: 9ac44c96-980a-481b-ae23-d8f56b82c605 X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM5PR02MB2650 X-Pg-Spam-Score: -1.9 (-) 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 --_000_DM5PR02MB2651EEE74D84F7F1AD07413F80FF0DM5PR02MB2651namp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, What is the best monitoring tool for Postgres database? Something like Orac= le 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 --_000_DM5PR02MB2651EEE74D84F7F1AD07413F80FF0DM5PR02MB2651namp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

 

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

 

Specifically I am interested in tools to help:<= /o:p>

 

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

Deadlocks, Long running queries etc.,

Monitoring of overall system performance<= /p>

General performance tuning

Storage/Disk latencies

 

 

Thanks

ravi

--_000_DM5PR02MB2651EEE74D84F7F1AD07413F80FF0DM5PR02MB2651namp_--