Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id B6B5DB5D803 for ; Fri, 30 Sep 2011 18:34:27 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 98003-09 for ; Fri, 30 Sep 2011 21:34:21 +0000 (UTC) X-Greylist: delayed 00:05:08.049117 by SQLgrey-1.8.0-rc2 Received: from prodcexchcas03.int.appriss.com (prodcexchcas03.int.appriss.com [64.6.216.166]) by mail.postgresql.org (Postfix) with ESMTP id 73BA8B5D801 for ; Fri, 30 Sep 2011 18:34:21 -0300 (ADT) Received: from prodcexch02.int.appriss.com ([::1]) by prodcexchcas03.int.appriss.com ([fe80::89d7:fb21:1de1:b4b8%10]) with mapi id 14.01.0323.003; Fri, 30 Sep 2011 17:29:06 -0400 From: Bobby Dewitt To: Gregg Jaskiewicz , Venkat Balaji CC: Tomas Vondra , Greg Smith , PGSQL Performance Subject: Re: PostgreSQL-9.0 Monitoring System to improve performance Thread-Topic: PostgreSQL-9.0 Monitoring System to improve performance Thread-Index: AQHMf7f67KFzs8Y8zkWoWnqLCdxagw== Date: Fri, 30 Sep 2011 21:29:06 +0000 Message-ID: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.13.0.110805 x-originating-ip: [10.10.14.22] Content-Type: text/plain; charset="us-ascii" Content-ID: Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.404 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RP_MATCHES_RCVD=-0.504 X-Spam-Level: X-Archive-Number: 201109/445 X-Sequence-Number: 45221 EnterpriseDB now has Postgres Enterprise Manager (http://enterprisedb.com/products-services-training/products/postgres-enter prise-manager) that has some of the information that is being asked for. It has a hot table analysis report that shows the number of scans, rows read, etc. Since much of the tool is using the pgAdmin code base, much of this is also available in pgAdmin but PEM will track the statistics at given intervals and show you trending graphs over time. It's still a very new tool so I'm sure they are working to add new features and have been looking for enhancement suggestions. Of course, it requires a service contract with them to use the tool, but it doesn't cost extra to add the tool if you already have a contract with them. It does have a 45 day evaluation if you wanted to check it out. Hope that helps. Bobby On 9/30/11 7:53 AM, "Gregg Jaskiewicz" wrote: >Looks like this is generally an area that can be targeted by some >businesses. Or an open source enthusiast. >One centre that captures all the information and produces a report >based on it would be a great thing. Especially in cases like mine, >where I have tens of postgresql installations on different hardware >and with different use patterns (but schemas and queries are the >same).