Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 227889FB39F for ; Tue, 6 Mar 2007 10:02:15 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 06547-02-6 for ; Tue, 6 Mar 2007 10:02:01 -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 196969FB31A for ; Tue, 6 Mar 2007 10:01:44 -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:49:09 +0100 Received: from DOMEXT-MTA by webaccess.indicator.bewith Novell_GroupWise; Tue, 06 Mar 2007 15:01:42 +0100 Message-Id: <45ED824B.A3DD.0030.0@indicator.be> X-Mailer: Novell GroupWise Internet Agent 7.0.1 Date: Tue, 06 Mar 2007 15:01:31 +0100 From: "Bart Degryse" To: "PostgreSQL" Cc: "Ezequias Rodrigues da Rocha" Subject: Re: Time of executed query References: <55c095e90703060520s3e4a1feej65f56cee46fd6700@mail.gmail.com><45 ED7A0A.A3DD.0030.0@indicator.be><55c095e90703060537q5f620430wbac3d3a8197673 f4@mail.gmail.com><55c095e90703060555h41df5050q37400142b869b624@mail.gmail.com> In-Reply-To: <55c095e90703060555h41df5050q37400142b869b624@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__Part9FBB3A2B.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.515 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/38 X-Sequence-Number: 27676 --=__Part9FBB3A2B.1__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable EXPLAIN ANALYZE is only for tuning purposes. Read the manual (http://www.postgresql.org/docs/8.1/interactive/sql-explain= .html) to get more insight >>> "Ezequias Rodrigues da Rocha" 2007-03-06 = 14:55 >>> EXPLAIN ANALYZE Is perfect but i have no idea of how to use it. My resultset is retrieving my rows. Another question that cames with the Analyze. PgAdmin return the time to retrieve the data or all time to fill the grid on the "SQL Editor". --=20 Ezequias Rodrigues da Rocha http://ezequiasrocha.blogspot.com/=20 use Mozilla Firefox:http://br.mozdev.org/firefox/ 2007/3/6, Shoaib Mir : > Did you try EXPLAIN ANALYZE ? > > --- > Shoaib Mir > EnterpriseDB (www.enterprisedb.com) > > > On 3/6/07, Ezequias Rodrigues da Rocha wrote: > > I preffer that the database give me this information. I don't know if > > it is possible becouse if we retrieve many rows and if we want to put > > this result in a new column the same time will be replicated many > > times and consuming more processing. > > > > Any other suggestion ? > > Ezequias > > > > 2007/3/6, Bart Degryse : > > > > > > > > > note the time just before your operation starts > > > note the time just after it ends > > > show timeafter - timebefore > > > > > > >>> "Ezequias Rodrigues da Rocha" = 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 ? > > > > > > -- > > > Ezequias Rodrigues da Rocha > > > http://ezequiasrocha.blogspot.com/=20 > > > use Mozilla Firefox: http://br.mozdev.org/firefox/=20 > > > > > > ---------------------------(end of > > > broadcast)--------------------------- > > > TIP 5: don't forget to increase your free space map settings > > > > > > > > > -- > > 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 > > > > --=__Part9FBB3A2B.1__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Description: HTML

EXPLAIN ANALYZE is only for tuning purposes.

Read the manual (http://www.postgresql.org/docs/8.1/interactive/sql-e= xplain.html) to get more insight

>>> "Ezequias = Rodrigues da Rocha" <ezequias.rocha@gmail.com> 2007-03-06 14:55 = >>>
EXPLAIN ANALYZE Is perfect but i have no idea of how to = use it. My
resultset is retrieving my rows.

Another question = that cames with the Analyze. PgAdmin return the time
to retrieve the = data or all time to fill the grid on the "SQL Editor".

--
Ezequi= as Rodrigues da Rocha
htt= p://ezequiasrocha.blogspot.com/
use Mozilla Firefox:http://br.mozdev= .org/firefox/

2007/3/6, Shoaib Mir <shoaibmir@gmail.com>:<= BR>> Did you try EXPLAIN ANALYZE <SQL Query>?
>
> = ---
> Shoaib Mir
> EnterpriseDB (www.enterprisedb.com)
><= BR>>
> On 3/6/07, Ezequias Rodrigues da Rocha <ezequias.rocha@g= mail.com> wrote:
> > I preffer that the database give me this = information. I don't know if
> > it is possible becouse if we = retrieve many rows and if we want to put
> > this result in a new = column the same time will be replicated many
> > times and = consuming more processing.
> >
> > Any other suggestion = ?
> > Ezequias
> >
> > 2007/3/6, Bart Degryse = <Bart.Degryse@indicator.be>:
> > >
> > = >
> > > note the time just before your operation starts
&= gt; > > note the time just after it ends
> > > show = timeafter - timebefore
> > >
> > > >>> = "Ezequias Rodrigues da Rocha" <ezequias.rocha@gmail.com > 2007-03-06<= BR>> > > 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 ?
> > >
> > > --
> > > = Ezequias Rodrigues da Rocha
> > > http://ezequiasrocha.blogspot.com/
> > > = use Mozilla Firefox: http://br.mo= zdev.org/firefox/
> > >
> > > -----------------= ----------(end of
> > > broadcast)---------------------------> > > TIP 5: don't forget to increase your free space map = settings
> > >
> >
> >
> > = --
> > Ezequias Rodrigues da Rocha
> > http://ezequiasrocha.blogspot.com/
>= > use Mozilla Firefox:http://br.mozdev.org/firefox/
> >
>= ; > ---------------------------(end of
> broadcast)---------------= ------------
> > TIP 5: don't forget to increase your free space = map settings
> >
>
>

--=__Part9FBB3A2B.1__=--