ClickHouse MonitoringMonitoring

Table: system.part_log_0


ProfileEvents	`Map(String, UInt64)`	7.14 MiB	232.98 MiB	32.62	571.96 thousand	427.13	All the profile events captured during this operation.
query_id	`String`	3.47 MiB	6.79 MiB	1.96	571.96 thousand	12.45	Identifier of the INSERT query that created this data part.
part_name	`String`	1.66 MiB	10.49 MiB	6.33	571.96 thousand	19.23	Name of the data part.
event_time_microseconds	`DateTime64(6)`	1.25 MiB	4.34 MiB	3.46	571.96 thousand	7.95	Event time with microseconds precision.
path_on_disk	`String`	1.15 MiB	23.95 MiB	20.85	571.96 thousand	43.91	Absolute path to the folder with data part files.
merged_from	`Array(String)`	858.24 KiB	9.58 MiB	11.43	571.96 thousand	17.56	An array of the source parts names which the current part was made up from.
bytes_uncompressed	`UInt64`	846.80 KiB	4.34 MiB	5.24	571.96 thousand	7.95	Uncompressed size of the resulting part in bytes.
size_in_bytes	`UInt64`	845.45 KiB	4.34 MiB	5.25	571.96 thousand	7.95	Size of the data part on disk in bytes.
rows	`UInt64`	510.01 KiB	4.34 MiB	8.7	571.96 thousand	7.95	The number of rows in the data part.
read_bytes	`UInt64`	382.02 KiB	4.34 MiB	11.62	571.96 thousand	7.95	The number of bytes was read during the merge.
peak_memory_usage	`UInt64`	273.99 KiB	4.34 MiB	16.2	571.96 thousand	7.95	The maximum amount of used during merge RAM
read_rows	`UInt64`	266.47 KiB	4.34 MiB	16.66	571.96 thousand	7.95	The number of rows was read during the merge.
event_time	`DateTime`	262.28 KiB	2.17 MiB	8.46	571.96 thousand	3.97	Event time.
duration_ms	`UInt64`	215.56 KiB	4.34 MiB	20.59	571.96 thousand	7.95	Duration of this operation.
table	`String`	142.16 KiB	9.86 MiB	71.03	571.96 thousand	18.08	Name of the table the data part is in.
part_type	`String`	106.50 KiB	3.96 MiB	38.07	571.96 thousand	7.26	The type of the part. Possible values: Wide and Compact.
table_uuid	`UUID`	104.01 KiB	8.67 MiB	85.36	571.96 thousand	15.9	UUID of the table the data part belongs to.
partition	`String`	95.19 KiB	1.77 MiB	19.07	571.96 thousand	3.25	The partition name.
disk_name	`String`	93.22 KiB	2.44 MiB	26.79	571.96 thousand	4.47	The disk name data part lies on.
partition_id	`String`	82.97 KiB	2.87 MiB	35.42	571.96 thousand	5.26	ID of the partition that the data part was inserted to. The column takes the `all` value if the partitioning is by `tuple()`.
event_type	`Enum8('NewPart' = 1, 'MergeParts' = 2, 'DownloadPart' = 3, 'RemovePart' = 4, 'MutatePart' = 5, 'MovePart' = 6)`	62.43 KiB	554.91 KiB	8.89	571.96 thousand	0.99	Type of the event that occurred with the data part. Can have one of the following values: NewPart — Inserting of a new data part, MergeParts — Merging of data parts, DownloadPart — Downloading a data part, RemovePart — Removing or detaching a data part using DETACH PARTITION, MutatePart — Mutating of a data part, MovePart — Moving the data part from the one disk to another one.
merge_algorithm	`Enum8('Undecided' = 0, 'Vertical' = 1, 'Horizontal' = 2)`	52.02 KiB	554.91 KiB	10.67	571.96 thousand	0.99	Merge algorithm for the event with type MERGE_PARTS. Can have one of the following values: Undecided, Horizontal, Vertical
merge_reason	`Enum8('NotAMerge' = 1, 'RegularMerge' = 2, 'TTLDeleteMerge' = 3, 'TTLRecompressMerge' = 4)`	50.28 KiB	554.91 KiB	11.04	571.96 thousand	0.99	The reason for the event with type MERGE_PARTS. Can have one of the following values: NotAMerge — The current event has the type other than MERGE_PARTS, RegularMerge — Some regular merge, TTLDeleteMerge — Cleaning up expired data. TTLRecompressMerge — Recompressing data part with the.
database	`String`	9.69 KiB	8.58 MiB	906	571.96 thousand	15.72	Name of the database the data part is in.
event_date	`Date`	1.24 KiB	1.08 MiB	894.85	571.96 thousand	1.99	Event date.
hostname	`LowCardinality(String)`	991.00 B	556.25 KiB	574.77	571.96 thousand	1	Hostname of the server executing the query.
error	`UInt16`	297.00 B	702.00 B	2.36	571.96 thousand	0	The error code of the occurred exception.
exception	`String`	297.00 B	702.00 B	2.36	571.96 thousand	0	Text message of the occurred error.

0 of 28 row(s) selected.

Table: system.part_log_0


ProfileEvents	`Map(String, UInt64)`	7.14 MiB	232.98 MiB	32.62	571.96 thousand	427.13	All the profile events captured during this operation.
query_id	`String`	3.47 MiB	6.79 MiB	1.96	571.96 thousand	12.45	Identifier of the INSERT query that created this data part.
part_name	`String`	1.66 MiB	10.49 MiB	6.33	571.96 thousand	19.23	Name of the data part.
event_time_microseconds	`DateTime64(6)`	1.25 MiB	4.34 MiB	3.46	571.96 thousand	7.95	Event time with microseconds precision.
path_on_disk	`String`	1.15 MiB	23.95 MiB	20.85	571.96 thousand	43.91	Absolute path to the folder with data part files.
merged_from	`Array(String)`	858.24 KiB	9.58 MiB	11.43	571.96 thousand	17.56	An array of the source parts names which the current part was made up from.
bytes_uncompressed	`UInt64`	846.80 KiB	4.34 MiB	5.24	571.96 thousand	7.95	Uncompressed size of the resulting part in bytes.
size_in_bytes	`UInt64`	845.45 KiB	4.34 MiB	5.25	571.96 thousand	7.95	Size of the data part on disk in bytes.
rows	`UInt64`	510.01 KiB	4.34 MiB	8.7	571.96 thousand	7.95	The number of rows in the data part.
read_bytes	`UInt64`	382.02 KiB	4.34 MiB	11.62	571.96 thousand	7.95	The number of bytes was read during the merge.
peak_memory_usage	`UInt64`	273.99 KiB	4.34 MiB	16.2	571.96 thousand	7.95	The maximum amount of used during merge RAM
read_rows	`UInt64`	266.47 KiB	4.34 MiB	16.66	571.96 thousand	7.95	The number of rows was read during the merge.
event_time	`DateTime`	262.28 KiB	2.17 MiB	8.46	571.96 thousand	3.97	Event time.
duration_ms	`UInt64`	215.56 KiB	4.34 MiB	20.59	571.96 thousand	7.95	Duration of this operation.
table	`String`	142.16 KiB	9.86 MiB	71.03	571.96 thousand	18.08	Name of the table the data part is in.
part_type	`String`	106.50 KiB	3.96 MiB	38.07	571.96 thousand	7.26	The type of the part. Possible values: Wide and Compact.
table_uuid	`UUID`	104.01 KiB	8.67 MiB	85.36	571.96 thousand	15.9	UUID of the table the data part belongs to.
partition	`String`	95.19 KiB	1.77 MiB	19.07	571.96 thousand	3.25	The partition name.
disk_name	`String`	93.22 KiB	2.44 MiB	26.79	571.96 thousand	4.47	The disk name data part lies on.
partition_id	`String`	82.97 KiB	2.87 MiB	35.42	571.96 thousand	5.26	ID of the partition that the data part was inserted to. The column takes the `all` value if the partitioning is by `tuple()`.
event_type	`Enum8('NewPart' = 1, 'MergeParts' = 2, 'DownloadPart' = 3, 'RemovePart' = 4, 'MutatePart' = 5, 'MovePart' = 6)`	62.43 KiB	554.91 KiB	8.89	571.96 thousand	0.99	Type of the event that occurred with the data part. Can have one of the following values: NewPart — Inserting of a new data part, MergeParts — Merging of data parts, DownloadPart — Downloading a data part, RemovePart — Removing or detaching a data part using DETACH PARTITION, MutatePart — Mutating of a data part, MovePart — Moving the data part from the one disk to another one.
merge_algorithm	`Enum8('Undecided' = 0, 'Vertical' = 1, 'Horizontal' = 2)`	52.02 KiB	554.91 KiB	10.67	571.96 thousand	0.99	Merge algorithm for the event with type MERGE_PARTS. Can have one of the following values: Undecided, Horizontal, Vertical
merge_reason	`Enum8('NotAMerge' = 1, 'RegularMerge' = 2, 'TTLDeleteMerge' = 3, 'TTLRecompressMerge' = 4)`	50.28 KiB	554.91 KiB	11.04	571.96 thousand	0.99	The reason for the event with type MERGE_PARTS. Can have one of the following values: NotAMerge — The current event has the type other than MERGE_PARTS, RegularMerge — Some regular merge, TTLDeleteMerge — Cleaning up expired data. TTLRecompressMerge — Recompressing data part with the.
database	`String`	9.69 KiB	8.58 MiB	906	571.96 thousand	15.72	Name of the database the data part is in.
event_date	`Date`	1.24 KiB	1.08 MiB	894.85	571.96 thousand	1.99	Event date.
hostname	`LowCardinality(String)`	991.00 B	556.25 KiB	574.77	571.96 thousand	1	Hostname of the server executing the query.
error	`UInt16`	297.00 B	702.00 B	2.36	571.96 thousand	0	The error code of the occurred exception.
exception	`String`	297.00 B	702.00 B	2.36	571.96 thousand	0	Text message of the occurred error.

0 of 28 row(s) selected.