Re: log_min_cost_statement

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: log_min_cost_statement
Дата
Msg-id 200404132046.05893.peter_e@gmx.net
обсуждение исходный текст
Ответ на log_min_cost_statement  (Nichlas Löfdahl <crotalus@acc.umu.se>)
Список pgsql-admin
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.


В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: log_min_cost_statement
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Real time replication of PG DBs accross two servers - any experiences?