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