getSessionMemoryStat

Syntax

getSessionMemoryStat()

None

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

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 memory usage of DFS metadata in distributed storage (in Bytes)
__TSDBCacheEngine__	the cache of the TSDB engine (in Bytes)
__TSDBLevelFileIndex__	the cache of level file index in the TSDB engine (in Bytes)
__TSDBCachedSymbolBase__	the cache of SYMBOL base in TSDB engine (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.

t = getSessionMemoryStat();
t;