Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 48A869FB5DF for ; Tue, 6 Mar 2007 10:01:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 03138-03-5 for ; Tue, 6 Mar 2007 10:01:12 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.250]) by postgresql.org (Postfix) with ESMTP id B935D9FBB89 for ; Tue, 6 Mar 2007 09:59:50 -0400 (AST) Received: by an-out-0708.google.com with SMTP id c24so1646061ana for ; Tue, 06 Mar 2007 05:59:49 -0800 (PST) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=r6poii07mmRHwLNfP32rGAQ6g/DjdCYcE4tW2pm3P9zWqQ1BRf5Dkf+cLijDofEHEaphr78i94s+u6XDxh6OU/jyEImv6E6/uhgwwho1ZVEBhVEq1bmLygr6OYOZOFE9x9TjfDca1W4hVG92vASgGaMZYyKD0hzAzhPqJ3Z1FAk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=m7SQ6AfP+K0gvU+U1xJuzO2vdNkaM2nSZmMNHUCOf2qnaj5eR+FKFH68BA+Jh/VpfpDcGRzklKP/dbhkMDY4N+BGMLQ5EKyinbptzt6vuZfwZh3ZnLj8SCCO52TtcFNg9vptmNl+kas285un2nm6KAjG0NInv7nUZnbNEGA2H6A= Received: by 10.100.133.9 with SMTP id g9mr3339935and.1173189589379; Tue, 06 Mar 2007 05:59:49 -0800 (PST) Received: by 10.100.38.6 with HTTP; Tue, 6 Mar 2007 05:59:49 -0800 (PST) Message-ID: Date: Tue, 6 Mar 2007 18:59:49 +0500 From: "Shoaib Mir" To: "Ezequias Rodrigues da Rocha" Subject: Re: [SQL] Time of executed query Cc: "Bart Degryse" , PostgreSQL , Pgadmin-Support In-Reply-To: <55c095e90703060555h41df5050q37400142b869b624@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_49827_15532334.1173189589341" References: <55c095e90703060520s3e4a1feej65f56cee46fd6700@mail.gmail.com> <45ED7A0A.A3DD.0030.0@indicator.be> <55c095e90703060537q5f620430wbac3d3a8197673f4@mail.gmail.com> <55c095e90703060555h41df5050q37400142b869b624@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL, BAYES_40, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200703/20 X-Sequence-Number: 6735 ------=_Part_49827_15532334.1173189589341 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline EXPLAIN ANALYZE does give the query execution time at the end of its output. -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 3/6/07, Ezequias Rodrigues da Rocha wrote: > > 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". > > -- > Ezequias Rodrigues da Rocha > http://ezequiasrocha.blogspot.com/ > 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/ > > > > use Mozilla Firefox: http://br.mozdev.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 > > > > > > > > ------=_Part_49827_15532334.1173189589341 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline EXPLAIN ANALYZE does give the query execution time at the end of its output.

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 3/6/07, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.com> wrote:

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".

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

2007/3/6, Shoaib Mir <shoaibmir@gmail.com>:
> Did you try EXPLAIN ANALYZE <SQL Query>?
>
> ---
> Shoaib Mir
> EnterpriseDB ( www.enterprisedb.com)
>
>
> On 3/6/07, Ezequias Rodrigues da Rocha <ezequias.rocha@gmail.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
> > > 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 ?
> > >
> > > --
> > > 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
> > >
> >
> >
> > --
> > 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
> >
>
>

------=_Part_49827_15532334.1173189589341--