Re: logging options...

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