Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column

2025-07-18 Thread Tom Lane
I wrote: > Well, we don't have a most common element in this scenario --- the > whole point is that the occurrence counts resulting from the lossy > counting algorithm are too low to be trustworthy. However, what we > do have is the cutoff frequency, and it seems to me that we could use > that as

Re: Is there a way to identify a plan generated by GECO?

2025-07-18 Thread Jerry Brenner
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