Updated on 2025-05-29 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, as described in Table 1.

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. For a stored procedure, function, or package, the first query time is queried and does not change with the running of statements in the stored procedure.

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: No disk flushing is performed on any database node.
  • All: Disk flushing has been performed on all the database nodes.
  • [a:b]: Among the total b database nodes, disk flushing has been performed on a database nodes.

query

text

Statement being executed.

top_mem_dn

text

Top N memory usage.