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
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
