Re: thousands of CachedPlan entry per backend

On Thu, Jun 1, 2023 at 4:51 AM James Pang (chaolpan) wrote: > 2) from this line, we saw total 42 blocks ,215 chunks > CacheMemoryContext: 8737352 total in 42 blocks; 1021944 free (215 chunks); > 7715408 used, > > But from sum of it’s child level entrys, total sum(child lines) > block ,t

RE: thousands of CachedPlan entry per backend

these lines about "SPI Plan" are these PL/PGSQL functions related through SPI_prepare plan entry, right? SPI Plan: 1024 total in 1 blocks; 600 free (0 chunks); 424 used CachedPlan: 2048 total in 2 blocks; 304 free (1 chunks); 1744 used: xxx CachedPlanSource: 2048 total in 2 blocks;