X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1C7E34762CF for ; Mon, 24 Mar 2003 14:47:22 -0500 (EST) Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id 4DF31476241 for ; Mon, 24 Mar 2003 14:47:17 -0500 (EST) Received: from [66.219.92.2] (HELO temoku) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 2920444; Mon, 24 Mar 2003 11:47:06 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: Stephan Szabo , "pgsql-performance@postgresql.org" Subject: Re: Slow query Date: Mon, 24 Mar 2003 11:47:09 -0800 User-Agent: KMail/1.4.3 References: <993DBE5B4D02194382EC8DF8554A5273113E5A@postoffice.waterford.org> In-Reply-To: <993DBE5B4D02194382EC8DF8554A5273113E5A@postoffice.waterford.org> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200303241147.09853.josh@agliodbs.com> X-Spam-Status: No, hits=-19.2 required=5.0 tests=BAYES_20,IN_REP_TO,REFERENCES,USER_AGENT_KMAIL autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200303/165 X-Sequence-Number: 1463 Stephan, Hmmm ... I'm a bit confused by the new EXPLAIN output. Stefan, does Oleg'= s=20 output show the time for *one* subplan execution, executed for 44,000 loops= ,=20 or does it show the total time? The former would make more sense given his= =20 query, but I'm just not sure .... --=20 -Josh Berkus Aglio Database Solutions San Francisco