From: | Mircea Cadariu <cadariu(dot)mircea(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Metadata and record block access stats for indexes |
Date: | 2025-02-28 19:58:32 |
Message-ID: | f0b091ff-864a-45ed-8ddd-1f81263661a0@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
For the purpose of writing a blog post I was checking the index stats
recorded for a workload, but found them rather confusing. Following
along the code with the debugger it eventually made sense, and I could
eventually understand what's counted. Looking around a bit, I
discovered an older discussion [1] in the mailing lists and learned that
the issue is known. The proposal in that thread is to start counting
separate metadata and record stats depending on what type of index block
is retrieved.
I realized those would have helped me better understand the collected
index stats, so I started working on a patch to add these in the system
views. Attached is a WIP patch file with partial coverage of the B-Tree
index code. The implementation follows the existing stats collection
approach and the naming convention proposed in [1]. Let me know if what
I'm doing is feasible and if there's any concerns I could address. Next
steps would be to replace all places where I currently pass in NULL with
proper counting, as well as update tests and docs.
Looking forward to your feedback! Thanks!
Cheers,
Mircea
Attachment | Content-Type | Size |
---|---|---|
v1-0001-Preliminary-work-to-capture-and-expose-separate-r.patch | text/plain | 101.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Nathan Bossart | 2025-02-28 20:01:32 | Re: optimize file transfer in pg_upgrade |
Previous Message | Masahiko Sawada | 2025-02-28 19:50:39 | Re: Make COPY format extendable: Extract COPY TO format implementations |