logging options...

From: Jessica Richard <rjessil(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: logging options...
Date: 2008-09-02 17:35:54
Message-ID: 580136.19452.qm@web56407.mail.re3.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Guillaume Lelarge 2008-09-02 18:55:01 Re: logging options...
Previous Message Greg Smith 2008-09-02 17:28:45 Re: too many clog files