Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS

Поиск
Список
Период
Сортировка
От Andrey Borodin
Тема Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS
Дата
Msg-id CAAhFRxjiRwTGe91BSe940x5EWS267RyO=9gfZ9z1_Ne63-YjFA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS  (Andres Freund <andres@anarazel.de>)
Ответы Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS
Список pgsql-hackers
On Mon, Feb 13, 2023 at 4:29 PM Andres Freund <andres@anarazel.de> wrote:
> > 1. Some more increments on hot paths. We have to add this tiny toll to
> > every single buffer hit, but it will be seldom of any use.
>
> Additionally, I bet it slows down EXPLAIN (ANALYZE, BUFFERS) noticeably. It's
> already quite expensive...
>

I think collection of instrumentation is done unconditionally.
We always do that
pgBufferUsage.shared_blks_hit++;
when the buffer is in shared_buffers.


Best regards, Andrey Borodin.



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Make EXPLAIN generate a generic plan for a parameterized query
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Inconsistency in reporting checkpointer stats