Help Center > > Developer Guide> System Catalogs and System Views> System Views> GS_SESSION_MEMORY_STATISTICS

GS_SESSION_MEMORY_STATISTICS

Updated at:Jul 15, 2020 GMT+08:00

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 this backend is connected to

usename

name

Name of the user logged in to the backend

pid

bigint

Process 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 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

Information about statement flushing into disks on DNs

None indicates that the statement has not been flushed to disks on any DNs.

All indicates that the statement has been flushed to disks on every DN.

[a:b] indicates that the statement has been flushed to disks on a of b DNs.

query

text

Statement that is being executed

node_group

text

Logical cluster of the user running the statement

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel