Re: proposal - queryid can be used as filter for auto_explain

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: proposal - queryid can be used as filter for auto_explain
Date: 2026-04-13 09:01:47
Message-ID: adyw-3p7wnfSr2Go@jrouhaud
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2026-04-13 09:21:23 Re: Unicode update and some tooling improvements
Previous Message jian he 2026-04-13 09:01:06 Re: DELETE/UPDATE FOR PORTION OF with rule system is not working