GS_GLC_MEMORY_DETAIL

"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.

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	Current 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.