X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 786D552997 for ; Mon, 27 Jun 2005 22:05:06 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 61888-02 for ; Tue, 28 Jun 2005 01:05:03 +0000 (GMT) Received: from mail23.sea5.speakeasy.net (mail23.sea5.speakeasy.net [69.17.117.25]) by svr1.postgresql.org (Postfix) with ESMTP id BA4175299C for ; Mon, 27 Jun 2005 22:05:01 -0300 (ADT) Received: (qmail 12608 invoked from network); 28 Jun 2005 01:05:05 -0000 Received: from dsl093-114-095.chi2.dsl.speakeasy.net (HELO mofo.meme.com) ([66.93.114.95]) (envelope-sender ) by mail23.sea5.speakeasy.net (qmail-ldap-1.03) with SMTP for ; 28 Jun 2005 01:05:05 -0000 Received: from mofo (localhost.localdomain [127.0.0.1]) by mofo.meme.com (Postfix) with ESMTP id 72AE86E421; Mon, 27 Jun 2005 20:54:08 -0500 (CDT) Date: Tue, 28 Jun 2005 01:54:08 +0000 From: "Karl O. Pinc" Subject: Re: Performance analysis of plpgsql code To: Michael Fuhr Cc: pgsql-performance@postgresql.org References: <1119915045l.4428l.5l@mofo> <20050627233303.GA17069@winnie.fuhr.org> In-Reply-To: <20050627233303.GA17069@winnie.fuhr.org> (from mike@fuhr.org on Mon Jun 27 18:33:03 2005) X-Mailer: Balsa 2.3.0 Message-Id: <1119923648l.11411l.0l@mofo> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii; DelSp=Yes; Format=Flowed Content-Disposition: inline Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200506/510 X-Sequence-Number: 13147 On 06/27/2005 06:33:03 PM, Michael Fuhr wrote: > On Mon, Jun 27, 2005 at 11:30:45PM +0000, Karl O. Pinc wrote: > > > > Short of that I think I'm going to be reduced to > > writing a C function that returns the real > > system time so I can spatter my code with > > RAISE statements that indicate actual execution > > time. > > See timeofday(). That only gives you the time at the start of the transaction, so you get no indication of how long anything in the transaction takes. Karl Free Software: "You don't pay back, you pay forward." -- Robert A. Heinlein