Re: postgres query log analysis?

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/