Updated on 2024-05-07 GMT+08:00

GS_LSC_MEMORY_DETAIL

GS_LSC_MEMORY_DETAIL displays the memory usage of the local system cache of all threads based on the MemoryContext node. The data is displayed only when Global SysCache is enabled.

Table 1 GS_LSC_MEMORY_DETAIL columns

Name

Type

Description

threadid

text

Thread start time and ID (string: timestamp.sessionid).

tid

bigint

Thread ID.

thrdtype

text

Thread type. It can be any thread type in the system, such as postgresql and wlmmonitor.

contextname

text

Name of the memory context.

level

smallint

Hierarchy of the memory context.

parent

text

Name of the parent memory context.

totalsize

bigint

Total size of the memory context, in bytes.

freesize

bigint

Total size of released memory in the memory context, in bytes.

usedsize

bigint

Total size of used memory in the memory context, in bytes.