| From: | Peter Geoghegan <pg(at)bowt(dot)ie> |
|---|---|
| To: | Xiaoxuan Li <xiaoxuan(dot)li(dot)dev(at)gmail(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: auto_explain crashes on EXPLAIN (BUFFERS) of an index scan (19, master) |
| Date: | 2026-11-14 16:27:13 |
| Message-ID: | CAH2-Wzn9HisibB4dBXP3znd4mfXaBKWPQnQi4baDdb4yrG+Lkg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Nov 13, 2026 at 10:44 PM Xiaoxuan Li <xiaoxuan(dot)li(dot)dev(at)gmail(dot)com> wrote:
> On REL_19_STABLE (e2b2267d24e, 19rc2) and master (206e71935e1),
> EXPLAIN (BUFFERS) without ANALYZE of a query that uses an index
> crashes the backend when auto_explain logs it with log_analyze on:
>
> CREATE TABLE t (a int PRIMARY KEY, b int);
> LOAD 'auto_explain';
> SET auto_explain.log_min_duration = 0;
> SET auto_explain.log_analyze = on;
> EXPLAIN (BUFFERS) SELECT * FROM t WHERE a = 5;
> server closed the connection unexpectedly
>
> #0 show_indexscan_info ()
> #1 ExplainNode ()
> #2 ExplainPrintPlan ()
> #3 explain_ExecutorEnd ()
>
> Index Scan, Index Only Scan and Bitmap Index Scan plans all crash.
> 18.6 is fine. f026fbf059f crashes and its parent does not.
I'll look into this next week, after 19.0 is released. Its branch is
currently frozen.
Thanks
--
Peter Geoghegan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sho Ito | 2026-11-14 16:52:16 | Re: [PATCH] psql: Fix REPACK index completion after a column list |
| Previous Message | Melanie Plageman | 2026-11-14 16:23:47 | Re: [BUG / PATCH] PG19: VACUUM misestimates reltuples (often 0) after on-access VM setting |