Skip to main content
Skip table of contents

SHOW MEMORY

Description

The SHOW MEMORY command returns memory metrics around HyperIndex.

Syntax

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

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
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.