Re: thousands of CachedPlan entry per backend

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: thousands of CachedPlan entry per backend
Дата
Msg-id CAMkU=1ykgN2=DeNZxKQSW6yg3h4+PfCyf_3n3pqjhiM7PK4dVQ@mail.gmail.com
обсуждение исходный текст
Ответ на RE: thousands of CachedPlan entry per backend  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
Список 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 по дате отправления:

Предыдущее
От: "James Pang (chaolpan)"
Дата:
Сообщение: RE: thousands of CachedPlan entry per backend
Следующее
От: Satalabaha Postgres
Дата:
Сообщение: Understand time taken by individual SQL statements in a procedure