Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id E71799FB3A9
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue,  6 Mar 2007 09:31:32 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024)
	with ESMTP id 48282-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue,  6 Mar 2007 09:31:28 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from interscan.indicator.com (mail.indicator.be [193.121.199.3])
	by postgresql.org (Postfix) with ESMTP id 491D29FB7C3
	for <pgsql-sql@postgresql.org>; Tue,  6 Mar 2007 09:26:28 -0400 (AST)
Received: from webaccess.indicator.be ([10.100.1.7]) by
	interscan.indicator.com with InterScan Message Security Suite;
	Tue, 06 Mar 2007 14:13:52 +0100
Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise;
	Tue, 06 Mar 2007 14:26:25 +0100
Message-Id: <45ED7A0A.A3DD.0030.0@indicator.be>
X-Mailer: Novell GroupWise Internet Agent 7.0.1 
Date: Tue, 06 Mar 2007 14:26:18 +0100
From: "Bart Degryse" <Bart.Degryse@indicator.be>
To: "PostgreSQL" <pgsql-sql@postgresql.org>
Cc: "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com>
Subject: Re: Time of executed query
References: <55c095e90703060520s3e4a1feej65f56cee46fd6700@mail.gmail.com>
In-Reply-To: <55c095e90703060520s3e4a1feej65f56cee46fd6700@mail.gmail.com>
Mime-Version: 1.0
Content-Type: multipart/alternative;
	boundary="=__Part4165E4EA.1__="
X-imss-version: 2.046
X-imss-result: Passed
X-imss-approveListMatch: *@indicator.be
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.545 tagged_above=0 required=5 tests=AWL, BAYES_50,
	FORGED_RCVD_HELO, HTML_30_40, HTML_MESSAGE, UNPARSEABLE_RELAY
X-Spam-Level: 
X-Archive-Number: 200703/29
X-Sequence-Number: 27667

--=__Part4165E4EA.1__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

note the time just before your operation starts
note the time just after it ends
show timeafter - timebefore

>>> "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com> 2007-03-06 =
14:20 >>>
Hi list,

It is possible to retrieve the time of a SQL statement leads to
execute ? I would like to put in my application how much time each
operation leads to finish.

Any suggestion ?

--=20
Ezequias Rodrigues da Rocha
http://ezequiasrocha.blogspot.com/=20
use Mozilla Firefox:http://br.mozdev.org/firefox/

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

--=__Part4165E4EA.1__=
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-15=
">
<META content=3D"MSHTML 6.00.2800.1264" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma">
<DIV>note the time just before your operation starts</DIV>
<DIV>note the time just after it ends</DIV>
<DIV>show timeafter - timebefore<BR><BR>&gt;&gt;&gt; "Ezequias Rodrigues =
da Rocha" &lt;ezequias.rocha@gmail.com&gt; 2007-03-06 14:20 &gt;&gt;&gt;<BR=
>Hi list,<BR><BR>It is possible to retrieve the time of a SQL statement =
leads to<BR>execute ? I would like to put in my application how much time =
each<BR>operation leads to finish.<BR><BR>Any suggestion ?<BR><BR>-- =
<BR>Ezequias Rodrigues da Rocha<BR><A href=3D"http://ezequiasrocha.blogspot=
.com/">http://ezequiasrocha.blogspot.com/</A><BR>use Mozilla Firefox:http:/=
/br.mozdev.org/firefox/<BR><BR>---------------------------(end of =
broadcast)---------------------------<BR>TIP 5: don't forget to increase =
your free space map settings<BR></DIV></BODY></HTML>

--=__Part4165E4EA.1__=--