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

SESSION_MEMORY_RUNTIME

SESSION_MEMORY_RUNTIME displays load management information about memory usage of ongoing complex jobs executed by the current user. The current feature is a lab feature. Contact Huawei technical support before using it.

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

Thread ID of the backend

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 the database nodes, in MB

max_peak_memory

integer

Maximum memory peak of the statement across the database nodes, in MB

spill_info

text

Information about statement spill to the database nodes
  • None: The statement has not been spilled to disks on the database nodes.
  • All: The statement has been spilled to disks on the database nodes.
  • [a:b]: The statement has been spilled to disks on a of b database nodes.

query

text

Statement being executed

node_group

text

Logical database of the user running the statement

top_mem_dn

text

Top N memory usage