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 20F0BD1E95F for ; Tue, 13 Apr 2004 12:26:21 -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 54139-08 for ; Tue, 13 Apr 2004 12:26:18 -0300 (ADT) Received: from khan.acc.umu.se (khan.acc.umu.se [130.239.18.139]) by svr1.postgresql.org (Postfix) with ESMTP id 5C8AED1E96A for ; Tue, 13 Apr 2004 12:26:17 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by amavisd-new (Postfix) with ESMTP id B41AED259 for ; Tue, 13 Apr 2004 17:26:02 +0200 (MEST) Received: from shaka.acc.umu.se (shaka.acc.umu.se [130.239.18.148]) by khan.acc.umu.se (Postfix) with ESMTP id 114EBD250 for ; Tue, 13 Apr 2004 17:26:02 +0200 (MEST) Received: by shaka.acc.umu.se (Postfix, from userid 23132) id EF19BF; Tue, 13 Apr 2004 17:26:01 +0200 (MEST) Date: Tue, 13 Apr 2004 17:26:01 +0200 From: Nichlas =?iso-8859-1?Q?L=F6fdahl?= To: pgsql-admin@postgresql.org Subject: log_min_cost_statement Message-ID: <20040413152601.GA22288@shaka.acc.umu.se> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.1i X-Virus-Scanned: by amavisd-new at acc.umu.se X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/200 X-Sequence-Number: 13173 Hello! 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. Just a thought! /Nichlas