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