Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 95D149FB788 for ; Tue, 6 Mar 2007 09:37:46 -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 99067-08 for ; Tue, 6 Mar 2007 09:37:32 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by postgresql.org (Postfix) with ESMTP id 0DF989FB2E2 for ; Tue, 6 Mar 2007 09:37:42 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so177911ugf for ; Tue, 06 Mar 2007 05:37:41 -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:content-transfer-encoding:content-disposition:references; b=KIlkY47SwqUVc2OCVVXPqXY3HtwujtFgmizk9WW2ojMBqDDVvJ4/4NMwqVgtxxVvbjeSN3ICH+Ot/3hkXu+lvhjCMxojeWxF7Gsohv2m9w6DYWb4jQeu4W64+GqmC/+tFDpQJeOCCFuT8YAdMrHxO0HVI5r3kKxOHx1U6dsqccg= 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:content-transfer-encoding:content-disposition:references; b=tEriWhI4RAEeien5sBznpfPtvVFfD+3YMqpVegAhDAzJ0hQ43udI30Wng+2C/sEqHPx/TuxL1t6PuucDLeAOxIhgpNj14ncjrW1yFdX2RJJ5xe0KXHvjiYXKVD4i0OfeidCgDWYm3/AeQta9WA2wz39GPiDELk9gI8aFGjmMitc= Received: by 10.67.103.7 with SMTP id f7mr1705236ugm.1173188261166; Tue, 06 Mar 2007 05:37:41 -0800 (PST) Received: by 10.67.94.13 with HTTP; Tue, 6 Mar 2007 05:37:41 -0800 (PST) Message-ID: <55c095e90703060537q5f620430wbac3d3a8197673f4@mail.gmail.com> Date: Tue, 6 Mar 2007 10:37:41 -0300 From: "Ezequias Rodrigues da Rocha" To: "Bart Degryse" Subject: Re: Time of executed query Cc: PostgreSQL In-Reply-To: <45ED7A0A.A3DD.0030.0@indicator.be> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <55c095e90703060520s3e4a1feej65f56cee46fd6700@mail.gmail.com> <45ED7A0A.A3DD.0030.0@indicator.be> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/30 X-Sequence-Number: 27668 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/