From: Guillaume Lelarge <guillaume@lelarge.info>
To: Jessica Richard <rjessil@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: logging options...
Date: Tue, 02 Sep 2008 20:55:01 +0200
Message-ID: <48BD8C05.1040008@lelarge.info> (raw)
In-Reply-To: <580136.19452.qm@web56407.mail.re3.yahoo.com>
References: <580136.19452.qm@web56407.mail.re3.yahoo.com>
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.orghttp://dalibo.com
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: guillaume@lelarge.info, rjessil@yahoo.com
Subject: Re: logging options...
In-Reply-To: <48BD8C05.1040008@lelarge.info>
* 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