Updated on 2025-05-29 GMT+08:00

GS_GLC_MEMORY_DETAIL

GS_GLC_MEMORY_DETAIL displays the memory usage of the global PL/pgSQL cache in all databases. This view is available only when enable_global_plsqlcache is set to on.

Table 1 GS_GLC_MEMORY_DETAIL columns

Name

Type

Description

contextname

text

Name of a memory object.

database

text

Database to which the memory object belongs. "pkg_bucket" and "func_bucket" are displayed as "NULL".

schema

text

Database to which the memory object belongs. "pkg_bucket" and "func_bucket" are displayed as "NULL".

type

text

Object type.

  • "pkg_bucket": indicates that the object is the parent node of a package object.
  • "func_bucket": indicates that the object is the parent node of a function or stored procedure.
  • "pkg": indicates that the object is a package object.
  • "func": indicates that the object is a function or stored procedure.

status

text

Status of the cache object. "valid" indicates that the cache object is available, and 'invalid' indicates that the cache object is unavailable. The "pkg_bucket" and "func_bucket" objects have no status and are displayed as "NULL".

location

text

Current location of a cached object. It is displayed as "in_global_hash_table" in the cache hash table and "in_global_expired_list" in the invalid linked list.

The "pkg_bucket" and "func_bucket" objects are displayed as "NULL".

env

bigint

Environment parameter when an object is created, that is, the value of behavior_compat_flags. The "pkg_bucket" and "func_bucket" objects are displayed as 0.

usedsize

bigint

Size of a cached object.

usecount

bigint

Number of objects that are referencing the global cache. When no object references the global compilation product, the number is 0.

oid

bigint

OID of a memory object.

isspec

bool

Specifies whether the memory object is a packet header.

searchpath

text

The memory object accesses the schema and other environment variables of the compilation product.

invalidreason

text

Reason why a memory object becomes invalid.