Updated on 2025-05-29 GMT+08:00

GLOBAL_SESSION_SQL_MEMORY

GLOBAL_SESSION_SQL_MEMORY displays the memory usage of the statements being executed by the current user on each node, as shown in Table 1.

Table 1 GLOBAL_SESSION_SQL_MEMORY columns

Name

Type

Description

node_name

text

Name of the node in the current cluster.

pid

bigint

Thread ID.

sessionid

bigint

Session ID.

unique_sql_id

bigint

Unique SQL statement ID.

query_id

bigint

Debug query ID of a statement.

query

text

Current running statement of the session.

peak_used_memory

integer

Peak memory usage of the statement, in MB.

current_used_memory

integer

Current memory usage of the statement, in MB.