Updated on 2023-10-23 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. This view is displayed only when GSC is enabled. Note that 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.

The current feature is a lab feature. Contact Huawei technical support before using it.

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.