Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8D8136505D6 for ; Tue, 2 Sep 2008 16:41:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 26526-03-4 for ; Tue, 2 Sep 2008 16:41:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sd-2317.dedibox.fr (sd-2317.dedibox.fr [88.191.17.192]) by postgresql.org (Postfix) with ESMTP id 3B3E76504DB for ; Tue, 2 Sep 2008 15:55:04 -0300 (ADT) Received: from [192.168.10.64] (ASte-Genev-Bois-153-1-80-122.w86-203.abo.wanadoo.fr [86.203.226.122]) by sd-2317.dedibox.fr (Postfix) with ESMTP id 50BF8385F; Tue, 2 Sep 2008 20:55:01 +0200 (CEST) Message-ID: <48BD8C05.1040008@lelarge.info> Date: Tue, 02 Sep 2008 20:55:01 +0200 From: Guillaume Lelarge User-Agent: Thunderbird 2.0.0.16 (X11/20080724) MIME-Version: 1.0 To: Jessica Richard CC: pgsql-performance@postgresql.org Subject: Re: logging options... References: <580136.19452.qm@web56407.mail.re3.yahoo.com> In-Reply-To: <580136.19452.qm@web56407.mail.re3.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200809/40 X-Sequence-Number: 31353 Jessica Richard a écrit : > for a short test purpose, I would like to see what queries are running > and how long each of them takes.....by reconfiguring postgres.conf on > the server level. > > log_statement = 'all' is giving me the query statements.. but I don't > know where I can turn "timing" on just like what I can run from the > command line "\timing'....to measure how long each of the queries takes > to finish... > Either you configure log_statement to all, ddl or mod and log_duration to on, either you configure log_min_duration_statement to 0. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com