Re: Is there a way to identify a plan generated by GECO?
| От | Jerry Brenner |
|---|---|
| Тема | Re: Is there a way to identify a plan generated by GECO? |
| Дата | |
| Msg-id | CACoKFYQBVOmU3gRvmYhvBzSFTef02eMbn6ejxeR0sf5vSzbn4g@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Is there a way to identify a plan generated by GECO? (Tom Lane <tgl@sss.pgh.pa.us>) |
| Список | pgsql-performance |
We just jdbc and bind variables, so we are using PreparedStatements.
plan_cache_mode is set to auto
So, it sounds like there could be plan caching. (I wasn't aware of that.)
Is there any kind of running counter in a system view that tracks the number of executions of cached plans?
We are capturing the plans via auto_explain and limited to the explain options available with that path. Is there anything in the plan that would tell us if the execution used a cached plan? (My manual explains does not use a prepare.)
Thanks, Jerry
On Thu, Jul 17, 2025 at 8:10 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Jerry Brenner <jbrenner@guidewire.com> writes:
> I don't have any background with the randomized search. Does the repeated
> pattern with the same plan being executed multiple times in a time range
> and then the plan changes, never to change back, match the expectation with
> the randomization?
[ shrug... ] Insufficient information. There could be some plan
caching going on that contributes to this effect, though.
regards, tom lane
В списке pgsql-performance по дате отправления: