Help Center/ GaussDB/ Distributed_8.x/ Schemas/ DBE_PERF Schema/ Session and Thread/ GLOBAL_SESSION_MEMORY
Updated on 2024-06-03 GMT+08:00
View PDF

GLOBAL_SESSION_MEMORY

Collects statistics about memory usage at the session level on each node in the unit of MB, including all the memory allocated to GaussDB and stream threads on DNs for jobs currently executed by users, as described in Table 1.

Table 1 GLOBAL_SESSION_MEMORY columns

Name

Type

Description

node_name

name

Node name.

sessid

text

Thread start time and ID.

init_mem

integer

Memory allocated to the currently executed job before the job enters the executor.

used_mem

integer

Memory allocated to the currently executed job.

peak_mem

integer

Peak memory allocated to the currently executed job.
Parent topic: Session and Thread