Re: auto_explain crashes on EXPLAIN (BUFFERS) of an index scan (19, master)

[Peter Geoghegan]

On Fri, Nov 13, 2026 at 10:44 PM Xiaoxuan Li <xiaoxuan.li....@gmail.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