• Data Warehouse Service

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

PV_SESSION_MEMORY_DETAIL

PV_SESSION_MEMORY_DETAIL collects statistics about thread memory usage based on MemoryContext nodes.

Table 1 PV_SESSION_MEMORY_DETAIL columns

Name

Type

Description

sessid

text

Thread ID and start time

sesstype

text

Thread name

contextname

text

Name of the memory context

level

smallint

Level of memory context importance

parent

text

Name of the parent memory context

totalsize

bigint

Total size of the current memory context

freesize

bigint

Total size of released memory in the current memory context

usedsize

bigint

Total size of used memory in the current memory context