MULTIINDEXES System Table Description

Description

A pseudo table generated to display information about Merge Tree indexes and their components.

Fields

Field Name Type Description

CATALOGID

bigint

The catalog ID of Merge Tree index and its components.

COMPACTION

string

Possible values:

  • NONE

  • SOURCE

  • TARGET

COMPACTION_EPOCH

bigint

Merge Tree index compaction epoch.

COMPONENTTYPE

string

The different structures or components that make up the Merge Tree data storage.
Possible values:

  • MEMTABLE

  • SSTABLE

  • INTERMEDIATE_BTREE

  • MAIN_BTREE

CONSTRAINT_EPOCH

bigint

Multi index constraint epoch.

LEAFCOUNT

bigint

The number of index leaves in Merge Tree index component.

LEAVES_MERGED

bigint

The number of index leaves merged during the last compaction into this component.

LEAVES_UPDATED

bigint

The number of index leaves updated during the last compaction into this component.

MULTIINDEXID

bigint

Merge Tree index object ID.

OBJECTID

bigint

Merge Tree index component object ID (PlatformIndex).