pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedlogging options...
2+ messages / 2 participants
[nested] [flat]
* logging options...
@ 2008-09-02 17:35 Jessica Richard <rjessil@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: Jessica Richard @ 2008-09-02 17:35 UTC (permalink / raw)
To: pgsql-performance
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...
Thanks,
Jessica
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: logging options...
@ 2008-09-02 18:55 Guillaume Lelarge <guillaume@lelarge.info>
parent: Jessica Richard <rjessil@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Guillaume Lelarge @ 2008-09-02 18:55 UTC (permalink / raw)
To: Jessica Richard <rjessil@yahoo.com>; +Cc: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-09-02 18:55 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-09-02 17:35 logging options... Jessica Richard <rjessil@yahoo.com>
2008-09-02 18:55 ` Guillaume Lelarge <guillaume@lelarge.info>
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