George Pavlov wrote:
Look into pgfouine on pgFoundry.
http://pgfoundry.org/projects/pgfouine/
thanks! definitely much better, but still not entirely believable, at
least on first try. e.g. i have a query with 4 conditions in the ORDER
BY. pgfouine reports show the query as having the last 3 of those
repeated 18 times! it also fails to normalize a lot of the queries
(seems related to prepared statements). the "queries by type" and the
"hourly reports" are way off (the "queries by type" table has no rows,
the total queries in the hourly statistics section do not match the
number of queries count in the "overall statistics" section and the
select and "write" queries parts all show as 0). all of these problems
are in syslog mode, stderr mode is probably a bit worse. i will play
with the tool some more and try to diagnose the various problems better.
Narrow down the problems it's having to some sample cases and post
bug-reports. That's the best way to contribute and "fix" the problem.
--
Postgresql & php tutorials
http://www.designmagick.com/
