From: Bobby Dewitt <Bdewitt@appriss.com>
To: Gregg Jaskiewicz <gryzman@gmail.com>
To: Venkat Balaji <venkat.balaji@verse.in>
Cc: Tomas Vondra <tv@fuzzy.cz>
Cc: Greg Smith <greg@2ndquadrant.com>
Cc: PGSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: PostgreSQL-9.0 Monitoring System to improve performance
Date: Fri, 30 Sep 2011 21:29:06 +0000
Message-ID: <CAABAA22.2B5B4%bdewitt@appriss.com> (raw)
In-Reply-To: <CAJY59_jaLqus5e1kVD2aEPaT-TNcxTjU8mE2faWYO2frZ3iXUQ@mail.gmail.com>
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" <gryzman@gmail.com> 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).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Bdewitt@appriss.com, gryzman@gmail.com, venkat.balaji@verse.in, tv@fuzzy.cz, greg@2ndquadrant.com
Subject: Re: PostgreSQL-9.0 Monitoring System to improve performance
In-Reply-To: <CAABAA22.2B5B4%bdewitt@appriss.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox