Re: thousands of CachedPlan entry per backend - Mailing list pgsql-performance

From Jeff Janes
Subject Re: thousands of CachedPlan entry per backend
Date
Msg-id CAMkU=1ykgN2=DeNZxKQSW6yg3h4+PfCyf_3n3pqjhiM7PK4dVQ@mail.gmail.com
Whole thread Raw
In response to RE: thousands of CachedPlan entry per backend  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
List pgsql-performance
On Thu, Jun 1, 2023 at 4:51 AM James Pang (chaolpan) <chaolpan@cisco.com> 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 ,trunks show much more than “CacheMemoryContext,  is expected to see that?


Yes, that is expected.  The parent context reports only its own direct memory usage and blocks.  It does not include the sum of memory usage of its child contexts.

Cheers,

Jeff 

pgsql-performance by date:

Previous
From: "James Pang (chaolpan)"
Date:
Subject: RE: thousands of CachedPlan entry per backend
Next
From: Satalabaha Postgres
Date:
Subject: Understand time taken by individual SQL statements in a procedure