From: Thomas Pundt <mlists@rp-online.de>
To: pgsql-performance@postgresql.org
Subject: Re: Query Feromance
Date: Tue, 21 Mar 2006 09:43:57 +0100
Message-ID: <200603210943.57454.mlists@rp-online.de> (raw)
In-Reply-To: <441FB88E.2060801@bluestudio.it>
References: <441EC34D.1000901@bluestudio.it>
<001301c64c3c$3404b3f0$8b00000a@reimer>
<441FB88E.2060801@bluestudio.it>
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 <thomas.pundt@rp-online.de> ---- http://rp-online.de/ ----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mlists@rp-online.de
Subject: Re: Query Feromance
In-Reply-To: <200603210943.57454.mlists@rp-online.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox