X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id DC8B99DCA39 for ; Tue, 28 Feb 2006 20:06:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 46275-05 for ; Tue, 28 Feb 2006 20:06:34 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from polaris.pinpointresearch.com (66-7-238-130.cust.telepacific.net [66.7.238.130]) by postgresql.org (Postfix) with ESMTP id 09B0A9DCA1F for ; Tue, 28 Feb 2006 20:06:29 -0400 (AST) Received: from [192.168.1.179] (betelgeuse.pinpointresearch.com [192.168.1.179]) by polaris.pinpointresearch.com (Postfix) with ESMTP id F2CB1E04DB1E; Tue, 28 Feb 2006 16:06:32 -0800 (PST) Message-ID: <4404E588.7010007@pinpointresearch.com> Date: Tue, 28 Feb 2006 16:06:32 -0800 From: Steve Crawford User-Agent: Mozilla Thunderbird 1.0 (X11/20041207) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Daniel Caune CC: pgsql-sql@postgresql.org Subject: Re: plsql / time statement References: <1E293D3FF63A3740B10AD5AAD88535D201ACE111@UBIMAIL1.ubisoft.org> In-Reply-To: <1E293D3FF63A3740B10AD5AAD88535D201ACE111@UBIMAIL1.ubisoft.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.117 required=5 tests=[AWL=0.117] X-Spam-Score: 0.117 X-Spam-Level: X-Archive-Number: 200602/327 X-Sequence-Number: 24337 Daniel Caune wrote: > Hi, > > > > Is there any option to set so that psql provides the execution time of > each SQL statement executed? \timing (either as a manual command or as a default in your .psqlrc file). Cheers, Steve