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 841783A53B4 for ; Sun, 9 Jan 2005 05:23:48 +0000 (GMT) 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 94398-01 for ; Sun, 9 Jan 2005 05:23:45 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 69B4F3A53A6 for ; Sun, 9 Jan 2005 05:23:44 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j095NglG024310; Sun, 9 Jan 2005 00:23:42 -0500 (EST) To: "Guenzl, Martin" Cc: pgsql-performance@postgresql.org Subject: Re: Help with EXPLAIN ANALYZE runtimes In-reply-to: <200501090444.j094ideg019542@mail01.syd.optusnet.com.au> References: <200501090444.j094ideg019542@mail01.syd.optusnet.com.au> Comments: In-reply-to "Guenzl, Martin" message dated "Sun, 09 Jan 2005 15:44:30 +1100" Date: Sun, 09 Jan 2005 00:23:42 -0500 Message-ID: <24309.1105248222@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.002 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/94 X-Sequence-Number: 9784 "Guenzl, Martin" writes: > On the latter, the EXPLAIN ANALYZE returned what I thought was a strange > result - here is the excerpt ... Do you think we are psychics who can guess at your problem when you've shown us none of the table definitions, none of the query, and only a small part of the EXPLAIN output? Donning my Karnak headgear, I will guess that this is actually not a SELECT query but some kind of update operation, and that the time sink is in the updating part and not in the data extraction part. (Inefficient foreign-key operations would be a likely cause, as would poorly written user-defined triggers.) But that's strictly a guess. regards, tom lane