Hello,
my web application grows slower and slower over time. After some
profiling I came to the conclusion that my SQL queries are the biggest
time spenders (25 seconds). Obviously I need to optimise my queries and
maybe introduce some new indexes.
The problem is, that my application uses dynamic queries. I therefor can
not determine what are the most common queries.
I have used the postgresql logging ption before. Is there a tool to
analyze the logfile for the most common and/or most time consuming queries?
TIA
Ulrich