# MV\_COLUMNSTORE\_ACTIVE\_MERGE\_PLANS

This view contains information about merge plans that are running.

| Column Name       | Description                                                                                                                                                                                                                                                                                                                |
| ----------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `DATABASE_NAME`   | The name of the database.                                                                                                                                                                                                                                                                                                  |
| `TABLE_NAME`      | The name of the table.                                                                                                                                                                                                                                                                                                     |
| `PARTITION_ID`    | The ID of the related partition.                                                                                                                                                                                                                                                                                           |
| `CREATION_TIME`   | The timestamp when the merge plan was created.                                                                                                                                                                                                                                                                             |
| `ACCESS_TIME`     | The timestamp when the information for this plan was collected.                                                                                                                                                                                                                                                            |
| `LWPID`           | The process ID (PID) of the merge plan.                                                                                                                                                                                                                                                                                    |
| `DETAILS_STATIC`  | A JSON string that provides details about merge plans that are currently running. Contains information relevant to the plan that will not change during the plan's execution. This field is provided for debugging purposes.                                                                                               |
| `DETAILS_DYNAMIC` | A JSON string that provides details about merge plans that are currently running. Contains information that may change during the plan's execution. For example, as a plan progresses and creates more segments, the IDs for those new segments will show up in this field. This field is provided for debugging purposes. |

***

Modified at: July 3, 2025

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

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