Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 2979BB5DBD6
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue, 11 Oct 2011 16:08:39 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 45675-05
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Tue, 11 Oct 2011 19:08:33 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.8.0-rc2
Received: from nm29.bullet.mail.sp2.yahoo.com (nm29.bullet.mail.sp2.yahoo.com
	[98.139.91.99])
	by mail.postgresql.org (Postfix) with SMTP id AE905B5DBC7
	for <pgsql-performance@postgresql.org>;
	Tue, 11 Oct 2011 16:08:32 -0300 (ADT)
Received: from [98.139.91.69] by nm29.bullet.mail.sp2.yahoo.com with NNFMP;
	11 Oct 2011 19:08:31 -0000
Received: from [98.139.91.41] by tm9.bullet.mail.sp2.yahoo.com with NNFMP;
	11 Oct 2011 19:08:31 -0000
Received: from [127.0.0.1] by omp1041.mail.sp2.yahoo.com with NNFMP;
	11 Oct 2011 19:08:31 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 574945.6613.bm@omp1041.mail.sp2.yahoo.com
Received: (qmail 90802 invoked by uid 60001); 11 Oct 2011 19:08:31 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1318360111; bh=1gJeFUjOry7dEAZ+vQU9u2hZEnus8u+BZLytWqNN6Ro=;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
	b=HodEviGl71SGodrKOxi6D6hgeo0ZvSpNP+qkIJ0utNB8ujoUUg4rNznY3/f3aatTQ0Ql2gIWS1jpTPlRRzUaYrUPDqf3g4nGZaZ3zGtDdnYT/WPnGo2V3obhsKKaj7V+/PSfQe1lKK15aK5AhwL/xS+W/Z5q8iDlQs2vJPYpS5w=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
	b=THAagcP2N/7m5PpTvTHaXdsP6/1GWU9J7VwJAZvXCXFdii0WtQeJFaxKCAiEVDkpk+F7IriiehoUjqdpRTPsh1kBDn3GOCxONKadi6oiWTlOmjmqjI58HIBF12Oy5Cb8CiRq2pYPG7R87BcaS48LLq5jeo42OUYodNAgdyN+pxM=;
X-YMail-OSG: Vz8ZwmMVM1l44IFcKsJK19jwTtVoDtF9l.L3iRddOoWvBnZ
	x9tWzzQX.KM.T51byxrCXelGZjH9Ue9laAM_JOO_pOkzjacn2qrdjxcbg3Hv
	wxsTCEEwvEH4GVjVVeLiQ7k1V3JzlWsf1w_MYpzQIEDgDZnN5OR2v81Vcq0D
	pjs0uk67PJFkEY2Y2FgVpyB4S76108ZKIsSL6x.BkStJEGoN4_fs6sM3TC2s
	PzEfo_yUe7nHHEykwVN0G4W7V9sGpCr1AsjMqCy04NYFBLL88bBWOw1ypZl0
	qZA1DM7gjxoHeayPzH4s0PFrg1gnS6GAAIjePslDkBEHQZ3Dk8Xf4OCgd2hK
	a2_xAZ08hOg3fuNKgjEpletu8bNjbUyRyMmZfq_YKaS7Jb6idjykCDxgRkIe
	G38BkOAfWGJMv8DaGMNPAB.yTi4sLvhNWsDYCkraRCyuIecO76NmzWGVNKvi E4sc-
Received: from [41.239.67.14] by web38602.mail.mud.yahoo.com via HTTP;
	Tue, 11 Oct 2011 12:08:31 PDT
X-Mailer: YahooMailWebService/0.8.114.317681
Message-ID: <1318360111.86763.YahooMailNeo@web38602.mail.mud.yahoo.com>
Date: Tue, 11 Oct 2011 12:08:31 -0700 (PDT)
From: Radhya sahal <rad_cs_2006@yahoo.com>
Reply-To: Radhya sahal <rad_cs_2006@yahoo.com>
Subject: postgresql  query runtime 
To: pgsql-performance group <pgsql-performance@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="-2114655128-1273045726-1318360111=:86763"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.151 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=0.1, FREEMAIL_FROM=0.001,
	FREEMAIL_REPLYTO_END_DIGIT=1.151, HTML_MESSAGE=0.001,
	RCVD_IN_DNSWL_NONE=-0.0001, RP_MATCHES_RCVD=-0.504
X-Spam-Level: 
X-Archive-Number: 201110/111
X-Sequence-Number: 45333

---2114655128-1273045726-1318360111=:86763
Content-Type: text/plain; charset=us-ascii

Hi 

I want to know how can i measure runtime query in postgresql if i use command line psql?
not explain rutime for the query such as the runtime which appear in pgadmin ?
such as Total query runtime: 203 ms.
---2114655128-1273045726-1318360111=:86763
Content-Type: text/html; charset=us-ascii

<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:14pt"><div>Hi <br></div><div>I want to know how can i measure runtime query in postgresql if i use command line psql?</div><div>not explain rutime for the query such as the runtime which appear in pgadmin ?</div><div>such as Total query runtime: 203 ms.<br></div><div></div></div></body></html>
---2114655128-1273045726-1318360111=:86763--