| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Jessica Richard <rjessil(at)yahoo(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: logging options... |
| Date: | 2008-09-02 18:55:01 |
| Message-ID: | 48BD8C05.1040008@lelarge.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matt Smiley | 2008-09-02 19:38:19 | Re: limit clause breaks query planner? |
| Previous Message | Jessica Richard | 2008-09-02 17:35:54 | logging options... |