Re: EXPLAIN BUFFERS

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: EXPLAIN BUFFERS
Дата
Msg-id 14662.1260460243@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: EXPLAIN BUFFERS  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: EXPLAIN BUFFERS  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Thu, Dec 10, 2009 at 9:03 AM, Euler Taveira de Oliveira
> <euler@timbira.com> wrote:
>> Why? If you want this information for all of your queries, you can always set
>> auto_explain.log_min_duration to 0. But if you're suggesting that we should
>> maintain log_statement_stats (that was not I understand from Tom's email [1]),
>> it's not that difficult to a change ShowBufferUsage().

> Mmm, OK, if Tom thinks we should rip it out, I'm not going to second-guess him.

Feel free to question that.  But it's ancient code and I'm not convinced
it still has a reason to live.  If you want to investigate the I/O
behavior of a particular query, you'll use EXPLAIN.  If you want to get
an idea of the system-wide behavior, you'll use the stats collector.
What use case is left for the backend-local counters?
        regards, tom lane


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: EXPLAIN BUFFERS
Следующее
От: Greg Smith
Дата:
Сообщение: Re: EXPLAIN BUFFERS