Re: Actual Cost

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Actual Cost
Дата
Msg-id 31101.1550429783@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Actual Cost  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-hackers
Jeff Janes <jeff.janes@gmail.com> writes:
> What would I find very useful is a verbosity option to get the cost
> estimates expressed as a multiplier of each *_cost parameter, rather than
> just as a scalar.

Perhaps, but refactoring to get that seems impractically invasive &
expensive, since e.g. index AM cost estimate functions would have to
be redefined, plus we'd have to carry around some kind of cost vector
rather than single numbers for every Path ...

> And at the whole-query level, get an rusage report
> rather than just wall-clock duration.

I'm sure you're aware of log_statement_stats and friends already.
I agree though that that's not necessarily an optimal user interface.

            regards, tom lane


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

Предыдущее
От: Michael Banck
Дата:
Сообщение: Re: Offline enabling/disabling of data checksums
Следующее
От: Donald Dong
Дата:
Сообщение: Re: Actual Cost