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

From Nikolay Samokhvalov
Subject Re: EXPLAIN: showing ReadStream / prefetch stats
Date
Msg-id CAM527d9dSPTBHEynuLH3bRR=hNb-Pj8RP=nh+LdO49ndcVsZ2A@mail.gmail.com
Whole thread
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, Sep 22, 2026 at 8:23 AM Tomas Vondra <tomas@vondra.me> wrote:
> It's not clear to me why this would be desirable. The query execution
> clearly *does* perform the I/O, even if the buffers end up not being
> used. Hiding that would be very confusing / misleading.
>
> In other words, I/O and buffers may disagree - that's not a bug. Those
> counters are tracking different things.

Thanks all. Agreed that issued I/O should remain accounted for.

Is Prefetch avg/max also intended to include buffers discarded by
read_stream_reset()? If so, agreed, the patch is wrong. The comment above
read_stream_count_prefetch() says it is called once per buffer returned
to the consumer.

Nik



pgsql-hackers by date:

Previous
From: Manu
Date:
Subject: Re: Fix race condition in SSI when reading PredXact->SxactGlobalXmin
Next
From: Tomas Vondra
Date:
Subject: Re: EXPLAIN: showing ReadStream / prefetch stats