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

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

In response to

Browse pgsql-hackers by date

  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