| From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans) |
| Date: | 2024-08-27 15:15:46 |
| Message-ID: | CAH2-WzkhjWBd1OMO6VfSc4BVhGovbKiPMgBj0WjEEwPEwktfbQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Aug 15, 2024 at 3:22 PM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> Attached patch has EXPLAIN ANALYZE display the total number of
> primitive index scans for all 3 kinds of index scan node.
Attached is v2, which fixes bitrot.
v2 also uses new terminology. EXPLAIN ANALYZE will now show "Index
Searches: N", not "Primitive Index Scans: N". Although there is
limited precedent for using the primitive scan terminology, I think
that it's a bit unwieldy.
No other notable changes.
--
Peter Geoghegan
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0001-Show-index-search-count-in-EXPLAIN-ANALYZE.patch | application/octet-stream | 43.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2024-08-27 15:16:51 | Re: Enable data checksums by default |
| Previous Message | Karina Litskevich | 2024-08-27 15:05:53 | Invalid "trailing junk" error message when non-English letters are used |