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 CDD62D1C9C8 for ; Tue, 13 Apr 2004 15:26: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 34783-03 for ; Tue, 13 Apr 2004 15:26:19 -0300 (ADT) Received: from candle.pha.pa.us (candle.pha.pa.us [207.106.42.251]) by svr1.postgresql.org (Postfix) with ESMTP id 1A1A2D1C9C4 for ; Tue, 13 Apr 2004 15:26:16 -0300 (ADT) Received: (from pgman@localhost) by candle.pha.pa.us (8.11.6/8.11.6) id i3DIQFB01304; Tue, 13 Apr 2004 14:26:15 -0400 (EDT) From: Bruce Momjian Message-Id: <200404131826.i3DIQFB01304@candle.pha.pa.us> Subject: Re: log_min_cost_statement In-Reply-To: <20040413152601.GA22288@shaka.acc.umu.se> To: =?ISO-8859-1?Q?Nichlas_L=F6fdahl?= Date: Tue, 13 Apr 2004 14:26:15 -0400 (EDT) Cc: pgsql-admin@postgresql.org X-Mailer: ELM [version 2.4ME+ PL108 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Content-Type: text/plain; charset=UNKNOWN-8BIT X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/204 X-Sequence-Number: 13177 Nichlas Löfdahl wrote: > 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. Uh, yea, I guess we could, but the costs are more comparison with other costs, not really with other queries, I think, so I am not sure it would be meaningful. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073