ClickHouse: 22.3 is twice slower than 21.3 under the same conditions

Refer to https://clickhouse.com/docs/en/getting-started/example-datasets/star-schema/. Performance tests were performed to compare the 21.3.4.25-lts and 22.3.2.1-lts kernels,

Hardware specifications: CPU:32U Memory: 128 GB table lineorder_flat: 13709313797 rows;

The expectation of testing is that 22.3 is better than 21.3 or basically the same. Test results show that the performance of Q4, Q7, Q8, and Q9 SQL 21.3 is better than that of 22.3,But the 21.3 uses five to six times the Peak memory usage of the 22.3.

The following uses Q4 trace logs as an example: 21.3：

[ClickHouse21] 2022.05.11 15:57:39.799349 [ 874111 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Debug> executeQuery: (from 192.168.0.7:51956, using production parser) SELECT sum(LO_REVENUE), toYear(LO_ORDERDATE) AS year, P_BRAND FROM lineorder_flat WHERE P_CATEGORY = *** AND S_REGION = *** GROUP BY year, P_BRAND ORDER BY year, P_BRAND;
[ClickHouse21] 2022.05.11 15:57:39.799826 [ 874111 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Debug> InterpreterSelectQuery: MergeTreeWhereOptimizer: condition "P_CATEGORY = 'MFGR#12'" moved to PREWHERE
[ClickHouse21] 2022.05.11 15:57:39.800470 [ 874111 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> ContextAccess (default): Access granted: SELECT(LO_ORDERDATE, LO_REVENUE, S_REGION, P_CATEGORY, P_BRAND) ON default.lineorder_flat
[ClickHouse21] 2022.05.11 15:57:39.800736 [ 874111 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Debug> default.lineorder_flat (fd59eeee-a13e-4204-befb-b4858d5ce79f) (SelectExecutor): Key condition: unknown, unknown, and, unknown, and
[ClickHouse21] 2022.05.11 15:57:39.800758 [ 874111 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Debug> default.lineorder_flat (fd59eeee-a13e-4204-befb-b4858d5ce79f) (SelectExecutor): MinMax index condition: unknown, unknown, and, unknown, and
[ClickHouse21] 2022.05.11 15:57:39.801314 [ 874111 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Debug> default.lineorder_flat (fd59eeee-a13e-4204-befb-b4858d5ce79f) (SelectExecutor): Selected 29/29 parts by partition key, 29 parts by primary key, 1722010/1722039 marks by primary key, 1722010 marks to read from 29 ranges
[ClickHouse21] 2022.05.11 15:57:39.802340 [ 874111 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> default.lineorder_flat (fd59eeee-a13e-4204-befb-b4858d5ce79f) (SelectExecutor): Reading approx. 13709313797 rows with 32 streams
[ClickHouse21] 2022.05.11 15:57:39.803220 [ 874111 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
[ClickHouse21] 2022.05.11 15:57:39.808983 [ 874141 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.809056 [ 874141 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.809067 [ 874366 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.809120 [ 874366 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.809140 [ 874141 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.809146 [ 874324 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.809173 [ 874366 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.809401 [ 874252 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.809460 [ 874252 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.809532 [ 874252 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.809755 [ 874360 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.809823 [ 874360 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.809872 [ 874339 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.809924 [ 874339 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.809934 [ 874360 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.809987 [ 874339 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.810206 [ 874125 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.810262 [ 874125 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.810322 [ 874192 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.810338 [ 874125 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.810391 [ 874192 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.810421 [ 874153 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.810473 [ 874153 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.810476 [ 874192 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.810543 [ 874153 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.811111 [ 874146 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.811166 [ 874146 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.811227 [ 874146 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.811458 [ 874336 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.811503 [ 874336 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.811528 [ 874195 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.811568 [ 874336 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.811570 [ 874195 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.811667 [ 874195 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.812402 [ 874337 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.812464 [ 874337 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.812483 [ 874151 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.812533 [ 874151 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.812546 [ 874337 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.812594 [ 874151 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.813003 [ 874368 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.813047 [ 874368 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.813107 [ 874368 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.813487 [ 874232 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.813537 [ 874232 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.813598 [ 874232 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.813637 [ 874127 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.813679 [ 874127 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.813734 [ 874127 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.813742 [ 874348 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.813790 [ 874348 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.813849 [ 874348 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.813810 [ 874237 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.813883 [ 874237 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.813948 [ 874237 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.814262 [ 874143 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.814344 [ 874198 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.814384 [ 874129 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.814397 [ 874198 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.814465 [ 874154 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.814513 [ 874198 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.810208 [ 874208 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.814402 [ 874342 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.814546 [ 874208 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.814474 [ 874129 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.814569 [ 874342 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.814621 [ 874208 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.812532 [ 874351 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.814636 [ 874129 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.814531 [ 874154 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.814790 [ 874154 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.815142 [ 874344 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.815198 [ 874344 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.815262 [ 874344 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.809183 [ 874324 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.816305 [ 874324 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.814695 [ 874351 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.816951 [ 874272 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.817026 [ 874272 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.817035 [ 874351 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.817086 [ 874272 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.817586 [ 874200 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.817627 [ 874200 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.817687 [ 874200 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.817753 [ 874145 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.817798 [ 874145 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.817868 [ 874145 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.818692 [ 874242 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.818747 [ 874242 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.818805 [ 874242 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.814358 [ 874143 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.819542 [ 874143 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.814673 [ 874342 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:39.822059 [ 874130 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregating
[ClickHouse21] 2022.05.11 15:57:39.822117 [ 874130 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse21] 2022.05.11 15:57:39.822170 [ 874130 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Converting aggregation data to two-level.
[ClickHouse21] 2022.05.11 15:57:44.900398 [ 874125 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3476264 to 280 rows (from 144.90 MiB) in 5.096278196 sec. (682118.178463741 rows/sec., 28.43 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.900671 [ 874141 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3361066 to 280 rows (from 139.80 MiB) in 5.096591088 sec. (659473.3503171718 rows/sec., 27.43 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.901181 [ 874143 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3423639 to 280 rows (from 142.52 MiB) in 5.097114768 sec. (671681.7564112577 rows/sec., 27.96 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.901267 [ 874351 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3292253 to 280 rows (from 137.33 MiB) in 5.097214545 sec. (645892.5695465306 rows/sec., 26.94 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.901281 [ 874145 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3403205 to 280 rows (from 141.79 MiB) in 5.097144552 sec. (667668.9203692806 rows/sec., 27.82 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.901409 [ 874195 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3471148 to 280 rows (from 144.39 MiB) in 5.097251912 sec. (680984.1969607563 rows/sec., 28.33 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.901524 [ 874252 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3437659 to 280 rows (from 142.66 MiB) in 5.09740689 sec. (674393.6817647296 rows/sec., 27.99 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.901654 [ 874344 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3412839 to 280 rows (from 141.76 MiB) in 5.097549638 sec. (669505.7904995725 rows/sec., 27.81 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.900407 [ 874208 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3502084 to 280 rows (from 145.86 MiB) in 5.096315488 sec. (687179.5924420604 rows/sec., 28.62 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.901733 [ 874198 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3483390 to 280 rows (from 145.21 MiB) in 5.097599037 sec. (683339.3475470401 rows/sec., 28.49 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.901739 [ 874242 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3459519 to 280 rows (from 144.06 MiB) in 5.097599907 sec. (678656.4389349986 rows/sec., 28.26 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.901741 [ 874232 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3496679 to 280 rows (from 145.53 MiB) in 5.097577213 sec. (685949.1978037449 rows/sec., 28.55 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.901807 [ 874200 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3496304 to 280 rows (from 145.60 MiB) in 5.097641473 sec. (685866.987413377 rows/sec., 28.56 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.901813 [ 874146 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3414926 to 280 rows (from 141.91 MiB) in 5.097720488 sec. (669892.75069881 rows/sec., 27.84 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.901838 [ 874127 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3519733 to 280 rows (from 146.74 MiB) in 5.097792139 sec. (690442.6277157787 rows/sec., 28.79 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.901923 [ 874339 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3458285 to 280 rows (from 143.95 MiB) in 5.097764717 sec. (678392.4311899545 rows/sec., 28.24 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.901990 [ 874130 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3313719 to 280 rows (from 138.05 MiB) in 5.097901 sec. (650016.3498663469 rows/sec., 27.08 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.901994 [ 874154 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3258731 to 280 rows (from 135.61 MiB) in 5.097920337 sec. (639227.5250651882 rows/sec., 26.60 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.902118 [ 874324 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3485877 to 280 rows (from 144.65 MiB) in 5.098062736 sec. (683765.0261509061 rows/sec., 28.37 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.902549 [ 874151 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3517815 to 280 rows (from 146.31 MiB) in 5.098520046 sec. (689967.8668047744 rows/sec., 28.70 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.902616 [ 874272 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3425031 to 280 rows (from 142.36 MiB) in 5.098463868 sec. (671777.0467094737 rows/sec., 27.92 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.902692 [ 874129 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3362815 to 280 rows (from 140.19 MiB) in 5.09857795 sec. (659559.3973413705 rows/sec., 27.50 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.902936 [ 874192 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3387097 to 280 rows (from 140.81 MiB) in 5.09889327 sec. (664280.8195120351 rows/sec., 27.62 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.902955 [ 874336 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3299903 to 280 rows (from 137.47 MiB) in 5.098894478 sec. (647180.092515733 rows/sec., 26.96 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.902979 [ 874337 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3346636 to 280 rows (from 139.15 MiB) in 5.098893183 sec. (656345.5793029504 rows/sec., 27.29 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.902989 [ 874368 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3545066 to 280 rows (from 147.50 MiB) in 5.098842648 sec. (695268.7589585723 rows/sec., 28.93 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.903005 [ 874360 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3417738 to 280 rows (from 142.24 MiB) in 5.09890506 sec. (670288.6129046694 rows/sec., 27.90 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.903010 [ 874153 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3000428 to 280 rows (from 124.82 MiB) in 5.098975774 sec. (588437.3907598016 rows/sec., 24.48 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.903191 [ 874237 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3442425 to 280 rows (from 143.32 MiB) in 5.09912042 sec. (675101.7266621053 rows/sec., 28.11 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.903215 [ 874366 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3331908 to 280 rows (from 139.04 MiB) in 5.099086552 sec. (653432.3287164316 rows/sec., 27.27 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.903252 [ 874342 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3464588 to 280 rows (from 144.59 MiB) in 5.099108432 sec. (679449.7599340322 rows/sec., 28.36 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.904322 [ 874348 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> AggregatingTransform: Aggregated. 3381491 to 280 rows (from 141.26 MiB) in 5.100200204 sec. (663011.4240119347 rows/sec., 27.70 MiB/sec.)
[ClickHouse21] 2022.05.11 15:57:44.904354 [ 874348 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Trace> Aggregator: Merging aggregated data
[ClickHouse21] 2022.05.11 15:57:44.909449 [ 874111 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Information> executeQuery: Read 13709313797 rows, 131.47 GiB in 5.110021328 sec., 2682829075 rows/sec., 25.73 GiB/sec.
[ClickHouse21] 2022.05.11 15:57:44.909490 [ 874111 ] {d575b8ee-1cd2-44d7-8324-0b306057861a} <Debug> MemoryTracker: Peak memory usage (for query): 302.60 MiB.
1904384670017	1992	MFGR#121
1918589347240	1992	MFGR#1210
1939101153254	1992	MFGR#1211
1899564467531	1992	MFGR#1212
1956218984260	1992	MFGR#1213
1990660102539	1992	MFGR#1214
1935205749032	1992	MFGR#1215
1994911083938	1992	MFGR#1216
1944692981628	1992	MFGR#1217
1948536236460	1992	MFGR#1218
1899304697074	1992	MFGR#1219
1993313478617	1992	MFGR#122
1892552254557	1992	MFGR#1220
1965429044233	1992	MFGR#1221
1926130436388	1992	MFGR#1222
1887121638768	1992	MFGR#1223
1946679417646	1992	MFGR#1224
1913594806486	1992	MFGR#1225
1924674188599	1992	MFGR#1226
1836741372478	1992	MFGR#1227
1964426636304	1992	MFGR#1228
1930918438565	1992	MFGR#1229
2005173567273	1992	MFGR#123
1874557015164	1992	MFGR#1230
1923181774887	1992	MFGR#1231
2050675104338	1992	MFGR#1232
1876150558393	1992	MFGR#1233
1907215730181	1992	MFGR#1234
1926985629603	1992	MFGR#1235
1902737129450	1992	MFGR#1236
1944448690851	1992	MFGR#1237
1889914230763	1992	MFGR#1238
1894400917931	1992	MFGR#1239
1945288492382	1992	MFGR#124
2002441179557	1992	MFGR#1240
1898201944630	1992	MFGR#125
1847768942212	1992	MFGR#126
1892220181676	1992	MFGR#127
1919018918408	1992	MFGR#128
1837321757497	1992	MFGR#129
1263400992597	1993	MFGR#121
1273305186320	1993	MFGR#1210
1281598795261	1993	MFGR#1211
1240125236357	1993	MFGR#1212
1297532931336	1993	MFGR#1213
1326417321252	1993	MFGR#1214
1277376984942	1993	MFGR#1215
1317607624777	1993	MFGR#1216
1290327370560	1993	MFGR#1217
1289825550067	1993	MFGR#1218
1259776446472	1993	MFGR#1219
1323507537707	1993	MFGR#122
1247924919246	1993	MFGR#1220
1295676582948	1993	MFGR#1221
1274664004430	1993	MFGR#1222
1250364661167	1993	MFGR#1223
1285975764669	1993	MFGR#1224
1260535627415	1993	MFGR#1225
1266125252446	1993	MFGR#1226
1223208164340	1993	MFGR#1227
1309671347386	1993	MFGR#1228
1278754852902	1993	MFGR#1229
1313037165778	1993	MFGR#123
1235360867262	1993	MFGR#1230
1267238670982	1993	MFGR#1231
1356422597918	1993	MFGR#1232
1229891468679	1993	MFGR#1233
1264450093098	1993	MFGR#1234
1265370391443	1993	MFGR#1235
1255144472614	1993	MFGR#1236
1288465200746	1993	MFGR#1237
1262454653131	1993	MFGR#1238
1251138895097	1993	MFGR#1239
1283220251293	1993	MFGR#124
1298898836160	1993	MFGR#1240
1264110101423	1993	MFGR#125
1220255547025	1993	MFGR#126
1253278242937	1993	MFGR#127
1273950311859	1993	MFGR#128
1216737809563	1993	MFGR#129
1754735336692	1994	MFGR#121
1777041252210	1994	MFGR#1210
1799862859702	1994	MFGR#1211
1743131434659	1994	MFGR#1212
1817112174659	1994	MFGR#1213
1870828353532	1994	MFGR#1214
1791307263649	1994	MFGR#1215
1851718666434	1994	MFGR#1216
1804310666178	1994	MFGR#1217
1808746342484	1994	MFGR#1218
1762351566395	1994	MFGR#1219
1853748111821	1994	MFGR#122
1744253058741	1994	MFGR#1220
1809522476862	1994	MFGR#1221
1787640618196	1994	MFGR#1222
1765545470804	1994	MFGR#1223
1805363651916	1994	MFGR#1224
1765147140910	1994	MFGR#1225
1767826450387	1994	MFGR#1226
1718799664362	1994	MFGR#1227
1821368665268	1994	MFGR#1228
1797915108652	1994	MFGR#1229
1845870418731	1994	MFGR#123
1738956173724	1994	MFGR#1230
1779241227427	1994	MFGR#1231
1903926670188	1994	MFGR#1232
1738542137889	1994	MFGR#1233
1782496445983	1994	MFGR#1234
1788636114792	1994	MFGR#1235
1743904207734	1994	MFGR#1236
1800946799355	1994	MFGR#1237
1771131050306	1994	MFGR#1238
1767569062115	1994	MFGR#1239
1803445002829	1994	MFGR#124
1845770494095	1994	MFGR#1240
1778955731245	1994	MFGR#125
1719824390745	1994	MFGR#126
1766775532765	1994	MFGR#127
1781592953533	1994	MFGR#128
1717470678980	1994	MFGR#129
1402688506093	1995	MFGR#121
1431608292389	1995	MFGR#1210
1444907822566	1995	MFGR#1211
1397446440099	1995	MFGR#1212
1448845690858	1995	MFGR#1213
1486034559097	1995	MFGR#1214
1432274231226	1995	MFGR#1215
1487264154768	1995	MFGR#1216
1455130791030	1995	MFGR#1217
1464672334350	1995	MFGR#1218
1413978522293	1995	MFGR#1219
1497680330422	1995	MFGR#122
1409974146035	1995	MFGR#1220
1465857181378	1995	MFGR#1221
1435456251408	1995	MFGR#1222
1406802929131	1995	MFGR#1223
1439535155478	1995	MFGR#1224
1429275683123	1995	MFGR#1225
1423765085443	1995	MFGR#1226
1371107895515	1995	MFGR#1227
1475886373596	1995	MFGR#1228
1449941214715	1995	MFGR#1229
1477146471820	1995	MFGR#123
1395342204873	1995	MFGR#1230
1422862802830	1995	MFGR#1231
1516211927190	1995	MFGR#1232
1393008358534	1995	MFGR#1233
1425732700148	1995	MFGR#1234
1442594629006	1995	MFGR#1235
1425068065001	1995	MFGR#1236
1444126801810	1995	MFGR#1237
1393904894046	1995	MFGR#1238
1412504190258	1995	MFGR#1239
1447897353141	1995	MFGR#124
1474391133795	1995	MFGR#1240
1432785190928	1995	MFGR#125
1390038933830	1995	MFGR#126
1410752517408	1995	MFGR#127
1438122078538	1995	MFGR#128
1369081012671	1995	MFGR#129
1319464901569	1996	MFGR#121
1327389117763	1996	MFGR#1210
1347477775996	1996	MFGR#1211
1304387996981	1996	MFGR#1212
1359690100703	1996	MFGR#1213
1389970795128	1996	MFGR#1214
1349413109085	1996	MFGR#1215
1374954907745	1996	MFGR#1216
1358072661715	1996	MFGR#1217
1350419938029	1996	MFGR#1218
1316338043174	1996	MFGR#1219
1384151557401	1996	MFGR#122
1304891206506	1996	MFGR#1220
1350370810347	1996	MFGR#1221
1325364178168	1996	MFGR#1222
1315327435795	1996	MFGR#1223
1361229291556	1996	MFGR#1224
1325748784166	1996	MFGR#1225
1331401043665	1996	MFGR#1226
1274650587298	1996	MFGR#1227
1359897740032	1996	MFGR#1228
1342679179101	1996	MFGR#1229
1379554045523	1996	MFGR#123
1300170095112	1996	MFGR#1230
1334114594907	1996	MFGR#1231
1414606618819	1996	MFGR#1232
1297388205098	1996	MFGR#1233
1325913957502	1996	MFGR#1234
1338189025680	1996	MFGR#1235
1323028720993	1996	MFGR#1236
1348604965133	1996	MFGR#1237
1309746590804	1996	MFGR#1238
1324465376727	1996	MFGR#1239
1345540704176	1996	MFGR#124
1390112334733	1996	MFGR#1240
1322783672457	1996	MFGR#125
1286074902635	1996	MFGR#126
1313500325878	1996	MFGR#127
1337711497197	1996	MFGR#128
1276809027419	1996	MFGR#129
1437183341351	1997	MFGR#121
1447675525211	1997	MFGR#1210
1479950344396	1997	MFGR#1211
1420175425849	1997	MFGR#1212
1489101253973	1997	MFGR#1213
1523514595032	1997	MFGR#1214
1461347166676	1997	MFGR#1215
1498229476349	1997	MFGR#1216
1483191238451	1997	MFGR#1217
1475772884060	1997	MFGR#1218
1442130411666	1997	MFGR#1219
1509415550932	1997	MFGR#122
1438110976412	1997	MFGR#1220
1493173608928	1997	MFGR#1221
1460831744296	1997	MFGR#1222
1431573417006	1997	MFGR#1223
1477239576920	1997	MFGR#1224
1443445626185	1997	MFGR#1225
1457146758574	1997	MFGR#1226
1401766130826	1997	MFGR#1227
1493259974869	1997	MFGR#1228
1474364937888	1997	MFGR#1229
1505034361796	1997	MFGR#123
1434639743840	1997	MFGR#1230
1452593415595	1997	MFGR#1231
1555540277192	1997	MFGR#1232
1424349811394	1997	MFGR#1233
1454595537084	1997	MFGR#1234
1466527735714	1997	MFGR#1235
1448443593641	1997	MFGR#1236
1471755850908	1997	MFGR#1237
1442420140102	1997	MFGR#1238
1445026398575	1997	MFGR#1239
1476380877590	1997	MFGR#124
1519524294796	1997	MFGR#1240
1446922030910	1997	MFGR#125
1412911344463	1997	MFGR#126
1444541368396	1997	MFGR#127
1453088557062	1997	MFGR#128
1389999311898	1997	MFGR#129
669137094432	1998	MFGR#121
680046187287	1998	MFGR#1210
692206357145	1998	MFGR#1211
668077537634	1998	MFGR#1212
698482410211	1998	MFGR#1213
708985903165	1998	MFGR#1214
684256465733	1998	MFGR#1215
696246856563	1998	MFGR#1216
696190595379	1998	MFGR#1217
697049520434	1998	MFGR#1218
673535555244	1998	MFGR#1219
708048851591	1998	MFGR#122
668538292374	1998	MFGR#1220
695937716573	1998	MFGR#1221
687813408829	1998	MFGR#1222
669941469760	1998	MFGR#1223
695851341696	1998	MFGR#1224
673536507925	1998	MFGR#1225
682403168960	1998	MFGR#1226
651952240525	1998	MFGR#1227
702048434204	1998	MFGR#1228
684176245090	1998	MFGR#1229
709842265571	1998	MFGR#123
663622156619	1998	MFGR#1230
679418917885	1998	MFGR#1231
724399166095	1998	MFGR#1232
661767263434	1998	MFGR#1233
676017588753	1998	MFGR#1234
690960948675	1998	MFGR#1235
674743069949	1998	MFGR#1236
686734956165	1998	MFGR#1237
672389390219	1998	MFGR#1238
679368356031	1998	MFGR#1239
691179176731	1998	MFGR#124
703209099104	1998	MFGR#1240
669960942013	1998	MFGR#125
657059104689	1998	MFGR#126
673532061386	1998	MFGR#127
680831704412	1998	MFGR#128
658281839401	1998	MFGR#129

22.3:

[ClickHouse22] 2022.05.11 17:18:33.240569 [ 70746 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> executeQuery: (from 192.168.0.7:51466) SELECT sum(LO_REVENUE), toYear(LO_ORDERDATE) AS year, P_BRAND FROM lineorder_flat WHERE P_CATEGORY = 'MFGR#12' AND S_REGION = 'AMERICA' GROUP BY year, P_BRAND ORDER BY year, P_BRAND;
[ClickHouse22] 2022.05.11 17:18:33.241095 [ 70746 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> InterpreterSelectQuery: MergeTreeWhereOptimizer: condition "P_CATEGORY = 'MFGR#12'" moved to PREWHERE
[ClickHouse22] 2022.05.11 17:18:33.241403 [ 70746 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> InterpreterSelectQuery: MergeTreeWhereOptimizer: condition "P_CATEGORY = 'MFGR#12'" moved to PREWHERE
[ClickHouse22] 2022.05.11 17:18:33.241647 [ 70746 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> ContextAccess (default): Access granted: SELECT(LO_ORDERDATE, LO_REVENUE, S_REGION, P_CATEGORY, P_BRAND) ON default.lineorder_flat
[ClickHouse22] 2022.05.11 17:18:33.241860 [ 70746 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> ContextAccess (default): Access granted: SELECT(LO_ORDERDATE, LO_REVENUE, S_REGION, P_CATEGORY, P_BRAND) ON default.lineorder_flat
[ClickHouse22] 2022.05.11 17:18:33.241930 [ 70746 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> InterpreterSelectQuery: FetchColumns -> Complete
[ClickHouse22] 2022.05.11 17:18:33.242160 [ 70746 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> default.lineorder_flat (fd59eeee-a13e-4204-befb-b4858d5ce79f) (SelectExecutor): Key condition: unknown, unknown, and, unknown, and
[ClickHouse22] 2022.05.11 17:18:33.242338 [ 70746 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> default.lineorder_flat (fd59eeee-a13e-4204-befb-b4858d5ce79f) (SelectExecutor): MinMax index condition: unknown, unknown, and, unknown, and
[ClickHouse22] 2022.05.11 17:18:33.243553 [ 70746 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> default.lineorder_flat (fd59eeee-a13e-4204-befb-b4858d5ce79f) (SelectExecutor): Selected 29/29 parts by partition key, 29 parts by primary key, 1722010/1722010 marks by primary key, 1722010 marks to read from 29 ranges
[ClickHouse22] 2022.05.11 17:18:33.244339 [ 70746 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> default.lineorder_flat (fd59eeee-a13e-4204-befb-b4858d5ce79f) (SelectExecutor): Reading approx. 13709313797 rows with 32 streams
[ClickHouse22] 2022.05.11 17:18:33.264488 [ 70940 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.264523 [ 70940 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.264732 [ 70997 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.264776 [ 70997 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.293544 [ 71001 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.293588 [ 71001 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.294811 [ 70824 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.294842 [ 70824 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.296642 [ 70945 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.296690 [ 70945 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.317372 [ 71037 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.317417 [ 71037 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.317597 [ 70815 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.317655 [ 70815 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.319381 [ 71059 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.319425 [ 71059 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.320445 [ 70854 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.320474 [ 70854 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.356944 [ 70972 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.356989 [ 70972 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.357723 [ 70975 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.357766 [ 70975 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.357800 [ 71053 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.357827 [ 71053 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.358567 [ 70839 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.358620 [ 70839 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.365723 [ 70943 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.365770 [ 70943 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.366851 [ 70995 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.366899 [ 70995 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.366927 [ 71009 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.366975 [ 71009 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.367006 [ 71045 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.367039 [ 71045 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.369536 [ 70953 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.369612 [ 70953 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.370023 [ 70864 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.370046 [ 70864 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.370194 [ 70833 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.370242 [ 70833 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.374039 [ 70820 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.374123 [ 70820 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.375531 [ 71021 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.375603 [ 71021 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.375535 [ 70947 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.375631 [ 70947 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.376053 [ 70827 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.376085 [ 70827 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.377932 [ 71023 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.377996 [ 71023 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.379832 [ 70878 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.379889 [ 70878 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.383425 [ 70957 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.383505 [ 70957 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.383577 [ 70990 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.383632 [ 70990 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.383767 [ 71020 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.383817 [ 71020 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.384614 [ 70941 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.384655 [ 70941 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.385337 [ 70987 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.385381 [ 70987 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:33.386394 [ 70837 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> AggregatingTransform: Aggregating
[ClickHouse22] 2022.05.11 17:18:33.386457 [ 70837 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Aggregation method: serialized
[ClickHouse22] 2022.05.11 17:18:46.162370 [ 71021 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3294216 to 280 rows (from 136.99 MiB) in 12.916490424 sec. (255039.557 rows/sec., 10.61 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.162707 [ 70878 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3368385 to 280 rows (from 140.33 MiB) in 12.916863455 sec. (260774.221 rows/sec., 10.86 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.162867 [ 71053 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3545279 to 280 rows (from 147.82 MiB) in 12.917081212 sec. (274464.404 rows/sec., 11.44 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.162453 [ 71059 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3409984 to 280 rows (from 142.06 MiB) in 12.916670263 sec. (263998.688 rows/sec., 11.00 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.162870 [ 70990 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3443439 to 280 rows (from 143.65 MiB) in 12.916968308 sec. (266582.600 rows/sec., 11.12 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.162918 [ 70975 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3429239 to 280 rows (from 142.75 MiB) in 12.917128901 sec. (265479.971 rows/sec., 11.05 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.162451 [ 70837 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3453350 to 280 rows (from 144.00 MiB) in 12.91654254 sec. (267358.698 rows/sec., 11.15 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.163110 [ 70987 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3331741 to 280 rows (from 138.80 MiB) in 12.91722013 sec. (257930.187 rows/sec., 10.75 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.163175 [ 71001 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3357958 to 280 rows (from 139.63 MiB) in 12.917352256 sec. (259957.144 rows/sec., 10.81 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.163640 [ 71045 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3451869 to 280 rows (from 143.53 MiB) in 12.917792645 sec. (267218.177 rows/sec., 11.11 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.163972 [ 70943 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3388132 to 280 rows (from 140.89 MiB) in 12.918137185 sec. (262277.134 rows/sec., 10.91 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.164194 [ 70833 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3318943 to 280 rows (from 138.33 MiB) in 12.918377937 sec. (256916.388 rows/sec., 10.71 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.164316 [ 70864 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3360555 to 280 rows (from 139.58 MiB) in 12.918522105 sec. (260134.632 rows/sec., 10.80 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.164981 [ 70820 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3430554 to 280 rows (from 142.89 MiB) in 12.919194624 sec. (265539.308 rows/sec., 11.06 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.165148 [ 70854 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3455241 to 280 rows (from 143.67 MiB) in 12.919336746 sec. (267447.243 rows/sec., 11.12 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.165298 [ 70815 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3349699 to 280 rows (from 139.82 MiB) in 12.919478574 sec. (259275.092 rows/sec., 10.82 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.165778 [ 70824 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3412752 to 280 rows (from 142.13 MiB) in 12.919951964 sec. (264145.874 rows/sec., 11.00 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.165854 [ 70997 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3635506 to 280 rows (from 151.05 MiB) in 12.919973649 sec. (281386.487 rows/sec., 11.69 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.165866 [ 70839 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3338306 to 280 rows (from 138.88 MiB) in 12.920096173 sec. (258380.894 rows/sec., 10.75 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.165950 [ 70953 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3116597 to 280 rows (from 129.76 MiB) in 12.920142763 sec. (241220.013 rows/sec., 10.04 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.166002 [ 70940 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3334561 to 280 rows (from 138.79 MiB) in 12.920126478 sec. (258090.430 rows/sec., 10.74 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.166083 [ 70957 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3393904 to 280 rows (from 141.00 MiB) in 12.920177553 sec. (262682.458 rows/sec., 10.91 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.166087 [ 70945 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3517685 to 280 rows (from 146.58 MiB) in 12.920257512 sec. (272261.214 rows/sec., 11.34 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.166277 [ 70827 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3380896 to 280 rows (from 140.51 MiB) in 12.920416401 sec. (261670.824 rows/sec., 10.88 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.166663 [ 71020 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3518603 to 280 rows (from 145.99 MiB) in 12.920760288 sec. (272321.669 rows/sec., 11.30 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.166752 [ 71037 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3575442 to 280 rows (from 149.12 MiB) in 12.920977353 sec. (276716.064 rows/sec., 11.54 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.166953 [ 70972 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3426833 to 280 rows (from 142.41 MiB) in 12.921151391 sec. (265211.118 rows/sec., 11.02 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.167235 [ 70941 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3197310 to 280 rows (from 132.94 MiB) in 12.921340527 sec. (247444.140 rows/sec., 10.29 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.167305 [ 71023 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3486572 to 280 rows (from 145.39 MiB) in 12.921451316 sec. (269828.204 rows/sec., 11.25 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.167584 [ 70995 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3467247 to 280 rows (from 144.51 MiB) in 12.921727789 sec. (268326.888 rows/sec., 11.18 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.168876 [ 71009 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3487686 to 280 rows (from 145.16 MiB) in 12.923010948 sec. (269881.842 rows/sec., 11.23 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.180791 [ 70947 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> AggregatingTransform: Aggregated. 3411777 to 280 rows (from 142.44 MiB) in 12.934912572 sec. (263764.983 rows/sec., 11.01 MiB/sec.)
[ClickHouse22] 2022.05.11 17:18:46.180829 [ 70947 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Trace> Aggregator: Merging aggregated data
1904384670017	1992	MFGR#121
1918589347240	1992	MFGR#1210
1939101153254	1992	MFGR#1211
1899564467531	1992	MFGR#1212
1956218984260	1992	MFGR#1213
1990660102539	1992	MFGR#1214
1935205749032	1992	MFGR#1215
1994911083938	1992	MFGR#1216
1944692981628	1992	MFGR#1217
1948536236460	1992	MFGR#1218
1899304697074	1992	MFGR#1219
1993313478617	1992	MFGR#122
1892552254557	1992	MFGR#1220
1965429044233	1992	MFGR#1221
1926130436388	1992	MFGR#1222
1887121638768	1992	MFGR#1223
1946679417646	1992	MFGR#1224
1913594806486	1992	MFGR#1225
1924674188599	1992	MFGR#1226
1836741372478	1992	MFGR#1227
1964426636304	1992	MFGR#1228
1930918438565	1992	MFGR#1229
2005173567273	1992	MFGR#123
1874557015164	1992	MFGR#1230
1923181774887	1992	MFGR#1231
2050675104338	1992	MFGR#1232
1876150558393	1992	MFGR#1233
1907215730181	1992	MFGR#1234
1926985629603	1992	MFGR#1235
1902737129450	1992	MFGR#1236
1944448690851	1992	MFGR#1237
1889914230763	1992	MFGR#1238
1894400917931	1992	MFGR#1239
1945288492382	1992	MFGR#124
2002441179557	1992	MFGR#1240
1898201944630	1992	MFGR#125
1847768942212	1992	MFGR#126
1892220181676	1992	MFGR#127
1919018918408	1992	MFGR#128
1837321757497	1992	MFGR#129
1263400992597	1993	MFGR#121
1273305186320	1993	MFGR#1210
1281598795261	1993	MFGR#1211
1240125236357	1993	MFGR#1212
1297532931336	1993	MFGR#1213
1326417321252	1993	MFGR#1214
1277376984942	1993	MFGR#1215
1317607624777	1993	MFGR#1216
1290327370560	1993	MFGR#1217
1289825550067	1993	MFGR#1218
1259776446472	1993	MFGR#1219
1323507537707	1993	MFGR#122
1247924919246	1993	MFGR#1220
1295676582948	1993	MFGR#1221
1274664004430	1993	MFGR#1222
1250364661167	1993	MFGR#1223
1285975764669	1993	MFGR#1224
1260535627415	1993	MFGR#1225
1266125252446	1993	MFGR#1226
1223208164340	1993	MFGR#1227
1309671347386	1993	MFGR#1228
1278754852902	1993	MFGR#1229
1313037165778	1993	MFGR#123
1235360867262	1993	MFGR#1230
1267238670982	1993	MFGR#1231
1356422597918	1993	MFGR#1232
1229891468679	1993	MFGR#1233
1264450093098	1993	MFGR#1234
1265370391443	1993	MFGR#1235
1255144472614	1993	MFGR#1236
1288465200746	1993	MFGR#1237
1262454653131	1993	MFGR#1238
1251138895097	1993	MFGR#1239
1283220251293	1993	MFGR#124
1298898836160	1993	MFGR#1240
1264110101423	1993	MFGR#125
1220255547025	1993	MFGR#126
1253278242937	1993	MFGR#127
1273950311859	1993	MFGR#128
1216737809563	1993	MFGR#129
1754735336692	1994	MFGR#121
1777041252210	1994	MFGR#1210
1799862859702	1994	MFGR#1211
1743131434659	1994	MFGR#1212
1817112174659	1994	MFGR#1213
1870828353532	1994	MFGR#1214
1791307263649	1994	MFGR#1215
1851718666434	1994	MFGR#1216
1804310666178	1994	MFGR#1217
1808746342484	1994	MFGR#1218
1762351566395	1994	MFGR#1219
1853748111821	1994	MFGR#122
1744253058741	1994	MFGR#1220
1809522476862	1994	MFGR#1221
1787640618196	1994	MFGR#1222
1765545470804	1994	MFGR#1223
1805363651916	1994	MFGR#1224
1765147140910	1994	MFGR#1225
1767826450387	1994	MFGR#1226
1718799664362	1994	MFGR#1227
1821368665268	1994	MFGR#1228
1797915108652	1994	MFGR#1229
1845870418731	1994	MFGR#123
1738956173724	1994	MFGR#1230
1779241227427	1994	MFGR#1231
1903926670188	1994	MFGR#1232
1738542137889	1994	MFGR#1233
1782496445983	1994	MFGR#1234
1788636114792	1994	MFGR#1235
1743904207734	1994	MFGR#1236
1800946799355	1994	MFGR#1237
1771131050306	1994	MFGR#1238
1767569062115	1994	MFGR#1239
1803445002829	1994	MFGR#124
1845770494095	1994	MFGR#1240
1778955731245	1994	MFGR#125
1719824390745	1994	MFGR#126
1766775532765	1994	MFGR#127
1781592953533	1994	MFGR#128
1717470678980	1994	MFGR#129
1402688506093	1995	MFGR#121
1431608292389	1995	MFGR#1210
1444907822566	1995	MFGR#1211
1397446440099	1995	MFGR#1212
1448845690858	1995	MFGR#1213
1486034559097	1995	MFGR#1214
1432274231226	1995	MFGR#1215
1487264154768	1995	MFGR#1216
1455130791030	1995	MFGR#1217
1464672334350	1995	MFGR#1218
1413978522293	1995	MFGR#1219
1497680330422	1995	MFGR#122
1409974146035	1995	MFGR#1220
1465857181378	1995	MFGR#1221
1435456251408	1995	MFGR#1222
1406802929131	1995	MFGR#1223
1439535155478	1995	MFGR#1224
1429275683123	1995	MFGR#1225
1423765085443	1995	MFGR#1226
1371107895515	1995	MFGR#1227
1475886373596	1995	MFGR#1228
1449941214715	1995	MFGR#1229
1477146471820	1995	MFGR#123
1395342204873	1995	MFGR#1230
1422862802830	1995	MFGR#1231
1516211927190	1995	MFGR#1232
1393008358534	1995	MFGR#1233
1425732700148	1995	MFGR#1234
1442594629006	1995	MFGR#1235
1425068065001	1995	MFGR#1236
1444126801810	1995	MFGR#1237
1393904894046	1995	MFGR#1238
1412504190258	1995	MFGR#1239
1447897353141	1995	MFGR#124
1474391133795	1995	MFGR#1240
1432785190928	1995	MFGR#125
1390038933830	1995	MFGR#126
1410752517408	1995	MFGR#127
1438122078538	1995	MFGR#128
1369081012671	1995	MFGR#129
1319464901569	1996	MFGR#121
1327389117763	1996	MFGR#1210
1347477775996	1996	MFGR#1211
1304387996981	1996	MFGR#1212
1359690100703	1996	MFGR#1213
1389970795128	1996	MFGR#1214
1349413109085	1996	MFGR#1215
1374954907745	1996	MFGR#1216
1358072661715	1996	MFGR#1217
1350419938029	1996	MFGR#1218
1316338043174	1996	MFGR#1219
1384151557401	1996	MFGR#122
1304891206506	1996	MFGR#1220
1350370810347	1996	MFGR#1221
1325364178168	1996	MFGR#1222
1315327435795	1996	MFGR#1223
1361229291556	1996	MFGR#1224
1325748784166	1996	MFGR#1225
1331401043665	1996	MFGR#1226
1274650587298	1996	MFGR#1227
1359897740032	1996	MFGR#1228
1342679179101	1996	MFGR#1229
1379554045523	1996	MFGR#123
1300170095112	1996	MFGR#1230
1334114594907	1996	MFGR#1231
1414606618819	1996	MFGR#1232
1297388205098	1996	MFGR#1233
1325913957502	1996	MFGR#1234
1338189025680	1996	MFGR#1235
1323028720993	1996	MFGR#1236
1348604965133	1996	MFGR#1237
1309746590804	1996	MFGR#1238
1324465376727	1996	MFGR#1239
1345540704176	1996	MFGR#124
1390112334733	1996	MFGR#1240
1322783672457	1996	MFGR#125
1286074902635	1996	MFGR#126
1313500325878	1996	MFGR#127
1337711497197	1996	MFGR#128
1276809027419	1996	MFGR#129
1437183341351	1997	MFGR#121
1447675525211	1997	MFGR#1210
1479950344396	1997	MFGR#1211
1420175425849	1997	MFGR#1212
1489101253973	1997	MFGR#1213
1523514595032	1997	MFGR#1214
1461347166676	1997	MFGR#1215
1498229476349	1997	MFGR#1216
1483191238451	1997	MFGR#1217
1475772884060	1997	MFGR#1218
1442130411666	1997	MFGR#1219
1509415550932	1997	MFGR#122
1438110976412	1997	MFGR#1220
1493173608928	1997	MFGR#1221
1460831744296	1997	MFGR#1222
1431573417006	1997	MFGR#1223
1477239576920	1997	MFGR#1224
1443445626185	1997	MFGR#1225
1457146758574	1997	MFGR#1226
1401766130826	1997	MFGR#1227
1493259974869	1997	MFGR#1228
1474364937888	1997	MFGR#1229
1505034361796	1997	MFGR#123
1434639743840	1997	MFGR#1230
1452593415595	1997	MFGR#1231
1555540277192	1997	MFGR#1232
1424349811394	1997	MFGR#1233
1454595537084	1997	MFGR#1234
1466527735714	1997	MFGR#1235
1448443593641	1997	MFGR#1236
1471755850908	1997	MFGR#1237
1442420140102	1997	MFGR#1238
1445026398575	1997	MFGR#1239
1476380877590	1997	MFGR#124
1519524294796	1997	MFGR#1240
1446922030910	1997	MFGR#125
1412911344463	1997	MFGR#126
1444541368396	1997	MFGR#127
1453088557062	1997	MFGR#128
1389999311898	1997	MFGR#129
669137094432	1998	MFGR#121
680046187287	1998	MFGR#1210
692206357145	1998	MFGR#1211
668077537634	1998	MFGR#1212
698482410211	1998	MFGR#1213
708985903165	1998	MFGR#1214
684256465733	1998	MFGR#1215
696246856563	1998	MFGR#1216
696190595379	1998	MFGR#1217
697049520434	1998	MFGR#1218
673535555244	1998	MFGR#1219
708048851591	1998	MFGR#122
668538292374	1998	MFGR#1220
695937716573	1998	MFGR#1221
687813408829	1998	MFGR#1222
669941469760	1998	MFGR#1223
695851341696	1998	MFGR#1224
673536507925	1998	MFGR#1225
682403168960	1998	MFGR#1226
651952240525	1998	MFGR#1227
702048434204	1998	MFGR#1228
684176245090	1998	MFGR#1229
709842265571	1998	MFGR#123
663622156619	1998	MFGR#1230
679418917885	1998	MFGR#1231
724399166095	1998	MFGR#1232
661767263434	1998	MFGR#1233
676017588753	1998	MFGR#1234
690960948675	1998	MFGR#1235
674743069949	1998	MFGR#1236
686734956165	1998	MFGR#1237
672389390219	1998	MFGR#1238
679368356031	1998	MFGR#1239
691179176731	1998	MFGR#124
703209099104	1998	MFGR#1240
669960942013	1998	MFGR#125
657059104689	1998	MFGR#126
673532061386	1998	MFGR#127
680831704412	1998	MFGR#128
658281839401	1998	MFGR#129
[ClickHouse22] 2022.05.11 17:18:46.182426 [ 70746 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Information> executeQuery: Read 13709313797 rows, 131.47 GiB in 12.941789078 sec., 1059305920 rows/sec., 10.16 GiB/sec.
[ClickHouse22] 2022.05.11 17:18:46.185119 [ 70746 ] {b6ec2343-11d9-4a3c-952f-8e6bd8b36980} <Debug> MemoryTracker: Peak memory usage (for query): 55.87 MiB.

According to the trace logs, the main differences are the aggregation conversion process, the reason, whether the difference is caused by optimizing memory usage, or whether there are related configurations that can optimize this phenomenon.

About this issue

  • Original URL
  • State: closed
  • Created 2 years ago
  • Reactions: 3
  • Comments: 18 (14 by maintainers)

Most upvoted comments

it was a big slowdown in reading from merge tree. and it seems to be already fixed in #37978 (actually, I had to apply three pr-s which are depend on each other: #36856, #37978 and #38239). after applying these to 420bdfa27510fe18e20f881d74ab66cddc44583d (HEAD, tag: v22.3.7.28-lts) everything looks right:

21.3.20.1 22.3.7.28 w/ patch
1.0 0.76
0.12 0.1
0.045 0.045
7.4 4.0
6.1 3.5
5.8 3.2
10.4 7.1
6.3 5.8
5.4 5.4
0.09 0.085
10.5 6.8
2.9 2.4
2.3 2.0

some numbers for v21 changed ^ 'cause last measurements were done on plain binaries outside of docker. affected versions: 22.1 - 22.6

+1
nickitat on Jul 6, 2022

my tests haven’t shown slowdown for 4-th query, but actually showed it for 8-th and 9-th:

21.3.20.1 22.3.7.28
1.0 0.78
0.12 0.1
0.045 0.045
7.7 6.4
6.4 5.1
6.0 4.8
10.7 10.4
6.5 9.0
5.6 6.9
0.85 0.85
11.1 10.3
3.0 2.8
2.4 2.3

Q8:

SELECT
    C_CITY,
    S_CITY,
    toYear(LO_ORDERDATE) AS year,
    sum(LO_REVENUE) AS revenue
FROM lineorder_flat
WHERE C_NATION = 'UNITED STATES' AND S_NATION = 'UNITED STATES' AND year >= 1992 AND year <= 1997
GROUP BY
    C_CITY,
    S_CITY,
    year
ORDER BY
    year ASC,
    revenue DESC;

Q9:

SELECT
    C_CITY,
    S_CITY,
    toYear(LO_ORDERDATE) AS year,
    sum(LO_REVENUE) AS revenue
FROM lineorder_flat
WHERE (C_CITY = 'UNITED KI1' OR C_CITY = 'UNITED KI5') AND (S_CITY = 'UNITED KI1' OR S_CITY = 'UNITED KI5') AND year >= 1992 AND year <= 1997
GROUP BY
    C_CITY,
    S_CITY,
    year
ORDER BY
    year ASC,
    revenue DESC;

and again new version uses much less memory. so I suppose that some optimization of memory usage in aggregation (with method serialized) happened, that may negatively affect exec time.

+1
nickitat on Jul 4, 2022

I also wondering is it the official build since those traces like 1904384670017 1992 MFGR#121 doesn’t look like CH’s traces.

it’s data/result from the query. They did not use format Null

+1
den-crane on May 20, 2022
Read more comments on GitHub
← ClickHouse: DB::Exception: ODBCBridgeHelper: clickhouse-odbc-bridge is not responding
ClickHouse: A bug in Kafka engine: Segmentation fault (JSONEachRowRowInputFormat) →