• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_SHARED_MEMORY_DETAIL

PG_SHARED_MEMORY_DETAIL

PG_SHARED_MEMORY_DETAIL queries the usage information about all the shared memory contexts.

Table 1 PG_SHARED_MEMORY_DETAIL columns

Name

Type

Description

contextname

text

Name of the context in the memory

level

smallint

Level of the context in the memory

parent

text

Context of the parent memory

totalsize

bigint

Size of the shared memory

freesize

bigint

Remaining size of the shared memory

usedsize

bigint

Usage size of the shared memory