Updated on 2023-10-23 GMT+08:00

SESSION_MEMORY_DETAIL

SESSION_MEMORY_DETAIL collects statistics about thread memory usage by MemoryContext node.

Table 1 SESSION_MEMORY_DETAIL columns

Name

Type

Description

sessid

text

Thread start time and ID

sesstype

text

Thread name

contextname

text

Name of the memory context

level

smallint

Level of memory context importance

parent

text

Name of the parent memory context

totalsize

bigint

Size of the applied memory (unit: byte)

freesize

bigint

Size of the idle memory (unit: byte)

usedsize

bigint

Size of the used memory (unit: byte)