Re: log_min_cost_statement

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: log_min_cost_statement
Дата
Msg-id 200404131826.i3DIQFB01304@candle.pha.pa.us
обсуждение исходный текст
Ответ на log_min_cost_statement  (Nichlas Löfdahl <crotalus@acc.umu.se>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Postgres Admin - Export Database
Следующее
От: Tom Lane
Дата:
Сообщение: Re: log_min_cost_statement