Help Center/Data Warehouse Service/Standard Data Warehouse (9.1.0.x)/DWS System Catalogs and Views/System Views/GS_SESSION_MEMORY_STATISTICS
Updated on 2025-10-09 GMT+08:00
View PDF

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

Column

Type

Description

datid

OID

OID of the database the backend is connected to.

usename

Name

Username logged in to the backend.

pid

Bigint

Backend thread ID.

start_time

Timestamp with time zone

Start time of statement execution.

min_peak_memory

Integer

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

max_peak_memory

Integer

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

spill_info

Text

Spill information for the statement on all DNs. The options are:

None: The statement has not been spilled to disks on any DNs.

All: The statement has been spilled to disks on all DNs.

[a:b]: The statement has been spilled to disks on a of b DNs.

query

Text

Statement currently being executed.

node_group

Text

Logical cluster of the user running the statement.

Parent Topic: System Views