ClickHouse performance comparison

Tested Commits ^?

Reference	Patched
ClickHouse local version 25.7.1.291 (official build).	commit 896ccc4536c18d89a3ce2454acc085ea78bf0eb1 Author: Vladimir Cherkasov Date: Tue Jun 17 18:29:57 2025 +0000 Merge pull request #80165 from ClickHouse/vidmir/issue_77369 Fix logical error with <=> operator and Join storage

Reference

Patched

ClickHouse local version 25.7.1.291 (official build).

commit 896ccc4536c18d89a3ce2454acc085ea78bf0eb1
Author: Vladimir Cherkasov 
Date:   Tue Jun 17 18:29:57 2025 +0000

    Merge pull request #80165 from ClickHouse/vidmir/issue_77369
    
    Fix logical error with <=> operator and Join storage

All Query Times ^?

Old, s	New, s	Ratio of speedup (-) or slowdown (+)	Relative difference (new − old) / old	p < 0.01 threshold	Test	#	Query
1.003	1.014	+1.011x	0.01	0.068	agg_functions_argmin_argmax	0	select argMin(Title, EventTime) from hits_100m_single where Title != '' group by intHash32(UserID) % 1000000 FORMAT Null
0.917	0.898	-1.021x	-0.021	0.041	agg_functions_argmin_argmax	1	select argMinIf(Title, EventTime, Title != '') from hits_100m_single group by intHash32(UserID) % 1000000 FORMAT Null
1.058	1.017	-1.04x	-0.039	0.042	agg_functions_argmin_argmax	2	select argMinIf(Title::Nullable(String), EventTime::Nullable(DateTime), Title::Nullable(String) != '') from hits_100m_single group by intHash32(UserID) % 1000000 FORMAT Null
0.765	0.812	+1.061x	0.06	0.09	agg_functions_argmin_argmax	3	select argMin(RegionID, EventTime) from hits_100m_single where Title != '' group by intHash32(UserID) % 1000000 FORMAT Null
1.647	1.701	+1.033x	0.033	0.047	agg_functions_argmin_argmax	4	select argMin((Title, RegionID), EventTime) from hits_100m_single where Title != '' group by intHash32(UserID) % 1000000 FORMAT Null
0.863	0.888	+1.029x	0.028	0.037	agg_functions_argmin_argmax	5	select argMinIf(Title, EventTime, Title != '') from hits_100m_single group by intHash32(UserID) % 1000000 FORMAT Null
0.033	0.034	+1.021x	0.021	0.037	agg_functions_argmin_argmax	6	select argMax(WatchID, Age) from hits_100m_single FORMAT Null
0.035	0.034	-1.009x	-0.009	0.039	agg_functions_argmin_argmax	7	select argMax(WatchID, Age::Nullable(UInt8)) from hits_100m_single FORMAT Null
2.013	2.085	+1.036x	0.035	0.035	agg_functions_argmin_argmax	8	select argMax(WatchID, (EventDate, EventTime)) from hits_100m_single where Title != '' group by intHash32(UserID) % 1000000 FORMAT Null
0.049	0.048	-1.006x	-0.006	0.009	agg_functions_argmin_argmax	9	select argMax(MobilePhone, MobilePhoneModel) from hits_100m_single
0.047	0.05	+1.066x	0.065	0.082	aggregate_functions_of_group_by_keys	0	SELECT min(length(URL)), max(length(URL)) FROM hits_10m_single GROUP BY length(URL) FORMAT Null
0.159	0.149	-1.068x	-0.064	0.388	aggregate_functions_of_group_by_keys	1	SELECT any(WatchID), anyLast(WatchID) FROM hits_10m_single GROUP BY WatchID FORMAT Null
0.022	0.022	-1.005x	-0.006	0.041	aggregation_in_order_2	0	SELECT sum(val2) FROM mt_30_parts_100_uniqs GROUP BY val1 FORMAT Null
0.028	0.028	-1.004x	-0.005	0.022	aggregation_in_order_2	1	SELECT sum(val2) FROM mt_30_parts_10000_uniqs GROUP BY val1 FORMAT Null
0.281	0.284	+1.01x	0.01	0.073	aggregation_in_order_2	2	SELECT sum(val2) FROM mt_30_parts_1000000_uniqs GROUP BY val1 FORMAT Null
0.232	0.148	-1.566x	-0.362	0.409	aggregation_in_order_2	3	SELECT groupArray(val2) FROM mt_30_parts_100_uniqs GROUP BY val1 FORMAT Null
0.125	0.119	-1.049x	-0.047	0.121	aggregation_in_order_2	4	SELECT groupArray(val2) FROM mt_30_parts_10000_uniqs GROUP BY val1 FORMAT Null
0.409	0.403	-1.014x	-0.015	0.13	aggregation_in_order_2	5	SELECT groupArray(val2) FROM mt_30_parts_1000000_uniqs GROUP BY val1 FORMAT Null
0.649	0.628	-1.033x	-0.032	0.088	aggregation_in_order_2	6	SELECT uniqExact(val2) FROM mt_30_parts_100_uniqs GROUP BY val1 FORMAT Null
0.743	0.727	-1.022x	-0.022	0.038	aggregation_in_order_2	7	SELECT uniqExact(val2) FROM mt_30_parts_10000_uniqs GROUP BY val1 FORMAT Null
0.668	0.656	-1.02x	-0.02	0.09	aggregation_in_order_2	8	SELECT uniqExact(val2) FROM mt_30_parts_1000000_uniqs GROUP BY val1 FORMAT Null
0.01	0.01	-1.01x	-0.012	0.03	alter_select	0	select count() from alter_select_mt format Null settings max_threads=1
0.013	0.013	+1.023x	0.02	0.038	alter_select	1	select count() from alter_select_rmt format Null settings max_threads=1
0.765	0.759	-1.008x	-0.008	0.058	alter_select	2	select * from alter_select_mt format Null settings max_threads=1
0.758	0.766	+1.011x	0.01	0.045	alter_select	3	select * from alter_select_rmt format Null settings max_threads=1
0.01	0.01	+1x	-0.002	0.02	analyze_array_tuples	0	SELECT [(1, 1), (2, 2), (3, 3), (4, 4), (5, 5), (6, 6), (7, 7), (8, 8), (9, 9), (10, 10), (11, 11), (12, 12), (13, 13), (14, 14), (15, 15), (16, 16), (17, 17), (18, 18), (19, 19), (20, 20), (21, 21), (22, 22), (23, 23), (24, 24), (25, 25), (26, 26), (27, 27), (28, 28), (29, 29), (30, 30), (31, 31), (32, 32), (33, 33), (34, 34), (35, 35), (36, 36), (37, 37), (38, 38), (39, 39), (40, 40), (41, 41), (42, 42), (43, 43), (44, 44), (45, 45), (46, 46), (47, 47), (48, 48), (49, 49), (50, 50), (51, 51), (52, 52), (53, 53), (54, 54), (55, 55), (56, 56), (57, 57), (58, 58), (59, 59), (60, 60), (61, 61), (62, 62), (63, 63), (64, 64), (65, 65), (66, 66), (67, 67), (68, 68), (69, 69), (70, 70), (71, 71), (72, 72), (73, 73), (74, 74), (75, 75), (76, 76), (77, 77), (78, 78), (79, 79), (80, 80), (81, 81), (82, 82), (83, 83), (84, 84), (85, 85), (86, 86), (87, 87), (88, 88), (89, 89), (90, 90), (91, 91), (92, 92), (93, 93), (94, 94), (95, 95), (96, 96), (97, 97), (98, 98), (99, 99), (100, 100), (101, 1...(0)
0.174	0.172	-1.012x	-0.012	0.06	arrayAUCPR	0	SELECT avg(ifNotFinite(arrayAUCPR(arrayMap(x -> rand(x) / 0x100000000, range(2 + rand() % 100)), arrayMap(x -> rand(x) % 2, range(2 + rand() % 100))), 0)) FROM numbers(100000)
0.349	0.348	-1.003x	-0.003	0.025	array_fill	0	SELECT arraySlice(arrayFill(x -> ((x % 2) >= 0), range(100000000)), 1, 10) FORMAT Null
0.124	0.101	-1.225x	-0.185	0.192	array_fill	1	SELECT arraySlice(arrayFill(x -> (((x.1) % 2) >= 0), arrayMap(x -> (x, toString(x)), range(10000000))), 1, 10) FORMAT Null
0.221	0.322	+1.454x	0.454	0.454	array_fill	2	SELECT arraySlice(arrayFill(x -> ((x % 2) >= 2), range(100000000)), 1, 10) FORMAT Null
0.089	0.084	-1.054x	-0.052	0.044	array_fill	3	SELECT arraySlice(arrayFill(x -> (((x.1) % 2) >= 2), arrayMap(x -> (x, toString(x)), range(10000000))), 1, 10) FORMAT Null
0.668	0.662	-1.008x	-0.009	0.172	array_fill	4	SELECT arraySlice(arrayFill(x -> ((x % 2) = 0), range(100000000)), 1, 10) FORMAT Null
0.253	0.222	-1.136x	-0.12	0.119	array_fill	5	SELECT arraySlice(arrayFill(x -> (((x.1) % 2) = 0), arrayMap(x -> (x, toString(x)), range(10000000))), 1, 10) FORMAT Null
0.018	0.018	-1.006x	-0.003	0.018	array_index_low_cardinality_numbers	0	SELECT count() FROM perf_lc_num WHERE num = 42
0.172	0.173	+1.007x	0.006	0.029	array_index_low_cardinality_numbers	1	SELECT count() FROM perf_lc_num WHERE arr[1] = 42
0.162	0.162	+1.001x	0.001	0.004	array_index_low_cardinality_numbers	2	SELECT count() FROM perf_lc_num WHERE has(arr, 42)
0.182	0.183	+1.007x	0.006	0.028	array_index_low_cardinality_numbers	3	SELECT count() FROM perf_lc_num WHERE indexOf(arr, 42) > 0
0.186	0.18	-1.036x	-0.035	0.061	array_index_low_cardinality_numbers	4	SELECT count() FROM perf_lc_num WHERE arr[1] = num
0.169	0.168	-1.007x	-0.007	0.037	array_index_low_cardinality_numbers	5	SELECT count() FROM perf_lc_num WHERE has(arr, num)
0.178	0.177	-1.006x	-0.007	0.023	array_index_low_cardinality_numbers	6	SELECT count() FROM perf_lc_num WHERE indexOf(arr, num) > 0
0.175	0.178	+1.015x	0.014	0.053	array_index_low_cardinality_numbers	7	SELECT count() FROM perf_lc_num WHERE has(arr, num * 10)
0.195	0.194	-1.006x	-0.006	0.019	array_index_low_cardinality_numbers	8	SELECT count() FROM perf_lc_num WHERE has(arr, (num * 1000 + 20) % 137)
0.262	0.31	+1.181x	0.18	0.183	array_index_low_cardinality_strings	0	SELECT count() FROM perf_lc_str WHERE str = 'asdf337'
0.403	0.383	-1.051x	-0.049	0.065	array_index_low_cardinality_strings	1	SELECT count() FROM perf_lc_str WHERE arr[1] = 'asdf337'
0.339	0.311	-1.09x	-0.083	0.148	array_index_low_cardinality_strings	2	SELECT count() FROM perf_lc_str WHERE has(arr, 'asdf337')
0.316	0.351	+1.11x	0.11	0.11	array_index_low_cardinality_strings	3	SELECT count() FROM perf_lc_str WHERE indexOf(arr, 'asdf337') > 0
0.664	0.734	+1.106x	0.105	0.115	array_index_low_cardinality_strings	4	SELECT count() FROM perf_lc_str WHERE arr[1] = str
0.702	0.753	+1.072x	0.072	0.089	array_index_low_cardinality_strings	5	SELECT count() FROM perf_lc_str WHERE has(arr, str)
0.759	0.716	-1.059x	-0.056	0.114	array_index_low_cardinality_strings	6	SELECT count() FROM perf_lc_str WHERE indexOf(arr, str) > 0
0.805	0.866	+1.075x	0.075	0.151	array_index_low_cardinality_strings	7	SELECT count() FROM perf_lc_str WHERE has(arr, concat('0', str))
0.811	0.834	+1.027x	0.027	0.136	array_index_low_cardinality_strings	8	SELECT count() FROM perf_lc_str WHERE has(arr, concat(str, 'str'))
0.817	0.855	+1.047x	0.046	0.089	array_index_low_cardinality_strings	9	SELECT count() FROM perf_lc_str WHERE has(arr, concat(str, '0'))
0.166	0.177	+1.07x	0.069	0.071	array_reduce	0	SELECT arrayReduce('count', range(1000000)) FROM numbers_mt(500000000) format Null
0.164	0.165	+1.002x	0.001	0.041	array_reduce	1	SELECT arrayReduce('sum', range(1000000)) FROM numbers_mt(500000000) format Null
0.17	0.17	+1x	-0.001	0.053	array_reduce	2	SELECT arrayReduceInRanges('count', [(1, 1000000)], range(1000000)) FROM numbers_mt(500000000) format Null
0.172	0.172	-1.004x	-0.004	0.04	array_reduce	3	SELECT arrayReduceInRanges('sum', [(1, 1000000)], range(1000000)) FROM numbers_mt(500000000) format Null
0.155	0.155	+1.002x	0.001	0.021	array_reduce	4	SELECT arrayReduceInRanges('count', arrayZip(range(1000000), range(1000000)), range(1000000))[123456]
0.157	0.157	+1.003x	0.003	0.011	array_reduce	5	SELECT arrayReduceInRanges('sum', arrayZip(range(1000000), range(1000000)), range(1000000))[123456]
0.042	0.042	+1x	0	0.024	bigint_formatting	0	SELECT * FROM bigint WHERE NOT ignore(toString(u128)) SETTINGS max_threads = 1
0.042	0.042	-1.01x	-0.009	0.028	bigint_formatting	1	SELECT * FROM bigint WHERE NOT ignore(toString(i128)) SETTINGS max_threads = 1
0.115	0.114	-1.003x	-0.003	0.015	bigint_formatting	2	SELECT * FROM bigint WHERE NOT ignore(toString(u256)) SETTINGS max_threads = 1
0.113	0.114	+1.014x	0.013	0.032	bigint_formatting	3	SELECT * FROM bigint WHERE NOT ignore(toString(i256)) SETTINGS max_threads = 1
0.126	0.124	-1.017x	-0.017	0.058	bit_operations_fixed_string_numbers	0	SELECT count() FROM numbers(100000000) WHERE NOT ignore(bitXor(reinterpretAsFixedString(number), reinterpretAsFixedString(number + 1)))
0.085	0.084	-1.008x	-0.008	0.013	bit_operations_fixed_string_numbers	1	SELECT count() FROM numbers(100000000) WHERE NOT ignore(bitXor(reinterpretAsFixedString(number), reinterpretAsFixedString(0xabcd0123cdef4567)))
0.224	0.219	-1.02x	-0.021	0.14	bloom_filter_insert	0	INSERT INTO test_bf SELECT number AS id, [CAST(id, 'String'), CAST(id + 1, 'String'), CAST(id + 2, 'String')] FROM numbers(1000000)
0.007	0.007	+1.015x	0.011	0.018	bloom_filter_select	0	SELECT count() FROM test_bf_indexOf WHERE indexOf(ary, '1') = 2
0.007	0.006	-1.015x	-0.007	0.018	bloom_filter_select	1	SELECT count() FROM test_bf_indexOf WHERE indexOf(ary, '1') > 0
1.041	1.032	-1.009x	-0.01	0.035	coalesce	0	select coalesce(materialize(null), -1) from numbers(1000000000) format Null settings max_block_size = 8192
0.032	0.032	+1.013x	0.01	0.035	codec_none	0	SELECT sum(length(Title)) FROM hits_none
1.223	1.23	+1.006x	0.005	0.013	codecs_float_insert	0	INSERT INTO codec_seq_Float64_NONE (n) SELECT number/pi() FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
1.122	1.136	+1.013x	0.013	0.031	codecs_float_insert	1	INSERT INTO codec_seq_Float64_LZ4 (n) SELECT number/pi() FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.314	0.314	-1.002x	-0.002	0.011	codecs_float_insert	2	INSERT INTO codec_seq_Float64_ZSTD (n) SELECT number/pi() FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.824	0.834	+1.012x	0.012	0.023	codecs_float_insert	4	INSERT INTO codec_seq_Float64_Gorilla (n) SELECT number/pi() FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
1.019	1.032	+1.013x	0.012	0.273	codecs_float_insert	6	INSERT INTO codec_mon_Float64_NONE (n) SELECT number+sin(number) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.56	0.563	+1.006x	0.005	0.025	codecs_float_insert	7	INSERT INTO codec_mon_Float64_LZ4 (n) SELECT number+sin(number) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.184	0.183	-1.003x	-0.003	0.033	codecs_float_insert	12	INSERT INTO codec_rnd_Float64_NONE (n) SELECT (intHash64(number) - 4294967295)/pi() FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.36	0.36	+1.002x	0.001	0.032	codecs_float_insert	14	INSERT INTO codec_rnd_Float64_ZSTD (n) SELECT (intHash64(number) - 4294967295)/pi() FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
1.249	1.268	+1.015x	0.015	0.089	codecs_float_insert	15	INSERT INTO codec_rnd_Float64_DoubleDelta (n) SELECT (intHash64(number) - 4294967295)/pi() FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.379	0.446	+1.179x	0.179	0.292	codecs_float_insert	17	INSERT INTO codec_rnd_Float64_FPC (n) SELECT (intHash64(number) - 4294967295)/pi() FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.148	0.15	+1.016x	0.016	0.027	codecs_int_insert	0	INSERT INTO codec_seq_UInt64_NONE (n) SELECT number FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.476	0.484	+1.017x	0.017	0.123	codecs_int_insert	1	INSERT INTO codec_seq_UInt64_LZ4 (n) SELECT number FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.15	0.152	+1.017x	0.016	0.034	codecs_int_insert	3	INSERT INTO codec_seq_UInt64_Delta (n) SELECT number FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.233	0.232	-1.004x	-0.005	0.029	codecs_int_insert	4	INSERT INTO codec_seq_UInt64_T64 (n) SELECT number FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.541	0.54	-1.001x	-0.002	0.022	codecs_int_insert	8	INSERT INTO codec_mon_UInt64_ZSTD (n) SELECT number*512+(intHash64(number)%512) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.191	0.192	+1.007x	0.006	0.123	codecs_int_insert	9	INSERT INTO codec_mon_UInt64_Delta (n) SELECT number*512+(intHash64(number)%512) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.577	0.606	+1.05x	0.05	0.521	codecs_int_insert	12	INSERT INTO codec_rnd_UInt64_NONE (n) SELECT intHash64(number) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
1.233	1.243	+1.008x	0.007	0.026	codecs_int_insert	13	INSERT INTO codec_rnd_UInt64_LZ4 (n) SELECT intHash64(number) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
1.231	1.236	+1.004x	0.004	0.013	codecs_int_insert	15	INSERT INTO codec_rnd_UInt64_Delta (n) SELECT intHash64(number) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
1.241	1.242	+1.001x	0	0.019	codecs_int_insert	17	INSERT INTO codec_rnd_UInt64_DoubleDelta (n) SELECT intHash64(number) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.13	0.131	+1.004x	0.003	0.023	column_array_filter	0	SELECT arr FROM (SELECT cast(range(number % 10) as Array(Int128)) AS arr FROM (SELECT * FROM system.numbers LIMIT 10000000) WHERE length(arr) <= 5) format Null
0.13	0.128	-1.013x	-0.014	0.032	column_array_filter	1	SELECT arr FROM (SELECT cast(range(number % 10) as Array(UInt128)) AS arr FROM (SELECT * FROM system.numbers LIMIT 10000000) WHERE length(arr) <= 5) format Null
0.184	0.194	+1.054x	0.053	0.068	column_array_filter	2	SELECT arr FROM (SELECT cast(range(number % 10) as Array(Int256)) AS arr FROM (SELECT * FROM system.numbers LIMIT 10000000) WHERE length(arr) <= 5) format Null
0.185	0.182	-1.016x	-0.016	0.021	column_array_filter	3	SELECT arr FROM (SELECT cast(range(number % 10) as Array(UInt256)) AS arr FROM (SELECT * FROM system.numbers LIMIT 10000000) WHERE length(arr) <= 5) format Null
0.164	0.162	-1.007x	-0.008	0.02	column_array_filter	4	SELECT arr FROM (SELECT cast(range(number % 10) as Array(Decimal32(0))) AS arr FROM (SELECT * FROM system.numbers LIMIT 10000000) WHERE length(arr) <= 5) format Null
0.174	0.172	-1.007x	-0.008	0.013	column_array_filter	5	SELECT arr FROM (SELECT cast(range(number % 10) as Array(Decimal64(0))) AS arr FROM (SELECT * FROM system.numbers LIMIT 10000000) WHERE length(arr) <= 5) format Null
0.129	0.132	+1.021x	0.02	0.041	column_array_filter	6	SELECT arr FROM (SELECT cast(range(number % 10) as Array(Decimal128(0))) AS arr FROM (SELECT * FROM system.numbers LIMIT 10000000) WHERE length(arr) <= 5) format Null
0.188	0.186	-1.015x	-0.015	0.037	column_array_filter	7	SELECT arr FROM (SELECT cast(range(number % 10) as Array(Decimal256(0))) AS arr FROM (SELECT * FROM system.numbers LIMIT 10000000) WHERE length(arr) <= 5) format Null
0.064	0.066	+1.023x	0.023	0.059	compact_part_subcolumns	0	SELECT data.k0, data.k1, data.k2, data.k3, data.k4, data.k5, data.k6, data.k7, data.k8, data.k9 FROM t_json_1 FORMAT Null
0.059	0.057	-1.044x	-0.042	0.091	compact_part_subcolumns	1	SELECT data.a0 FROM t_json_2 FORMAT Null
0.146	0.145	-1.006x	-0.007	0.014	complex_array_creation	0	SELECT count() FROM zeros(10000000) WHERE NOT ignore([[zero], [zero]])
0.175	0.175	-1.002x	-0.002	0.01	complex_array_creation	1	SELECT count() FROM zeros(10000000) WHERE NOT ignore([[], [zero]])
0.03	0.029	-1.014x	-0.015	0.013	consistent_hashes	0	SELECT kostikConsistentHash(number, 2) FROM numbers(10000000) FORMAT Null
0.028	0.028	-1.004x	-0.007	0.015	consistent_hashes	1	SELECT jumpConsistentHash(number, 2) FROM numbers(10000000) FORMAT Null
0.03	0.03	+1.01x	0.009	0.022	consistent_hashes	2	SELECT kostikConsistentHash(number, 500) FROM numbers(10000000) FORMAT Null
0.489	0.488	-1.003x	-0.004	0.006	consistent_hashes	3	SELECT jumpConsistentHash(number, 500) FROM numbers(10000000) FORMAT Null
0.029	0.029	+1x	0	0.011	consistent_hashes	4	SELECT kostikConsistentHash(number, 32768) FROM numbers(10000000) FORMAT Null
0.746	0.745	-1.001x	-0.002	0.007	consistent_hashes	5	SELECT jumpConsistentHash(number, 32768) FROM numbers(10000000) FORMAT Null
0.008	0.008	+1x	-0.003	0.018	countDigits	0	SELECT count() FROM test.hits WHERE NOT ignore(countDigits(RegionID))
0.004	0.004	+1x	-0.005	0.024	countDigits	1	SELECT count() FROM test.hits WHERE NOT ignore(countDigits(AdvEngineID))
0.008	0.008	+1x	-0.004	0.014	countDigits	2	SELECT count() FROM test.hits WHERE NOT ignore(countDigits(ClientIP))
0.009	0.009	+1x	0.001	0.024	countDigits	3	SELECT count() FROM test.hits WHERE NOT ignore(countDigits(WatchID))
0.047	0.048	+1.011x	0.01	0.009	countIf	0	SELECT countIf(number % 2) FROM numbers(100000000)
0.035	0.036	+1.003x	0.001	0.011	countIf	1	SELECT countIf(key IS NOT NULL) FROM ( SELECT materialize(toNullable(1)) AS key FROM numbers(100000000) )
0.036	0.035	-1.003x	-0.004	0.009	countIf	2	SELECT countIf(key IS NOT NULL) FROM ( SELECT materialize(CAST(NULL, 'Nullable(Int8)')) AS key FROM numbers(100000000) )
0.08	0.081	+1.015x	0.014	0.017	count_from_formats	5	SELECT count() FROM table_CSVWithNamesAndTypes FORMAT Null
0.053	0.053	+1.006x	0.004	0.016	count_from_formats	21	SELECT count() FROM table_TSKV FORMAT Null
0.176	0.186	+1.056x	0.055	0.055	count_from_formats	22	SELECT count() FROM table_Avro FORMAT Null
0.113	0.112	-1.009x	-0.009	0.009	count_from_formats	23	SELECT count() FROM table_MsgPack FORMAT Null
0.002	0.002	-1.042x	-0.006	0.02	count_from_formats	27	SELECT count() FROM table_ORC FORMAT Null
0.267	0.27	+1.014x	0.013	0.013	count_from_formats	39	SELECT count() FROM table_JSONEachRow group by _file, _path FORMAT Null
0.173	0.182	+1.054x	0.054	0.054	count_from_formats	51	SELECT count() FROM table_Avro group by _file, _path FORMAT Null
0.163	0.162	-1.001x	-0.002	0.029	count_from_formats	53	SELECT count() FROM table_Protobuf group by _file, _path FORMAT Null
0.122	0.122	+1.001x	0.001	0.016	count_from_formats	64	SELECT _path, _file FROM table_CustomSeparated group by _file, _path FORMAT Null
0.104	0.106	+1.015x	0.014	0.022	count_from_formats	73	SELECT _path, _file FROM table_JSONCompact group by _file, _path FORMAT Null
0.13	0.129	-1.009x	-0.009	0.051	cpu_synthetic	1	SELECT count() FROM hits_100m_single WHERE NOT ignore(cityHash64(SearchPhrase))
0.126	0.129	+1.02x	0.019	0.088	cpu_synthetic	3	SELECT count() FROM hits_100m_single WHERE NOT ignore(farmHash64(SearchPhrase))
0.081	0.08	-1.007x	-0.008	0.015	cpu_synthetic	8	SELECT count() FROM hits_10m_single WHERE NOT ignore(cityHash64(PageCharset)) SETTINGS max_threads = 1
0.265	0.268	+1.012x	0.012	0.022	cpu_synthetic	10	SELECT count() FROM hits_10m_single WHERE NOT ignore(sipHash64(SearchPhrase)) SETTINGS max_threads = 1
0.888	0.886	-1.002x	-0.003	0.006	cpu_synthetic	13	SELECT count() FROM hits_10m_single WHERE NOT ignore(sipHash64(URL)) SETTINGS max_threads = 1
0.629	0.627	-1.003x	-0.003	0.013	cpu_synthetic	17	SELECT count() FROM hits_10m_single WHERE positionCaseInsensitiveUTF8(URL, 'новости') != 0 SETTINGS max_threads = 1
0.069	0.067	-1.036x	-0.035	0.047	cpu_synthetic	31	SELECT uniq(UserID) FROM hits_100m_single
0.096	0.097	+1.003x	0.003	0.044	cpu_synthetic	33	SELECT uniqCombined(17)(UserID) FROM hits_100m_single
0.245	0.247	+1.009x	0.008	0.044	cpu_synthetic	34	SELECT uniqExact(UserID) FROM hits_10m_single SETTINGS max_threads = 1
0.321	0.321	-1.001x	-0.001	0.052	cpu_synthetic	37	SELECT RegionID, uniq(UserID) FROM hits_100m_single GROUP BY RegionID
0.109	0.11	+1.007x	0.006	0.011	date_time_long	37	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDateTime('2017-01-01 00:00:00') + number % 100000000 + rand() % 100000 AS t, toStartOfFifteenMinutes(t, 'Asia/Istanbul'))
0.11	0.11	-1.005x	-0.005	0.017	date_time_long	39	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDateTime('2017-01-01 00:00:00') + number % 100000000 + rand() % 100000 AS t, toStartOfHour(t, 'UTC'))
0.13	0.13	+1.001x	0.001	0.009	date_time_long	80	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDateTime('2017-01-01 00:00:00') + number % 100000000 + rand() % 100000 AS t, toRelativeHourNum(t, 'Asia/Kolkata'))
0.249	0.246	-1.013x	-0.014	0.018	date_time_long	91	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDateTime('2017-01-01 00:00:00') + number % 100000000 + rand() % 100000 AS t, toYYYYMMDD(t, 'Asia/Istanbul'))
0.187	0.188	+1.003x	0.003	0.016	date_time_long	100	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDateTime('2017-01-01 00:00:00') + number % 100000000 + rand() % 100000 AS t, toRelativeQuarterNum(t, 'Asia/Istanbul'))
0.189	0.19	+1.003x	0.003	0.019	date_time_long	101	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDateTime('2017-01-01 00:00:00') + number % 100000000 + rand() % 100000 AS t, toRelativeQuarterNum(t, 'Asia/Kolkata'))
0.26	0.258	-1.007x	-0.007	0.016	date_time_long	112	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDateTime('2017-01-01 00:00:00') + number % 100000000 + rand() % 100000 AS t, toStartOfWeek(t, 0, 'Asia/Istanbul'))
0.123	0.123	+1.002x	0.002	0.015	date_time_long	126	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDate('2017-01-01') + number % 1000 + rand() % 10 AS t, toYear(t))
0.51	0.51	+1.001x	0	0.012	date_time_long	158	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDateTime('2017-01-01 00:00:00') + number % 100000000 + rand() % 100000 AS t, addQuarters(t, 1))
0.103	0.104	+1.005x	0.004	0.013	date_time_long	163	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDateTime('2017-01-01 00:00:00') + number % 100000000 + rand() % 100000 AS t, subtractHours(t, 1))
0.243	0.243	-1.001x	-0.001	0.006	date_time_short	0	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDateTime('2017-01-01 00:00:00') + number % 100000000 + rand() % 100000 AS t, toMonday(t, 'Asia/Istanbul'))
0.134	0.134	+1.003x	0.002	0.013	date_time_short	3	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDate('2017-01-01') + number % 1000 + rand() % 10 AS t, toMonday(t))
0.499	0.502	+1.004x	0.004	0.006	date_time_short	5	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDate('2017-01-01') + number % 1000 + rand() % 10 AS t, toYYYYMMDDhhmmss(t))
0.103	0.104	+1.006x	0.005	0.017	date_time_short	6	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDateTime('2017-01-01 00:00:00') + number % 100000000 + rand() % 100000 AS t, toUnixTimestamp(t, 'Asia/Istanbul'))
0.114	0.116	+1.017x	0.016	0.025	date_time_short	7	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDate('2017-01-01') + number % 1000 + rand() % 10 AS t, toUnixTimestamp(toUInt16(t)))
0.1	0.1	-1.001x	-0.001	0.016	date_time_short	8	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDateTime('2017-01-01 00:00:00') + number % 100000000 + rand() % 100000 AS t, lessOrEquals(t, 1))
0.1	0.1	+1.002x	0.001	0.02	date_time_short	9	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDateTime('2017-01-01 00:00:00') + number % 100000000 + rand() % 100000 AS t, greater(t, 1))
0.103	0.104	+1.004x	0.003	0.012	date_time_short	10	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDateTime('2017-01-01 00:00:00') + number % 100000000 + rand() % 100000 AS t, plus(t, 1))
0.216	0.217	+1.008x	0.007	0.01	date_time_short	13	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDateTime('2017-01-01 00:00:00') + number % 100000000 + rand() % 100000 AS t, date_trunc('month', t))
0.129	0.129	+1.003x	0.002	0.015	date_time_short	15	SELECT count() FROM numbers(50000000) WHERE NOT ignore(toDate('2017-01-01') + number % 1000 + rand() % 10 AS t, toDayOfWeek(t))
0.066	0.067	+1.018x	0.017	0.055	decimal_aggregates	1	SELECT min(d64), max(d64), argMin(x, d64), argMax(x, d64) FROM t
0.073	0.074	+1.003x	0.002	0.048	decimal_aggregates	3	SELECT avg(d32), sum(d32), sumWithOverflow(d32) FROM t
0.273	0.277	+1.014x	0.013	0.039	decimal_aggregates	6	SELECT uniq(d32), uniqCombined(d32), uniqExact(d32), uniqHLL12(d32) FROM (SELECT * FROM t LIMIT 10000000)
0.324	0.326	+1.005x	0.005	0.027	decimal_aggregates	7	SELECT uniq(d64), uniqCombined(d64), uniqExact(d64), uniqHLL12(d64) FROM (SELECT * FROM t LIMIT 10000000)
0.198	0.2	+1.009x	0.009	0.048	decimal_aggregates	10	SELECT median(d64), medianExact(d64), medianExactWeighted(d64, 2) FROM (SELECT * FROM t LIMIT 1000000)
0.254	0.253	-1.005x	-0.005	0.023	decimal_aggregates	14	SELECT quantile(d128), quantileExact(d128), quantileExactWeighted(d128, 2) FROM (SELECT * FROM t LIMIT 1000000)
0.047	0.048	+1.021x	0.02	0.206	decimal_aggregates	15	SELECT quantilesExactLow(0.5)(d32) FROM (SELECT * FROM t LIMIT 10000000)
0.092	0.076	-1.203x	-0.168	0.26	decimal_aggregates	18	SELECT quantilesExactHigh(0.1, 0.5, 0.9)(d32) FROM (SELECT * FROM t LIMIT 10000000)
0.493	0.471	-1.047x	-0.045	0.187	decimal_aggregates	19	SELECT quantilesExact(0.1, 0.9)(d32), quantilesExactWeighted(0.1, 0.9)(d32, 2) FROM (SELECT * FROM t LIMIT 10000000)
0.023	0.023	-1.009x	-0.008	0.022	decimal_aggregates	24	SELECT varPop(d128), varSamp(d128), stddevPop(d128) FROM (SELECT * FROM t LIMIT 10000000)
0.249	0.263	+1.054x	0.054	0.094	decimal_casts	1	SELECT toInt32(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t FORMAT Null
0.25	0.243	-1.029x	-0.028	0.073	decimal_casts	2	SELECT toInt64(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t FORMAT Null
0.276	0.262	-1.057x	-0.054	0.053	decimal_casts	3	SELECT toUInt64(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t FORMAT Null
0.027	0.027	+1.011x	0.008	0.033	decimal_casts	5	SELECT toInt256(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t LIMIT 10000000 FORMAT Null
0.45	0.434	-1.037x	-0.036	0.067	decimal_casts	8	SELECT toFloat64(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t FORMAT Null
0.132	0.132	-1.005x	-0.006	0.056	decimal_casts	9	SELECT toInt32(d32), toInt64(d32), toInt128(d32) FROM t FORMAT Null
0.183	0.193	+1.053x	0.053	0.058	decimal_casts	10	SELECT toInt32(d64), toInt64(d64), toInt128(d64) FROM t FORMAT Null
0.305	0.307	+1.005x	0.005	0.116	decimal_casts	11	SELECT toInt32(d128), toInt64(d128), toInt128(d128) FROM t FORMAT Null
0.311	0.322	+1.035x	0.035	0.051	decimal_casts	12	SELECT toFloat32(d32), toFloat32(d64), toFloat32(d128) FROM t FORMAT Null
0.468	0.485	+1.037x	0.036	0.046	decimal_casts	14	SELECT toInt256(d32), toInt256(d64), toInt256(d128) FROM t FORMAT Null
0.11	0.103	-1.071x	-0.067	0.063	distinct_in_order	0	SELECT DISTINCT high FROM distinct_cardinality_high FORMAT Null
0.161	0.162	+1.004x	0.004	0.101	distinct_in_order	1	SELECT DISTINCT high, medium FROM distinct_cardinality_high FORMAT Null
0.085	0.086	+1.014x	0.015	0.027	distinct_in_order	2	SELECT DISTINCT high, medium FROM distinct_cardinality_high ORDER BY high, medium FORMAT Null
0.084	0.084	-1.004x	-0.004	0.03	distinct_in_order	3	SELECT DISTINCT high, medium FROM distinct_cardinality_high ORDER BY high FORMAT Null
0.014	0.014	+1x	-0.003	0.019	distinct_in_order	4	SELECT DISTINCT low FROM distinct_cardinality_low FORMAT Null
0.062	0.066	+1.067x	0.067	0.07	distinct_in_order	5	SELECT DISTINCT low, medium FROM distinct_cardinality_low FORMAT Null
0.053	0.053	-1.006x	-0.006	0.036	distinct_in_order	6	SELECT DISTINCT low, medium FROM distinct_cardinality_low ORDER BY low, medium FORMAT Null
0.052	0.053	+1.01x	0.011	0.038	distinct_in_order	7	SELECT DISTINCT low, medium FROM distinct_cardinality_low ORDER BY low FORMAT Null
0.28	0.215	-1.306x	-0.235	0.352	empty_string_deserialization	0	SELECT count() FROM empty_strings WHERE NOT ignore(s)
0.511	0.509	-1.004x	-0.005	0.073	empty_string_serialization	0	INSERT INTO empty_strings SELECT '' FROM zeros(100000000);
0.102	0.102	+1.003x	0.002	0.019	explain_ast	0	EXPLAIN AST SELECT * FROM ( SELECT c1, c2, c3_q[1] AS c3_q1, c3_q[3] AS c3_q3, c3_q[2] AS c3_median, least(c3_max, c3_q3 + (1.5 * (c3_q3 - c3_q1))) AS c3_max, greatest(c3_min, c3_q1 - (1.5 * (c3_q3 - c3_q1))) AS c3_min, c3_avg, c4_q[1] AS c4_q1, c4_q[3] AS c4_q3, c4_q[2] AS c4_median, least(c4_max, c4_q3 + (1.5 * (c4_q3 - c4_q1))) AS c4_max, greatest(c4_min, c4_q1 - (1.5 * (c4_q3 - c4_q1))) AS c4_min, c4_avg, c5_q[1] AS c5_q1, c5_q[3] AS c5_q3, c5_q[2] AS c5_median, least(c5_max, c5_q3 + (1.5 * (c5_q3 - c5_q1))) AS c5_max, greatest(c5_min, c5_q1 - (1.5 * (c5_q3 - c5_q1))) AS c5_min, c5_avg, c6_q[1] AS c6_q1, c6_q[3] AS c6_q3, c6_q[2] AS c6_median, least(c6_max, c6_q3 + (1.5 * (c6_q3 - c6_q1))) AS c6_max, greatest(c6_min, c6_q1 - (1.5 * (c6_q3 - c6_q1))) AS c6_min, c6_avg, c7_q[1] AS c7_q1, c7_q[3] AS c7_q3, c7_q[2] AS c7_median, least(c7_max, c7_q3 + (1.5 * (c7_q3 - c7_q1))) AS c7_max, greatest(c7_min, c7_q1 - (1.5 * (c7_q3 - c7_q1))) AS c7_min, c7_avg, c8_q[1] AS c8_q1, c8_q...(0)
1.398	1.288	-1.086x	-0.079	0.095	file_table_function	0	INSERT INTO FUNCTION file('test_file', 'TabSeparated', 'key UInt64, value UInt64') SELECT number, number FROM numbers(10000000)
1.088	1.08	-1.008x	-0.008	0.022	file_table_function	2	INSERT INTO FUNCTION file('test_file', 'TabSeparatedWithNamesAndTypes', 'key UInt64, value UInt64') SELECT number, number FROM numbers(10000000)
1.215	1.212	-1.002x	-0.003	0.015	file_table_function	4	INSERT INTO FUNCTION file('test_file', 'CSVWithNames', 'key UInt64, value UInt64') SELECT number, number FROM numbers(10000000)
0.081	0.097	+1.197x	0.197	0.39	file_table_function	5	INSERT INTO FUNCTION file('test_file', 'Values', 'key UInt64, value UInt64') SELECT number, number FROM numbers(10000000)
1.766	1.742	-1.014x	-0.014	0.043	file_table_function	7	INSERT INTO FUNCTION file('test_file', 'JSONCompactEachRow', 'key UInt64, value UInt64') SELECT number, number FROM numbers(10000000)
2.028	2.054	+1.013x	0.012	0.05	file_table_function	9	INSERT INTO FUNCTION file('test_file', 'TSKV', 'key UInt64, value UInt64') SELECT number, number FROM numbers(10000000)
1.081	1.032	-1.048x	-0.046	0.242	file_table_function	11	INSERT INTO FUNCTION file('test_file', 'Native', 'key UInt64, value UInt64') SELECT number, number FROM numbers(10000000)
0.027	0.027	-1.007x	-0.006	0.021	file_table_function	13	INSERT INTO FUNCTION file('test_file', 'TabSeparated', 'key UInt64, value1 UInt64, value2 UInt64, value3 UInt64, value4 UInt64, value5 UInt64') SELECT number, number, number, number, number, number FROM numbers(1000000)
0.027	0.028	+1.007x	0.006	0.016	file_table_function	16	INSERT INTO FUNCTION file('test_file', 'CSV', 'key UInt64, value1 UInt64, value2 UInt64, value3 UInt64, value4 UInt64, value5 UInt64') SELECT number, number, number, number, number, number FROM numbers(1000000)
0.255	0.261	+1.025x	0.024	0.341	file_table_function	21	INSERT INTO FUNCTION file('test_file', 'JSONCompactEachRowWithNamesAndTypes', 'key UInt64, value1 UInt64, value2 UInt64, value3 UInt64, value4 UInt64, value5 UInt64') SELECT number, number, number, number, number, number FROM numbers(1000000)
0.259	0.26	+1.005x	0.005	0.026	final_with_lonely_parts	0	SELECT max(val), count(*) FROM with_lonely FINAL;
0.161	0.16	-1.009x	-0.009	0.011	final_with_lonely_parts	1	SELECT max(val), count(*) FROM with_lonely FINAL WHERE dt != '2022-11-01';
0.09	0.069	-1.306x	-0.234	0.272	formats_columns_sampling	0	SELECT WatchID FROM table_TabSeparatedWithNames FORMAT Null
0.134	0.134	-1.003x	-0.004	0.006	formats_columns_sampling	1	SELECT WatchID FROM table_CustomSeparatedWithNames FORMAT Null
0.174	0.158	-1.1x	-0.092	0.203	formats_columns_sampling	2	SELECT WatchID FROM table_CSVWithNames FORMAT Null
0.423	0.402	-1.051x	-0.049	0.066	formats_columns_sampling	3	SELECT WatchID FROM table_JSONEachRow FORMAT Null
0.202	0.204	+1.011x	0.01	0.201	formats_columns_sampling	4	SELECT WatchID FROM table_JSONCompactEachRowWithNames FORMAT Null
0.31	0.309	-1.002x	-0.003	0.01	formats_columns_sampling	6	SELECT WatchID FROM table_Avro FORMAT Null
0.003	0.003	+1x	0.014	0.014	formats_columns_sampling	7	SELECT WatchID FROM table_ORC FORMAT Null
0.004	0.004	+1x	-0.002	0.016	formats_columns_sampling	8	SELECT WatchID FROM table_Parquet FORMAT Null
0.021	0.022	+1.043x	0.043	0.111	formats_columns_sampling	9	SELECT WatchID FROM table_Arrow FORMAT Null
0.032	0.032	-1.006x	-0.009	0.068	formats_columns_sampling	10	SELECT WatchID FROM table_Native FORMAT Null
0.091	0.091	-1.001x	-0.001	0.018	function_calculation_after_sorting_and_limit	0	SELECT sipHash64(number) FROM numbers(1e8) ORDER BY number LIMIT 5
0.122	0.122	-1.003x	-0.004	0.023	function_calculation_after_sorting_and_limit	1	SELECT sipHash64(number) FROM numbers(1e8) ORDER BY number + 1 LIMIT 5
0.996	0.987	-1.009x	-0.01	0.013	function_calculation_after_sorting_and_limit	2	SELECT sipHash64(number) FROM numbers(1e8) ORDER BY number + 1 LIMIT 99999995, 5
5.901	6.085	+1.031x	0.031	0.064	function_tokens	0	with 'Many years later as he faced the firing squad, Colonel Aureliano Buendia was to remember that distant afternoon when his father took him to discover ice.' as s select splitByChar(' ', materialize(s)) as w from numbers(1000000)
1.163	1.172	+1.007x	0.007	0.128	function_tokens	1	with 'Many years later as he faced the firing squad, Colonel Aureliano Buendia was to remember that distant afternoon when his father took him to discover ice.' as s select splitByRegexp(' ', materialize(s)) as w from numbers(200000)
0.09	0.091	+1.014x	0.013	0.037	function_tokens	2	with 'Many years later as he faced the firing squad, Colonel Aureliano Buendia was to remember that distant afternoon when his father took him to discover ice.' as s select splitByRegexp('\s+', materialize(s)) as w from numbers(20000)
0.097	0.097	-1.005x	-0.006	0.024	general_purpose_hashes	10	SELECT count() from numbers(10000000) where not ignore(metroHash64(toString(1000000000+number)))
0.421	0.621	+1.474x	0.474	0.481	general_purpose_hashes	11	SELECT count() from numbers_mt(500000000) where not ignore(metroHash64(toString(1000000000+number)))
0.032	0.032	+1.013x	0.012	0.015	general_purpose_hashes	16	SELECT count() from numbers(10000000) where not ignore(murmurHash2_64(materialize('')))
0.022	0.022	+1x	-0.001	0.016	general_purpose_hashes	36	SELECT count() from numbers(10000000) where not ignore(hiveHash(materialize('')))
0.157	0.142	-1.106x	-0.096	0.122	general_purpose_hashes	49	SELECT count() from numbers_mt(500000000) where not ignore(xxh3(materialize('')))
0.234	0.239	+1.024x	0.023	0.079	general_purpose_hashes	56	SELECT count() from zeros(1000000) where not ignore(cityHash64(materialize('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris sollicitudin nisi ac erat mollis dapibus. Maecenas leo purus, bibendum eu erat eget, iaculis molestie tortor. Phasellus maximus odio nec mauris ultrices dictum. Morbi efficitur nisl eget congue mollis. Vestibulum pharetra diam vitae urna interdum, eget ultricies justo sollicitudin. Nunc sit amet purus id leo tempus dignissim. Donec ac lacus ut orci tempus scelerisque quis ultricies nibh. Nullam lobortis, erat ac ullamcorper interdum, odio nisl elementum quam, ut malesuada massa nunc eget quam. Nam suscipit neque quis sapien ultricies imperdiet. Maecenas augue libero, finibus tristique sagittis et, semper nec arcu. Morbi non tortor ultrices, sollicitudin justo sed, accumsan ligula. Nullam at ipsum in nibh auctor ullamcorper. Nullam laoreet neque id lorem condimentum tincidunt. Nullam vel orci nibh. Ut sit amet sem faucibus, fringilla orci at, lacini...(56)
0.168	0.16	-1.055x	-0.053	0.101	general_purpose_hashes	57	SELECT count() from zeros_mt(5000000) where not ignore(cityHash64(materialize('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris sollicitudin nisi ac erat mollis dapibus. Maecenas leo purus, bibendum eu erat eget, iaculis molestie tortor. Phasellus maximus odio nec mauris ultrices dictum. Morbi efficitur nisl eget congue mollis. Vestibulum pharetra diam vitae urna interdum, eget ultricies justo sollicitudin. Nunc sit amet purus id leo tempus dignissim. Donec ac lacus ut orci tempus scelerisque quis ultricies nibh. Nullam lobortis, erat ac ullamcorper interdum, odio nisl elementum quam, ut malesuada massa nunc eget quam. Nam suscipit neque quis sapien ultricies imperdiet. Maecenas augue libero, finibus tristique sagittis et, semper nec arcu. Morbi non tortor ultrices, sollicitudin justo sed, accumsan ligula. Nullam at ipsum in nibh auctor ullamcorper. Nullam laoreet neque id lorem condimentum tincidunt. Nullam vel orci nibh. Ut sit amet sem faucibus, fringilla orci at, lac...(57)
0.285	0.264	-1.081x	-0.075	0.084	general_purpose_hashes	67	SELECT count() from zeros_mt(5000000) where not ignore(murmurHash3_32(materialize('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris sollicitudin nisi ac erat mollis dapibus. Maecenas leo purus, bibendum eu erat eget, iaculis molestie tortor. Phasellus maximus odio nec mauris ultrices dictum. Morbi efficitur nisl eget congue mollis. Vestibulum pharetra diam vitae urna interdum, eget ultricies justo sollicitudin. Nunc sit amet purus id leo tempus dignissim. Donec ac lacus ut orci tempus scelerisque quis ultricies nibh. Nullam lobortis, erat ac ullamcorper interdum, odio nisl elementum quam, ut malesuada massa nunc eget quam. Nam suscipit neque quis sapien ultricies imperdiet. Maecenas augue libero, finibus tristique sagittis et, semper nec arcu. Morbi non tortor ultrices, sollicitudin justo sed, accumsan ligula. Nullam at ipsum in nibh auctor ullamcorper. Nullam laoreet neque id lorem condimentum tincidunt. Nullam vel orci nibh. Ut sit amet sem faucibus, fringilla orci at,...(67)
1.035	1.033	-1.002x	-0.002	0.008	general_purpose_hashes	74	SELECT count() from zeros(1000000) where not ignore(hiveHash(materialize('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris sollicitudin nisi ac erat mollis dapibus. Maecenas leo purus, bibendum eu erat eget, iaculis molestie tortor. Phasellus maximus odio nec mauris ultrices dictum. Morbi efficitur nisl eget congue mollis. Vestibulum pharetra diam vitae urna interdum, eget ultricies justo sollicitudin. Nunc sit amet purus id leo tempus dignissim. Donec ac lacus ut orci tempus scelerisque quis ultricies nibh. Nullam lobortis, erat ac ullamcorper interdum, odio nisl elementum quam, ut malesuada massa nunc eget quam. Nam suscipit neque quis sapien ultricies imperdiet. Maecenas augue libero, finibus tristique sagittis et, semper nec arcu. Morbi non tortor ultrices, sollicitudin justo sed, accumsan ligula. Nullam at ipsum in nibh auctor ullamcorper. Nullam laoreet neque id lorem condimentum tincidunt. Nullam vel orci nibh. Ut sit amet sem faucibus, fringilla orci at, lacinia ...(74)
0.179	0.173	-1.033x	-0.032	0.053	general_purpose_hashes	77	SELECT count() from zeros_mt(5000000) where not ignore(xxHash32(materialize('Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris sollicitudin nisi ac erat mollis dapibus. Maecenas leo purus, bibendum eu erat eget, iaculis molestie tortor. Phasellus maximus odio nec mauris ultrices dictum. Morbi efficitur nisl eget congue mollis. Vestibulum pharetra diam vitae urna interdum, eget ultricies justo sollicitudin. Nunc sit amet purus id leo tempus dignissim. Donec ac lacus ut orci tempus scelerisque quis ultricies nibh. Nullam lobortis, erat ac ullamcorper interdum, odio nisl elementum quam, ut malesuada massa nunc eget quam. Nam suscipit neque quis sapien ultricies imperdiet. Maecenas augue libero, finibus tristique sagittis et, semper nec arcu. Morbi non tortor ultrices, sollicitudin justo sed, accumsan ligula. Nullam at ipsum in nibh auctor ullamcorper. Nullam laoreet neque id lorem condimentum tincidunt. Nullam vel orci nibh. Ut sit amet sem faucibus, fringilla orci at, lacin...(77)
0.415	0.416	+1.004x	0.003	0.219	group_array_moving_sum	1	select k, groupArrayMovingSum(1000)(v) from moving_sum_50m group by k format Null
0.432	0.424	-1.018x	-0.018	0.203	group_array_moving_sum	2	select k, groupArrayMovingSum(10000)(v) from moving_sum_50m group by k format Null
0.899	0.92	+1.023x	0.023	0.115	group_array_moving_sum	3	select k, groupArrayMovingSum(10)(v) from moving_sum_100m group by k format Null
0.898	0.918	+1.022x	0.022	0.102	group_array_moving_sum	4	select k, groupArrayMovingSum(1000)(v) from moving_sum_100m group by k format Null
0.91	0.883	-1.031x	-0.03	0.038	group_array_moving_sum	5	select k, groupArrayMovingSum(10000)(v) from moving_sum_100m group by k format Null
0.668	0.664	-1.006x	-0.007	0.05	group_array_moving_sum	6	select k % 10 kk, groupArrayMovingSum(10)(v) from moving_sum_50m group by kk format Null
0.682	0.666	-1.024x	-0.024	0.133	group_array_moving_sum	7	select k % 10 kk, groupArrayMovingSum(1000)(v) from moving_sum_50m group by kk format Null
0.695	0.672	-1.033x	-0.032	0.057	group_array_moving_sum	8	select k % 10 kk, groupArrayMovingSum(10000)(v) from moving_sum_50m group by kk format Null
1.428	1.272	-1.123x	-0.11	0.114	group_array_moving_sum	9	select k % 10 kk, groupArrayMovingSum(10)(v) from moving_sum_100m group by kk format Null
1.454	1.42	-1.024x	-0.024	0.136	group_array_moving_sum	11	select k % 10 kk, groupArrayMovingSum(10000)(v) from moving_sum_100m group by kk format Null
0.025	0.025	-1.004x	-0.003	0.053	group_array_sorted	1	select k, groupArraySorted(1000)(v) from sorted_50m group by k format Null
0.064	0.07	+1.087x	0.087	0.129	group_array_sorted	2	select k, groupArraySorted(10000)(v) from sorted_50m group by k format Null
0.033	0.032	-1.028x	-0.028	0.05	group_array_sorted	3	select k, groupArraySorted(10)(v) from sorted_100m group by k format Null
0.04	0.038	-1.052x	-0.051	0.073	group_array_sorted	4	select k, groupArraySorted(1000)(v) from sorted_100m group by k format Null
0.085	0.086	+1.013x	0.013	0.168	group_array_sorted	5	select k, groupArraySorted(10000)(v) from sorted_100m group by k format Null
0.028	0.028	+1.011x	0.013	0.03	group_array_sorted	6	select k % 10 kk, groupArraySorted(10)(v) from sorted_50m group by kk format Null
0.032	0.033	+1.009x	0.009	0.035	group_array_sorted	7	select k % 10 kk, groupArraySorted(1000)(v) from sorted_50m group by kk format Null
0.078	0.077	-1.016x	-0.015	0.029	group_array_sorted	8	select k % 10 kk, groupArraySorted(10000)(v) from sorted_50m group by kk format Null
0.055	0.056	+1.027x	0.028	0.043	group_array_sorted	10	select k % 10 kk, groupArraySorted(1000)(v) from sorted_100m group by kk format Null
0.107	0.105	-1.018x	-0.018	0.027	group_array_sorted	11	select k % 10 kk, groupArraySorted(10000)(v) from sorted_100m group by kk format Null
0.028	0.028	+1.004x	0.002	0.015	group_by_consecutive_keys	0	SELECT toUInt64(intDiv(number, 1000000)) AS n, count(), sum(number) FROM numbers(10000000) GROUP BY n FORMAT Null
0.028	0.028	-1.004x	-0.006	0.015	group_by_consecutive_keys	1	SELECT toString(intDiv(number, 1000000)) AS n, count(), sum(number) FROM numbers(10000000) GROUP BY n FORMAT Null
0.135	0.134	-1.009x	-0.009	0.014	group_by_consecutive_keys	2	SELECT toUInt64(intDiv(number, 1000000)) AS n, count(), uniq(number) FROM numbers(10000000) GROUP BY n FORMAT Null
0.056	0.056	-1.005x	-0.006	0.011	group_by_consecutive_keys	3	SELECT toUInt64(intDiv(number, 100000)) AS n, count(), sum(number) FROM numbers(10000000) GROUP BY n FORMAT Null
0.073	0.073	+1.001x	0	0.029	group_by_consecutive_keys	4	SELECT toUInt64(intDiv(number, 100)) AS n, count(), sum(number) FROM numbers(10000000) GROUP BY n FORMAT Null
0.15	0.148	-1.008x	-0.009	0.034	group_by_consecutive_keys	5	SELECT toUInt64(intDiv(number, 10)) AS n, count(), sum(number) FROM numbers(10000000) GROUP BY n FORMAT Null
0.104	0.104	+1.001x	0.001	0.008	group_by_fixed_keys	1	WITH toUInt8(number) AS k, toUInt16(k) AS k1, toUInt32(k) AS k2, k AS k3 SELECT k1, k2, k3, count() FROM numbers(100000000) GROUP BY k1, k2, k3
0.103	0.103	-1.004x	-0.004	0.011	group_by_fixed_keys	2	WITH toUInt8(number) AS k, k AS k1, k + 1 AS k2 SELECT k1, k2, count() FROM numbers(100000000) GROUP BY k1, k2
0.102	0.102	+1x	0	0.019	group_by_fixed_keys	3	WITH toUInt8(number) AS k, k AS k1, k + 1 AS k2, k + 2 AS k3, k + 3 AS k4 SELECT k1, k2, k3, k4, count() FROM numbers(100000000) GROUP BY k1, k2, k3, k4
0.285	0.284	-1.004x	-0.005	0.013	group_by_fixed_keys	4	WITH toUInt8(number) AS k, toUInt64(k) AS k1, k1 + 1 AS k2 SELECT k1, k2, count() FROM numbers(100000000) GROUP BY k1, k2
0.118	0.125	+1.052x	0.051	0.232	group_by_fixed_keys	5	select a, b from group_by_fk group by a, b format Null
0.278	0.257	-1.082x	-0.077	0.264	group_by_fixed_keys	6	select a, c from group_by_fk group by a, c format Null
0.192	0.187	-1.026x	-0.026	0.029	group_by_fixed_keys	7	select a, d from group_by_fk group by a, d format Null
0.182	0.192	+1.053x	0.052	0.383	group_by_fixed_keys	8	select e, f from group_by_fk group by e, f format Null
0.291	0.279	-1.042x	-0.041	0.315	group_by_fixed_keys	9	select e, h from group_by_fk group by e, h format Null
0.402	0.404	+1.004x	0.004	0.295	group_by_fixed_keys	12	select e, f, h from group_by_fk group by e, f, h format Null
0.111	0.11	-1.002x	-0.002	0.01	h3	0	SELECT count() FROM zeros(100000) WHERE NOT ignore(geoToH3(37.62 + rand(1) / 0x100000000, 55.75 + rand(2) / 0x100000000, toUInt8(15)))
0.054	0.053	-1.015x	-0.015	0.077	has_all	0	SELECT hasAll(set, subset) FROM test_table_small_Int8 FORMAT Null
0.124	0.123	-1.004x	-0.004	0.013	has_all	1	SELECT hasAll(set, subset) FROM test_table_small_Int16 FORMAT Null
0.424	0.425	+1.002x	0.002	0.011	has_all	3	SELECT hasAll(set, subset) FROM test_table_small_Int64 FORMAT Null
0.175	0.174	-1.003x	-0.004	0.027	has_all	4	SELECT hasAll(set, subset) FROM test_table_medium_Int8 FORMAT Null
0.4	0.404	+1.01x	0.01	0.037	has_all	6	SELECT hasAll(set, subset) FROM test_table_medium_Int32 FORMAT Null
0.176	0.193	+1.097x	0.096	0.122	has_all	7	SELECT hasAll(set, subset) FROM test_table_medium_Int64 FORMAT Null
0.029	0.029	-1.007x	-0.009	0.024	has_all	8	SELECT hasAll(set, subset) FROM test_table_large_Int8 FORMAT Null
0.035	0.035	-1.014x	-0.015	0.029	has_all	9	SELECT hasAll(set, subset) FROM test_table_large_Int16 FORMAT Null
0.068	0.066	-1.037x	-0.036	0.06	has_all	10	SELECT hasAll(set, subset) FROM test_table_large_Int32 FORMAT Null
0.091	0.092	+1.014x	0.013	0.106	has_all	11	SELECT hasAll(set, subset) FROM test_table_large_Int64 FORMAT Null
0.017	0.017	+1x	0	0.018	hashed_dictionary	0	WITH rand64() % toUInt64(5000000) as key SELECT dictGet('default.simple_key_hashed_dictionary', 'value_int', key) FROM numbers_mt(5000000) FORMAT Null;
0.038	0.038	+1.005x	0.007	0.016	hashed_dictionary	1	WITH rand64() % toUInt64(5000000) as key SELECT dictGet('default.simple_key_hashed_dictionary', 'value_string', key) FROM numbers_mt(5000000) FORMAT Null;
0.017	0.016	-1.012x	-0.01	0.02	hashed_dictionary	2	WITH rand64() % toUInt64(5000000) as key SELECT dictGet('default.simple_key_hashed_dictionary', 'value_decimal', key) FROM numbers_mt(5000000) FORMAT Null;
0.018	0.018	+1.017x	0.017	0.02	hashed_dictionary	4	WITH rand64() % toUInt64(5000000) as key SELECT dictHas('default.simple_key_hashed_dictionary', key) FROM numbers_mt(5000000) FORMAT Null;
0.084	0.084	-1.006x	-0.006	0.058	hashed_dictionary	6	WITH (rand64() % toUInt64(5000000), toString(rand64() % toUInt64(5000000))) as key SELECT dictGet('default.complex_key_hashed_dictionary', 'value_int', key) FROM numbers_mt(5000000) FORMAT Null;
0.11	0.112	+1.013x	0.012	0.043	hashed_dictionary	7	WITH (rand64() % toUInt64(5000000), toString(rand64() % toUInt64(5000000))) as key SELECT dictGet('default.complex_key_hashed_dictionary', 'value_string', key) FROM numbers_mt(5000000) FORMAT Null;
0.085	0.084	-1.011x	-0.01	0.012	hashed_dictionary	8	WITH (rand64() % toUInt64(5000000), toString(rand64() % toUInt64(5000000))) as key SELECT dictGet('default.complex_key_hashed_dictionary', 'value_decimal', key) FROM numbers_mt(5000000) FORMAT Null;
0.112	0.113	+1.015x	0.014	0.016	hashed_dictionary	9	WITH (rand64() % toUInt64(5000000), toString(rand64() % toUInt64(5000000))) as key SELECT dictGet('default.complex_key_hashed_dictionary', 'value_string_nullable', key) FROM numbers_mt(5000000) FORMAT Null;
0.086	0.086	-1.005x	-0.005	0.021	hashed_dictionary	10	WITH (rand64() % toUInt64(5000000), toString(rand64() % toUInt64(5000000))) as key SELECT dictHas('default.complex_key_hashed_dictionary', key) FROM numbers_mt(5000000) FORMAT Null;
0.664	0.667	+1.006x	0.005	0.043	hashed_dictionary	11	SELECT * FROM complex_key_hashed_dictionary FORMAT Null;
0.43	0.432	+1.005x	0.004	0.058	hashed_dictionary_load_factor	6	SYSTEM RELOAD DICTIONARY complex_key_HASHED_dictionary_l0_5
0.406	0.403	-1.007x	-0.008	0.031	hashed_dictionary_load_factor	8	SYSTEM RELOAD DICTIONARY complex_key_HASHED_dictionary_l0_99
1.14	1.147	+1.006x	0.005	0.028	hashed_dictionary_load_factor	9	SYSTEM RELOAD DICTIONARY complex_key_SPARSE_HASHED_dictionary_l0_5
1.35	1.367	+1.012x	0.011	0.035	hashed_dictionary_load_factor	10	SYSTEM RELOAD DICTIONARY complex_key_SPARSE_HASHED_dictionary_l0_7
0.091	0.091	+1.001x	0.001	0.012	hashed_dictionary_load_factor	12	WITH rand64() % 3_000_000 as key SELECT dictHas('default.simple_key_HASHED_dictionary_l0_5', key) FROM numbers(3_000_000) FORMAT Null
0.091	0.091	+1.003x	0.003	0.016	hashed_dictionary_load_factor	13	WITH rand64() % 3_000_000 as key SELECT dictHas('default.simple_key_HASHED_dictionary_l0_7', key) FROM numbers(3_000_000) FORMAT Null
0.122	0.121	-1.005x	-0.006	0.029	hashed_dictionary_load_factor	17	WITH rand64() % 3_000_000 as key SELECT dictHas('default.simple_key_SPARSE_HASHED_dictionary_l0_99', key) FROM numbers(3_000_000) FORMAT Null
0.459	0.461	+1.004x	0.004	0.006	hashed_dictionary_load_factor	18	WITH (rand64() % 2_000_000, toString(rand64() % 2_000_000)) as key SELECT dictHas('default.complex_key_HASHED_dictionary_l0_5', key) FROM numbers(2_000_000) FORMAT Null
0.457	0.46	+1.005x	0.005	0.01	hashed_dictionary_load_factor	19	WITH (rand64() % 2_000_000, toString(rand64() % 2_000_000)) as key SELECT dictHas('default.complex_key_HASHED_dictionary_l0_7', key) FROM numbers(2_000_000) FORMAT Null
1.022	1.036	+1.014x	0.013	0.013	hashed_dictionary_load_factor	23	WITH (rand64() % 2_000_000, toString(rand64() % 2_000_000)) as key SELECT dictHas('default.complex_key_SPARSE_HASHED_dictionary_l0_99', key) FROM numbers(2_000_000) FORMAT Null
0.094	0.094	-1.001x	-0.002	0.042	hierarchical_dictionaries	0	SELECT dictGetHierarchy('hierarchical_flat_dictionary', number + 1) FROM numbers(1000000) FORMAT Null;
1.161	1.174	+1.011x	0.011	0.018	hierarchical_dictionaries	1	SELECT dictGetDescendants('hierarchical_flat_dictionary', number + 1) FROM numbers(1000000) FORMAT Null;
0.212	0.212	-1.001x	-0.002	0.095	hierarchical_dictionaries	2	SELECT dictGetHierarchy('hierarchical_hashed_shards1_dictionary', number + 1) FROM numbers(1000000) FORMAT Null;
1.188	1.195	+1.006x	0.005	0.028	hierarchical_dictionaries	3	SELECT dictGetDescendants('hierarchical_hashed_shards1_dictionary', number + 1) FROM numbers(1000000) FORMAT Null;
0.23	0.226	-1.017x	-0.017	0.063	hierarchical_dictionaries	4	SELECT dictGetHierarchy('hierarchical_hashed_shards16_dictionary', number + 1) FROM numbers(1000000) FORMAT Null;
1.192	1.173	-1.016x	-0.016	0.024	hierarchical_dictionaries	5	SELECT dictGetDescendants('hierarchical_hashed_shards16_dictionary', number + 1) FROM numbers(1000000) FORMAT Null;
0.214	0.218	+1.022x	0.021	0.021	hierarchical_dictionaries	6	SELECT dictGetHierarchy('hierarchical_hashed_array_shards1_dictionary', number + 1) FROM numbers(1000000) FORMAT Null;
1.242	1.248	+1.006x	0.005	0.014	hierarchical_dictionaries	7	SELECT dictGetDescendants('hierarchical_hashed_array_shards1_dictionary', number + 1) FROM numbers(1000000) FORMAT Null;
0.258	0.254	-1.013x	-0.013	0.068	hierarchical_dictionaries	8	SELECT dictGetHierarchy('hierarchical_hashed_array_shards16_dictionary', number + 1) FROM numbers(1000000) FORMAT Null;
1.187	1.186	-1x	-0.001	0.017	hierarchical_dictionaries	9	SELECT dictGetDescendants('hierarchical_hashed_array_shards16_dictionary', number + 1) FROM numbers(1000000) FORMAT Null;
0.061	0.06	-1.008x	-0.009	0.012	if_to_multiif	0	WITH number AS x SELECT sum(x < 1 ? 1 : (x < 5 ? 2 : 3)) FROM numbers(100000000)
1.144	1.139	-1.004x	-0.005	0.01	if_to_multiif	1	WITH number AS x SELECT any(x < 1 ? '1' : (x < 5 ? '2' : '3')) FROM numbers(100000000)
0.112	0.112	-1.004x	-0.005	0.011	if_to_multiif	2	WITH number AS x SELECT sum(x < 1 ? 1 : (x < 5 ? 2 : (x < 10 ? 3 : (x % 2 ? 4 : 5)))) FROM numbers(100000000)
0.234	0.234	+1x	0	0.011	if_to_multiif	3	WITH number AS x SELECT any(x < 1 ? '1' : (x < 5 ? '2' : (x < 10 ? '3' : (x % 2 ? '4' : '5')))) FROM numbers(10000000)
0.039	0.039	-1.005x	-0.007	0.011	if_to_multiif	4	WITH number AS x, x = 1 ? 1 : (x = 2 ? 2 : (x = 3 ? 3 : (x = 4 ? 4 : (x = 5 ? 5 : (x = 6 ? 6 : (x = 7 ? 7 : (x = 8 ? 8 : (x = 9 ? 9 : (x = 10 ? 10 : (x = 11 ? 11 : (x = 12 ? 12 : (x = 13 ? 13 : (x = 14 ? 14 : (x = 15 ? 15 : (x = 16 ? 16 : (x = 17 ? 17 : (x = 18 ? 18 : (x = 19 ? 19 : 20)))))))))))))))))) AS res SELECT sum(res) FROM numbers(10000000)
0.043	0.043	+1.014x	0.014	0.041	information_value	0	SELECT categoricalInformationValue(Age < 15, IsMobile) from hits_100m_single
0.077	0.078	+1.001x	0.001	0.056	information_value	1	SELECT categoricalInformationValue(Age < 15, Age >= 15 and Age < 30, Age >= 30 and Age < 45, Age >= 45 and Age < 60, Age >= 60, IsMobile) from hits_100m_single
0.188	0.187	-1.001x	-0.001	0.117	insert_select_squashing	0	INSERT INTO squash_performance SELECT * FROM generateRandom(42) LIMIT 500000
0.116	0.116	+1.002x	0.001	0.018	inserts_arrays_lowcardinality	0	INSERT INTO lot_of_string_arrays_dst SELECT rand64() as id, columns('^col') FROM lot_of_string_arrays_src
0.584	0.588	+1.007x	0.006	0.02	inserts_arrays_lowcardinality	1	INSERT INTO lot_of_string_arrays_dst_lowcardinality SELECT rand64() as id, columns('^col') FROM lot_of_string_arrays_src
0.148	0.144	-1.028x	-0.027	0.047	ip_trie	0	SELECT dictGetFloat32('default.dict_ip_trie', 'val', tuple(rand32())) FROM numbers(500000) FORMAT Null
0.222	0.223	+1.005x	0.005	0.049	ip_trie	1	SELECT dictGetFloat32('default.dict_ip_trie', 'val', tuple(randomFixedString(16))) FROM numbers(500000) FORMAT Null
0.093	0.093	+1x	0	0.044	ip_trie	2	SELECT dictGetFloat32('default.dict_ip_trie', 'val', tuple(IPv6StringToNum(ip))) FROM table_ip_from_dict WHERE ver == 4 LIMIT 500000 FORMAT Null
0.039	0.038	-1.027x	-0.027	0.058	ip_trie	3	SELECT dictGetFloat32('default.dict_ip_trie', 'val', tuple(IPv6StringToNum(ip))) FROM table_ip_from_dict WHERE ver == 6 LIMIT 500000 FORMAT Null
0.125	0.105	-1.196x	-0.164	0.186	jit_aggregate_functions	47	SELECT min(value_1), min(value_2), sum(toUInt256(value_3)), min(value_3) FROM jit_test_merge_tree_nullable GROUP BY key FORMAT Null
0.123	0.104	-1.192x	-0.162	0.167	jit_aggregate_functions	55	SELECT avg(value_1), avg(value_2), sum(toUInt256(value_3)), avg(value_3) FROM jit_test_merge_tree_nullable GROUP BY key FORMAT Null
0.153	0.154	+1.007x	0.007	0.074	jit_aggregate_functions	208	SELECT max(value_1), max(value_2), sum(toUInt256(value_3)), max(value_3), max(value_4), max(value_5) FROM jit_test_memory GROUP BY key FORMAT Null
0.109	0.108	-1.012x	-0.012	0.173	jit_aggregate_functions	233	SELECT groupBitAnd(value_1), groupBitAnd(value_2), sum(toUInt256(value_3)), groupBitAnd(value_3), groupBitAnd(value_4), groupBitAnd(value_5) FROM jit_test_merge_tree GROUP BY key FORMAT Null
0.132	0.14	+1.062x	0.061	0.234	jit_aggregate_functions	309	SELECT groupBitOrIf(value_1, predicate), groupBitOrIf(value_2, predicate), sumIf(toUInt256(value_3), predicate), groupBitOrIf(value_3, predicate), groupBitOrIf(value_4, predicate), groupBitOrIf(value_5, predicate) FROM jit_test_merge_tree GROUP BY key FORMAT Null
0.437	0.426	-1.025x	-0.025	0.076	jit_aggregate_functions	332	SELECT max(WatchID), max(CounterID), sum(toUInt256(ClientIP)), max(ClientIP) FROM hits_100m_single GROUP BY intHash32(UserID) % 1000000 FORMAT Null
0.501	0.469	-1.067x	-0.063	0.067	jit_aggregate_functions	353	SELECT avg(WatchID), avg(CounterID), sum(toUInt256(ClientIP)), avg(ClientIP), avg(IPNetworkID), avg(SearchEngineID) FROM hits_100m_single GROUP BY intHash32(UserID) % 1000000 FORMAT Null
0.485	0.489	+1.008x	0.008	0.046	jit_aggregate_functions	372	WITH (WatchID % 2 == 0) AS predicate SELECT maxIf(WatchID, predicate), maxIf(CounterID, predicate), sumIf(toUInt256(ClientIP), predicate), maxIf(ClientIP, predicate) FROM hits_100m_single GROUP BY intHash32(UserID) % 1000000 FORMAT Null
0.446	0.458	+1.028x	0.027	0.063	jit_aggregate_functions	381	WITH (WatchID % 2 == 0) AS predicate SELECT minIf(WatchID, predicate), minIf(CounterID, predicate), minIf(ClientIP, predicate), minIf(IPNetworkID, predicate), minIf(SearchEngineID, predicate) FROM hits_100m_single GROUP BY intHash32(UserID) % 1000000 FORMAT Null
0.453	0.462	+1.02x	0.019	0.051	jit_aggregate_functions	382	WITH (WatchID % 2 == 0) AS predicate SELECT maxIf(WatchID, predicate), maxIf(CounterID, predicate), maxIf(ClientIP, predicate), maxIf(IPNetworkID, predicate), maxIf(SearchEngineID, predicate) FROM hits_100m_single GROUP BY intHash32(UserID) % 1000000 FORMAT Null
0.144	0.132	-1.089x	-0.082	0.155	jit_large_requests	0	SELECT COUNT() FROM jit_test WHERE NOT ignore(a / b + c / d + e / f + g / h + i / j) SETTINGS compile_expressions = 0;
0.069	0.066	-1.049x	-0.047	0.062	jit_large_requests	1	SELECT COUNT() FROM jit_test WHERE NOT ignore(a / b + c / d + e / f + g / h + i / j) SETTINGS compile_expressions = 1, min_count_to_compile_expression = 1
0.484	0.502	+1.037x	0.036	0.08	join_append_block	0	SELECT count(c) FROM numbers_mt(100000000) AS a INNER JOIN (SELECT number, toString(number) AS c FROM numbers(2000000)) AS b ON (a.number % 10000000) = b.number settings join_algorithm='hash'
0.443	0.437	-1.015x	-0.015	0.06	join_append_block	1	SELECT count(c) FROM numbers_mt(100000000) AS a INNER JOIN (SELECT number, toString(number) AS c FROM numbers(2000000)) AS b ON (a.number % 10000000) = b.number settings join_algorithm='parallel_hash'
0.74	0.734	-1.009x	-0.009	0.02	join_convert_outer_to_inner	0	SELECT lhs.id, rhs.id, lhs.value, rhs.value FROM test_table_1 AS lhs LEFT JOIN test_table_2 AS rhs ON lhs.id = rhs.id WHERE rhs.value != '' FORMAT Null
0.004	0.005	+1.067x	0.059	0.027	join_convert_outer_to_inner	1	SELECT lhs.id, rhs.id, lhs.value, rhs.value FROM test_table_1 AS lhs LEFT JOIN test_table_2 AS rhs ON lhs.id = rhs.id WHERE rhs.value != '' AND rhs.id = 5 FORMAT Null
0.721	0.702	-1.028x	-0.027	0.066	join_convert_outer_to_inner	2	SELECT lhs.id, rhs.id, lhs.value, rhs.value FROM test_table_1 AS lhs RIGHT JOIN test_table_2 AS rhs ON lhs.id = rhs.id WHERE lhs.value != '' FORMAT Null
0.005	0.005	+1.02x	0.031	0.022	join_convert_outer_to_inner	3	SELECT lhs.id, rhs.id, lhs.value, rhs.value FROM test_table_1 AS lhs RIGHT JOIN test_table_2 AS rhs ON lhs.id = rhs.id WHERE lhs.value != '' AND lhs.id = 5 FORMAT Null
2.091	2.087	-1.002x	-0.002	0.025	join_convert_outer_to_inner	4	SELECT lhs.id, rhs.id, lhs.value, rhs.value FROM test_table_1 AS lhs FULL JOIN test_table_2 AS rhs ON lhs.id = rhs.id WHERE lhs.value != '' AND rhs.value != ''
0.004	0.004	+1x	0.002	0.026	join_max_streams	0	SELECT * FROM (SELECT 1 AS k FROM numbers_mt(1)) t1 LEFT JOIN (SELECT 1 AS k FROM numbers_mt(10000000000) WHERE number = 1) t2 USING k
0.267	0.261	-1.023x	-0.023	0.032	join_max_streams	1	SELECT * FROM (SELECT 1 AS k FROM numbers_mt(1)) t1 LEFT JOIN (SELECT 1 AS k FROM numbers_mt(10000000000) GROUP BY k) t2 USING k
0.004	0.004	+1x	-0.006	0.022	join_max_streams	2	SELECT * FROM (SELECT 1 AS k FROM numbers_mt(1)) t1 LEFT JOIN (SELECT 1 AS k FROM numbers_mt(10000000000) WHERE number = 1) t2 ON t1.k = t2.k
0.151	0.152	+1.011x	0.01	0.034	json_extract_rapidjson	0	SELECT 'rapidjson-1', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractString(materialize('{"sparam":"test_string","nparam": 772}'), 'sparam'))
0.147	0.147	+1.001x	0	0.031	json_extract_rapidjson	1	SELECT 'rapidjson-2', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractString(materialize('{"sparam":"test_string","nparam": 772}'), 'sparam', 'nested_1'))
0.153	0.152	-1.002x	-0.002	0.015	json_extract_rapidjson	2	SELECT 'rapidjson-3', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractInt(materialize('{"sparam":"test_string","nparam": 772}'), 'nparam'))
0.149	0.15	+1.008x	0.008	0.024	json_extract_rapidjson	3	SELECT 'rapidjson-4', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractUInt(materialize('{"sparam":"test_string","nparam": 772}'), 'nparam'))
0.15	0.146	-1.031x	-0.03	0.037	json_extract_rapidjson	4	SELECT 'rapidjson-5', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractFloat(materialize('{"sparam":"test_string","nparam": 772}'), 'fparam'))
0.638	0.644	+1.01x	0.01	0.032	json_extract_rapidjson	5	SELECT 'rapidjson-6', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractString(materialize('{"sparam":{"nested_1":"test_string","nested_2":"test_2"}, "nparam":8495, "fparam":{"nested_1":91.15,"nested_2":[334, 89.05, 1000.01]}, "bparam":false}'), 'sparam'))
0.471	0.468	-1.007x	-0.007	0.034	json_extract_rapidjson	8	SELECT 'rapidjson-9', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractUInt(materialize('{"sparam":{"nested_1":"test_string","nested_2":"test_2"}, "nparam":8495, "fparam":{"nested_1":91.15,"nested_2":[334, 89.05, 1000.01]}, "bparam":false}'), 'nparam'))
0.652	0.655	+1.004x	0.004	0.02	json_extract_rapidjson	9	SELECT 'rapidjson-10', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractRaw(materialize('{"sparam":{"nested_1":"test_string","nested_2":"test_2"}, "nparam":8495, "fparam":{"nested_1":91.15,"nested_2":[334, 89.05, 1000.01]}, "bparam":false}'), 'fparam'))
0.474	0.47	-1.007x	-0.008	0.013	json_extract_rapidjson	10	SELECT 'rapidjson-11', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractFloat(materialize('{"sparam":{"nested_1":"test_string","nested_2":"test_2"}, "nparam":8495, "fparam":{"nested_1":91.15,"nested_2":[334, 89.05, 1000.01]}, "bparam":false}'), 'fparam'))
0.489	0.495	+1.013x	0.012	0.029	json_extract_rapidjson	11	SELECT 'rapidjson-12', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractFloat(materialize('{"sparam":{"nested_1":"test_string","nested_2":"test_2"}, "nparam":8495, "fparam":{"nested_1":91.15,"nested_2":[334, 89.05, 1000.01]}, "bparam":false}'), 'fparam', 'nested_2', -2))
0.158	0.157	-1.006x	-0.006	0.035	json_type	0	INSERT INTO t_json_1 SELECT materialize('{"k1":1, "k2": "some"}') FROM numbers(200000)
0.169	0.17	+1.004x	0.004	0.052	json_type	1	INSERT INTO t_json_2 SELECT '{"col' \|\| toString(number % 100) \|\| '":' \|\| toString(number) \|\| '}' FROM numbers(100000)
0.305	0.307	+1.007x	0.006	0.019	json_type	2	INSERT INTO t_json_3 SELECT materialize('{"k1":[{"k2":"aaa","k3":[{"k4":"bbb"},{"k4":"ccc"}]},{"k2":"ddd","k3":[{"k4":"eee"},{"k4":"fff"}]}]}') FROM numbers_mt(100000)
0.173	0.164	-1.061x	-0.058	0.092	lazyMaterialization	0	SELECT * FROM test.hits ORDER BY EventTime LIMIT 1 FORMAT Null
0.184	0.187	+1.012x	0.012	0.023	lazyMaterialization	1	SELECT * FROM test.hits WHERE URL LIKE '%google%' ORDER BY EventTime LIMIT 1 FORMAT Null
0.076	0.076	-1.001x	-0.001	0.009	leftpad	0	SELECT max(length(MobilePhoneModel)) FROM hits_100m_single
0.038	0.038	-1.003x	-0.003	0.031	leftpad	1	SELECT max(length(Params)) FROM hits_100m_single
0.494	0.488	-1.013x	-0.014	0.029	leftpad	2	SELECT max(length(Title)) FROM hits_10m_single
0.475	0.469	-1.012x	-0.012	0.014	leftpad	3	SELECT max(length(PageCharset)) FROM hits_100m_single
0.461	0.464	+1.007x	0.007	0.016	leftpad	4	SELECT max(length(Referer)) FROM hits_10m_single
0.403	0.407	+1.011x	0.011	0.021	leftpad	5	SELECT max(length(URL)) FROM hits_10m_single
0.036	0.036	+1.006x	0.004	0.016	leftpad	6	SELECT max(length(UTMSource)) FROM hits_100m_single
0.311	0.3	-1.038x	-0.037	0.057	local_replica	0	select sum(number) from remote('127.0.0.{1\|2}', numbers_mt(1000000000)) group by bitAnd(number, 1)
0.008	0.008	+1x	0.004	0.014	logical_functions_large	0	SELECT count() FROM (SELECT materialize(1) AS x1, materialize(1) AS x2, materialize(1) AS x3, materialize(1) AS x4, materialize(1) AS x5, materialize(1) AS x6, materialize(1) AS x7, materialize(1) AS x8, materialize(1) AS x9, materialize(1) AS x10 FROM zeros(20000000)) WHERE NOT ignore(and(x1,x2,x3,x4,x5,x6,x7,x8,x9,x10))
0.043	0.044	+1.002x	0.002	0.009	logical_functions_large	1	SELECT count() FROM (SELECT materialize(0) AS x1, materialize(0) AS x2, materialize(0) AS x3, materialize(0) AS x4, materialize(0) AS x5, materialize(0) AS x6, materialize(0) AS x7, materialize(0) AS x8, materialize(0) AS x9, materialize(0) AS x10 FROM zeros(150000000)) WHERE NOT ignore(and(x1,x2,x3,x4,x5,x6,x7,x8,x9,x10))
0.008	0.008	+1x	-0.007	0.014	logical_functions_large	2	SELECT count() FROM (SELECT materialize(0) AS x1, materialize(0) AS x2, materialize(0) AS x3, materialize(0) AS x4, materialize(0) AS x5, materialize(0) AS x6, materialize(0) AS x7, materialize(0) AS x8, materialize(0) AS x9, materialize(0) AS x10 FROM zeros(20000000)) WHERE NOT ignore(or(x1,x2,x3,x4,x5,x6,x7,x8,x9,x10))
0.027	0.027	-1.004x	-0.002	0.012	logical_functions_large	3	SELECT count() FROM (SELECT materialize(1) AS x1, materialize(1) AS x2, materialize(1) AS x3, materialize(1) AS x4, materialize(1) AS x5, materialize(1) AS x6, materialize(1) AS x7, materialize(1) AS x8, materialize(1) AS x9, materialize(1) AS x10 FROM zeros(100000000)) WHERE NOT ignore(or(x1,x2,x3,x4,x5,x6,x7,x8,x9,x10))
0.139	0.139	+1x	-0.001	0.02	logical_functions_large	4	SELECT count() FROM (SELECT materialize(1) AS x1, materialize(1) AS x2, materialize(1) AS x3, materialize(1) AS x4, materialize(1) AS x5, materialize(1) AS x6, materialize(1) AS x7, materialize(1) AS x8, materialize(1) AS x9, materialize(1) AS x10 FROM zeros(500000000)) WHERE NOT ignore(xor(x1,x2,x3,x4,x5,x6,x7,x8,x9,x10))
0.092	0.092	+1.004x	0.004	0.012	logical_functions_large	5	SELECT count() FROM (SELECT materialize(toUInt8(1)) AS x1, materialize(toUInt16(1)) AS x2, materialize(toUInt32(1)) AS x3, materialize(toUInt64(1)) AS x4, materialize(toInt8(1)) AS x5, materialize(toInt16(1)) AS x6, materialize(toInt32(1)) AS x7, materialize(toInt64(1)) AS x8, materialize(toFloat32(1)) AS x9, materialize(toFloat64(1)) AS x10 FROM zeros(20000000)) WHERE NOT ignore(and(x1,x2,x3,x4,x5,x6,x7,x8,x9,x10))
0.18	0.18	+1.002x	0.001	0.015	logical_functions_large	6	SELECT count() FROM (SELECT materialize(toUInt8(0)) AS x1, materialize(toUInt16(0)) AS x2, materialize(toUInt32(0)) AS x3, materialize(toUInt64(0)) AS x4, materialize(toInt8(0)) AS x5, materialize(toInt16(0)) AS x6, materialize(toInt32(0)) AS x7, materialize(toInt64(0)) AS x8, materialize(toFloat32(0)) AS x9, materialize(toFloat64(0)) AS x10 FROM zeros(40000000)) WHERE NOT ignore(and(x1,x2,x3,x4,x5,x6,x7,x8,x9,x10))
0.092	0.092	-1.001x	-0.001	0.021	logical_functions_large	7	SELECT count() FROM (SELECT materialize(toUInt8(0)) AS x1, materialize(toUInt16(0)) AS x2, materialize(toUInt32(0)) AS x3, materialize(toUInt64(0)) AS x4, materialize(toInt8(0)) AS x5, materialize(toInt16(0)) AS x6, materialize(toInt32(0)) AS x7, materialize(toInt64(0)) AS x8, materialize(toFloat32(0)) AS x9, materialize(toFloat64(0)) AS x10 FROM zeros(20000000)) WHERE NOT ignore(or(x1,x2,x3,x4,x5,x6,x7,x8,x9,x10))
0.093	0.091	-1.013x	-0.013	0.022	logical_functions_large	8	SELECT count() FROM (SELECT materialize(toUInt8(1)) AS x1, materialize(toUInt16(1)) AS x2, materialize(toUInt32(1)) AS x3, materialize(toUInt64(1)) AS x4, materialize(toInt8(1)) AS x5, materialize(toInt16(1)) AS x6, materialize(toInt32(1)) AS x7, materialize(toInt64(1)) AS x8, materialize(toFloat32(1)) AS x9, materialize(toFloat64(1)) AS x10 FROM zeros(20000000)) WHERE NOT ignore(or(x1,x2,x3,x4,x5,x6,x7,x8,x9,x10))
0.091	0.092	+1.005x	0.006	0.025	logical_functions_large	9	SELECT count() FROM (SELECT materialize(toUInt8(1)) AS x1, materialize(toUInt16(1)) AS x2, materialize(toUInt32(1)) AS x3, materialize(toUInt64(1)) AS x4, materialize(toInt8(1)) AS x5, materialize(toInt16(1)) AS x6, materialize(toInt32(1)) AS x7, materialize(toInt64(1)) AS x8, materialize(toFloat32(1)) AS x9, materialize(toFloat64(1)) AS x10 FROM zeros(20000000)) WHERE NOT ignore(xor(x1,x2,x3,x4,x5,x6,x7,x8,x9,x10))
0.006	0.006	+1.016x	0.018	0.031	low_cardinality_query	0	SELECT count() FROM test_lc_query WHERE lc = '12' OR lc = '34'
0.006	0.006	+1x	0.006	0.023	low_cardinality_query	1	SELECT count() FROM test_lc_query WHERE lc = '12' OR lc = '34' OR lc = '56'
0.408	0.39	-1.046x	-0.045	0.067	memory_bound_merging	0	select avg(a) from remote('127.0.0.{1,2}', default, t_mbm) group by a format Null
0.163	0.164	+1.009x	0.008	0.1	memory_cache_friendliness	0	SELECT sum(x * x + x) FROM test_memory
0.059	0.059	-1.014x	-0.014	0.066	merge_tree_insert	2	INSERT INTO merge_tree_insert_3 SELECT rand64(0), rand64(1), rand64(2) FROM system.numbers LIMIT 500000
0.108	0.108	+1.005x	0.005	0.028	merge_tree_insert	3	INSERT INTO merge_tree_insert_1 SELECT rand64(0), rand64(1), rand64(2) FROM system.numbers LIMIT 1000000
0.113	0.112	-1.005x	-0.006	0.02	merge_tree_insert	4	INSERT INTO merge_tree_insert_2 SELECT rand64(0), rand64(1), rand64(2) FROM system.numbers LIMIT 1000000
0.113	0.114	+1.009x	0.008	0.056	merge_tree_insert	5	INSERT INTO merge_tree_insert_3 SELECT rand64(0), rand64(1), rand64(2) FROM system.numbers LIMIT 1000000
0.149	0.151	+1.012x	0.011	0.052	merge_tree_insert	6	INSERT INTO merge_tree_insert_1 SELECT rand64(0), rand64(1), rand64(2) FROM system.numbers LIMIT 1500000
1.017	1.001	-1.016x	-0.016	0.029	merge_tree_insert	16	INSERT INTO merge_tree_insert_5 SELECT toString(rand64(0)), toString(rand64(1)), toString(rand64(2)) FROM system.numbers LIMIT 1500000
0.984	1	+1.016x	0.015	0.024	merge_tree_insert	17	INSERT INTO merge_tree_insert_6 SELECT toString(rand64(0)), toString(rand64(1)), toString(rand64(2)) FROM system.numbers LIMIT 1500000
0.08	0.082	+1.02x	0.02	0.048	merge_tree_insert	20	INSERT INTO merge_tree_insert_9 SELECT rand64(0) % 1000000, rand64(1) % 1500000, rand64(2) % 2000000 FROM system.numbers LIMIT 500000
0.143	0.144	+1.007x	0.006	0.015	merge_tree_insert	21	INSERT INTO merge_tree_insert_7 SELECT rand64(0) % 1000000, rand64(1) % 1500000, rand64(2) % 2000000 FROM system.numbers LIMIT 1000000
0.168	0.172	+1.024x	0.024	0.034	merge_tree_insert	22	INSERT INTO merge_tree_insert_8 SELECT rand64(0) % 1000000, rand64(1) % 1500000, rand64(2) % 2000000 FROM system.numbers LIMIT 1000000
0.007	0.007	+1x	0.005	0.032	merge_tree_many_partitions	0	SELECT count() FROM bad_partitions
0.01	0.01	+1.01x	0.006	0.022	monotonous_order_by	0	SELECT * FROM (SELECT CounterID, EventDate FROM hits_10m_single) ORDER BY toFloat32(toFloat64(toFloat32(toFloat64(CounterID)))) FORMAT Null
0.39	0.388	-1.004x	-0.004	0.018	monotonous_order_by	1	SELECT * FROM (SELECT CounterID, EventDate FROM hits_10m_single) ORDER BY toFloat32(toFloat64(toFloat32(toFloat64(CounterID)))) DESC, toFloat32(toFloat64(toFloat32(toFloat64(EventDate)))) ASC FORMAT Null
0.089	0.088	-1.011x	-0.012	0.07	new_json_type	0	INSERT INTO t_json_1 SELECT materialize('{"k1":1, "k2": "some"}') FROM numbers(200000)
0.303	0.3	-1.011x	-0.011	0.026	new_json_type	1	INSERT INTO t_json_2 SELECT '{"col' \|\| toString(number % 100) \|\| '":' \|\| toString(number) \|\| '}' FROM numbers(100000)
0.204	0.201	-1.013x	-0.013	0.04	new_json_type	2	INSERT INTO t_json_3 SELECT materialize('{"k1":[{"k2":"aaa","k3":[{"k4":"bbb"},{"k4":"ccc"}]},{"k2":"ddd","k3":[{"k4":"eee"},{"k4":"fff"}]}]}') FROM numbers_mt(100000)
0.255	0.252	-1.011x	-0.012	0.011	norm_distance	0	SELECT sum(dist) FROM (SELECT L1Norm(v) AS dist FROM vecs_BFloat16)
0.374	0.374	-1.001x	-0.001	0.011	norm_distance	5	SELECT sum(dist) FROM (SELECT LinfNorm(v) AS dist FROM vecs_Float32)
0.573	0.568	-1.009x	-0.01	0.014	norm_distance	6	SELECT sum(dist) FROM (SELECT L1Norm(v) AS dist FROM vecs_Float64)
0.258	0.26	+1.009x	0.008	0.023	norm_distance	10	WITH (SELECT v FROM vecs_BFloat16 limit 1) AS a SELECT sum(dist) FROM (SELECT L2Distance(a, v) AS dist FROM vecs_BFloat16)
0.405	0.405	+1.001x	0.001	0.011	norm_distance	11	WITH (SELECT v FROM vecs_BFloat16 limit 1) AS a SELECT sum(dist) FROM (SELECT LinfDistance(a, v) AS dist FROM vecs_BFloat16)
0.394	0.391	-1.008x	-0.008	0.008	norm_distance	12	WITH (SELECT v FROM vecs_Float32 limit 1) AS a SELECT sum(dist) FROM (SELECT L1Distance(a, v) AS dist FROM vecs_Float32)
0.313	0.316	+1.011x	0.01	0.013	norm_distance	13	WITH (SELECT v FROM vecs_Float32 limit 1) AS a SELECT sum(dist) FROM (SELECT L2Distance(a, v) AS dist FROM vecs_Float32)
0.314	0.315	+1.003x	0.002	0.005	norm_distance	18	WITH (SELECT v FROM vecs_BFloat16 limit 1) AS a SELECT sum(dist) FROM (SELECT cosineDistance(a, v) AS dist FROM vecs_BFloat16)
0.349	0.348	-1.002x	-0.002	0.005	norm_distance	19	WITH (SELECT v FROM vecs_Float32 limit 1) AS a SELECT sum(dist) FROM (SELECT cosineDistance(a, v) AS dist FROM vecs_Float32)
0.582	0.581	-1.002x	-0.003	0.006	norm_distance	20	WITH (SELECT v FROM vecs_Float64 limit 1) AS a SELECT sum(dist) FROM (SELECT cosineDistance(a, v) AS dist FROM vecs_Float64)
0.675	0.695	+1.03x	0.029	0.084	normalize_utf8	0	SELECT normalizeUTF8NFC(SearchPhrase) FROM hits_100m_single FORMAT Null
0.7	0.698	-1.004x	-0.004	0.062	normalize_utf8	1	SELECT normalizeUTF8NFD(SearchPhrase) FROM hits_100m_single FORMAT Null
0.698	0.708	+1.014x	0.014	0.07	normalize_utf8	2	SELECT normalizeUTF8NFKC(SearchPhrase) FROM hits_100m_single FORMAT Null
0.74	0.722	-1.025x	-0.025	0.081	normalize_utf8	3	SELECT normalizeUTF8NFKD(SearchPhrase) FROM hits_100m_single FORMAT Null
0.007	0.007	-1.014x	-0.008	0.019	optimize_functions_to_subcolumns	0	SELECT count() FROM t_subcolumns WHERE NOT ignore(length(a))
0.008	0.008	+1.013x	0.008	0.018	optimize_functions_to_subcolumns	1	SELECT count() FROM t_subcolumns WHERE notEmpty(a)
0.007	0.007	-1.014x	-0.002	0.017	optimize_functions_to_subcolumns	2	SELECT count() FROM t_subcolumns WHERE NOT ignore(length(m))
0.008	0.008	+1x	-0.006	0.016	optimize_functions_to_subcolumns	3	SELECT count() FROM t_subcolumns WHERE notEmpty(m)
0.006	0.006	+1x	0.001	0.018	optimize_functions_to_subcolumns	4	SELECT count() FROM t_subcolumns WHERE isNotNull(s)
0.006	0.006	+1x	0.003	0.021	optimize_functions_to_subcolumns	5	SELECT count(s) FROM t_subcolumns
0.113	0.114	+1.01x	0.009	0.026	optimize_window_funnel	0	SELECT level, count() from (select windowFunnel(86400)(time, event='a', event='b', event='c', event='d') level from action group by uid) group by level FORMAT Null
0.054	0.053	-1.006x	-0.006	0.05	optimized_select_final_one_part	0	SELECT * FROM optimized_select_final FINAL where s = 'string' FORMAT Null
0.029	0.029	+1.003x	0.002	0.037	orc_filter_push_down	0	select a % 10, length(b) % 10, count(1) from test_orc_fpd where a > 9000000 group by a % 10, length(b) % 10
0.007	0.007	+1x	-0.004	0.02	orc_filter_push_down	1	select a % 10, length(b) % 10, count(1) from test_orc_fpd where a in (9000000, 1000) group by a % 10, length(b) % 10
0.012	0.012	-1.008x	-0.004	0.023	orc_tuple_field_prune	0	select * from file('test_orc_tfp.orc', 'ORC', 'tuple_column Tuple(c Nullable(Int64))') format Null
0.044	0.044	-1.002x	-0.002	0.024	orc_tuple_field_prune	1	select * from file('test_orc_tfp.orc', 'ORC', 'array_tuple_column Nested(c Nullable(Int64))') format Null
0.097	0.098	+1.012x	0.012	0.033	orc_tuple_field_prune	2	select * from file('test_orc_tfp.orc', 'ORC', 'map_tuple_column Map(String, Tuple(c Nullable(Int64)))') format Null
0.634	0.646	+1.019x	0.019	0.042	order_by_single_column	0	SELECT URL as col FROM hits_100m_single ORDER BY col LIMIT 1000,1
0.1	0.099	-1.007x	-0.008	0.04	order_by_single_column	1	SELECT SearchPhrase as col FROM hits_100m_single ORDER BY col LIMIT 10000,1
0.194	0.197	+1.017x	0.016	0.036	order_by_single_column	2	SELECT SearchPhrase as col FROM hits_100m_single WHERE notEmpty(col) ORDER BY col LIMIT 10000,1
0.039	0.04	+1.015x	0.013	0.016	order_by_single_column	3	SELECT MobilePhoneModel as col FROM hits_100m_single ORDER BY col LIMIT 20000,1
0.047	0.047	-1.004x	-0.005	0.042	order_by_single_column	4	SELECT MobilePhoneModel as col FROM hits_100m_single WHERE notEmpty(col) ORDER BY col LIMIT 500000,1
0.062	0.062	+1.005x	0.006	0.064	order_by_single_column	5	SELECT PageCharset as col FROM hits_100m_single ORDER BY col LIMIT 10000,1
0.578	0.567	-1.019x	-0.019	0.068	order_by_single_column	6	SELECT Title as col FROM hits_100m_single ORDER BY col LIMIT 1000,1
0.004	0.004	+1x	-0.005	0.018	parallel_final	0	SELECT count() FROM replacing_final_16p_ord final
0.004	0.004	+1x	-0.001	0.027	parallel_final	2	SELECT count() FROM replacing_final_16p_int_keys_ord final
0.004	0.004	+1x	0.002	0.024	parallel_final	4	SELECT count() FROM replacing_final_16p_str_keys_ord final
0.004	0.004	+1x	-0.005	0.024	parallel_final	5	SELECT count() FROM replacing_final_16p_str_keys_rnd final
0.04	0.042	+1.045x	0.042	0.091	parallel_final	6	SELECT count() FROM replacing_final_1024p_ord final
0.046	0.046	+1.007x	0.006	0.041	parallel_final	9	SELECT sum(s) FROM replacing_final_16p_ord final group by key1 limit 10
0.046	0.045	-1.027x	-0.028	0.063	parallel_final	10	SELECT sum(s) FROM replacing_final_16p_rnd final group by key1 limit 10
0.046	0.046	-1.007x	-0.008	0.059	parallel_final	14	SELECT sum(s) FROM replacing_final_16p_str_keys_rnd final group by key1 limit 10
0.018	0.018	-1.006x	-0.003	0.015	parallel_final	20	SELECT sum(s) FROM replacing_final_16p_int_keys_ord final group by key1 % 8192 limit 10
0.013	0.013	+1x	0	0.022	parallel_final	23	SELECT sum(s) FROM replacing_final_16p_str_keys_rnd final group by key1 % 8192 limit 10
1.061	1.07	+1.009x	0.008	0.03	parallel_hash_build_phase	0	select * from numbers_mt(100) t1 inner join numbers_mt(1e8) t2 using (number) format Null
0.688	0.644	-1.069x	-0.065	0.081	parallel_insert	0	INSERT INTO hits2 SELECT CounterID, EventDate, UserID, Title FROM hits_10m_single SETTINGS max_insert_threads=8
0.734	0.72	-1.019x	-0.019	0.018	point_in_polygon_3d_huge_multipolygon	0	WITH (SELECT poly FROM multipoly_holder LIMIT 1) AS mp, arrayShuffle(mp) AS mp_shuffled SELECT count() FROM random_pts WHERE NOT ignore(pointInPolygon(pt, mp_shuffled));
0.15	0.149	-1.004x	-0.005	0.013	point_in_polygon_const_3d	0	WITH 2001 AS side, -1000 AS min_coord SELECT count() FROM ( SELECT number FROM numbers(side * side) ) AS grid WHERE NOT ignore ( pointInPolygon ( (min_coord + (number % side), min_coord + (number / side)), [ [ [(100,100),(900,100),(900,900),(100,900)], [(300,300),(500,300),(500,500),(300,500)], [(600,600),(800,600),(800,800),(600,800)] ], [ [(-900,100),(-100,100),(-100,900),(-900,900)], [(-700,300),(-500,300),(-500,500),(-700,500)], [(-400,600),(-200,600),(-200,800),(-400,800)] ], [ [(-900,-900),(-100,-900),(-100,-100),(-900,-100)], [(-700,-700),(-500,-700),(-500,-500),(-700,-500)], [(-400,-400),(-200,-400),(-200,-200),(-400,-200)] ] ] ) );
0.122	0.123	+1.004x	0.004	0.024	prepare_hash_before_merge	0	SELECT COUNT(DISTINCT Title) FROM test.hits SETTINGS max_threads = 24
0.144	0.144	-1.001x	-0.002	0.086	prepare_hash_before_merge	1	SELECT COUNT(DISTINCT Title) FROM test.hits SETTINGS max_threads = 56
0.149	0.15	+1.003x	0.003	0.048	prepare_hash_before_merge	2	SELECT COUNT(DISTINCT Title) FROM test.hits SETTINGS max_threads = 64
0.117	0.116	-1.004x	-0.005	0.064	prepare_hash_before_merge	3	SELECT COUNT(DISTINCT Referer) FROM test.hits SETTINGS max_threads = 22
0.657	0.65	-1.01x	-0.011	0.014	prewhere	0	SELECT Title FROM hits_10m_single PREWHERE WatchID % 2 = 1 WHERE UserID = 10000 FORMAT Null
0.104	0.104	-1.004x	-0.004	0.045	prewhere_with_row_level_filter	0	SELECT sum(n) FROM test_prl
0.125	0.125	+1.005x	0.004	0.022	prewhere_with_row_level_filter	1	SELECT sum(n) FROM test_prl WHERE n % 3 AND n % 5
0.115	0.115	-1.005x	-0.006	0.025	prewhere_with_row_level_filter	2	SELECT sum(n) FROM test_prl PREWHERE n % 3 AND n % 5
0.117	0.116	-1.008x	-0.008	0.036	prewhere_with_row_level_filter	3	SELECT sum(n) FROM test_prl PREWHERE n % 3 WHERE n % 5
0.122	0.125	+1.028x	0.027	0.056	prewhere_with_row_level_filter	4	SELECT sum(n) FROM test_prl PREWHERE n % 5 WHERE n % 3
0.065	0.081	+1.234x	0.233	0.244	quantile_merge	0	SELECT quantileMerge(arrayJoin(arrayMap(x -> state, range(5000000)))) FROM (SELECT quantileState(rand()) AS state FROM numbers(10000))
0.624	0.624	+1x	0	0.006	random_string_utf8	0	SELECT count() FROM zeros(10000000) WHERE NOT ignore(randomStringUTF8(10))
0.608	0.608	-1.001x	-0.001	0.01	random_string_utf8	1	SELECT count() FROM zeros(1000000) WHERE NOT ignore(randomStringUTF8(100))
0.67	0.671	+1.001x	0.001	0.011	random_string_utf8	2	SELECT count() FROM zeros(100000) WHERE NOT ignore(randomStringUTF8(1000))
0.709	0.705	-1.006x	-0.006	0.023	random_string_utf8	3	SELECT count() FROM zeros(10000) WHERE NOT ignore(randomStringUTF8(10000))
0.386	0.387	+1.003x	0.002	0.013	random_string_utf8	4	SELECT count() FROM zeros(10000000) WHERE NOT ignore(randomStringUTF8(rand() % 10))
0.31	0.309	-1.005x	-0.005	0.015	random_string_utf8	5	SELECT count() FROM zeros(1000000) WHERE NOT ignore(randomStringUTF8(rand() % 100))
0.334	0.333	-1.002x	-0.003	0.025	random_string_utf8	6	SELECT count() FROM zeros(100000) WHERE NOT ignore(randomStringUTF8(rand() % 1000))
0.075	0.076	+1.008x	0.007	0.032	range	0	SELECT range(number % 100) FROM numbers(10000000) FORMAT Null
0.132	0.132	-1.004x	-0.005	0.037	range	1	SELECT range(0, number % 100, 1) FROM numbers(10000000) FORMAT Null
0.009	0.009	+1.011x	0.006	0.038	re2_regex_caching	0	select toString(number) as haystack, like(haystack, '%x_') from(select * from numbers_mt(1500000)) format Null
0.009	0.01	+1.032x	0.03	0.071	re2_regex_caching	1	select toString(number) as haystack, match(haystack, '.x.') from(select from numbers_mt(1500000)) format Null
1.728	1.614	-1.07x	-0.066	0.219	re2_regex_caching	2	select toString(number) as haystack, '%' \|\| toString(number) \|\| '_' as needle, like(haystack, needle) from (select * from numbers_mt(1500000)) format Null
0.102	0.111	+1.087x	0.086	0.074	re2_regex_caching	3	select toString(number) as haystack, '%' \|\| toString(number % 10) \|\| '_' as needle, like(haystack, needle) from (select * from numbers_mt(1500000)) format Null
1.494	1.438	-1.039x	-0.038	0.158	re2_regex_caching	4	select toString(number) as haystack, '.' \|\| toString(number) \|\| '.' as needle, match(haystack, needle) from (select from numbers_mt(1500000)) format Null
0.103	0.11	+1.07x	0.069	0.066	re2_regex_caching	5	select toString(number) as haystack, '.' \|\| toString(number % 10) \|\| '.' as needle, match(haystack, needle) from (select from numbers_mt(1500000)) format Null
0.11	0.117	+1.063x	0.062	0.062	re2_regex_caching	6	select toString(number) as haystack, '([a-zA-Z][a-zA-Z0-9])://([^ /]+)(/[^ ])?([^ @]+)@([^ @]+)([0-9][0-9]?)/([0-9][0-9]?)/([0-9][0-9]([0-9][0-9])?)(?:(?:25[0-5]\|2[0-4][0-9]\|[01]?[0-9][0-9])\.){3}(?:25[0-5]\|2[0-4][0-9]\|[01]?[0-9][0-9])' \|\| toString(number % 10) as needle, match(haystack, needle) from (select * from numbers_mt(1500000)) format Null
0.061	0.061	+1.003x	0.004	0.026	read_from_comp_parts	0	SELECT count() FROM mt_comp_parts WHERE NOT ignore(s1)
0.222	0.213	-1.043x	-0.042	0.049	read_from_comp_parts	1	SELECT count() FROM mt_comp_parts WHERE NOT ignore(c2, s1, arr1, s2)
0.096	0.096	+1.006x	0.006	0.068	read_from_comp_parts	2	SELECT count() FROM mt_comp_parts WHERE NOT ignore(c1, s1, c3)
0.06	0.06	-1.002x	-0.002	0.012	read_from_comp_parts	3	SELECT count() FROM mt_comp_parts WHERE NOT ignore(c1, c2, c3)
0.22	0.222	+1.01x	0.01	0.021	read_from_comp_parts	4	SELECT count() FROM mt_comp_parts WHERE NOT ignore(*)
0.026	0.026	-1.008x	-0.011	0.031	read_in_order_many_parts	0	SELECT val2 FROM mt_100_parts_10000_uniqs ORDER BY val1 LIMIT 1000000 FORMAT Null
0.178	0.181	+1.015x	0.015	0.104	read_in_order_many_parts	1	SELECT val2 FROM mt_1000_parts_10000_uniqs ORDER BY val1 LIMIT 1000000 FORMAT Null
0.08	0.08	-1.003x	-0.002	0.036	read_in_order_many_parts	2	SELECT val2 FROM mt_100_parts_10000_uniqs ORDER BY val1 LIMIT 10000000 FORMAT Null
0.218	0.222	+1.018x	0.017	0.039	read_in_order_many_parts	3	SELECT val2 FROM mt_1000_parts_10000_uniqs ORDER BY val1 LIMIT 10000000 FORMAT Null
0.04	0.039	-1.023x	-0.021	0.023	read_in_order_many_parts	4	SELECT sum(val2) FROM mt_100_parts_100_uniqs GROUP BY val1 FORMAT Null
0.063	0.064	+1.008x	0.007	0.028	read_in_order_many_parts	5	SELECT sum(val2) FROM mt_100_parts_10000_uniqs GROUP BY val1 FORMAT Null
0.179	0.183	+1.022x	0.021	0.06	read_in_order_many_parts	6	SELECT sum(val2) FROM mt_1000_parts_100_uniqs GROUP BY val1 FORMAT Null
0.538	0.518	-1.04x	-0.039	0.061	read_in_order_many_parts	7	SELECT sum(val2) FROM mt_1000_parts_10000_uniqs GROUP BY val1 FORMAT Null
0.376	0.362	-1.036x	-0.035	0.034	reading_from_file	0	SELECT sum(length(base58Encode(URL))) FROM file(reading_from_file.parquet) FORMAT Null
0.073	0.073	+1x	-0.001	0.033	redundant_functions_in_order_by	0	SELECT CounterID, EventDate FROM hits_100m_single ORDER BY CounterID, exp(CounterID), sqrt(CounterID) FORMAT Null
0.075	0.074	-1.016x	-0.016	0.032	redundant_functions_in_order_by	1	SELECT CounterID, EventDate FROM hits_100m_single ORDER BY CounterID, EventDate, exp(CounterID), toDateTime(EventDate) FORMAT Null
0.173	0.171	-1.011x	-0.011	0.022	redundant_functions_in_order_by	2	SELECT CounterID, EventDate FROM hits_100m_single ORDER BY CounterID DESC, EventDate DESC, exp(CounterID), toDateTime(EventDate) FORMAT Null
0.548	0.541	-1.012x	-0.013	0.055	replace_int256	0	SELECT i1i2, u1u2 FROM tab
0.24	0.236	-1.015x	-0.015	0.026	replace_int256	1	SELECT intDivOrZero(i1, i2), intDivOrZero(u1, u2) FROM tab
0.63	0.628	-1.003x	-0.003	0.036	replace_int256	2	SELECT modulo(i1, i2), modulo(u1, u2) FROM tab
0.516	0.521	+1.009x	0.009	0.023	replace_int256	3	SELECT i1+i2, u1+u2 FROM tab
0.576	0.579	+1.006x	0.005	0.014	replace_int256	4	SELECT i1-i2, u1-u2 FROM tab
0.08	0.079	-1.022x	-0.023	0.03	rewrite_array_exists	0	select arrayExists(x -> x = 5, materialize(range(10))) from numbers(10000000) format Null
0.066	0.068	+1.029x	0.027	0.03	rewrite_array_exists	1	select has(materialize(range(10)), 5) from numbers(10000000) format Null
0.105	0.105	-1.004x	-0.004	0.011	round_down	0	SELECT count() FROM zeros (100000000) WHERE NOT ignore(roundDuration(rand() % 65536))
0.936	0.938	+1.002x	0.001	0.003	round_down	1	SELECT count() FROM zeros (100000000) WHERE NOT ignore(roundDown(rand() % 65536, [0, 1, 10, 30, 60, 120, 180, 240, 300, 600, 1200, 1800, 3600, 7200, 18000, 36000]))
0.079	0.079	+1x	0	0.005	round_down	2	SELECT count() FROM zeros (100000000) WHERE NOT ignore(roundAge(rand() % 100))
0.992	0.99	-1.003x	-0.003	0.01	round_down	3	SELECT count() FROM zeros (100000000) WHERE NOT ignore(roundDown(rand() % 100, [0, 1, 18, 25, 35, 45, 55]))
0.573	0.571	-1.004x	-0.004	0.006	round_down	4	SELECT count() FROM numbers(10000000) WHERE NOT ignore(roundDown(rand() % 65536, (SELECT groupArray(number) FROM numbers(65536))))
0.68	0.681	+1.003x	0.002	0.08	scalar	0	WITH (SELECT mid_seqs FROM cdp_tags WHERE tag_id='tag1') AS bm1, (SELECT mid_seqs FROM cdp_tags WHERE tag_id='tag2') AS bm2, (SELECT mid_seqs FROM cdp_tags WHERE tag_id='tag3') AS bm3, (SELECT mid_seqs FROM cdp_tags WHERE tag_id='tag4') AS bm4, (SELECT mid_seqs FROM cdp_tags WHERE tag_id='tag5') AS bm5, (SELECT mid_seqs FROM cdp_tags WHERE tag_id='tag6') AS bm6, (SELECT mid_seqs FROM cdp_tags WHERE tag_id='tag7') AS bm7, (SELECT mid_seqs FROM cdp_tags WHERE tag_id='tag8') AS bm8, toDateTime('2000-01-01 00:00:00') AS ts_begin, addSeconds(toDateTime('2000-01-01 00:00:00'), 1e8) AS ts_end SELECT multiIf(bitmapContains(bm1, mid_seq), 1, bitmapContains(bm2, mid_seq), 2, bitmapContains(bm3, mid_seq), 3, bitmapContains(bm4, mid_seq), 4, bitmapContains(bm5, mid_seq), 5, bitmapContains(bm6, mid_seq), 6, bitmapContains(bm7, mid_seq), 7, bitmapContains(bm8, mid_seq), 8, 0) AS tag, count() AS gc, sum(order_total_sales) AS total FROM cdp_orders PREWHERE order_complete_time >= ts_begin AND order_com...(0)
0.08	0.082	+1.02x	0.018	0.136	select_format	0	INSERT INTO table_Pretty SELECT * FROM test.hits LIMIT 10000
0.078	0.079	+1.001x	0.001	0.124	select_format	1	INSERT INTO table_PrettyCompact SELECT * FROM test.hits LIMIT 10000
0.079	0.079	+1.004x	0.004	0.135	select_format	3	INSERT INTO table_PrettyNoEscapes SELECT * FROM test.hits LIMIT 10000
0.08	0.079	-1.006x	-0.008	0.108	select_format	4	INSERT INTO table_PrettySpace SELECT * FROM test.hits LIMIT 10000
0.152	0.157	+1.029x	0.029	0.167	select_format	6	INSERT INTO table_XML SELECT * FROM test.hits LIMIT 10000
0.437	0.437	-1x	-0.001	0.09	select_format	9	INSERT INTO table_CSV SELECT * FROM test.hits LIMIT 100000
0.68	0.681	+1.002x	0.001	0.022	select_format	13	INSERT INTO table_JSONCompact SELECT * FROM test.hits LIMIT 100000
1.1	1.057	-1.04x	-0.039	0.099	select_format	14	INSERT INTO table_JSONEachRow SELECT * FROM test.hits LIMIT 100000
0.467	0.465	-1.004x	-0.004	0.022	select_format	21	INSERT INTO table_MsgPack SELECT * FROM test.hits LIMIT 100000
0.616	0.617	+1.003x	0.003	0.017	select_format	23	INSERT INTO table_Parquet SELECT * FROM test.hits LIMIT 100000
1.144	1.14	-1.003x	-0.004	0.017	set_hits	0	SELECT count() FROM hits_100m_single WHERE UserID IN (SELECT UserID FROM hits_100m_single WHERE AdvEngineID != 0) SETTINGS max_threads = 1
0.143	0.142	-1.001x	-0.001	0.025	set_hits	1	SELECT count() FROM hits_10m_single WHERE UserID IN (SELECT UserID FROM hits_10m_single)
0.253	0.254	+1.005x	0.005	0.016	set_hits	2	SELECT count() FROM hits_10m_single WHERE SearchPhrase IN (SELECT SearchPhrase FROM hits_10m_single)
0.934	0.909	-1.028x	-0.028	0.051	set_hits	3	SELECT count() FROM hits_100m_single WHERE URL IN (SELECT URL FROM hits_100m_single WHERE AdvEngineID != 0)
0.302	0.306	+1.015x	0.014	0.06	set_hits	4	SELECT count() FROM hits_10m_single WHERE URL IN (SELECT URL FROM hits_10m_single WHERE SearchEngineID != 0)
0.358	0.354	-1.01x	-0.01	0.023	set_hits	5	SELECT count() FROM hits_100m_single WHERE RegionID IN (SELECT RegionID FROM hits_100m_single)
0.006	0.006	-1.018x	-0.02	0.027	set_index_analysis	0	SELECT count() FROM test_set WHERE x = 1234 SETTINGS max_threads = 8;
0.065	0.065	-1.005x	-0.006	0.016	short_circuit_functions	0	SELECT if(number % 100, number, isValidUTF8(repeat(toString(number + 10), 100))) FROM numbers(10000000) FORMAT Null
0.217	0.217	-1.002x	-0.002	0.037	short_circuit_functions	5	SELECT and(not isValidUTF8(repeat(toString(number), 100)), isValidUTF8(repeat(toString(number + 10), 100)), isValidUTF8(repeat(toString(number + 20), 100))) FROM numbers(1000000) FORMAT Null
0.218	0.218	+1x	0	0.009	short_circuit_functions	6	SELECT isValidUTF8(repeat(toString(number), 100)) or isValidUTF8(repeat(toString(number + 10), 100)) or isValidUTF8(repeat(toString(number + 20), 100)) FROM numbers(1000000) FORMAT Null
0.208	0.207	-1.004x	-0.005	0.149	short_circuit_functions	7	SELECT multiIf(number >= 500000, isValidUTF8(repeat(toString(number), 100)), less(number, 50000), number * 2, isValidUTF8(repeat(toString(number + 10), 100))) FROM numbers(1000000) FORMAT Null
0.002	0.002	+1x	0	0.018	short_circuit_functions	9	SELECT toColumnTypeName(isValidUTF8(repeat(toString(number), 100))) FROM numbers(1000000) FORMAT Null
0.215	0.217	+1.007x	0.007	0.028	short_circuit_functions	12	SELECT or(not isValidUTF8(repeat(toString(number), 100)), isValidUTF8(repeat(toString(number), 100)), isValidUTF8(repeat(toString(number + 10), 100))) FROM numbers(1000000) FORMAT Null
0.214	0.208	-1.026x	-0.026	0.043	short_circuit_functions	14	SELECT if(number % 2, isValidUTF8(repeat(toString(number), 100)), isValidUTF8(repeat(toString(number), 100))) FROM numbers(1000000) FORMAT Null
0.258	0.258	+1x	-0.001	0.01	short_circuit_functions	16	SELECT and(isValidUTF8(repeat(toString(number), 100)), isValidUTF8(repeat(toString(number), 10)), isValidUTF8(repeat(toString(number), 100))) from numbers(1000000) FORMAT Null
0.078	0.079	+1.014x	0.013	0.054	short_circuit_functions	19	SELECT if(number % 5 == 0, arraySum(bitPositionsToArray(number)), 0) from numbers(10000000) FORMAT Null
0.513	0.517	+1.007x	0.007	0.011	short_circuit_functions	21	SELECT if(number % 5 == 0, toInt8OrZero(toString(number)), Null) FROM numbers(100000000) FORMAT Null
0.059	0.058	-1.009x	-0.009	0.023	sort_radix_trivial	0	SELECT rand32() AS x FROM numbers(1000000) ORDER BY x FORMAT Null
0.075	0.076	+1.012x	0.01	0.032	sort_radix_trivial	1	SELECT rand64() AS x FROM numbers(1000000) ORDER BY x FORMAT Null
0.088	0.089	+1.009x	0.009	0.014	sort_radix_trivial	2	SELECT 1 / rand64() AS x FROM numbers(1000000) ORDER BY x FORMAT Null
0.002	0.002	+1x	0	0.018	sparse_grams	0	SELECT sparseGrams(repeat('a', 2000))
0.002	0.002	+1x	-0.001	0.019	sparse_grams	3	SELECT sparseGramsUTF8(repeat('ы', 2000))
0.099	0.099	+1.001x	0.001	0.034	string_bytes_functions	0	SELECT sum(stringBytesUniq(s)) FROM test_string_bytes FORMAT Null
3.875	3.86	-1.004x	-0.004	0.018	string_bytes_functions	1	SELECT sum(stringBytesEntropy(s)) FROM test_string_bytes FORMAT Null
0.426	0.429	+1.007x	0.007	0.027	string_set	0	SELECT 1 FROM hits_10m_words WHERE word IN (SELECT word FROM hits_10m_words) FORMAT Null
0.126	0.132	+1.049x	0.048	0.085	string_set	1	SELECT 1 FROM strings WHERE short IN (SELECT short FROM strings) FORMAT Null
0.245	0.245	+1.001x	0.001	0.019	string_set	2	SELECT 1 FROM strings WHERE long IN (SELECT long FROM strings) FORMAT Null
0.203	0.202	-1.002x	-0.003	0.027	string_set	3	SELECT 1 FROM strings WHERE short IN (SELECT long FROM strings) FORMAT Null
0.148	0.153	+1.035x	0.034	0.067	string_set	4	SELECT 1 FROM strings WHERE long IN (SELECT short FROM strings) FORMAT Null
0.255	0.26	+1.021x	0.02	0.047	string_set	5	SELECT 1 FROM hits_10m_words WHERE word IN (SELECT short FROM strings) FORMAT Null
0.334	0.335	+1.003x	0.003	0.022	string_set	6	SELECT 1 FROM hits_10m_words WHERE word IN (SELECT long FROM strings) FORMAT Null
0.205	0.205	+1.001x	0.001	0.002	subqueries	0	select a, b from tab where (a, b) in (select toUInt32(number) as x, toUInt32(sleep(0.1) + 1) from numbers_mt(16)) settings max_threads = 2, max_block_size = 4
0.205	0.205	+1.001x	0.001	0.001	subqueries	1	select a, b from tab where (1, 1) = (select min(toUInt32(number + 1)) as x, min(toUInt32(sleep(0.1) + 1)) from numbers_mt(16)) settings max_threads = 2, max_block_size = 4
0.03	0.03	+1x	-0.003	0.012	sum	0	SELECT sum(number) FROM numbers(100000000)
0.044	0.044	+1.002x	0.003	0.02	sum	1	SELECT sum(toUInt32(number)) FROM numbers(100000000)
0.049	0.048	-1.01x	-0.01	0.011	sum	3	SELECT sum(toUInt8(number)) FROM numbers(100000000)
0.063	0.063	-1.013x	-0.014	0.013	sum	5	SELECT sum(toFloat64(number)) FROM numbers(100000000)
0.057	0.057	-1.009x	-0.011	0.011	sum	10	SELECT sum(toNullable(toUInt16(number))) FROM numbers(100000000)
0.103	0.103	-1.003x	-0.004	0.014	sum	12	SELECT sum(toNullable(toFloat32(number))) FROM numbers(100000000)
0.227	0.226	-1.008x	-0.008	0.02	sum	18	select sumIf(number::Int128, rand32() % 2 = 0) from numbers(100000000)
0.562	0.559	-1.005x	-0.006	0.014	sum	20	select sumIf(number::Int256, rand32() % 2 = 0) from numbers(100000000)
0.014	0.014	-1.014x	-0.01	0.02	sum	22	SELECT sum(x) FROM nullfloat32
0.018	0.018	+1.011x	0.007	0.019	sum	23	SELECT sum(x::Nullable(Float64)) FROM nullfloat32
0.057	0.058	+1.002x	0.001	0.013	sumIf	0	SELECT sumIf(number, number % 2) FROM numbers(100000000)
0.106	0.106	+1.005x	0.004	0.021	trim_numbers	0	SELECT count() FROM numbers(10000000) WHERE NOT ignore(trim(toString(number)))
0.095	0.094	-1.01x	-0.011	0.02	trim_numbers	1	SELECT count() FROM numbers(10000000) WHERE NOT ignore(ltrim(toString(number)))
0.096	0.096	+1.006x	0.006	0.008	trim_numbers	2	SELECT count() FROM numbers(10000000) WHERE NOT ignore(rtrim(toString(number)))
0.167	0.166	-1.008x	-0.009	0.012	trim_numbers	3	SELECT count() FROM numbers(10000000) WHERE NOT ignore(trim(LEADING '012345' FROM toString(number)))
0.239	0.24	+1.004x	0.003	0.013	trim_numbers	4	SELECT count() FROM numbers(10000000) WHERE NOT ignore(trim(TRAILING '012345' FROM toString(number)))
0.307	0.305	-1.006x	-0.007	0.011	trim_numbers	5	SELECT count() FROM numbers(10000000) WHERE NOT ignore(trim(BOTH '012345' FROM toString(number)))
0.344	0.352	+1.024x	0.023	0.032	trivial_insert_select_from_files	0	INSERT INTO table_dst_TabSeparated SELECT * FROM table_src_TabSeparated
0.33	0.355	+1.075x	0.074	0.087	trivial_insert_select_from_files	1	INSERT INTO table_dst_TabSeparatedWithNames SELECT * FROM table_src_TabSeparatedWithNames
0.343	0.346	+1.008x	0.008	0.048	trivial_insert_select_from_files	2	INSERT INTO table_dst_TabSeparatedWithNamesAndTypes SELECT * FROM table_src_TabSeparatedWithNamesAndTypes
0.417	0.408	-1.023x	-0.023	0.033	trivial_insert_select_from_files	3	INSERT INTO table_dst_CSV SELECT * FROM table_src_CSV
0.409	0.426	+1.041x	0.04	0.044	trivial_insert_select_from_files	4	INSERT INTO table_dst_CSVWithNames SELECT * FROM table_src_CSVWithNames
0.632	0.627	-1.008x	-0.008	0.055	trivial_insert_select_from_files	5	INSERT INTO table_dst_JSONEachRow SELECT * FROM table_src_JSONEachRow
0.447	0.452	+1.011x	0.011	0.05	trivial_insert_select_from_files	6	INSERT INTO table_dst_JSONCompactEachRow SELECT * FROM table_src_JSONCompactEachRow
0.465	0.434	-1.071x	-0.067	0.087	trivial_insert_select_from_files	7	INSERT INTO table_dst_JSONCompactEachRowWithNamesAndTypes SELECT * FROM table_src_JSONCompactEachRowWithNamesAndTypes
0.365	0.377	+1.032x	0.032	0.075	trivial_insert_select_from_files	8	INSERT INTO table_dst_TSKV SELECT * FROM table_src_TSKV
0.453	0.456	+1.006x	0.005	0.031	unary_logical_functions	0	SELECT not(number) FROM numbers(1000000000) FORMAT Null
0.639	0.636	-1.004x	-0.005	0.044	unary_logical_functions	1	SELECT not(toUInt32(number)) FROM numbers(1000000000) FORMAT Null
0.675	0.651	-1.037x	-0.036	0.051	unary_logical_functions	2	SELECT not(toUInt16(number)) FROM numbers(1000000000) FORMAT Null
0.669	0.671	+1.003x	0.002	0.023	unary_logical_functions	3	SELECT not(toUInt8(number)) FROM numbers(1000000000) FORMAT Null
0.763	0.763	-1x	-0.001	0.042	unary_logical_functions	4	SELECT not(toInt64(number)) FROM numbers(1000000000) FORMAT Null
0.644	0.639	-1.008x	-0.009	0.022	unary_logical_functions	5	SELECT not(toInt32(number)) FROM numbers(1000000000) FORMAT Null
0.658	0.666	+1.012x	0.012	0.029	unary_logical_functions	6	SELECT not(toInt16(number)) FROM numbers(1000000000) FORMAT Null
0.666	0.66	-1.009x	-0.01	0.028	unary_logical_functions	7	SELECT not(toInt8(number)) FROM numbers(1000000000) FORMAT Null
0.906	0.911	+1.005x	0.005	0.047	unary_logical_functions	8	SELECT not(toFloat64(number)) FROM numbers(1000000000) FORMAT Null
1.18	1.18	-1x	-0.001	0.023	unary_logical_functions	9	SELECT not(toFloat32(number)) FROM numbers(1000000000) FORMAT Null
0.072	0.072	+1.006x	0.005	0.073	uniqExactIf	0	SELECT uniqExactIf(number, 1) FROM numbers_mt(1e7)
0.07	0.071	+1.014x	0.014	0.1	uniqExactIf	1	SELECT uniqExactState(number) FROM numbers_mt(1e7) Format Null
0.075	0.075	-1.001x	-0.002	0.095	uniqExactIf	2	SELECT uniqExactArray([number]) FROM numbers_mt(1e7) Format Null
0.076	0.069	-1.1x	-0.091	0.095	uniqExactIf	3	with (SELECT uniqExactState(number) FROM numbers_mt(1e7)) as a select uniqExactMerge(a)
0.45	0.45	-1x	-0.001	0.028	uniqExactIf	4	SELECT uniqExactOrNull(number) FROM numbers_mt(1e7)
0.485	0.466	-1.041x	-0.04	0.102	uniq_with_key	0	SELECT uniqExact(a) FROM t_100 group by b
0.54	0.553	+1.024x	0.024	0.103	uniq_with_key	1	SELECT uniqExact(a) FROM t_500 group by b
0.467	0.438	-1.066x	-0.063	0.081	uniq_with_key	2	SELECT uniqExact(a) FROM t_1000 group by b
0.561	0.55	-1.021x	-0.021	0.067	uniq_with_key	3	SELECT uniqExact(a) FROM t_5000 group by b
0.431	0.443	+1.027x	0.026	0.047	uniq_with_key	4	SELECT uniqExact(a) FROM t_10000 group by b
0.588	0.609	+1.036x	0.035	0.061	uniq_with_key	5	SELECT uniqExact(a) FROM t_50000 group by b
0.826	0.844	+1.022x	0.021	0.063	uniq_with_key	6	SELECT uniqExact(a) FROM t_100000 group by b
0.16	0.157	-1.014x	-0.014	0.056	uniq_without_key_dist	0	SELECT uniqExact(a) FROM remote('127.0.0.{1,2}', default, t_100000) SETTINGS max_threads=5
0.22	0.22	+1.003x	0.002	0.016	uniq_without_key_dist	1	SELECT uniqExact(a) FROM remote('127.0.0.{1,2}', default, t_250000) SETTINGS max_threads=5
0.225	0.229	+1.018x	0.018	0.064	uniq_without_key_dist	2	SELECT uniqExact(a) FROM remote('127.0.0.{1,2}', default, t_500000) SETTINGS max_threads=5
0.321	0.323	+1.007x	0.006	0.029	uniq_without_key_dist	3	SELECT uniqExact(a) FROM remote('127.0.0.{1,2}', default, t_1000000) SETTINGS max_threads=5
0.511	0.509	-1.005x	-0.005	0.034	uniq_without_key_dist	4	SELECT uniqExact(a) FROM remote('127.0.0.{1,2}', default, t_5000000) SETTINGS max_threads=5
0.464	0.478	+1.031x	0.03	0.105	url_hits	0	SELECT count() FROM hits_100m_single WHERE NOT ignore(protocol(URL))
0.611	0.64	+1.048x	0.047	0.064	url_hits	1	SELECT count() FROM hits_100m_single WHERE NOT ignore(domain(URL))
0.768	0.746	-1.029x	-0.029	0.062	url_hits	2	SELECT count() FROM hits_100m_single WHERE NOT ignore(domainRFC(URL))
0.743	0.737	-1.009x	-0.009	0.049	url_hits	6	SELECT count() FROM hits_100m_single WHERE NOT ignore(firstSignificantSubdomain(URL))
0.874	0.853	-1.025x	-0.025	0.06	url_hits	7	SELECT count() FROM hits_100m_single WHERE NOT ignore(firstSignificantSubdomainRFC(URL))
0.686	0.713	+1.04x	0.039	0.065	url_hits	10	SELECT count() FROM hits_100m_single WHERE NOT ignore(path(URL))
0.91	0.891	-1.021x	-0.021	0.045	url_hits	15	SELECT count() FROM hits_100m_single WHERE NOT ignore(extractURLParameters(URL))
0.69	0.682	-1.011x	-0.012	0.111	url_hits	20	SELECT count() FROM hits_100m_single WHERE NOT ignore(cutQueryString(URL))
0.191	0.203	+1.062x	0.062	0.074	url_hits	23	SELECT count() FROM hits_10m_single WHERE NOT ignore(URLPathHierarchy(URL))
1.206	1.237	+1.026x	0.026	0.038	window_functions_downstream_multithreading	0	SELECT id, AVG(value) OVER (ORDER BY id ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) AS frame1, MAX(value) OVER (ORDER BY id ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) AS frame2, sipHash64(frame1), sipHash64(frame2) FROM window_test
0.792	0.803	+1.014x	0.014	0.036	window_functions_downstream_multithreading	1	SELECT id AS key, sipHash64(sum(frame)) AS value FROM ( SELECT id, AVG(value) OVER (ORDER BY id ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) AS frame FROM window_test) GROUP BY key ORDER BY key, value
0.211	0.212	+1.001x	0.001	0.017	window_functions_downstream_multithreading	2	SELECT id % 100000 AS key, sipHash64(sum(frame)) AS value FROM ( SELECT id, AVG(value) OVER (ORDER BY id ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) AS frame FROM window_test) GROUP BY key ORDER BY key, value
5.819	5.73	-1.016x	-0.016	0.016	window_functions_downstream_multithreading	3	WITH 'xxxxyyyyxxxxyyyyxxxxyyyyxxxxyyyy' AS cipherKey SELECT id, AVG(value) OVER (ORDER BY id ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) AS frame, toString(frame) AS str, encrypt('aes-256-ofb', str, cipherKey) AS enc, decrypt('aes-256-ofb', str, cipherKey) AS dec FROM window_test
0.69	0.704	+1.021x	0.02	0.031	window_functions_downstream_multithreading	4	SELECT id, AVG(value) OVER (PARTITION by partition ORDER BY id ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) AS frame FROM window_test ORDER BY id
0.109	0.106	-1.034x	-0.034	0.125	window_functions_downstream_multithreading	5	SELECT DISTINCT AVG(value) OVER (PARTITION by partition ORDER BY id ROWS BETWEEN 1 PRECEDING AND 1 FOLLOWING) AS frame FROM window_test ORDER BY frame
0.119	0.121	+1.017x	0.017	0.025	writing_valid_utf8	0	INSERT INTO table_JSON SELECT SearchPhrase, ClientIP6, URL, Referer, URLDomain FROM test.hits LIMIT 100000
0.103	0.104	+1.002x	0.001	0.049	writing_valid_utf8	1	INSERT INTO table_JSONCompact SELECT SearchPhrase, ClientIP6, URL, Referer, URLDomain FROM test.hits LIMIT 100000
0.064	0.065	+1.008x	0.006	0.024	writing_valid_utf8	2	INSERT INTO table_XML SELECT SearchPhrase, ClientIP6, URL, Referer, URLDomain FROM test.hits LIMIT 100000

ClickHouse performance comparison

Tested Commits ?

All Query Times ?

Tested Commits ^?

All Query Times ^?