Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 3741865047B
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue,  2 Sep 2008 15:47:32 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 67697-01-3
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Tue,  2 Sep 2008 15:47:19 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from web56407.mail.re3.yahoo.com (web56407.mail.re3.yahoo.com
	[216.252.111.86])
	by postgresql.org (Postfix) with SMTP id 941096508CC
	for <pgsql-performance@postgresql.org>;
	Tue,  2 Sep 2008 14:35:56 -0300 (ADT)
Received: (qmail 19681 invoked by uid 60001); 2 Sep 2008 17:35:54 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID;
	b=FM2b2kaQNDGEzQCrJ1L7GxWZJAplpwS26DZ4q79woQK3cpqMqpd9xnozIICanD6v5ZQDk6JB/yDjGwhDbZjJYwPL63eE2FVT17E17N+YtlX7v4CvNaB3HN4AUSKTV5Mb4dQw6lmZ1vMuMHDL3MlRd/qWoYvBACIb/qIPG9geI8w=;
X-YMail-OSG: 
 6IYvs2cVM1lfJsclWMMf_iRv5tsm0QYaYQs6mXfztIgXEtWUympFT1l3pk9ky5PwunIvUY3cCfwITaTqRvAPUYgv2w33qXtKDRubtT4p6w--
Received: from [198.119.134.32] by web56407.mail.re3.yahoo.com via HTTP;
	Tue, 02 Sep 2008 10:35:54 PDT
X-Mailer: YahooMailRC/1096.28 YahooMailWebService/0.7.218.2
Date: Tue, 2 Sep 2008 10:35:54 -0700 (PDT)
From: Jessica Richard <rjessil@yahoo.com>
Subject: logging options...
To: pgsql-performance@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-225933306-1220376954=:19452"
Message-ID: <580136.19452.qm@web56407.mail.re3.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200809/39
X-Sequence-Number: 31352

--0-225933306-1220376954=:19452
Content-Type: text/plain; charset=us-ascii

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



      
--0-225933306-1220376954=:19452
Content-Type: text/html; charset=us-ascii

<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><div>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.<br><br>log_statement = 'all'&nbsp; 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...<br><br>Thanks,<br>Jessica<br></div></div><br>

      </body></html>
--0-225933306-1220376954=:19452--