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.
Cache Types:
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 |
||||
__OLAPCachedSymbolBa… |
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 |