SingleStore Managed Service

information_schema.MV_COLUMNSTORE_MERGE_STATUS

This view stores information about the status of background_merger processes for columnstore tables.

Column Name

Description

DATABASE_NAME

The name of the related database.

TABLE_NAME

The name of the related table.

PARTITION_ID

The ID of the related partition.

MERGER

Specifies whether the given status is for slow, fast, manual, or index merging.

STATE

The current state of the merge step: Idle, Waiting, Preparing, Merging Segments, Compacting Segments, Merging Indexes, Compacting Indexes, Updating Statistics, or Populating Altering-Encoding.

PLAN

The size, in number of segments, or the rows being merged.

PROGRESS_PERCENT

Merge progress represented as a number between 0 and 100.