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	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". If the cache object is a package, whether the cache object is a packet header or a packet body is displayed. For example, if the cache object is valid, the packet header is displayed as "valid:spec", and the packet body is displayed as "valid:body".
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	int8	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	int8	Size of a cached object.
usecount	int8	Number of objects that are referencing the global cache. When no object references the global compilation product, the number is 0.