On Tuesday 21 March 2006 09:25, Marco Furetto wrote:
| I'm managing the db of a "Content Management environment" and I'm
| searching for a "Query analyzer" to improve performance because i don't
| know how many and what type of queries are executing on the system (for
| the "where and join" block).
as a first step, I'd enable query duration logging; in postgresql.conf
I have set
log_min_duration_statement = 3000
this will log each query that needs more than 3 seconds to complete.
The next step would be to "explain analyze" the problematic queries.
Thomas Pundt <thomas(dot)pundt(at)rp-online(dot)de> ---- http://rp-online.de/ ----
In response to
pgsql-performance by date
|Next:||From: Jim C. Nasby||Date: 2006-03-21 09:50:49|
|Subject: Re: planner with index scan cost way off actual cost, advices to tweak cost constants?|
|Previous:||From: Marco Furetto||Date: 2006-03-21 08:25:50|
|Subject: Re: Query Feromance|