GS_SESSION_MEMORY_STATISTICS

GS_SESSION_MEMORY_STATISTICS displays load management information about memory usage of ongoing complex jobs executed by the current user.

Table 1 GS_SESSION_MEMORY_STATISTICS columns

Name

Type

Description

datid

oid

OID of the database that the 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

Unsupported currently

top_mem_dn

text

Memory usage

Feedback
编组 3备份
    openGauss 2024-04-21 00:47:23
    cancel