Re: log_min_cost_statement - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: log_min_cost_statement
Date
Msg-id 200404131826.i3DIQFB01304@candle.pha.pa.us
Whole thread Raw
In response to log_min_cost_statement  (Nichlas Löfdahl <crotalus@acc.umu.se>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres Admin - Export Database
Next
From: Tom Lane
Date:
Subject: Re: log_min_cost_statement