Re: PostgreSQL-9.0 Monitoring System to improve performance

pgwatch might also be worth taking a look at:
http://www.cybertec.at/en/postgresql_products/pgwatch-cybertec-enterprise-postgresql-monitor

Fernando.-

On Fri, Sep 30, 2011 at 18:29, Bobby Dewitt <Bdewitt(at)appriss(dot)com> wrote:

> 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).
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>