Re: PostgreSQL-9.0 Monitoring System to improve performance

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(at)gmail(dot)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).