| From: | Ulrich Wisser <ulrich(dot)wisser(at)relevanttraffic(dot)se> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | How to know which queries are to be optimised? |
| Date: | 2004-08-04 12:00:39 |
| Message-ID: | 4110CFE7.9000202@relevanttraffic.se |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2004-08-04 12:02:41 | Re: Test case for bug fix in 7.4.3 |
| Previous Message | Bernd Helmle | 2004-08-04 09:21:59 | Re: Updateable Views? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Valerie Schneider DSI/DEV | 2004-08-04 12:44:43 | Tuning queries on large database |
| Previous Message | Pierre-Frédéric Caillaud | 2004-08-04 06:40:41 | Re: Performance Bottleneck |