Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS - Mailing list pgsql-hackers

From Andrey Borodin
Subject Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS
Date
Msg-id CAAhFRxjiRwTGe91BSe940x5EWS267RyO=9gfZ9z1_Ne63-YjFA@mail.gmail.com
Whole thread Raw
In response to Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS  (Andres Freund <andres@anarazel.de>)
Responses Re: Buffer usage detailed by RelKind in EXPLAIN ANALYZE BUFFERS
List 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 by date:

Previous
From: Andres Freund
Date:
Subject: Re: Make EXPLAIN generate a generic plan for a parameterized query
Next
From: Andres Freund
Date:
Subject: Re: Inconsistency in reporting checkpointer stats