getCacheEngineStat

Syntax

getCacheEngineStat()

Arguments

None

Details

Get the status of the OLAP cache engine on the current node. The function can only be called on the data node.

Return a table containing the following columns:

• chunkId: the chunk ID

• physicalName: the physical name of the table to which the chunk belongs

• timeSinceLastWrite: the time elapsed (in milliseconds) since last write

• cachedRowsOfCompletedTxn: the number of cached records of completed transactions

• cachedRowsOfUncompletedTxn: the number of cached records of uncompleted transactions. Note: For each chunk, only the last transaction may not have been completed.

• cachedMemOfCompletedTxn: the memory usage (in Bytes) of completed transactions

• cachedMemOfUncompletedTxn: the memory usage (in Bytes) of uncompleted transactions

• cachedTids: list of transaction IDs (tid)

Examples

$ getCacheEngineStat()

chunkId	physicalName	timeSinceLastWrite	cachedRowsOfCompletedTxn	cachedRowsOfUncompletedTxn	cachedMemOfCompletedTxn	cachedMemOfUncompletedTxn	cachedTids
e4558d3c-fa41-52b5-418b-94e26cb70a75	pt_2	1056	222,386	0	3,558,176	0	2052