SHOW MEMORY
Description
The SHOW MEMORY command returns memory metrics around HyperIndex.
Syntax
bash
SHOW MEMORY [ALL | <node_number>] [IN <table>]A simple SHOW MEMORY returns metrics from Node 0.
ALL
Returns metrics from all nodes.
<node_number>
Allow fetching metrics from a specified node.
IN <table>
Allow retrieving HyperIndex metrics for a given table.
Output
| ColumnName | description |
|---|---|
| node | Node number from memory metric |
| schema | HyperIndex schema |
| table | HyperIndex table |
| table_type | HyperIndex table type (FACT,DIMENSION,EXTERNAL,LIMITED) |
| index | HyperIndex name |
| count | Number of entries in HyperIndex |
| size_bytes_in_memory | Memory footprint of HyperIndex (in byte) |
| dictionary_bytes_in_memory | Dictionary in-memory footprint (in byte) |
| bucketsize_bytes_on_disk | Bucket size on disk (in byte) |
| loaded | True if HyperIndex is loaded in memory |