• Data Warehouse Service

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

PV_SESSION_MEMORY

PV_SESSION_MEMORY collects statistics about memory usage at the session level in the unit of MB, including all the memory allocated to Postgres and Stream threads on DNs for tasks currently executed by users.

Table 1 PV_SESSION_MEMORY columns

Name

Type

Description

sessid

text

Thread start time and ID

init_mem

integer

Memory allocated to the currently executed task before the task enters the executor

used_mem

integer

Memory allocated to the currently executed task

peak_mem

integer

Peak memory allocated to the currently executed task