AI agents/LLMs: Fetch /llms.txt first to access the documentation index. Remove the trailing slash and append .md to any URL to access lighter, easier-to-parse Markdown pages instead of HTML (this page is accessible at https://docs.singlestore.com/db/v7.5/reference/information-schema-reference/segment-column-and-merge-status/mv-columnstore-merge-status.md).
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.
-
(Current Groups) is the current state of the segment groups regarding the sort key.
-
(Current Index Groups on <index name>) is the current state of the cross segment index blobs (for multi column indexes).
-
(Current Index Groups on Column <column name>) is the current state of the cross segment index blobs (for single column indexes, and columns part of a multi column index).
-
Fast Merger / Slow Merger are the two background merger processes.
-
Manual Merger indicates a user running the OPTIMIZE TABLE command.
|
|
STATE
|
For rows corresponding to the current state of a merge process:
-
Idle - not doing anything.
-
Waiting - waiting on another merger (mainly for manual OPTIMIZE commands).
-
Preparing - gathering information for merge.
-
Merging Segments
-
Compacting Segments
-
Merging Indexes
-
Compacting Indexes
-
Updating Statistics
-
Populating Altering-Encoding
For rows corresponding to the current state of the table (Current Groups, etc.):
|
|
PLAN
|
The size, in number of segments, or the rows being merged.
|
|
PROGRESS_PERCENT
|
Merge progress represented as a number between 0 and 100.
|