Hi, 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. Ciao, Thomas -- Thomas Pundt <[EMAIL PROTECTED]> ---- http://rp-online.de/ ---- ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
