Re: pg_plan_advice - Mailing list pgsql-hackers

From Robert Haas
Subject Re: pg_plan_advice
Date
Msg-id CA+Tgmob6=9SeuoXiT6S25zT4fNrvVVb8FTbvu_bOyCAjoeOHLQ@mail.gmail.com
Whole thread
In response to Re: pg_plan_advice  (Matheus Alcantara <matheusssilv97@gmail.com>)
List pgsql-hackers
On Thu, Mar 26, 2026 at 10:30 AM Matheus Alcantara
<matheusssilv97@gmail.com> wrote:
> Adding support for auto_explain to explain(plan_advice, ...) (or any
> other custom explain option from loadable modules) would help or make
> sense here? I have been thinking about this for a while.

I think that some generic support for custom explain options in
auto_explain is a good idea, but if you use that method to collect
advice strings, you're going to have quite a bit of log-filtering work
to do to get anything useful out of it. That might be fine for some
people, and it's certainly better than nothing, but I think eventually
we want a cleaner way. But still, +many for upgrading auto_explain
with this feature.

--
Robert Haas
EDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Matheus Alcantara
Date:
Subject: Re: pg_plan_advice
Next
From: Nathan Bossart
Date:
Subject: Re: Clean up NamedLWLockTranche stuff