[prev in list] [next in list] [prev in thread] [next in thread] 

List:       pgsql-performance
Subject:    Re: thousands of CachedPlan entry per backend
From:       Jeff Janes <jeff.janes () gmail ! com>
Date:       2023-06-02 19:17:13
Message-ID: CAMkU=1ykgN2=DeNZxKQSW6yg3h4+PfCyf_3n3pqjhiM7PK4dVQ () mail ! gmail ! com
[Download RAW message or body]

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

>

[Attachment #3 (text/html)]

<div dir="ltr"><div dir="ltr">On Thu, Jun 1, 2023 at 4:51 AM James Pang (chaolpan) \
&lt;<a href="mailto:chaolpan@cisco.com">chaolpan@cisco.com</a>&gt; \
wrote:<br></div><div class="gmail_quote"><blockquote class="gmail_quote" \
style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div class="msg4802293508126207883">





<div lang="EN-US" style="overflow-wrap: break-word;">
<div class="m_4802293508126207883WordSection1">
<p class="MsoNormal">   2) from   this line, we saw total 42 blocks ,215 chunks       \
CacheMemoryContext: 8737352 total in 42 blocks; 1021944 free (215 chunks); 7715408 \
used,<br></p><p class="MsoNormal"><u></u></p> <p class="MsoNormal">           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?</p></div></div></div></blockquote><div><br></div><div>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.</div><div><br></div><div>Cheers,</div><div><br></div><div>Jeff  \
</div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px \
solid rgb(204,204,204);padding-left:1ex"><div class="msg4802293508126207883"><div \
lang="EN-US" style="overflow-wrap: break-word;"><div \
class="m_4802293508126207883WordSection1"><div><div><blockquote \
style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid \
rgb(204,204,204);padding:0in 0in 0in 6pt;margin-left:4.8pt;margin-right:0in"><p \
class="MsoNormal" style="margin-bottom:12pt"> <u></u><u></u></p>
</blockquote>
</div>
</div>
</div>
</div>

</div></blockquote></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]