> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-8a08bda2.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> System table containing information about in-progress data part moves of MergeTree tables. Each data part movement is represented by a single row.

# system.moves

<h2 id="description">
  Description
</h2>

The table contains information about in-progress [data part moves](/reference/statements/alter/partition#move-partitionpart) of [MergeTree](/reference/engines/table-engines/mergetree-family/mergetree) tables. Each data part movement is represented by a single row.

<h2 id="columns">
  Columns
</h2>

* `database` ([String](/reference/data-types)) — Name of the database.
* `table` ([String](/reference/data-types)) — Name of the table containing moving data part.
* `elapsed` ([Float64](/reference/data-types)) — Time elapsed (in seconds) since data part movement started.
* `target_disk_name` ([String](/reference/data-types)) — Name of disk to which the data part is moving.
* `target_disk_path` ([String](/reference/data-types)) — Path to the mount point of the disk in the file system.
* `part_name` ([String](/reference/data-types)) — Name of the data part being moved.
* `part_size` ([UInt64](/reference/data-types)) — Data part size.
* `thread_id` ([UInt64](/reference/data-types)) — Identifier of a thread performing the movement.

<h2 id="example">
  Example
</h2>

```sql theme={null}
SELECT * FROM system.moves
```

```response theme={null}
┌─database─┬─table─┬─────elapsed─┬─target_disk_name─┬─target_disk_path─┬─part_name─┬─part_size─┬─thread_id─┐
│ default  │ test2 │ 1.668056039 │ s3               │ ./disks/s3/      │ all_3_3_0 │       136 │    296146 │
└──────────┴───────┴─────────────┴──────────────────┴──────────────────┴───────────┴───────────┴───────────┘
```

<h2 id="see-also">
  See Also
</h2>

* [MergeTree](/reference/engines/table-engines/mergetree-family/mergetree) table engine
* [Using Multiple Block Devices for Data Storage](/reference/engines/table-engines/mergetree-family/mergetree#table_engine-mergetree-multiple-volumes)
* [ALTER TABLE ... MOVE PART](/reference/statements/alter/partition#move-partitionpart) command