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