Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs
49.6kGet Started

system.merges

View as MarkdownEdit this pageReport an issueSet up docs MCP

Description

Contains information about merges and part mutations currently in process for tables in the MergeTree family.

Columns

  • database (String) — The name of the database the table is in.
  • table (String) — Table name.
  • elapsed (Float64) — The time elapsed (in seconds) since the merge started.
  • progress (Float64) — The percentage of completed work from 0 to 1.
  • num_parts (UInt64) — The number of parts to be merged.
  • source_part_names (Array(String)) — The list of source parts names.
  • result_part_name (String) — The name of the part that will be formed as the result of merging.
  • source_part_paths (Array(String)) — The list of paths for each source part.
  • result_part_path (String) — The path of the part that will be formed as the result of merging.
  • partition_id (String) — The identifier of the partition where the merge is happening.
  • partition (String) — The name of the partition
  • is_mutation (UInt8) — 1 if this process is a part mutation.
  • total_size_bytes_compressed (UInt64) — The total size of the compressed data in the merged chunks.
  • total_size_bytes_uncompressed (UInt64) — The total size of compressed data in the merged chunks.
  • total_size_marks (UInt64) — The total number of marks in the merged parts.
  • bytes_read_uncompressed (UInt64) — Number of bytes read, uncompressed.
  • rows_read (UInt64) — Number of rows read.
  • bytes_written_uncompressed (UInt64) — Number of bytes written, uncompressed.
  • rows_written (UInt64) — Number of rows written.
  • columns_written (UInt64) — Number of columns written (for Vertical merge algorithm).
  • memory_usage (UInt64) — Memory consumption of the merge process.
  • thread_id (UInt64) — Thread ID of the merge process.
  • merge_type (String) — The type of current merge. Empty if it’s an mutation.
  • merge_algorithm (String) — The algorithm used in current merge. Empty if it’s an mutation.
  • current_projection (String) — The name of the projection currently being merged or rebuilt. Empty if not in the projection merge stage.
  • current_projection_progress (Float64) — The progress of the current projection merge from 0 to 1.
  • current_projection_parts_merging (UInt64) — The number of projection parts currently being merged.
  • current_projection_parts_remaining (UInt64) — The number of projection parts remaining to be merged for the current projection.
  • projections_completed (Array(String)) — The list of projections that have been merged or rebuilt so far.
  • projections_remaining (Array(String)) — The list of projections that still need to be merged or rebuilt.
Navigation