Forum OpenACS Development: PostgreSQL Query Analysis over time

Collapse
Posted by Mark Aufflick on
This project:

http://pqa.projects.postgresql.org/

summarizes data from the pg log to make an html page of slowest queries, most often run queries etc.

It's written in ruby, but by using the regex's in the code, it should be easy to re-implement in tcl.

It does, though, need a lot of logging turned on in the postgresql.conf.