On Wed, Feb 1, 2023 at 11:53:34AM +0900, Yugo NAGATA wrote: > On Tue, 31 Jan 2023 20:38:21 -0600 > Justin Pryzby <pry...@telsasoft.com> wrote: > > > > > To: Bruce Momjian <br...@momjian.us> > > Cc: pgsql-hack...@postgresql.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 <br...@momjian.us> https://momjian.us EDB https://enterprisedb.com Embrace your flaws. They make you human, rather than perfect, which you will never be.