Updated on 2025-07-15 GMT+08:00

SESSION_MEMORY_DETAIL

Collects statistics on the memory usage of threads on the current node, in the unit specified by MemoryContext, as described in Table 1.

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)