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