X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3A502D1B495 for ; Fri, 9 Jan 2004 14:13:36 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 43217-01 for ; Fri, 9 Jan 2004 10:12:49 -0400 (AST) Received: from localhost.net (cust.89.121.adsl.cistron.nl [195.64.89.121]) by svr1.postgresql.org (Postfix) with ESMTP id 9E599D1B537 for ; Fri, 9 Jan 2004 10:12:45 -0400 (AST) Received: from trust-factory.com (localhost [127.0.0.1]) by localhost.net (Postfix) with ESMTP id 9B70083C80 for ; Fri, 9 Jan 2004 15:12:43 +0100 (CET) Message-ID: <3FFEB6DA.8000905@trust-factory.com> Date: Fri, 09 Jan 2004 15:12:42 +0100 From: Richard van den Berg Organization: Trust Factory User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.5) Gecko/20031007 X-Accept-Language: en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Explain not accurate Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/110 X-Sequence-Number: 5285 Hi there, I am quite new to postgresql, and love the explain feature. It enables us to predict which SQL queries needs to be optimized before we see any problems. However, I've run into an issue where explain tells us a the costs of a quiry are tremendous (105849017586), but the query actually runs quite fast. Even "explain analyze" shows these costs. This makes me wonder: can the estimates explain shows be dead wrong? I can explain in more detail (including the query and output of explain) if needed. I'm using 7.4 on Solaris 8. Sincerely, -- Richard van den Berg, CISSP Trust Factory B.V. | http://www.trust-factory.com/ Bazarstraat 44a | Phone: +31 70 3620684 NL-2518AK The Hague | Fax : +31 70 3603009 The Netherlands | Visit us at Lotusphere 2004 http://www.trust-factory.com/lotusphere