Re: Generating "Subplan Removed" in EXPLAIN

On Wed, Feb 1, 2023 at 11:53:34AM +0900, Yugo NAGATA wrote:
> On Tue, 31 Jan 2023 20:38:21 -0600
> Justin Pryzby <pryzby(at)telsasoft(dot)com> wrote:
>
> >
> > To: Bruce Momjian <bruce(at)momjian(dot)us>
> > Cc: pgsql-hackers(at)postgresql(dot)org
> > Subject: Re: Generating "Subplan Removed" in EXPLAIN
> > Date: Tue, 31 Jan 2023 20:38:21 -0600
> > User-Agent: Mutt/1.9.4 (2018-02-28)
> >
> > On Tue, Jan 31, 2023 at 08:59:57PM -0500, Bruce Momjian wrote:
> > > Does anyone know how to generate this? Thanks.
> >
> > The regression tests know:
> >
> > $ git grep -c 'Subplans Removed' ./src/test/regress/
> > src/test/regr
>
> Maybe, you missed to set plan_cache_mode to force_generic_plan.
> "Subplan Removed" doesn't appear when using a custom plan.

Yes, that is exactly what I as missing. Thank you!

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

Embrace your flaws. They make you human, rather than perfect,
which you will never be.