| From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
|---|---|
| To: | Alena Rybakina <a(dot)rybakina(at)postgrespro(dot)ru> |
| Cc: | 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-12-11 19:41:47 |
| Message-ID: | CAH2-WznqY3riCb9upatL7eLQ93EQK-o_kfAfsT64ragPnyzTZw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, Nov 9, 2024 at 1:46 PM Peter Geoghegan <pg(at)bowt(dot)ie> wrote:
> On Sat, Nov 9, 2024 at 12:37 PM Alena Rybakina
> <a(dot)rybakina(at)postgrespro(dot)ru> wrote:
> > I noticed that the "Index Searches" cases shown in the regression tests are only for partitioned tables, maybe something you should add some tests for regular tables like tenk1.
>
> I allowed the patch on this thread to bitrot, but I've been
> maintaining this same patch as part of the skip scan patchset.
> Attached is the latest version of this patch (technically this is the
> first patch in the skip scan patch series). Just to keep things
> passing on the CFTester app.
Attached revision just fixes bitrot.
The patch stopped applying against HEAD cleanly due to recent work
that made EXPLAIN ANALYZE show buffers output by default.
--
Peter Geoghegan
| Attachment | Content-Type | Size |
|---|---|---|
| v19-0001-Show-index-search-count-in-EXPLAIN-ANALYZE.patch | application/octet-stream | 52.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2024-12-11 19:54:08 | Re: Add Postgres module info |
| Previous Message | Andres Freund | 2024-12-11 19:26:12 | Re: Add Postgres module info |