getSessionMemoryStat

Syntax

getSessionMemoryStat()

Arguments

None

Details

Return information about memory usage of all sessions on the current node. It returns a table containing the following columns:

  • userId: the user ID or the cache type (in the format of __xxx__).

  • sessionId: the session ID.

  • memSize: memory usage of all sessions (in Bytes).

  • remoteIP: the IP address of the client that initiates the session.

  • remotePort: the port number of the client that initiates the session.

  • createTime: the creation time (of TIMESTAMP data type) of session.

  • lastActiveTime: last timestamp of the execution.

The cache type can be:

Cache Types Meaning
__DimensionalTable__ the cache of dimension tables (in Bytes)
__SharedTable__ the cache of shared tables (in Bytes)
__OLAPTablet__ the cache of the OLAP databases (in Bytes)
__OLAPCacheEngine__ the memory usage of OLAP cache engine (in Bytes)
__OLAPCachedSymbolBase__ the cache of SYMBOL base in OLAP engine (in Bytes)
__DFSMetadata__ the cache of DFS metadata (in Bytes)
__StreamingPubQueue__ the unprocessed messages in a publisher queue
__StreamingSubQueue__ the unprocessed messages in a subscriber queue

Note:

  • This function does not return the memory occupied by tasks being executed in the session.

  • For the columns createTime and lastActiveTime in the result table, versions before 1.30.21.4/2.00.9.4 return GMT time. From version 1.30.21.4/2.00.9.4 onwards, these columns return time in your current time zone.

Examples

t = getSessionMemoryStat();
t;
userId sessionId memSize remoteIP remotePort createTime lastActiveTime
__DimensionalTable__ 0 0.0.0.0
__SharedTable__ 0 0.0.0.0
__OLAPTablet__ 0 0.0.0.0
__OLAPCacheEngine__ 0 0.0.0.0
__OLAPCachedSymbolBase__ 0 0.0.0.0
__DFSMetadata__ 2769 0.0.0.0
__StreamingPubQueue__ 0 0.0.0.0
__StreamingSubQueue__ 0 0.0.0.0
admin 2882591513 1416 60.176.105.0 20861 2023.02.15T02:15:22.384 2023.02.15T02:24:16.307