Description

The SHOW MEMORY command returns memory metrics around HyperIndex.

Syntax

Syntax

SHOW MEMORY [ALL | <node_number>] [IN <table>]
BASH

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

ColumnNamedescription
nodeNode number from memory metric
schemaHyperIndex schema 
tableHyperIndex table 
table_typeHyperIndex table type (FACT,DIMENSION,EXTERNAL,LIMITED)
indexHyperIndex name
countNumber of entries in HyperIndex
size_bytes_in_memoryMemory footprint of HyperIndex (in byte)
dictionary_bytes_in_memoryDictionary in-memory footprint (in byte)
bucketsize_bytes_on_diskBucket size on disk (in byte)
loaded True if HyperIndex is loaded in memory