From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp> |
Cc: | Justin Pryzby <pryzby(at)telsasoft(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Generating "Subplan Removed" in EXPLAIN |
Date: | 2023-02-01 03:05:08 |
Message-ID: | Y9nW5Bo8hH+px6mJ@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Takamichi Osumi (Fujitsu) | 2023-02-01 03:05:49 | RE: Allow logical replication to copy tables in binary format |
Previous Message | Yugo NAGATA | 2023-02-01 02:53:34 | Re: Generating "Subplan Removed" in EXPLAIN |