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