Updated on 2024-06-03 GMT+08:00

GLOBAL_SESSION_MEMORY_DETAIL

Collects statistics about thread memory usage on each node by MemoryContext, as shown in Table 1.

Table 1 GLOBAL_SESSION_MEMORY_DETAIL columns

Name

Type

Description

node_name

name

Node name.

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 allocated memory (unit: byte).

freesize

bigint

Size of the idle memory (unit: byte).

usedsize

bigint

Size of the used memory (unit: byte).