Updated on 2023-10-23 GMT+08:00

SESSION_MEMORY_RUNTIME

SESSION_MEMORY_RUNTIME displays memory usage information about ongoing complex jobs executed by the current user.

Table 1 SESSION_MEMORY_RUNTIME columns

Name

Type

Description

datid

oid

OID of the database that this backend is connected to

usename

name

Name of the user logged in to the backend

pid

bigint

Backend thread ID

start_time

timestamp with time zone

Time when the statement starts to be executed

min_peak_memory

integer

Minimum memory peak of the statement across all DNs, in MB

max_peak_memory

integer

Maximum memory peak of the statement across all DNs, in MB

spill_info

text

Statement spill information on all DNs:
  • None: No data is spilled to disks on all DNs.
  • All: Data is spilled to disks on all DNs.
  • [a:b]: The statement has been spilled to disks on a of b DNs.

query

text

Statement being executed

node_group

text

Logical cluster of the user running the statement (The current feature is a lab feature. Contact Huawei engineers for technical support before using it.)

top_mem_dn

text

Top N memory usage