# MV\_COLUMNSTORE\_MERGE\_STATUS

This view stores information about the status of [background\_merger](https://docs.singlestore.com/db/v9.1/create-a-database/columnstore.md) 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.<ul> <li>(<code>Current Groups</code>) is the current state of the segment groups regarding the sort key.</li> <li>(<code>Current Index Groups on &#x3C;index name></code>) is the current state of the cross segment index blobs (for multi column indexes). </li> <li>(<code>Current Index Groups on Column &#x3C;column name></code>) is the current state of the cross segment index blobs (for single column indexes, and columns part of a multi column index). </li> <li><code>Fast Merger</code> / <code>Slow Merger</code> are the two background merger processes.</li> <li><code>Manual Merger</code> indicates a user running the <code>OPTIMIZE TABLE</code> command.</li> </ul> |
| `STATE`            | For rows corresponding to the current state of a merge process:<ul> <li><code>Idle</code> - not doing anything.</li> <li><code>Waiting</code> - waiting on another merger (mainly for manual OPTIMIZE commands).</li> <li><code>Preparing</code> - gathering information for merge.</li> <li><code>Merging Segments</code></li> <li><code>Compacting Segments</code></li> <li><code>Merging Indexes</code></li> <li><code>Compacting Indexes</code></li> <li><code>Updating Statistics</code></li> <li><code>Populating Altering-Encoding</code></li> </ul>For rows corresponding to the current state of the table (Current Groups, etc.):<ul> <li><code>NULL</code></li> <li><code>Building</code> - only for newly added indexes that are not yet populated.</li> </ul>   |
| `PLAN`             | The size, in number of segments, or the rows being merged.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
| `PROGRESS_PERCENT` | Merge progress represented as a number between 0 and 100.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    |

***

Modified at: August 29, 2022

Source: [/db/v9.1/reference/information-schema-reference/segment-column-and-merge-status/mv-columnstore-merge-status/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/segment-column-and-merge-status/mv-columnstore-merge-status/)

(An index of the documentation is available at /llms.txt)