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

GS_GSC_MEMORY_DETAIL

GS_GSC_MEMORY_DETAIL displays the memory usage of the global system cache of the current process on the current node. The data is displayed only when GSC is enabled.

The query is separated by the database memory context. Therefore, some memory statistics are missing. The memory context corresponding to the missing memory statistics is GlobalSysDBCache.

Table 1 GS_GSC_MEMORY_DETAIL columns

Name

Type

Description

db_id

text

Database ID.

totalsize

numeric

Total size of the shared memory, in bytes.

freesize

numeric

Remaining size of the shared memory, in bytes.

usedsize

numeric

Used size of the shared memory, in bytes.