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.
>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).
