X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 6FAD2D1E1F3 for ; Tue, 13 Apr 2004 15:46:20 -0300 (ADT) 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 42201-02 for ; Tue, 13 Apr 2004 15:46:19 -0300 (ADT) Received: from curie.credativ.org (credativ.com [217.160.209.18]) by svr1.postgresql.org (Postfix) with ESMTP id 33BCBD1E136 for ; Tue, 13 Apr 2004 15:46:18 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by curie.credativ.org (Postfix) with ESMTP id 14D7855BEB; Tue, 13 Apr 2004 20:46:19 +0200 (CEST) Received: from colt.pezone.net (dsl-213-023-254-104.arcor-ip.net [213.23.254.104]) (using TLSv1 with cipher RC4-MD5 (128/128 bits)) (No client certificate requested) by curie.credativ.org (Postfix) with ESMTP id 9A63E55BE8; Tue, 13 Apr 2004 20:46:16 +0200 (CEST) From: Peter Eisentraut To: Nichlas =?iso-8859-1?q?L=F6fdahl?= , pgsql-admin@postgresql.org Subject: Re: log_min_cost_statement Date: Tue, 13 Apr 2004 20:46:05 +0200 User-Agent: KMail/1.5.1 References: <20040413152601.GA22288@shaka.acc.umu.se> In-Reply-To: <20040413152601.GA22288@shaka.acc.umu.se> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit Content-Disposition: inline Message-Id: <200404132046.05893.peter_e@gmx.net> X-Virus-Scanned: by AMaViS at credativ.com X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/206 X-Sequence-Number: 13179 Nichlas Löfdahl wrote: > Would it be possible to have an option "log_min_cost_statement", > similar to "log_min_duration_statement" except that it logs all > statement that has an minimum cost estimated by the planner? I think > it would be easier to find unoptimized queries that way. If you believe that the costs have any absolute meaning at all then they should be proportional to the execution time, so the existing setting should be enough.