Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 7F9C99FA1FD; Fri, 15 Dec 2006 09:07:17 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 38313-09; Fri, 15 Dec 2006 09:07:11 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from gauss.credativ.com (ipx11302.ipxserver.de [212.112.227.254]) by postgresql.org (Postfix) with ESMTP id 634629FA0FB; Fri, 15 Dec 2006 09:07:16 -0400 (AST) Received: from bell.credativ.de (p50895721.dip.t-dialin.net [80.137.87.33]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by gauss.credativ.com (Postfix) with ESMTP id 5E88CD75F4; Fri, 15 Dec 2006 14:07:14 +0100 (CET) From: Peter Eisentraut To: pgsql-hackers@postgresql.org Subject: Re: [PERFORM] EXPLAIN ANALYZE on 8.2 Date: Fri, 15 Dec 2006 14:06:55 +0100 User-Agent: KMail/1.9.5 Cc: "Simon Riggs" , "Tom Lane" , "Kelly Burkhart" , "Evgeny Gridasov" , pgsql-performance@postgresql.org References: <20061214163230.d46f0138.eugrid@fpm.kubsu.ru> <29450.1166141131@sss.pgh.pa.us> <1166178488.3882.56.camel@silverbirch.site> In-Reply-To: <1166178488.3882.56.camel@silverbirch.site> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200612151406.57851.peter_e@gmx.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/602 X-Sequence-Number: 95082 Am Freitag, 15. Dezember 2006 11:28 schrieb Simon Riggs: > Until we work out a better solution we can fix this in two ways: > > 1. EXPLAIN ANALYZE [ [ WITH | WITHOUT ] TIME STATISTICS ] ... > > 2. enable_analyze_timer = off | on (default) (USERSET) The second one is enough in my mind. -- Peter Eisentraut http://developer.postgresql.org/~petere/