Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 448032E00D2 for ; Sun, 2 Dec 2007 21:06:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 78866-02 for ; Sun, 2 Dec 2007 21:06:45 -0400 (AST) Received: from proton.planetargon.com (proton.planetargon.com [198.145.115.11]) by postgresql.org (Postfix) with ESMTP id 47D8D2E0032 for ; Sun, 2 Dec 2007 21:06:50 -0400 (AST) Received: from [10.0.1.198] (c-67-165-16-168.hsd1.pa.comcast.net [67.165.16.168]) by proton.planetargon.com (Postfix) with ESMTP id BAD02952C04; Sun, 2 Dec 2007 17:06:20 -0800 (PST) In-Reply-To: <239.1196643379@sss.pgh.pa.us> References: <8C0EE80A-42A3-4CC1-850B-2A6B9220B422@seespotcode.net> <239.1196643379@sss.pgh.pa.us> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: pgsql-performance@postgresql.org Content-Transfer-Encoding: 7bit From: Michael Glaesemann Subject: Re: EXPLAIN ANALYZE time calculations Date: Sun, 2 Dec 2007 20:06:07 -0500 To: Tom Lane X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/22 X-Sequence-Number: 27838 On Dec 2, 2007, at 19:56 , Tom Lane wrote: > IOW the actual time to get in and out of a node is going to be a > shade more > than is reported. Thanks, Tom. Should be close enough for jazz. When I was first going over the Using Explain section, I stumbled a bit on the startup time/total time/loops bit (which is why explain- analyze.info times and percentages are currently miscalculated). I took startup time to be the time to return the first row *of the first loop*. But it's actually the average startup time to return the first row *in each loop*, right? Michael Glaesemann grzm seespotcode net