Re: EXPLAIN: showing ReadStream / prefetch stats - Mailing list pgsql-hackers

From Melanie Plageman
Subject Re: EXPLAIN: showing ReadStream / prefetch stats
Date
Msg-id CAAKRu_ZKCGgm=hVmuSLdsQ4n8dGDdQX-A2MzLCUezj-O+xFRHw@mail.gmail.com
Whole thread Raw
In response to Re: EXPLAIN: showing ReadStream / prefetch stats  (Tomas Vondra <tomas@vondra.me>)
Responses Re: EXPLAIN: showing ReadStream / prefetch stats
List pgsql-hackers
On Tue, Apr 7, 2026 at 1:34 PM Tomas Vondra <tomas@vondra.me> wrote:
>
> On 4/7/26 18:07, Melanie Plageman wrote:
>
> > I see I had bitmapheapscan use
> >     if (!node->ss.ps.instrument || pcxt->nworkers == 0)
> >         return;
> >
> > while seq scan uses
> >     if (!estate->es_instrument || pcxt->nworkers == 0)
> >         return;
> >
> > That does seem worth being consistent about. Though the estate one is
> > probably better to use and changing bitmapheapscan in this commit
> > might be noisy... I don't feel strongly either way.
>
> I'm not sure this is just a question of consistency, because BHS may
> need the shared instrumentation even if (es_instrument = 0), no? While
> the seqscan/tidrange scan only need it with EXPLAIN(IO).
>
> So I think the two nodes should check
>
>   ((estate->es_instrument & INSTRUMENT_IO) == 0)

Makes sense to me.

I skimmed v14 quite quickly and LGTM.

- Melanie



pgsql-hackers by date:

Previous
From: Matthias van de Meent
Date:
Subject: Re: Better shared data structure management and resizable shared data structures
Next
From: Robert Treat
Date:
Subject: Re: Adding REPACK [concurrently]