Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans) - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans)
Date
Msg-id 2pr5ycgwzp2j2ym3uchpa5vkdg55bz3ngpqa45ires7wddovf4@uqrrpjgk5mft
Whole thread Raw
In response to Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans)  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans)
List pgsql-hackers
Hi,

On 2025-03-08 11:47:25 -0500, Peter Geoghegan wrote:
> My current plan is to commit this on Tuesday or Wednesday, barring any
> objections.

A minor question about this patch: Was there a particular reason it added the
index specific instrumentation information inline in IndexScanState etc?  Of
course the amount of memory right now is rather trivial, so that is not an
issue memory usage wise. Is that the reason?

The background for my question is that I was looking at what it would take to
track the index and table buffer usage separately for
IndexScanState/IndexOnlyScanState and IndexScanInstrumentation seems to be
pre-destined for that information. But it seems a a bit too much memory to
just keep a BufferUsage around even when analyze isn't used.


Greetings,

Andres Freund


PS: Another thing that I think we ought to track is the number of fetches from
the table that missed, but that's not really related to my question here or
this thread...



pgsql-hackers by date:

Previous
From: Álvaro Herrera
Date:
Subject: Re: trivial grammar refactor
Next
From: Álvaro Herrera
Date:
Subject: Re: trivial grammar refactor