Re: proposal - queryid can be used as filter for auto_explain - Mailing list pgsql-hackers

From Julien Rouhaud
Subject Re: proposal - queryid can be used as filter for auto_explain
Date
Msg-id adyw-3p7wnfSr2Go@jrouhaud
Whole thread Raw
In response to proposal - queryid can be used as filter for auto_explain  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Hi,

On Mon, Apr 13, 2026 at 06:46:24AM +0200, Pavel Stehule wrote:
>
> 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?

+1.  I don't think it's something that will be useful very often, but when it's
going to be useful it would be *extremely* convenient to have.



pgsql-hackers by date:

Previous
From: jian he
Date:
Subject: Re: DELETE/UPDATE FOR PORTION OF with rule system is not working
Next
From: Peter Eisentraut
Date:
Subject: Re: Unicode update and some tooling improvements