proposal - queryid can be used as filter for auto_explain

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: proposal - queryid can be used as filter for auto_explain
Date: 2026-04-13 04:46:24
Message-ID: CAFj8pRDVFfzcC20VLE-7Lh4R=ofcd0V4gCFCnL0u_+dDtmi5OA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

I have to investigate strange behaviour of some specific query. One
possibility is non stability of plan. This is a bigger server with a bigger
load, and I am a little bit afraid to use auto_explain for all queries.

Currently auto_explain doesn't support it, but it can be practical if we
can specify a list of queryid as a filter of auto_explain.

What do you think about this idea?

Regards

Pavel

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Etsuro Fujita 2026-04-13 04:53:05 Re: Import Statistics in postgres_fdw before resorting to sampling.
Previous Message David Rowley 2026-04-13 04:35:03 Add bms_offset_members() function for bitshifting Bitmapsets