Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id AEDAF9FB7EE for ; Tue, 6 Mar 2007 09:43:38 -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 99860-03-2 for ; Tue, 6 Mar 2007 09:43:22 -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.251]) by postgresql.org (Postfix) with ESMTP id 716509FB602 for ; Tue, 6 Mar 2007 09:43:32 -0400 (AST) Received: by an-out-0708.google.com with SMTP id c24so1641953ana for ; Tue, 06 Mar 2007 05:43:31 -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=T1Z9/8y+kvDJ9AEqxuyZnW6+AWN4XUewlhFawCuxc9IFdtW9vhx14ZTHP0P99KFLyhjTQT2AAUOCNCkoa8fVIX4sUhwgOB6y/hezG5T4Uo78ZBbfvhzQVKNh2SFABx6es597GQNf4mVIAWpeH7dZsramXK5Vs0FMrS4hYu0HP1k= 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=T4Y4jQY+g/Nes1knK7Xv8spzeKeftRQnZigAmD95HQDPIpsKzk96x0xJfS8dPW06FmZnO24Rw5u31GNvslQHwZWJfiXD7GRdg2VtAbJ0QC4k+FNyixOglHWj7QJqyfeOu77QdlD2Uf9gzBNIjOsSdgm6KXvlrKOWfEiYc9rhh5w= Received: by 10.100.196.3 with SMTP id t3mr3336191anf.1173188611260; Tue, 06 Mar 2007 05:43:31 -0800 (PST) Received: by 10.100.38.6 with HTTP; Tue, 6 Mar 2007 05:43:31 -0800 (PST) Message-ID: Date: Tue, 6 Mar 2007 18:43:31 +0500 From: "Shoaib Mir" To: "Ezequias Rodrigues da Rocha" Subject: Re: Time of executed query Cc: "Bart Degryse" , PostgreSQL In-Reply-To: <55c095e90703060537q5f620430wbac3d3a8197673f4@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_49611_23207388.1173188611231" References: <55c095e90703060520s3e4a1feej65f56cee46fd6700@mail.gmail.com> <45ED7A0A.A3DD.0030.0@indicator.be> <55c095e90703060537q5f620430wbac3d3a8197673f4@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/32 X-Sequence-Number: 27670 ------=_Part_49611_23207388.1173188611231 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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_49611_23207388.1173188611231 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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_49611_23207388.1173188611231--