ClickHouse performance comparison

Tested Commits ?

OldNew
commit 5622a0769fa2f72461b7aaf5b7f30963b8ee337c (origin/master)
Merge: 9808d0be8 cfe9a0c4a
Author: alesapin 
Date:   Thu Oct 1 09:51:47 2020 +0300

    Merge pull request #15477 from ClickHouse/fix_ddl_worker_wait
    
    Fix wait event subscription in DDLWorker
commit 94ab1313e3d331551af504808baca8bd1ec0aee0
Author: alesapin 
Date:   Thu Oct 1 10:39:27 2020 +0300

    Add fno-builtin-memcpy

Real tested commit is:
commit 2062c339eb0487deb2c7b94b2a4ac7b934607420 (HEAD -> master, pr)
Merge: 5622a0769 94ab1313e
Author: alesapin 
Date:   Thu Oct 1 10:39:42 2020 +0300

    Merge 94ab1313e3d331551af504808baca8bd1ec0aee0 into 5622a0769fa2f72461b7aaf5b7f30963b8ee337c

Error Summary ?

Description
Some queries have unexpected duration
The query no. 6 of test 'joins_in_memory_pmj' has slowed down
The query no. 17 of test 'codecs_int_select' has slowed down
The query no. 3 of test 'set' has slowed down
The query no. 68 of test 'int_parsing' has slowed down
The query no. 5 of test 'set' has slowed down
The query no. 15 of test 'codecs_int_insert' has slowed down
The query no. 11 of test 'constant_column_comparison' has slowed down
The query no. 0 of test 'synthetic_hardware_benchmark' has slowed down
The query no. 14 of test 'constant_column_comparison' has slowed down
The query no. 1 of test 'trim_numbers' has slowed down
The query no. 4 of test 'constant_column_comparison' has slowed down
The query no. 2 of test 'merge_tree_huge_pk' has slowed down
The query no. 1 of test 'read_from_comp_parts' has slowed down
The query no. 3 of test 'string_set' has slowed down
The query no. 20 of test 'codecs_int_insert' has slowed down
The query no. 15 of test 'constant_column_comparison' has slowed down
The query no. 9 of test 'concat_hits' has slowed down
The query no. 2 of test 'functions_with_hash_tables' has slowed down
The query no. 10 of test 'date_time_64' has slowed down
The query no. 0 of test 'read_from_comp_parts' has slowed down
The query no. 12 of test 'order_with_limit' has slowed down
The query no. 5 of test 'order_with_limit' has slowed down
The query no. 2 of test 'duplicate_order_by_and_distinct' has slowed down
The query no. 11 of test 'order_with_limit' has slowed down
The test 'read_in_order_many_parts' is too slow to run as a whole. Investigate whether the create and fill queries can be sped up
The test 'read_from_comp_parts' is too slow to run as a whole. Investigate whether the create and fill queries can be sped up
The test 'questdb_sum_float64' is too slow to run as a whole. Investigate whether the create and fill queries can be sped up

Unexpected Query Duration ?

ProblemMarked as "short"?Run time, sTest#Query
normal queries must run longer than 0.1 s00.0169general_purpose_hashes_on_UUID50SELECT count() from numbers(1000000) where not ignore(murmurHash2_32(toDecimal128(number, 23)))
normal queries must run longer than 0.1 s00.0196general_purpose_hashes_on_UUID54SELECT count() from numbers(1000000) where not ignore(murmurHash3_32(toDecimal128(number, 23)))
normal queries must run longer than 0.1 s00.0155round_down2SELECT count() FROM zeros(10000000) WHERE NOT ignore(roundAge(rand() % 100))

Changes in Performance ?

Old, sNew, sRatio of speedup (-) or slowdown (+)Relative difference (new − old) / oldp < 0.01 thresholdTest#Query
0.5621.524+2.708x1.7081.693joins_in_memory_pmj6SELECT COUNT() FROM ints l INNER JOIN ints r ON l.i64 = r.i64 WHERE i32 = 20042
0.0650.155+2.373x1.3731.371codecs_int_select17SELECT count(n) FROM codec_rnd_UInt64_Delta WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.0620.015-4.012x-0.7510.750round_down2SELECT count() FROM zeros(10000000) WHERE NOT ignore(roundAge(rand() % 100))
0.1260.220+1.739x0.7390.737set3SELECT count() FROM zeros_mt(1000000000) WHERE rand64() IN (SELECT number FROM system.numbers LIMIT 16)
0.1790.052-3.440x-0.7090.708general_purpose_hashes_on_UUID59SELECT count() from numbers_mt(100000000) where not ignore(javaHash(toDecimal128(number, 23)))
0.0530.016-3.177x-0.6850.684general_purpose_hashes_on_UUID50SELECT count() from numbers(1000000) where not ignore(murmurHash2_32(toDecimal128(number, 23)))
0.4030.133-3.016x-0.6690.668decimal_casts3SELECT toUInt64(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t FORMAT Null
0.4060.135-3.004x-0.6680.667bit_operations_fixed_string_numbers1SELECT count() FROM numbers(100000000) WHERE NOT ignore(bitXor(reinterpretAsFixedString(number), reinterpretAsFixedString(0xabcd0123cdef4567)))
0.2080.345+1.656x0.6560.646int_parsing68SELECT count() FROM hits_10m_single WHERE NOT ignore(toString(URLHash)) SETTINGS max_threads = 1
0.1390.048-2.874x-0.6520.651decimal_aggregates19SELECT varPop(d64), varSamp(d64), stddevPop(d64) FROM (SELECT * FROM t LIMIT 1000000)
0.0560.019-2.867x-0.6520.650general_purpose_hashes_on_UUID54SELECT count() from numbers(1000000) where not ignore(murmurHash3_32(toDecimal128(number, 23)))
0.2070.340+1.644x0.6440.643set5SELECT count() FROM zeros_mt(1000000000) WHERE rand64() IN (SELECT number FROM system.numbers LIMIT 1024)
0.1820.065-2.782x-0.6410.640general_purpose_hashes_on_UUID65SELECT count() from numbers_mt(100000000) where not ignore(xxHash64(toDecimal128(number, 23)))
0.1830.071-2.549x-0.6080.607general_purpose_hashes_on_UUID63SELECT count() from numbers_mt(100000000) where not ignore(xxHash32(toDecimal128(number, 23)))
0.0710.031-2.276x-0.5600.559any_anyLast1SELECT anyLast(-1 * (((-2 * (number * -3)) * -4) * -5)) FROM numbers(120000000)
0.1500.069-2.176x-0.5410.540decimal_aggregates20SELECT varPop(d128), varSamp(d128), stddevPop(d128) FROM (SELECT * FROM t LIMIT 1000000)
0.3810.178-2.132x-0.5320.531decimal_casts11SELECT toInt32(d128), toInt64(d128), toInt128(d128) FROM t FORMAT Null
0.1920.099-1.940x-0.4850.484decimal_casts1SELECT toInt32(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t FORMAT Null
0.2010.297+1.477x0.4770.465codecs_int_insert15INSERT INTO codec_rnd_UInt64_LZ4 (n) SELECT intHash64(number) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.1150.060-1.904x-0.4750.474bit_operations_fixed_string0SELECT count() FROM test.hits WHERE NOT ignore(bitAnd(toFixedString(ClientIP6, 16), IPv6StringToNum(\'ffff:ffff:ffff:0000:0000:0000:0000:0000\')))
0.7690.406-1.895x-0.4730.472decimal_aggregates18SELECT varPop(d32), varSamp(d32), stddevPop(d32) FROM t
0.1140.061-1.861x-0.4630.462bit_operations_fixed_string1SELECT count() FROM test.hits WHERE NOT ignore(bitOr(toFixedString(ClientIP6, 16), IPv6StringToNum(\'ffff:ffff:ffff:0000:0000:0000:0000:0000\')))
0.1740.094-1.838x-0.4570.456decimal_casts0SELECT toUInt32(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t FORMAT Null
0.2010.109-1.830x-0.4540.453decimal_casts2SELECT toInt64(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t FORMAT Null
0.1080.059-1.821x-0.4510.450bit_operations_fixed_string2SELECT count() FROM test.hits WHERE NOT ignore(bitXor(toFixedString(ClientIP6, 16), IPv6StringToNum(\'ffff:ffff:ffff:0000:0000:0000:0000:0000\')))
0.4730.686+1.449x0.4490.445constant_column_comparison11SELECT count() FROM hits_100m_single WHERE MobilePhoneModel < \'model\' SETTINGS max_threads = 1
0.0420.060+1.431x0.4300.428synthetic_hardware_benchmark0SELECT count() FROM zeros( 100000000) WHERE NOT ignore(rand())
0.1070.067-1.604x-0.3770.376random_string_utf80SELECT count() FROM zeros(1000000) WHERE NOT ignore(randomStringUTF8(10))
0.1740.109-1.601x-0.3760.374general_purpose_hashes_on_UUID18SELECT count() from zeros_mt(1000000000) where not ignore(murmurHash2_64(materialize(toUUID(\'61f0c404-5cb3-11e7-907b-a6006ad3dba0\'))))
0.5690.782+1.374x0.3740.373constant_column_comparison14SELECT count() FROM hits_100m_single WHERE notEmpty(MobilePhoneModel) AND MobilePhoneModel < \'model\' SETTINGS max_threads = 1
0.2190.138-1.581x-0.3680.367decimal_casts4SELECT toInt128(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t FORMAT Null
0.1040.066-1.580x-0.3670.366random_string_utf81SELECT count() FROM zeros(100000) WHERE NOT ignore(randomStringUTF8(100))
0.1900.121-1.566x-0.3620.361logical_functions_small9SELECT count() FROM (SELECT toNullable(materialize(1)) AS x1, toNullable(materialize(1)) AS x2 FROM zeros(100000000)) WHERE NOT ignore(xor(x1,x2))
0.0530.034-1.567x-0.3620.361random_string_utf85SELECT count() FROM zeros(100000) WHERE NOT ignore(randomStringUTF8(rand() % 100))
0.1020.139+1.361x0.3610.358trim_numbers1SELECT count() FROM numbers(10000000) WHERE NOT ignore(ltrim(toString(number)))
0.0550.035-1.562x-0.3600.359random_string_utf86SELECT count() FROM zeros(10000) WHERE NOT ignore(randomStringUTF8(rand() % 1000))
0.1470.094-1.554x-0.3580.357synthetic_hardware_benchmark10SELECT count() FROM numbers( 100000000) WHERE NOT ignore(number / 7)
0.5310.721+1.356x0.3570.353constant_column_comparison4SELECT count() FROM hits_100m_single WHERE SearchPhrase < \'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz\' SETTINGS max_threads = 2
0.1090.070-1.550x-0.3550.354random_string_utf82SELECT count() FROM zeros(10000) WHERE NOT ignore(randomStringUTF8(1000))
0.1050.068-1.543x-0.3520.351random_string_utf83SELECT count() FROM zeros(1000) WHERE NOT ignore(randomStringUTF8(10000))
0.0590.039-1.486x-0.3270.326random_string_utf84SELECT count() FROM zeros(1000000) WHERE NOT ignore(randomStringUTF8(rand() % 10))
0.0110.015+1.319x0.3250.214merge_tree_huge_pk2SELECT count() FROM huge_pk WHERE c700 > 10
0.5690.751+1.319x0.3190.317read_from_comp_parts1SELECT count() FROM mt_comp_parts WHERE NOT ignore(c2, s1, arr1, s2)
0.2260.296+1.307x0.3070.301string_set3SELECT 1 FROM strings WHERE short IN (SELECT long FROM strings) FORMAT Null
0.1380.096-1.426x-0.3000.299decimal_casts12SELECT toFloat32(d32), toFloat32(d64), toFloat32(d128) FROM t FORMAT Null
0.1790.126-1.421x-0.2970.296float_mod0SELECT count() FROM numbers(100000000) WHERE NOT ignore(number % 1.1)
1.1790.829-1.422x-0.2970.296round_down4SELECT count() FROM numbers(10000000) WHERE NOT ignore(roundDown(rand() % 65536, (SELECT groupArray(number) FROM numbers(65536))))
0.0900.063-1.420x-0.2960.295synthetic_hardware_benchmark11SELECT count() FROM numbers_mt(1600000000) WHERE NOT ignore(number / 7)
0.0360.047+1.294x0.2940.252merge_tree_huge_pk1SELECT count() FROM huge_pk WHERE c001 in (2,3) and c400 in (10,0) and c100 < 2
0.4630.328-1.411x-0.2920.291math4SELECT count() FROM numbers(100000000) WHERE NOT ignore(exp10(toFloat64(number)))
0.1670.118-1.409x-0.2910.290decimal_casts7SELECT toFloat32(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t FORMAT Null
0.4390.564+1.284x0.2840.262codecs_int_insert20INSERT INTO codec_rnd_UInt64_Gorilla (n) SELECT intHash64(number) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.3610.460+1.271x0.2710.265constant_column_comparison15SELECT count() FROM hits_100m_single WHERE PageCharset < \'\' SETTINGS max_threads = 2
0.0960.122+1.266x0.2660.258concat_hits9SELECT count() FROM hits_100m_single WHERE NOT ignore(format(\'{}{}\', MobilePhoneModel, SearchPhrase))
0.4010.295-1.357x-0.2640.263date_time_short12SELECT count() FROM numbers(100000000) WHERE NOT ignore(toDateTime(\'2017-01-01 00:00:00\') + number % 100000000 + rand() % 100000 AS t, plus(t, 1))
0.6220.782+1.256x0.2560.252sum_map3SELECT sumMapWithOverflow(key, val) FROM sum_map_1000000 FORMAT Null
0.1220.091-1.341x-0.2560.255conditional4SELECT count() FROM zeros(10000000) WHERE NOT ignore(if(rand() % 2, toDateTime(rand()), toDate(rand())))
0.1720.128-1.338x-0.2520.252decimal_casts8SELECT toFloat64(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t FORMAT Null
0.3840.480+1.250x0.2490.247functions_with_hash_tables2select arrayEnumerateUniq(range(1 + (number % 100) * 10)) from numbers(100000) format Null
0.1420.107-1.325x-0.2470.246decimal_casts13SELECT toFloat64(d32), toFloat64(d64), toFloat64(d128) FROM t FORMAT Null
0.0360.045+1.245x0.2450.242date_time_6410SELECT count() from dt where not ignore(toRelativeMinuteNum(x))
0.0200.025+1.246x0.2430.194read_from_comp_parts0SELECT count() FROM mt_comp_parts WHERE NOT ignore(c1)
0.3950.300-1.316x-0.2400.239date_time_short10SELECT count() FROM numbers(100000000) WHERE NOT ignore(toDateTime(\'2017-01-01 00:00:00\') + number % 100000000 + rand() % 100000 AS t, lessOrEquals(t, 1))
0.3820.298-1.282x-0.2210.220date_time_short4SELECT count() FROM numbers(100000000) WHERE NOT ignore(toDateTime(\'2017-01-01 00:00:00\') + number % 100000000 + rand() % 100000 AS t, toUnixTimestamp(t, \'Europe/Moscow\'))
0.1650.128-1.283x-0.2210.220bitCount2SELECT bitCount(toUInt16(number)) FROM numbers(100000000) FORMAT Null
0.0850.103+1.221x0.2200.217order_with_limit12SELECT intHash64(number) AS n FROM numbers_mt(200000000) ORDER BY n LIMIT 10000 FORMAT Null
0.3870.303-1.278x-0.2180.217date_time_short11SELECT count() FROM numbers(100000000) WHERE NOT ignore(toDateTime(\'2017-01-01 00:00:00\') + number % 100000000 + rand() % 100000 AS t, greater(t, 1))
0.1160.091-1.270x-0.2130.212sum5SELECT sum(toFloat64(number)) FROM numbers(100000000)
0.2230.175-1.268x-0.2120.211generate_table_function4SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'i Nullable(Enum16(\\\'h\\\' = 1, \\\'w\\\' = 5 , \\\'o\\\' = -200))\', 0, 10, 10) LIMIT 1000000000);
0.1750.141-1.243x-0.1960.195codecs_int_select4SELECT count(n) FROM codec_seq_UInt64_T64 WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.2020.163-1.238x-0.1930.192array_join1SELECT count() FROM (SELECT [number] a, [number * 2] b FROM numbers(10000000)) AS t LEFT ARRAY JOIN a, b WHERE NOT ignore(a + b)
0.6860.561-1.223x-0.1830.182date_time_short15SELECT count() FROM numbers(100000000) WHERE NOT ignore(toDateTime(\'2017-01-01 00:00:00\') + number % 100000000 + rand() % 100000 AS t, date_trunc(\'month\', t))
0.6860.561-1.222x-0.1820.181date_time_short1SELECT count() FROM numbers(100000000) WHERE NOT ignore(toDateTime(\'2017-01-01 00:00:00\') + number % 100000000 + rand() % 100000 AS t, toMonday(t, \'Europe/Moscow\'))
0.1850.153-1.208x-0.1730.172codecs_int_select11SELECT count(n) FROM codec_mon_UInt64_T64 WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.0440.036-1.204x-0.1700.169cidr0SELECT count() FROM test.hits WHERE NOT ignore(IPv4CIDRToRange(ClientIP, rand() % 33))
0.3650.427+1.170x0.1700.166order_with_limit5SELECT number AS n FROM numbers_mt(200000000) ORDER BY n DESC LIMIT 10000 FORMAT Null
0.2110.175-1.203x-0.1690.168complex_array_creation1SELECT count() FROM zeros(10000000) WHERE NOT ignore([[], [zero]])
0.3970.331-1.198x-0.1660.165decimal_casts14SELECT toInt256(d32), toInt256(d64), toInt256(d128) FROM t FORMAT Null
0.2260.189-1.194x-0.1640.163order_with_limit1SELECT number AS n FROM numbers_mt(200000000) ORDER BY n DESC LIMIT 100 FORMAT Null
0.1140.132+1.161x0.1610.146duplicate_order_by_and_distinct2SELECT DISTINCT * FROM (SELECT DISTINCT CounterID, EventDate FROM hits_10m_single ORDER BY CounterID DESC) ORDER BY toStartOfWeek(EventDate) FORMAT Null
0.6780.569-1.190x-0.1610.160date_time_short14SELECT count() FROM numbers(100000000) WHERE NOT ignore(toDateTime(\'2017-01-01 00:00:00\') + number % 100000000 + rand() % 100000 AS t, toStartOfInterval(t, INTERVAL 1 month))
1.0360.870-1.191x-0.1610.160random_printable_ascii1SELECT count() FROM zeros(10000000) WHERE NOT ignore(randomPrintableASCII(100))
0.4040.340-1.187x-0.1580.157modulo1SELECT number % 255 FROM numbers(300000000) FORMAT Null
0.0100.011+1.155x0.1570.087single_fixed_string_groupby0SELECT count() FROM perf_lc_fixed_str_groupby GROUP BY a
0.1730.147-1.179x-0.1520.151injective_functions_inside_uniq1SELECT uniq(hex(hex(number))) FROM numbers(50000000)
0.7070.601-1.176x-0.1500.149array_element0SELECT count() FROM numbers(100000000) WHERE NOT ignore([[1], [2]][number % 2 + 2])
0.0830.070-1.173x-0.1480.147synthetic_hardware_benchmark15SELECT count() FROM numbers_mt(1600000000) WHERE NOT ignore(number % 34908756)
0.2440.208-1.169x-0.1460.145conditional6SELECT count() FROM zeros(10000000) WHERE NOT ignore(if(rand() % 2, [toDateTime(rand())], [toDate(rand())]))
0.1360.117-1.157x-0.1370.136sum13SELECT sum(toNullable(toFloat64(number))) FROM numbers(100000000)
0.0590.067+1.131x0.1310.129order_with_limit11SELECT intHash64(number) AS n FROM numbers_mt(200000000) ORDER BY n LIMIT 5000 FORMAT Null
0.3630.316-1.149x-0.1310.130distinct_combinator2SELECT sumIf(DISTINCT number % 10, number % 5 = 2) FROM numbers(100000000)
0.1590.138-1.149x-0.1310.130round_methods5SELECT count() FROM numbers(100000000) WHERE NOT ignore(round(toFloat64(number), -2))
0.3330.291-1.145x-0.1280.127insert_values_with_expressions0select * from file(\'test_all_expr_matches.values\', Values, \'d DateTime, i UInt32, s String, ni Nullable(UInt64), ns Nullable(String), ars Array(String)\') format Null
0.1700.148-1.145x-0.1270.126injective_functions_inside_uniq0SELECT uniq(negate(negate(negate(number)))) FROM numbers(50000000)
0.1000.088-1.145x-0.1270.126array_join0SELECT count() FROM (SELECT [number] a, [number * 2] b FROM numbers(10000000)) AS t ARRAY JOIN a, b WHERE NOT ignore(a + b)
0.6280.548-1.144x-0.1270.126float_formatting7SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(toFloat64(number % 100 + 0.123)))
0.6290.551-1.142x-0.1250.112concat_hits16SELECT count() FROM hits_100m_single WHERE NOT ignore(concat(URL, \'Hello\', URL))
0.0810.071-1.140x-0.1240.123sum3SELECT sum(toUInt8(number)) FROM numbers(100000000)
0.2650.233-1.137x-0.1210.120bit_operations_fixed_string_numbers0SELECT count() FROM numbers(100000000) WHERE NOT ignore(bitXor(reinterpretAsFixedString(number), reinterpretAsFixedString(number + 1)))
0.0750.066-1.133x-0.1180.117sum8SELECT sum(toNullable(number)) FROM numbers(100000000)
0.1510.133-1.130x-0.1160.115generate_table_function3SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'i Array(Nullable(Enum8(\\\'hello\\\' = 1, \\\'world\\\' = 5)))\', 0, 10, 10) LIMIT 100000000);
0.2820.250-1.128x-0.1140.113format_date_time5SELECT count() FROM numbers(10000000) WHERE NOT ignore(toDateTime(\'2017-01-01 00:00:00\') + number % 100000000 + rand() % 100000 AS t, formatDateTime(t, \'The current time is: %I:%M %p\'))
0.3630.322-1.126x-0.1130.112date_time_6413SELECT count() from dt64 where not ignore(addDays(x, 1))
0.7150.635-1.124x-0.1110.110float_formatting26SELECT count() FROM zeros(10000000) WHERE NOT ignore(toString(toFloat64(rand64())))
0.0310.027-1.121x-0.1090.108linear_regression0SELECT stochasticLinearRegressionState(0.0001, 0, 15)(Age, Income, ParamPrice, Robotness, RefererHash) FROM test.hits FORMAT Null
1.1020.984-1.120x-0.1080.107parallel_final15SELECT sum(s) FROM collapsing_final_1024p_rnd final group by key1 limit 10
0.0470.042-1.119x-0.1060.061consistent_hashes6SELECT sumburConsistentHash(toUInt32(number), 2) FROM numbers(10000000) FORMAT Null
0.5230.468-1.117x-0.1050.104float_formatting11SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(number / 7))
0.0440.040-1.117x-0.1050.104order_with_limit7SELECT intHash64(number) AS n FROM numbers_mt(500000000) ORDER BY n LIMIT 10 FORMAT Null
0.0360.033-1.115x-0.1030.102vectorize_aggregation_combinators0SELECT countMerge(v) FROM (SELECT countState() v FROM zeros(1000000000)) FORMAT Null
0.1620.145-1.113x-0.1020.101round_methods9SELECT count() FROM numbers(100000000) WHERE NOT ignore(trunc(toFloat64(number), -2))
0.1880.169-1.107x-0.0980.097complex_array_creation0SELECT count() FROM zeros(10000000) WHERE NOT ignore([[zero], [zero]])
0.0650.059-1.106x-0.0970.096bit_operations_fixed_string3SELECT count() FROM test.hits WHERE NOT ignore(bitNot(toFixedString(ClientIP6, 16)))
0.1620.147-1.103x-0.0940.093round_methods7SELECT count() FROM numbers(100000000) WHERE NOT ignore(floor(toFloat64(number), -2))
0.3930.356-1.103x-0.0940.093array_reduce2SELECT arrayReduceInRanges(\'count\', [(1, 100000000)], range(100000000))
0.5770.524-1.101x-0.0920.091array_reduce4SELECT arrayReduceInRanges(\'count\', arrayZip(range(1000000), range(1000000)), range(100000000))[123456]
0.1610.146-1.100x-0.0920.091round_methods6SELECT count() FROM numbers(100000000) WHERE NOT ignore(roundBankers(toFloat64(number), -2))
0.2130.194-1.098x-0.0900.089sum15SELECT sumKahan(toNullable(toFloat64(number))) FROM numbers(100000000)
0.1600.145-1.098x-0.0900.089round_methods8SELECT count() FROM numbers(100000000) WHERE NOT ignore(ceil(toFloat64(number), -2))
0.0220.020-1.095x-0.0860.085order_with_limit8SELECT intHash64(number) AS n FROM numbers_mt(200000000) ORDER BY n LIMIT 100 FORMAT Null
0.0380.035-1.091x-0.0850.037consistent_hashes0SELECT yandexConsistentHash(number, 2) FROM numbers(10000000) FORMAT Null
0.1910.176-1.086x-0.0800.079monotonous_order_by1SELECT * 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.6010.554-1.084x-0.0780.077float_formatting24SELECT count() FROM zeros(10000000) WHERE NOT ignore(toString(0xFFFFFFFF / rand()))
0.1660.154-1.083x-0.0770.076sort0SELECT sum(key) FROM (SELECT * FROM rand_unlimited_10m_8 ORDER BY key)
0.0630.058-1.078x-0.0750.074arithmetic_operations_in_aggr_func5SELECT max(((((number) * 10) * -2) * 3) * 2) + min(((((number) * 10) * -2) * 3) * 2) FROM numbers(50000000)
0.9390.870-1.079x-0.0740.073array_fill0SELECT arraySlice(arrayFill(x -> ((x % 2) >= 0), range(100000000)), 1, 10) FORMAT Null
0.5750.535-1.075x-0.0710.070float_formatting8SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(toFloat64(number % 1000 + 0.123456)))
0.5920.552-1.071x-0.0670.066array_reduce5SELECT arrayReduceInRanges(\'sum\', arrayZip(range(1000000), range(1000000)), range(100000000))[123456]
0.1050.098-1.071x-0.0670.066arithmetic_operations_in_aggr_func3SELECT min(-1 + (((-2 + (number + -3)) + -4) + -5)) FROM numbers(50000000)
0.2190.204-1.070x-0.0660.065linear_regression2SELECT stochasticLinearRegressionState(0.0001, 0, 15, \'Momentum\')(Age, Income, ParamPrice, Robotness, RefererHash) FROM hits_100m_single FORMAT Null
0.0380.036-1.068x-0.0660.065consistent_hashes1SELECT yandexConsistentHash(number, 500) FROM numbers(10000000) FORMAT Null
0.0800.075-1.069x-0.0650.064order_with_limit16SELECT intHash64(number) AS n FROM numbers_mt(200000000) ORDER BY n, n + 1, n + 2 LIMIT 1500 FORMAT Null
0.1030.096-1.068x-0.0640.063generate_table_function11SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'i Array(Nullable(Int32))\', 0, 10, 10) LIMIT 100000000);
0.1850.173-1.067x-0.0630.062round_methods4SELECT count() FROM numbers(100000000) WHERE NOT ignore(trunc(toInt64(number), -2))
0.0970.091-1.065x-0.0620.060order_with_limit17SELECT intHash64(number) AS n FROM numbers_mt(200000000) ORDER BY n, n + 1, n + 2 LIMIT 3000 FORMAT Null
1.0470.984-1.064x-0.0610.060array_fill2SELECT arraySlice(arrayFill(x -> ((x % 2) >= 2), range(100000000)), 1, 10) FORMAT Null
0.2130.200-1.063x-0.0600.059round_methods2SELECT count() FROM numbers(100000000) WHERE NOT ignore(floor(toInt64(number), -2))
0.6580.620-1.060x-0.0580.057functions_with_hash_tables5select entropy(number / 10) from numbers(1000 * 1000) group by number / 1000 format Null
0.4130.389-1.061x-0.0580.057float_formatting10SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(number / 3))
0.1570.149-1.057x-0.0540.053array_auc0SELECT avg(ifNotFinite(arrayAUC(arrayMap(x -> rand(x) / 0x100000000, range(2 + rand() % 100)), arrayMap(x -> rand(x) % 2, range(2 + rand() % 100))), 0)) FROM numbers(100000)
0.3370.320-1.052x-0.0500.049distinct_combinator3SELECT countIf(DISTINCT number % 10, number % 5 = 2) FROM numbers(100000000)

Unstable Queries ?

Old, sNew, sRelative difference (new - old)/oldp < 0.01 thresholdTest#Query
0.3923.8858.9108.910logical_functions_large4SELECT count() FROM\n (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))\n WHERE NOT ignore(xor(x1,x2,x3,x4,x5,x6,x7,x8,x9,x10))
0.5590.8160.4581.780joins_in_memory_pmj8SELECT COUNT() FROM ints l LEFT JOIN ints r USING i64 WHERE i32 = 20042
0.0620.1621.5941.594codecs_int_select3SELECT count(n) FROM codec_seq_UInt64_Delta WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.5640.8230.4581.522joins_in_memory_pmj4SELECT COUNT() FROM ints l INNER JOIN ints r USING i64 WHERE i32 = 20042
0.1620.3931.4251.425logical_functions_small10SELECT count() FROM (SELECT materialize(toUInt16(1)) AS x1, materialize(toUInt32(1)) AS x2 FROM zeros(200000000)) WHERE NOT ignore(and(x1,x2))
0.0680.1601.3541.354codecs_int_select10SELECT count(n) FROM codec_mon_UInt64_Delta WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.1720.4051.3431.343general_purpose_hashes_on_UUID3SELECT count() from zeros_mt(1000000000) where not ignore(cityHash64(generateUUIDv4()))
0.1730.3961.2781.278logical_functions_small13SELECT count() FROM (SELECT materialize(toUInt16(1)) AS x1, materialize(toUInt32(1)) AS x2 FROM zeros(200000000)) WHERE NOT ignore(or(x1,x2))
0.2200.4951.2431.243general_purpose_hashes_on_UUID38SELECT count() from zeros_mt(1000000000) where not ignore(xxHash32(materialize(toUUID(\'61f0c404-5cb3-11e7-907b-a6006ad3dba0\'))))
0.2860.6141.1411.141general_purpose_hashes_on_UUID39SELECT count() from zeros_mt(1000000000) where not ignore(xxHash32(generateUUIDv4()))
0.1810.3771.0861.086general_purpose_hashes_on_UUID31SELECT count() from zeros_mt(1000000000) where not ignore(javaHash(generateUUIDv4()))
0.0720.1511.0791.079random_string6SELECT count() FROM zeros(1000000) WHERE NOT ignore(randomString(rand() % 1000))
0.1180.2431.0551.055round_methods14SELECT count() FROM numbers(10000000) WHERE NOT ignore(trunc(toDecimal128(number, 0), -2))
0.1230.2521.0441.044round_methods12SELECT count() FROM numbers(10000000) WHERE NOT ignore(floor(toDecimal128(number, 0), -2))
0.4310.8791.0391.039constant_column_search13select sum(match(URL, \'yandex\')), sum(match(URL, \'google\')), sum(match(URL, \'facebook\')), sum(match(URL, \'wikipedia\')), sum(match(URL, \'reddit\')) FROM hits_100m_single
0.5251.0611.0201.020functions_coding0SELECT count() FROM numbers(100000000) WHERE NOT ignore(MACNumToString(number))
0.1690.3421.0181.018codecs_int_insert3INSERT INTO codec_seq_UInt64_Delta (n) SELECT number FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.2780.5611.0161.016if_transform_strings_to_enum3SELECT transform(number, [2, 4, 6], [\'google\', \'yandex\', \'yahoo\'], \'other\') as x FROM numbers(100000000) GROUP BY x FORMAT Null SETTINGS optimize_if_transform_strings_to_enum = 1
0.7081.4191.0031.003general_purpose_hashes_on_UUID41SELECT count() from zeros(100000000) where not ignore(xxHash64(generateUUIDv4()))
0.2330.4681.0031.003functions_coding2SELECT count() FROM zeros_mt(1000000000) WHERE NOT ignore(MACNumToString(rand64()))
0.1350.2701.0021.002round_methods11SELECT count() FROM numbers(10000000) WHERE NOT ignore(roundBankers(toDecimal128(number, 0), -2))
1.2422.4670.9850.985general_purpose_hashes36SELECT count() from numbers(100000000) where not ignore(xxHash32(toString(1000000000+number)))
0.1440.2860.9820.982bitCount5SELECT bitCount(toFloat64(number)) FROM numbers(100000000) FORMAT Null
0.1440.2830.9630.963functions_geo2SELECT count() FROM zeros(1000000) WHERE NOT ignore(geohashEncode(1.0/rand(), 2.0/rand()))
0.4840.9460.9550.955general_purpose_hashes49SELECT count() from numbers_mt(1000000000) where not ignore(xxHash32(toString(1000000000+number)))
0.1260.2470.9540.954round_methods13SELECT count() FROM numbers(10000000) WHERE NOT ignore(ceil(toDecimal128(number, 0), -2))
0.1450.2830.9520.952functions_geo4SELECT count() FROM numbers(1000000) WHERE NOT ignore(geohashEncode(number + 91.0, number + 181.0))
0.4290.8280.9290.929general_purpose_hashes_on_UUID4SELECT count() from zeros(100000000) where not ignore(farmHash64(materialize(toUUID(\'61f0c404-5cb3-11e7-907b-a6006ad3dba0\'))))
0.1720.3320.9240.924logical_functions_large9SELECT count() FROM\n (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))\n WHERE NOT ignore(xor(x1,x2,x3,x4,x5,x6,x7,x8,x9,x10))
0.2830.5360.8900.890general_purpose_hashes_on_UUID43SELECT count() from zeros_mt(1000000000) where not ignore(xxHash64(generateUUIDv4()))
0.0310.0590.8900.890any_anyLast0SELECT any(-1 * (((-2 * (number * -3)) * -4) * -5)) FROM numbers(120000000)
0.0330.0630.8710.871any_anyLast3SELECT any(number * round(toInt64(number), -2)) FROM numbers(120000000)
0.1280.2390.8660.866round_methods10SELECT count() FROM numbers(10000000) WHERE NOT ignore(round(toDecimal128(number, 0), -2))
0.2000.3730.8650.865codecs_int_insert17INSERT INTO codec_rnd_UInt64_Delta (n) SELECT intHash64(number) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.7581.4120.8630.863general_purpose_hashes_on_UUID9SELECT count() from zeros(100000000) where not ignore(metroHash64(generateUUIDv4()))
0.2700.4990.8440.844set0SELECT count() FROM zeros(100000000) WHERE rand64() IN (SELECT number FROM system.numbers LIMIT 1)
0.2030.3710.8250.825codecs_float_select7SELECT count(n) FROM codec_mon_Float64_ZSTD WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.1970.3580.8170.817codecs_float_select6SELECT count(n) FROM codec_seq_Float64_ZSTD WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.0790.1440.8150.815random_fixed_string1SELECT count() FROM zeros(10000000) WHERE NOT ignore(randomFixedString(100))
0.2310.4170.8060.806codecs_int_insert10INSERT INTO codec_mon_UInt64_Delta (n) SELECT number*512+(intHash64(number)%512) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.1360.2450.8020.802logical_functions_small14SELECT count() FROM (SELECT materialize(toUInt32(1)) AS x1, materialize(toUInt64(1)) AS x2 FROM zeros(100000000)) WHERE NOT ignore(or(x1,x2))
0.5701.0270.7990.799general_purpose_hashes_on_UUID5SELECT count() from zeros(100000000) where not ignore(farmHash64(generateUUIDv4()))
0.0330.0590.7960.796any_anyLast2SELECT any(number * 2) as n, n * 3 FROM numbers(120000000)
0.1090.1940.7700.770set1SELECT count() FROM zeros_mt(1000000000) WHERE rand64() IN (SELECT number FROM system.numbers LIMIT 1)
1.4302.5230.7640.764general_purpose_hashes31SELECT count() from numbers(100000000) where not ignore(murmurHash3_32(toString(1000000000+number)))
0.0350.0630.7610.761IPv42SELECT count() FROM ips_v4 WHERE NOT ignore(IPv4NumToStringClassC(IPv4StringToNum(materialize(ip)))) SETTINGS max_threads=1
0.1880.3300.7570.757set8SELECT count() FROM zeros(10000000) WHERE rand64() IN (SELECT number FROM system.numbers LIMIT 1048576)
0.0940.1650.7560.756codecs_int_insert5INSERT INTO codec_seq_UInt64_DoubleDelta (n) SELECT number FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.0540.0940.7400.740random_fixed_string3SELECT count() FROM zeros(10000) WHERE NOT ignore(randomFixedString(10000))
0.1330.2310.7360.736logical_functions_small11SELECT count() FROM (SELECT materialize(toUInt32(1)) AS x1, materialize(toUInt64(1)) AS x2 FROM zeros(100000000)) WHERE NOT ignore(and(x1,x2))
0.0890.1550.7280.728columns_hashing3select sum(MobilePhoneModel in (select MobilePhoneModel from hits_100m_single where MobilePhoneModel != \'\')) from hits_100m_single
0.1330.2300.7270.727base642SELECT count() FROM numbers(10000000) WHERE NOT ignore(base64Encode(toString(number)))
0.1750.3020.7260.726synthetic_hardware_benchmark16SELECT number % 10 AS k FROM numbers(100000000) GROUP BY k FORMAT Null
0.0680.1170.7250.725and_function1select count() from numbers(10000000) where number != 96594 AND number != 18511 AND number != 98085 AND number != 84177 AND number != 70314 AND number != 28083 AND number != 54202 AND number != 66522 AND number != 66939 AND number != 99469
0.0370.0620.7000.700IPv41SELECT count() FROM ips_v4 WHERE NOT ignore(IPv4NumToString(IPv4StringToNum(materialize(ip)))) SETTINGS max_threads=1
0.0520.0880.6960.696random_string3SELECT count() FROM zeros(10000) WHERE NOT ignore(randomString(10000))
0.4540.7700.6950.695cpu_synthetic9SELECT count() FROM hits_10m_single WHERE NOT ignore(cityHash64(URL)) SETTINGS max_threads = 1
0.3410.5760.6880.688leftpad1SELECT max(length(Params)) FROM hits_100m_single
0.3480.5840.6780.678leftpad6SELECT max(length(UTMSource)) FROM hits_100m_single
0.1660.2790.6770.677rand2SELECT count() FROM (SELECT generateUUIDv4() FROM zeros(100000000))
0.0360.0600.6700.670if_to_multiif1 WITH number AS x SELECT any(x < 1 ? \'1\' : (x < 5 ? \'2\' : \'3\')) FROM numbers(100000000)
0.3800.6320.6620.662leftpad0SELECT max(length(MobilePhoneModel)) FROM hits_100m_single
0.2700.4500.6610.661general_purpose_hashes_on_UUID15SELECT count() from zeros_mt(1000000000) where not ignore(murmurHash2_32(generateUUIDv4()))
0.5090.8410.6510.651int_parsing3SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(CounterID)) SETTINGS max_threads = 1
0.0600.0990.6480.648synthetic_hardware_benchmark6SELECT count() FROM numbers( 10000000) WHERE NOT ignore(toString(number))
0.1110.1820.6460.646float_formatting13SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(toFloat32(number)))
0.1410.2330.6440.644float_formatting25SELECT count() FROM zeros(10000000) WHERE NOT ignore(toString(toFloat64(rand())))
0.7001.1500.6430.643general_purpose_hashes_on_UUID13SELECT count() from zeros(100000000) where not ignore(murmurHash2_32(generateUUIDv4()))
0.0570.0950.6400.640codecs_int_select0SELECT count(n) FROM codec_seq_UInt64_NONE WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.0260.0440.6400.640IPv43SELECT count() FROM ips_v4 WHERE NOT ignore(IPv4ToIPv6(IPv4StringToNum(materialize(ip)))) SETTINGS max_threads=1
0.1490.2450.6380.638logical_functions_large2SELECT count() FROM\n (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))\n WHERE NOT ignore(or(x1,x2,x3,x4,x5,x6,x7,x8,x9,x10))
0.2660.4350.6340.634set7SELECT count() FROM zeros_mt(1000000000) WHERE rand64() IN (SELECT number FROM system.numbers LIMIT 16384)
0.7661.2520.6340.634and_function0select count() from numbers(10000000) where number != 96594 AND number != 18511 AND number != 98085 AND number != 84177 AND number != 70314 AND number != 28083 AND number != 54202 AND number != 66522 AND number != 66939 AND number != 99469 AND number != 65776 AND number != 22876 AND number != 42151 AND number != 19924 AND number != 66681 AND number != 63022 AND number != 17487 AND number != 83914 AND number != 59754 AND number != 968 AND number != 73334 AND number != 68569 AND number != 49853 AND number != 33155 AND number != 31777 AND number != 99698 AND number != 26708 AND number != 76409 AND number != 42191 AND number != 55397 AND number != 25724 AND number != 39170 AND number != 22728 AND number != 98238 AND number != 86052 AND number != 12756 AND number != 13948 AND number != 57774 AND number != 82511 AND number != 11337 AND number != 23506 AND number != 11875 AND number != 58536 AND number != 56919 AND number != 25986 AND number != 80710 AND number != 61797 AND number != 99244 AN...(0)
0.0880.1440.6290.629float_formatting18SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(toFloat32(number % 10000)))
0.2080.3380.6280.628int_parsing67SELECT count() FROM hits_10m_single WHERE NOT ignore(toString(RefererHash)) SETTINGS max_threads = 1
0.0640.1050.6260.626rand1SELECT count() FROM (SELECT rand64() FROM zeros(100000000))
0.9171.4920.6260.626general_purpose_hashes_on_UUID21SELECT count() from zeros(100000000) where not ignore(murmurHash3_32(generateUUIDv4()))
0.2520.4090.6230.623ngram_distance0SELECT ngramDistance(Title, URL) AS distance FROM hits_10m_single FORMAT Null
0.3260.5300.6220.622set2SELECT count() FROM zeros(100000000) WHERE rand64() IN (SELECT number FROM system.numbers LIMIT 16)
0.1640.2650.6170.617codecs_int_insert0INSERT INTO codec_seq_UInt64_NONE (n) SELECT number FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.3370.5430.6120.612constant_column_search9select sum(match(URL, \'yandex\')), sum(match(URL, \'google\')), sum(match(URL, \'http\')) FROM hits_100m_single
0.2250.3620.6080.608base648SELECT count() FROM numbers(10000000) WHERE tryBase64Decode(base64Encode(toString(number))) != toString(number)
0.1820.2930.6020.602ngram_distance3SELECT ngramDistance(Title, \'baby dont hurt me\') AS distance FROM hits_10m_single FORMAT Null
0.3500.5610.6020.602constant_column_search17select sum(multiSearchFirstIndex(URL, [\'yandex\', \'google\', \'http\', \'facebook\', \'google\'])) from hits_100m_single
0.2320.3710.6010.601base645SELECT count() FROM numbers(10000000) WHERE base64Decode(base64Encode(toString(number))) != toString(number)
0.2560.4110.6000.600float_parsing5SELECT count() FROM zeros(10000000) WHERE NOT ignore(toFloat64(toString(rand())))
0.2020.3240.5990.599general_purpose_hashes_on_UUID14SELECT count() from zeros_mt(1000000000) where not ignore(murmurHash2_32(materialize(toUUID(\'61f0c404-5cb3-11e7-907b-a6006ad3dba0\'))))
0.5350.8560.5980.598set4SELECT count() FROM zeros(100000000) WHERE rand64() IN (SELECT number FROM system.numbers LIMIT 1024)
0.0390.0630.5940.594if_to_multiif3 WITH number AS x SELECT any(x < 1 ? \'1\' : (x < 5 ? \'2\' : (x < 10 ? \'3\' : (x % 2 ? \'4\' : \'5\')))) FROM numbers(100000000)
0.1080.1730.5930.593empty_string_deserialization0SELECT count() FROM empty_strings WHERE NOT ignore(s)
0.0880.1400.5900.590random_fixed_string0SELECT count() FROM zeros(100000000) WHERE NOT ignore(randomFixedString(10))
0.1850.2950.5900.590ngram_distance2SELECT ngramDistance(Title, \'what is love\') AS distance FROM hits_10m_single FORMAT Null
0.4130.6570.5900.590functions_coding3SELECT count() FROM zeros_mt(1000000000) WHERE NOT ignore(MACStringToNum(MACNumToString(rand64())))
0.1840.2920.5840.584ngram_distance4SELECT ngramDistance(Title, \'no more\') AS distance FROM hits_10m_single FORMAT Null
0.1190.1890.5840.584codecs_int_select6SELECT count(n) FROM codec_seq_UInt64_Gorilla WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.4290.6790.5830.583cpu_synthetic15SELECT count() FROM hits_10m_single WHERE URL LIKE \'%metrika%\' SETTINGS max_threads = 1
0.2020.3190.5770.577ngram_distance1SELECT ngramDistance(Title, SearchPhrase) AS distance FROM hits_10m_single FORMAT Null
0.0860.1360.5710.571float_formatting17SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(toFloat32(number % 1000)))
0.2300.3600.5680.568codecs_float_select14SELECT count(n) FROM codec_rnd_Float64_Gorilla WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
1.0171.5960.5670.567functions_coding1SELECT count() FROM numbers(100000000) WHERE NOT ignore(MACStringToNum(MACNumToString(number)))
0.8181.2820.5650.565int_parsing23SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(IPNetworkID)) SETTINGS max_threads = 1
0.1830.2860.5600.560codecs_int_insert14INSERT INTO codec_rnd_UInt64_NONE (n) SELECT intHash64(number) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.5830.9100.5590.559general_purpose_hashes_on_UUID12SELECT count() from zeros(100000000) where not ignore(murmurHash2_32(materialize(toUUID(\'61f0c404-5cb3-11e7-907b-a6006ad3dba0\'))))
0.1720.2680.5570.557string_set4SELECT 1 FROM strings WHERE long IN (SELECT short FROM strings) FORMAT Null
0.0490.0770.5550.555random_fixed_string2SELECT count() FROM zeros(100000) WHERE NOT ignore(randomFixedString(1000))
0.0610.0940.5350.535codecs_int_select15SELECT count(n) FROM codec_rnd_UInt64_LZ4 WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
1.2131.8570.5300.530columns_hashing2select sum(URL in (select URL from hits_10m_single where URL != \'\')) from hits_10m_single
0.0800.1230.5290.529float_formatting16SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(toFloat32(number % 100)))
1.3552.0710.5280.528general_purpose_hashes35SELECT count() from numbers(100000000) where not ignore(hiveHash(toString(1000000000+number)))
0.0380.0590.5260.526rand0SELECT count() FROM (SELECT rand() FROM zeros(100000000))
0.1990.3020.5190.519codecs_float_select13SELECT count(n) FROM codec_mon_Float64_Gorilla WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.5490.8330.5170.517int_parsing11SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(ResolutionWidth)) SETTINGS max_threads = 1
0.1930.2920.5120.512float_parsing0SELECT count() FROM numbers(10000000) WHERE NOT ignore(toFloat64(toString(number)))
0.4140.6270.5120.512cpu_synthetic19SELECT count() FROM hits_10m_single WHERE match(URL, \'^https?://(?:www\\\\.)?metri[kc]a\\\\.yandex\\\\.(?:ru|com|com\\\\.tr|ua|by|kz)/.+?2014\') SETTINGS max_threads = 1
0.4350.6560.5050.505constant_column_comparison9SELECT count() FROM hits_100m_single WHERE MobilePhoneModel < \'\' SETTINGS max_threads = 1
0.0610.0930.5050.505float_formatting14SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(toFloat32(number % 2)))
0.0650.0980.4990.499codecs_float_select5SELECT count(n) FROM codec_rnd_Float64_LZ4 WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.1450.2180.4980.498random_string1SELECT count() FROM zeros(10000000) WHERE NOT ignore(randomString(100))
0.0750.1130.4970.497bitCount0SELECT bitCount(number) FROM numbers(100000000) FORMAT Null
0.0500.0750.4960.496random_string2SELECT count() FROM zeros(100000) WHERE NOT ignore(randomString(1000))
0.2210.3320.4960.496cpu_synthetic16SELECT count() FROM hits_100m_single WHERE URL LIKE \'%metrika%\'
0.2550.3810.4950.495codecs_int_insert18INSERT INTO codec_rnd_UInt64_T64 (n) SELECT intHash64(number) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.0780.1160.4920.492float_formatting15SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(toFloat32(number % 10)))
0.0640.0960.4920.492codecs_float_select1SELECT count(n) FROM codec_mon_Float64_NONE WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.0830.1240.4850.485if_array_num0SELECT count() FROM zeros(10000000) WHERE NOT ignore(rand() % 2 ? [1, 2, 3] : [4, 5])
0.2080.3090.4850.485codecs_float_select12SELECT count(n) FROM codec_seq_Float64_Gorilla WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.3470.5150.4830.483string_set0SELECT 1 FROM hits_10m_words WHERE word IN (SELECT word FROM hits_10m_words) FORMAT Null
0.0920.1360.4830.483float_formatting4SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(toFloat64(number % 1000)))
0.1770.2630.4810.481logical_functions_medium4SELECT count() FROM (SELECT materialize(1) AS x1, materialize(toUInt32(1)) AS x2, materialize(toUInt64(1)) AS x3 FROM zeros(50000000)) WHERE NOT ignore(and(x1,x2,x3))
0.2310.3430.4810.481codecs_int_insert7INSERT INTO codec_mon_UInt64_NONE (n) SELECT number*512+(intHash64(number)%512) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.0670.0990.4770.477codecs_float_select2SELECT count(n) FROM codec_rnd_Float64_NONE WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.0230.0350.4770.477IPv40SELECT count() FROM ips_v4 WHERE NOT ignore(IPv4StringToNum(materialize(ip))) SETTINGS max_threads=1
0.2000.2950.4740.474ngram_distance7SELECT ngramDistanceCaseInsensitive(Title, \'nO MOrE\') AS distance FROM hits_10m_single FORMAT Null
0.5990.8840.4740.474float_parsing7SELECT count() FROM zeros(10000000) WHERE NOT ignore(toFloat64(concat(toString(rand(1)), \'.\', toString(rand(2)))))
0.1360.2010.4710.471logical_functions_large0SELECT count() FROM\n (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))\n WHERE NOT ignore(and(x1,x2,x3,x4,x5,x6,x7,x8,x9,x10))
0.4440.6530.4710.471codecs_int_insert19INSERT INTO codec_rnd_UInt64_DoubleDelta (n) SELECT intHash64(number) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.2010.2960.4700.470ngram_distance6SELECT ngramDistanceCaseInsensitive(Title, \'BABY DonT hUrT me\') AS distance FROM hits_10m_single FORMAT Null
0.1920.2830.4690.469order_with_limit13SELECT intHash64(number) AS n FROM numbers_mt(100000000) ORDER BY n LIMIT 65535 FORMAT Null
0.2800.4110.4680.468string_set2SELECT 1 FROM strings WHERE long IN (SELECT long FROM strings) FORMAT Null
0.8121.1930.4680.468int_parsing26SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(SearchPhrase)) SETTINGS max_threads = 1
0.1630.2400.4670.467cpu_synthetic2SELECT count() FROM hits_10m_single WHERE NOT ignore(farmHash64(SearchPhrase)) SETTINGS max_threads = 1
0.2080.3040.4590.459ngram_distance5SELECT ngramDistanceCaseInsensitive(Title, \'wHAt Is lovE\') AS distance FROM hits_10m_single FORMAT Null
0.4620.6740.4590.459constant_column_comparison10SELECT count() FROM hits_100m_single WHERE MobilePhoneModel < \'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz\' SETTINGS max_threads = 1
0.6100.8910.4580.458int_parsing29SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(WindowClientWidth)) SETTINGS max_threads = 1
0.3220.4550.4100.454decimal_aggregates14SELECT quantile(d128), quantileExact(d128), quantileExactWeighted(d128, 2) FROM (SELECT * FROM t LIMIT 1000000)
0.0800.1160.4530.453base64_hits1SELECT count() FROM hits_10m_single WHERE NOT ignore(base64Encode(MobilePhoneModel))
0.3130.4550.4520.452string_join2SELECT 1 FROM strings AS l ANY LEFT JOIN strings AS r USING (long) FORMAT Null
0.2710.3940.4520.452generate_table_function8SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'d32 Decimal32(4), d64 Decimal64(8), d128 Decimal128(16)\', 0, 10, 10) LIMIT 1000000000);
0.3210.4260.3260.452decimal_aggregates17SELECT quantilesExact(0.1, 0.9)(d128), quantilesExactWeighted(0.1, 0.9)(d128, 2) FROM (SELECT * FROM t LIMIT 1000000)
0.1550.2260.4520.452codecs_int_select13SELECT count(n) FROM codec_mon_UInt64_Gorilla WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.2420.3500.4490.449codecs_int_select20SELECT count(n) FROM codec_rnd_UInt64_Gorilla WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.5640.8170.4460.446int_parsing34SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(SilverlightVersion3)) SETTINGS max_threads = 1
0.8991.2940.4390.439set_hits0SELECT count() FROM hits_100m_single WHERE UserID IN (SELECT UserID FROM hits_100m_single WHERE AdvEngineID != 0) SETTINGS max_threads = 1
0.4510.6480.4360.436number_formatting_formats8INSERT INTO table_XML SELECT number FROM numbers(10000000)
0.1270.1830.4350.435logical_functions_small16SELECT count() FROM (SELECT materialize(toUInt64(1)) AS x1, materialize(toUInt64(1)) AS x2 FROM zeros(100000000)) WHERE NOT ignore(xor(x1,x2))
0.3080.4420.4330.433set_hits4SELECT count() FROM hits_10m_single WHERE URL IN (SELECT URL FROM hits_10m_single WHERE SearchEngineID != 0)
1.2021.7160.4280.428float_parsing9SELECT count() FROM zeros(10000000) WHERE NOT ignore(toFloat64(concat(toString(rand64(1)), toString(rand64(2)), toString(rand64(3)))))
0.7741.1050.4270.427set6SELECT count() FROM zeros(100000000) WHERE rand64() IN (SELECT number FROM system.numbers LIMIT 16384)
0.2950.4210.4240.424constant_column_search2select count(multiSearchAllPositions(URL, [\'yandex\', \'google\'])) FROM hits_100m_single
0.1420.2020.4200.420number_formatting_formats0INSERT INTO table_TabSeparated SELECT number FROM numbers(10000000)
0.2900.4110.4170.417number_formatting_formats12INSERT INTO table_Native SELECT number FROM numbers(20000000)
0.5270.7470.4170.417empty_string_serialization0INSERT INTO empty_strings SELECT \'\' FROM zeros(100000000);
0.4440.6280.4140.414float_parsing6SELECT count() FROM zeros(10000000) WHERE NOT ignore(toFloat64(toString(rand64())))
0.2880.4070.4130.413number_formatting_formats13INSERT INTO table_Null SELECT number FROM numbers(20000000)
0.2790.3950.4120.412functions_geo0SELECT count() FROM numbers(1000000) WHERE NOT ignore(geohashEncode((number % 150)*1.1 - 75, (number * 3.14 % 300)*1.1 - 150))
0.3210.4530.4100.410set_hits5SELECT count() FROM hits_100m_single WHERE RegionID IN (SELECT RegionID FROM hits_100m_single)
0.1650.1680.0200.409logical_functions_small2SELECT count() FROM test_logical_functions._2_0_UInt8 WHERE NOT ignore(or(x1,x2))
0.2340.3300.4090.409codecs_float_select10SELECT count(n) FROM codec_mon_Float64_DoubleDelta WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.3000.4230.4070.407string_set6SELECT 1 FROM hits_10m_words WHERE word IN (SELECT long FROM strings) FORMAT Null
0.2960.4160.4070.407constant_column_search6select sum(multiSearchAny(URL, [\'yandex\', \'google\', \'yahoo\', \'pikabu\'])) from hits_100m_single
0.4970.7000.4070.407constant_column_comparison12SELECT count() FROM hits_100m_single WHERE notEmpty(MobilePhoneModel) AND MobilePhoneModel < \'\' SETTINGS max_threads = 1
0.0470.0670.4050.405visit_param_extract_raw0SELECT count() FROM zeros(2000000) WHERE NOT ignore(visitParamExtractRaw(materialize(\'{"myparam":"test_string"}\'), \'myparam\'))
0.2650.3720.4040.404read_hits_with_aio2SELECT count() FROM hits_100m_single where UserID=1234567890 SETTINGS max_threads = 1, min_bytes_to_use_direct_io = 0, max_read_buffer_size = 10485760;
0.1050.1480.4030.403set10SELECT count() FROM zeros_mt(100000000) WHERE rand64() IN (SELECT number FROM system.numbers LIMIT 1048576)
0.8581.2040.4020.402constant_column_search0SELECT count() FROM hits_100m_single WHERE match(URL, \' *tranio\\\\.ru/spain/*/commercial/*\') settings max_threads=5
0.1990.2780.4000.400cpu_synthetic4SELECT count() FROM hits_10m_single WHERE NOT ignore(metroHash64(SearchPhrase)) SETTINGS max_threads = 1
1.1531.6130.3990.399decimal_casts6SELECT toUInt256(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t LIMIT 10000000 FORMAT Null
0.0930.1300.3990.399bitCount3SELECT bitCount(toUInt8(number)) FROM numbers(100000000) FORMAT Null
0.6590.9210.3970.397set9SELECT count() FROM zeros(10000000) WHERE rand64() IN (SELECT number FROM system.numbers LIMIT 10000000)
0.6860.9580.3960.396general_purpose_hashes46SELECT count() from numbers_mt(1000000000) where not ignore(murmurHash3_128(toString(1000000000+number)))
0.0260.0360.3950.395string_sort16SELECT MobilePhoneModel FROM hits_100m_single ORDER BY MobilePhoneModel LIMIT 1500 format Null
0.0720.1010.3930.393distributed_aggregation1select count(sipHash64(zero)) from remote(\'127.0.0.{1,1}\', zeros_mt(100000000))
0.0250.0340.3870.387vectorize_aggregation_combinators1SELECT countMerge(v) FROM (SELECT number % 1024 k, countState() v FROM numbers(10000000) GROUP BY k) FORMAT Null
0.6130.8500.3850.385int_parsing60SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(ResponseStartTiming)) SETTINGS max_threads = 1
0.0880.1220.3850.385if_array_num3SELECT count() FROM zeros(10000000) WHERE NOT ignore(rand() % 2 ? [1, 2, 3] : [400, 500])
0.0690.0960.3850.385codecs_float_select0SELECT count(n) FROM codec_seq_Float64_NONE WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.0670.0930.3840.384float_formatting1SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(toFloat64(number % 2)))
0.0730.1020.3840.384distributed_aggregation3select count(sipHash64(zero)) from remote(\'127.0.0.{2,3}\', zeros_mt(100000000))
0.1390.1920.3830.383columns_hashing0select sum(UserID + 1 in (select UserID from hits_10m_single)) from hits_10m_single
0.1330.1850.3820.382set_hits1SELECT count() FROM hits_10m_single WHERE UserID IN (SELECT UserID FROM hits_10m_single)
0.0740.1020.3810.381distributed_aggregation2select count(sipHash64(zero)) from remote(\'127.0.0.{1,2}\', zeros_mt(100000000))
0.4790.6620.3800.380constant_column_comparison3SELECT count() FROM hits_100m_single WHERE SearchPhrase < \'\' SETTINGS max_threads = 2
0.2650.3660.3780.378set_hits2SELECT count() FROM hits_10m_single WHERE SearchPhrase IN (SELECT SearchPhrase FROM hits_10m_single)
0.2900.4000.3780.378constant_column_search14select sum(multiSearchAny(URL, [\'yandex\', \'google\', \'facebook\', \'wikipedia\', \'reddit\'])) from hits_100m_single
0.2740.3770.3760.376read_hits_with_aio0SELECT count() FROM hits_100m_single where UserID=1234567890 SETTINGS max_threads = 1, min_bytes_to_use_direct_io = 1, max_read_buffer_size = 10485760;
0.5820.8020.3760.376constant_column_comparison13SELECT count() FROM hits_100m_single WHERE notEmpty(MobilePhoneModel) AND MobilePhoneModel < \'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz\' SETTINGS max_threads = 1
0.1040.1430.3730.373trim_numbers2SELECT count() FROM numbers(10000000) WHERE NOT ignore(rtrim(toString(number)))
0.1430.1950.3680.368sum12SELECT sum(toNullable(toFloat32(number))) FROM numbers(100000000)
0.0690.0950.3660.366codecs_int_select16SELECT count(n) FROM codec_rnd_UInt64_ZSTD WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.0790.1070.3630.363date_time_641SELECT count() FROM dt64 where not ignore(x)
0.0640.061-0.0370.362parse_engine_file11SELECT * FROM table_Native FORMAT Null
0.1630.2220.3600.360generate_table_function15SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'i UUID\', 0, 10, 10) LIMIT 1000000000);
0.1460.1990.3580.358number_formatting_formats1INSERT INTO table_CSV SELECT number FROM numbers(10000000)
0.4730.6410.3560.356float_parsing8SELECT count() FROM zeros(10000000) WHERE NOT ignore(toFloat64(concat(toString(rand(1)), \'e\', toString(rand(2) % 100))))
0.1070.1450.3550.355trim_numbers0SELECT count() FROM numbers(10000000) WHERE NOT ignore(trim(toString(number)))
0.0630.0850.3550.355merge_table_streams0SELECT UserID FROM merge(default, \'^(hits_100m_single|merge_table_streams_\\\\d)$\') WHERE UserID = 12345678901234567890
1.1311.5300.3530.353decimal_casts5SELECT toInt256(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t LIMIT 10000000 FORMAT Null
0.5160.6990.3530.353constant_column_comparison6SELECT count() FROM hits_100m_single WHERE notEmpty(SearchPhrase) AND SearchPhrase < \'\' SETTINGS max_threads = 2
0.3050.4120.3510.351logical_functions_large7SELECT count() FROM\n (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))\n WHERE NOT ignore(or(x1,x2,x3,x4,x5,x6,x7,x8,x9,x10))
0.5730.7730.3490.349read_from_comp_parts4SELECT count() FROM mt_comp_parts WHERE NOT ignore(*)
0.9751.3130.3460.346parallel_final20SELECT sum(s) FROM collapsing_final_16p_str_keys_ord final group by key1 % 8192 limit 10
0.2000.2680.3390.339base64_hits0SELECT count() FROM hits_10m_single WHERE NOT ignore(base64Encode(SearchPhrase))
0.3960.5310.3390.339array_index_low_cardinality_numbers3SELECT count() FROM perf_lc_num WHERE indexOf(arr, 42) > 0
0.7110.9510.3370.337generate_table_function12SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'i Tuple(Int32, Array(Int64))\', 0, 10, 10) LIMIT 1000000000);
0.5370.7190.3370.337constant_column_comparison5SELECT count() FROM hits_100m_single WHERE SearchPhrase < \'поисковая фраза\' SETTINGS max_threads = 2
0.3620.4840.3350.335order_with_limit6SELECT number AS n FROM numbers_mt(200000000) ORDER BY n DESC LIMIT 65535 FORMAT Null
0.0770.1030.3340.334date_time_6415SELECT sum(x = x) FROM dt64
0.6540.8700.3280.328general_purpose_hashes11SELECT count() from numbers(100000000) where not ignore(xxHash64(materialize(\'\')))
0.0820.1090.3270.327date_time_643SELECT max(x) FROM dt64
0.8121.0780.3270.327cpu_synthetic11SELECT count() FROM hits_10m_single WHERE NOT ignore(sipHash64(URL)) SETTINGS max_threads = 1
0.2260.2990.3260.326string_set5SELECT 1 FROM hits_10m_words WHERE word IN (SELECT short FROM strings) FORMAT Null
0.0320.0430.3240.324date_time_640SELECT count() FROM dt where not ignore(x)
0.5990.7920.3200.320set11SELECT count() FROM zeros_mt(100000000) WHERE rand64() IN (SELECT number FROM system.numbers LIMIT 10000000)
0.2730.3610.3200.320codecs_int_insert16INSERT INTO codec_rnd_UInt64_ZSTD (n) SELECT intHash64(number) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.4250.5620.3200.320array_index_low_cardinality_numbers6SELECT count() FROM perf_lc_num WHERE indexOf(arr, num) > 0
0.1870.2470.3190.319if_to_multiif4\nWITH 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)\n
0.1340.1770.3180.318generate_table_function7SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'f32 Float32, f64 Float64\', 0, 10, 10) LIMIT 1000000000);
0.1220.1600.3170.317sum4SELECT sum(toFloat32(number)) FROM numbers(100000000)
0.3640.4800.3170.317generate_table_function1SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'ui64 UInt64, i64 Int64, ui32 UInt32, i32 Int32, ui16 UInt16, i16 Int16, ui8 UInt8, i8 Int8\', 0, 10, 10) LIMIT 1000000000);
0.2660.3500.3160.316functions_with_hash_tables0select arrayUniq(range(1 + (number % 100) * 10)) from numbers(100000) format Null
0.2050.2690.3130.313sum6SELECT sumKahan(toFloat32(number)) FROM numbers(100000000)
0.1980.2600.3110.311if_to_multiif0 WITH number AS x SELECT sum(x < 1 ? 1 : (x < 5 ? 2 : 3)) FROM numbers(100000000)
0.3530.4630.3110.311generate_table_function0SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'ui64 UInt64, i64 Int64, ui32 UInt32, i32 Int32, ui16 UInt16, i16 Int16, ui8 UInt8, i8 Int8\') LIMIT 1000000000);
0.1500.1970.3090.309string_set1SELECT 1 FROM strings WHERE short IN (SELECT short FROM strings) FORMAT Null
0.5820.7620.3090.309constant_column_comparison7SELECT count() FROM hits_100m_single WHERE notEmpty(SearchPhrase) AND SearchPhrase < \'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz\' SETTINGS max_threads = 2
0.1160.1520.3090.309base64_hits9SELECT count() FROM hits_10m_single WHERE tryBase64Decode(base64Encode(MobilePhoneModel)) != MobilePhoneModel
0.2110.2770.3090.309array_index_low_cardinality_strings3SELECT count() FROM perf_lc_str WHERE indexOf(arr, \'asdf337\') > 0
0.1340.1760.3080.308generate_table_function9SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'i Tuple(Int32, Int64)\', 0, 10, 10) LIMIT 1000000000);
0.0830.1080.3050.305read_from_comp_parts3SELECT count() FROM mt_comp_parts WHERE NOT ignore(c1, c2, c3)
0.4280.5590.3050.305cpu_synthetic29SELECT quantilesTDigestIf(0.5, 0.9)(SendTiming, SendTiming > 0) FROM hits_100m_single SETTINGS max_threads = 1
0.3580.4680.3050.305array_index_low_cardinality_numbers2SELECT count() FROM perf_lc_num WHERE has(arr, 42)
0.1690.2210.3040.304math12SELECT count() FROM numbers(100000000) WHERE NOT ignore(exp(toFloat32(number)))
0.3180.4140.3040.304cpu_synthetic6SELECT count() FROM hits_10m_single WHERE NOT ignore(sipHash64(SearchPhrase)) SETTINGS max_threads = 1
0.0970.1260.3010.301bitCount4SELECT bitCount(toInt32(number)) FROM numbers(100000000) FORMAT Null
0.3770.4910.3000.300if_to_multiif2 WITH number AS x SELECT sum(x < 1 ? 1 : (x < 5 ? 2 : (x < 10 ? 3 : (x % 2 ? 4 : 5)))) FROM numbers(100000000)
0.0700.0910.2960.296codecs_int_select14SELECT count(n) FROM codec_rnd_UInt64_NONE WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.3780.4890.2940.294string_join0SELECT 1 FROM hits_10m_words AS l ANY LEFT JOIN hits_10m_words AS r USING (word) FORMAT Null
0.3810.4930.2940.294cpu_synthetic12SELECT count() FROM hits_100m_single WHERE NOT ignore(sipHash64(URL))
0.6680.8630.2900.290leftpad3SELECT max(length(PageCharset)) FROM hits_100m_single
0.3600.4640.2890.289array_index_low_cardinality_numbers5SELECT count() FROM perf_lc_num WHERE has(arr, num)
0.3330.4300.2880.288leftpad5SELECT max(length(URL)) FROM hits_10m_single
0.0960.1240.2880.288concat_hits2SELECT count() FROM hits_100m_single WHERE NOT ignore(concat(MobilePhoneModel, SearchPhrase))
0.6450.8270.2820.282prewhere0SELECT Title FROM hits_10m_single PREWHERE WatchID % 2 = 1 WHERE UserID = 10000 FORMAT Null
0.0340.0440.2810.281date_time_642SELECT max(x) FROM dt
0.1110.1420.2810.281cpu_synthetic7SELECT count() FROM hits_100m_single WHERE NOT ignore(sipHash64(SearchPhrase))
0.1350.1730.2800.280codecs_float_select9SELECT count(n) FROM codec_seq_Float64_DoubleDelta WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.0920.1180.2780.278random_string5SELECT count() FROM zeros(10000000) WHERE NOT ignore(randomString(rand() % 100))
0.0960.1230.2780.278bitCount1SELECT bitCount(toUInt32(number)) FROM numbers(100000000) FORMAT Null
0.1190.1520.2780.278base64_hits5SELECT count() FROM hits_10m_single WHERE base64Decode(base64Encode(MobilePhoneModel)) != MobilePhoneModel
0.6340.8100.2770.277sum_map5SELECT maxMap((key, val)) FROM sum_map_1000000 FORMAT Null
0.5980.7640.2770.277sum_map0SELECT minMap(key, val) FROM sum_map_1000000 FORMAT Null
0.2000.2550.2750.275array_index_low_cardinality_strings2SELECT count() FROM perf_lc_str WHERE has(arr, \'asdf337\')
0.4440.5670.2740.274codecs_int_insert12INSERT INTO codec_mon_UInt64_DoubleDelta (n) SELECT number*512+(intHash64(number)%512) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.3930.5010.2720.272array_index_low_cardinality_numbers1SELECT count() FROM perf_lc_num WHERE arr[1] = 42
0.0650.0820.2710.271order_by_decimals1SELECT toDecimal32(number, 0) AS n FROM numbers(1000000) ORDER BY n FORMAT Null
0.2190.2780.2680.268general_purpose_hashes23SELECT count() from numbers_mt(1000000000) where not ignore(xxHash32(materialize(\'\')))
0.1260.1600.2660.266read_hits_with_aio1SELECT count() FROM hits_100m_single where EventDate between toDate(\'2013-07-10\') and toDate(\'2013-07-16\') and UserID=123 SETTINGS max_threads = 1, min_bytes_to_use_direct_io = 1, max_read_buffer_size = 10485760;
0.5430.6870.2640.264general_purpose_hashes54SELECT count() from zeros(1000000) where not ignore(metroHash64(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...(54)
0.2420.3060.2640.264bigint_arithm3SELECT toInt128(number) / number FROM numbers_mt(1000000000) FORMAT Null
0.6600.8340.2630.263sum_map1SELECT maxMap(key, val) FROM sum_map_1000000 FORMAT Null
0.4200.5300.2630.263constant_column_comparison16SELECT count() FROM hits_100m_single WHERE PageCharset < \'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz\' SETTINGS max_threads = 2
0.1830.2320.2620.262array_index_low_cardinality_strings0SELECT count() FROM perf_lc_str WHERE str = \'asdf337\'
0.5640.7110.2610.261base64_hits2SELECT count() FROM hits_10m_single WHERE NOT ignore(base64Encode(URL))
0.3880.4900.2600.260array_index_low_cardinality_numbers7SELECT count() FROM perf_lc_num WHERE has(arr, num * 10)
0.2980.3760.2590.259vectorize_aggregation_combinators2SELECT sumArray(v) FROM array_data FORMAT Null
0.0520.0590.1430.259great_circle_dist0SELECT count() FROM numbers(1000000) WHERE NOT ignore(greatCircleDistance((rand(1) % 360) * 1. - 180, (number % 150) * 1.2 - 90, (number % 360) + toFloat64(rand(2)) / 4294967296 - 180, (rand(3) % 180) * 1. - 90))
0.0830.1050.2580.258duplicate_order_by_and_distinct1SELECT DISTINCT * FROM (SELECT DISTINCT CounterID, EventDate FROM hits_10m_single) FORMAT Null
0.1090.1370.2580.258distributed_aggregation0select count() from (select sipHash64(zero) from zeros_mt(100000000) union all select sipHash64(zero) from zeros_mt(100000000))
0.0980.1230.2570.257if_string_hits2SELECT count() FROM hits_100m_single WHERE NOT ignore(rand() % 2 ? SearchPhrase : MobilePhoneModel)
0.1970.2470.2560.256read_from_comp_parts2SELECT count() FROM mt_comp_parts WHERE NOT ignore(c1, s1, c3)
0.1980.2490.2540.254string_join1SELECT 1 FROM strings AS l ANY LEFT JOIN strings AS r USING (short) FORMAT Null
0.6110.7650.2520.252sum_map4SELECT minMap((key, val)) FROM sum_map_1000000 FORMAT Null
0.0990.1230.2430.243trim_whitespace2SELECT trimBoth(value) FROM whitespaces FORMAT Null
0.1230.1520.2360.236read_hits_with_aio3SELECT count() FROM hits_100m_single where EventDate between toDate(\'2013-07-10\') and toDate(\'2013-07-16\') and UserID=123 SETTINGS max_threads = 1, min_bytes_to_use_direct_io = 0, max_read_buffer_size = 10485760;
0.4310.5330.2360.236array_index_low_cardinality_numbers4SELECT count() FROM perf_lc_num WHERE arr[1] = num
0.5540.6840.2350.235set_hits3SELECT count() FROM hits_100m_single WHERE URL IN (SELECT URL FROM hits_100m_single WHERE AdvEngineID != 0)
0.4070.5030.2350.235leftpad4SELECT max(length(Referer)) FROM hits_10m_single
0.1340.1660.2350.235if_array_num4SELECT count() FROM zeros(10000000) WHERE NOT ignore(rand() % 2 ? [1, 2, 3] : materialize([400, 500]))
0.0770.0950.2330.233early_constant_folding0SELECT count(JavaEnable) FROM hits_100m_single WHERE WatchID = 1 OR Title = \'next\' OR URL = \'prev\' OR OriginalURL = \'???\' OR 1
0.1320.1630.2320.232float_parsing1SELECT count() FROM numbers(10000000) WHERE NOT ignore(toFloat64(toString(number % 10)))
0.0930.1150.2310.231trim_whitespace0SELECT trimLeft(value) FROM whitespaces FORMAT Null
0.1980.2440.2300.230synthetic_hardware_benchmark30SELECT number % 1000 AS k, count() FROM numbers_mt(1600000000) GROUP BY k FORMAT Null
0.1560.1920.2300.230constant_column_comparison18SELECT count() FROM hits_100m_single WHERE Title < \'\'
0.4500.5530.2280.228array_index_low_cardinality_strings5SELECT count() FROM perf_lc_str WHERE has(arr, str)
0.8381.0290.2260.226float_parsing2SELECT count() FROM zeros(10000000) WHERE NOT ignore(toFloat64(toString(1 / rand())))
0.0820.1000.2240.224concat_hits4SELECT count() FROM hits_100m_single WHERE NOT ignore(concat(\'World\', SearchPhrase))
0.3270.4010.2240.224base64_hits8SELECT count() FROM hits_10m_single WHERE tryBase64Decode(base64Encode(SearchPhrase)) != SearchPhrase
0.5090.6230.2240.224array_index_low_cardinality_strings9SELECT count() FROM perf_lc_str WHERE has(arr, concat(str, \'0\'))
0.2630.3210.2230.223array_index_low_cardinality_strings1SELECT count() FROM perf_lc_str WHERE arr[1] = \'asdf337\'
0.5440.6650.2220.222set12\n SELECT number\n FROM numbers(10)\n WHERE (number IN\n (\n SELECT sum(number)\n FROM numbers(100000000)\n GROUP BY bitAnd(number, 15)\n )) OR (number IN\n (\n SELECT sum(number)\n FROM numbers(100000000)\n GROUP BY bitAnd(number, 17)\n ))\n
0.0650.0800.2210.221inserts_arrays_lowcardinality0INSERT INTO lot_of_string_arrays_dst SELECT rand64() as id, columns(\'^col\') FROM lot_of_string_arrays_src
0.3970.4840.2190.219codecs_int_insert8INSERT INTO codec_mon_UInt64_LZ4 (n) SELECT number*512+(intHash64(number)%512) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.0680.0830.2180.218order_by_decimals2SELECT toDecimal32(number, 0) AS n FROM numbers(1000000) ORDER BY n DESC FORMAT Null
0.3990.4870.2180.218leftpad2SELECT max(length(Title)) FROM hits_10m_single
0.5790.7040.2160.216basename1SELECT count() FROM hits_10m_single WHERE NOT ignore(basename(Referer))
0.3860.4690.2150.215order_by_read_in_order2SELECT * FROM hits_100m_single ORDER BY CounterID, EventDate, URL LIMIT 100
0.0980.1190.2140.214synthetic_hardware_benchmark33SELECT number % 100000 AS k, count() FROM numbers( 10000000) GROUP BY k FORMAT Null
0.1480.1800.2130.213date_time_6411SELECT count() from dt64 where not ignore(toRelativeMinuteNum(x))
1.2071.4630.2120.212questdb_sum_float643SELECT sum(x) FROM `zz_Float64 NULL_MergeTree ORDER BY tuple()`
0.3530.4280.2120.212codecs_float_select11SELECT count(n) FROM codec_rnd_Float64_DoubleDelta WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.0970.1170.2110.211sort_radix_trivial1SELECT rand64() AS x FROM numbers(1000000) ORDER BY x FORMAT Null
1.1411.3830.2110.211date_time_short8SELECT count() FROM numbers(100000000) WHERE NOT ignore(toDate(\'2017-01-01\') + number % 1000 + rand() % 10 AS t, toYYYYMMDDhhmmss(t))
0.4230.5130.2110.211constant_column_comparison17SELECT count() FROM hits_100m_single WHERE PageCharset < \'utf-8\' SETTINGS max_threads = 2
0.6740.8170.2100.210base64_hits3SELECT count() FROM hits_10m_single WHERE NOT ignore(base64Encode(Title))
0.0980.1180.2090.209trim_whitespace1SELECT trimRight(value) FROM whitespaces FORMAT Null
0.0440.0530.2060.206random_string0SELECT count() FROM zeros(10000000) WHERE NOT ignore(randomString(10))
0.3520.4240.2050.205order_with_limit4SELECT number AS n FROM numbers_mt(200000000) ORDER BY n DESC LIMIT 5000 FORMAT Null
0.2050.2470.2040.204constant_column_search24SELECT DISTINCT Title, multiFuzzyMatchAny(Title, 2, [\'^metrika\\\\.ry$\']) AS distance FROM hits_100m_single WHERE distance = 1
0.0360.0440.2030.203date_time_6414SELECT sum(x = x) FROM dt
0.3620.4360.2020.202order_with_limit3SELECT number AS n FROM numbers_mt(200000000) ORDER BY n DESC LIMIT 3000 FORMAT Null
0.5080.6110.2010.201array_index_low_cardinality_strings7SELECT count() FROM perf_lc_str WHERE has(arr, concat(\'0\', str))
0.0860.1030.1980.198concat_hits18SELECT count() FROM hits_100m_single WHERE NOT ignore(concat(MobilePhoneModel, \'Hello\', PageCharset))
0.4860.5820.1980.198array_index_low_cardinality_numbers8SELECT count() FROM perf_lc_num WHERE has(arr, (num * 1000 + 20) % 137)
0.3240.3890.1970.197base64_hits4SELECT count() FROM hits_10m_single WHERE base64Decode(base64Encode(SearchPhrase)) != SearchPhrase
0.9371.1210.1950.195base64_hits10SELECT count() FROM hits_10m_single WHERE tryBase64Decode(base64Encode(URL)) != URL
0.1050.1250.1940.194sort_radix_trivial2SELECT 1 / rand64() AS x FROM numbers(1000000) ORDER BY x FORMAT Null
0.0560.0670.1940.194round_down0SELECT count() FROM zeros(10000000) WHERE NOT ignore(roundDuration(rand() % 65536))
0.4820.5760.1940.194array_index_low_cardinality_strings4SELECT count() FROM perf_lc_str WHERE arr[1] = str
0.3460.4130.1940.194aggregation_in_order2SELECT avg(length(URL)) as x from hits_100m_single GROUP BY CounterID, EventDate FORMAT Null
0.4560.5440.1930.193array_index_low_cardinality_strings6SELECT count() FROM perf_lc_str WHERE indexOf(arr, str) > 0
0.9411.1220.1920.192base64_hits6SELECT count() FROM hits_10m_single WHERE base64Decode(base64Encode(URL)) != URL
0.4740.5650.1910.191basename0SELECT count() FROM hits_10m_single WHERE NOT ignore(basename(URL))
0.9521.1330.1900.190if_transform_strings_to_enum1SELECT transform(number, [2, 4, 6], [\'google\', \'yandex\', \'yahoo\'], \'other\') as x FROM numbers(100000000) GROUP BY x FORMAT Null
0.2730.3250.1890.189json_extract_simdjson11SELECT \'simdjson-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.0230.0260.1180.189great_circle_dist1SELECT count() FROM zeros(1000000) WHERE NOT ignore(greatCircleDistance(55. + toFloat64(rand(1)) / 4294967296, 37. + toFloat64(rand(2)) / 4294967296, 55. + toFloat64(rand(3)) / 4294967296, 37. + toFloat64(rand(4)) / 4294967296))
0.0650.0780.1880.188if_string_hits3SELECT count() FROM hits_100m_single WHERE NOT ignore(rand() % 2 ? \'\' : PageCharset)
0.0850.1010.1880.188concat_hits24SELECT count() FROM hits_100m_single WHERE NOT ignore(format(\'{}Hello{}\', MobilePhoneModel, PageCharset))
0.2170.2570.1870.187sum14SELECT sumKahan(toNullable(toFloat32(number))) FROM numbers(100000000)
0.5160.6120.1870.187array_index_low_cardinality_strings8SELECT count() FROM perf_lc_str WHERE has(arr, concat(str, \'str\'))
0.2430.2880.1860.186codecs_int_select9SELECT count(n) FROM codec_mon_UInt64_ZSTD WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.2420.2870.1860.186codecs_int_insert4INSERT INTO codec_seq_UInt64_T64 (n) SELECT number FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
1.0611.2580.1850.185base64_hits7SELECT count() FROM hits_10m_single WHERE base64Decode(base64Encode(Title)) != Title
0.1110.1310.1830.183visit_param_extract_raw1SELECT count() FROM zeros(2000000) WHERE NOT ignore(visitParamExtractRaw(materialize(\'{"myparam":{"nested_1":"test_string","nested_2":"test_2"}}\'), \'myparam\'))
0.2190.2590.1830.183parallel_final2SELECT count() FROM collapsing_final_16p_int_keys_ord final
0.3450.4080.1830.183aggregation_in_order0SELECT avg(length(URL)) as x from hits_100m_single GROUP BY CounterID FORMAT Null
1.1431.3510.1820.182questdb_sum_float641SELECT sum(x) FROM `zz_Float64_MergeTree ORDER BY tuple()`
0.2590.3030.1690.182json_extract_simdjson6SELECT \'simdjson-7\', 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\', \'nested_1\'))
0.0420.0490.1820.182concat_hits12SELECT count() FROM hits_100m_single WHERE NOT ignore(format(\'{}Hello\', MobilePhoneModel))
0.3360.3970.1810.181codecs_int_select19SELECT count(n) FROM codec_rnd_UInt64_DoubleDelta WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.3820.4510.1800.180synthetic_hardware_benchmark26SELECT number % 256 AS k, count(), sum(number), avg(number) FROM numbers(100000000) GROUP BY k FORMAT Null
0.1290.1520.1800.180if_array_num1SELECT count() FROM zeros(10000000) WHERE NOT ignore(rand() % 2 ? [1, 2, 3] : materialize([4, 5]))
1.0491.2390.1800.180base64_hits11SELECT count() FROM hits_10m_single WHERE tryBase64Decode(base64Encode(Title)) != Title
0.2970.3500.1790.179float_formatting21SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(toFloat32(number % 1000 + 0.123456)))
0.0820.0910.1170.178trim_whitespace5SELECT replaceRegexpAll(value, \'^ *| *$\', \'\') FROM whitespaces LIMIT 10000000 FORMAT Null
1.0381.2230.1780.178questdb_sum_int322SELECT sum(x) FROM `zz_Int32_MergeTree ORDER BY tuple()`
0.3080.3630.1770.177int_parsing35SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(SilverlightVersion4)) SETTINGS max_threads = 1
0.0620.0730.1750.175concat_hits6SELECT count() FROM hits_100m_single WHERE NOT ignore(concat(PageCharset, \'a\'))
0.0310.0360.1750.175aggregation_in_order1SELECT avg(length(URL)) as x from hits_10m_single GROUP BY CounterID, EventDate FORMAT Null
0.3660.4300.1740.174vectorize_aggregation_combinators3SELECT k, sumArray(v) FROM array_data GROUP BY k FORMAT Null
1.1411.2950.1350.173group_array_moving_sum3select k, groupArrayMovingSum(1000)(v) from moving_sum_100m group by k format Null
0.1340.1570.1730.173distributed_aggregation_memory_efficient0select sum(number) from remote(\'127.0.0{2,3,4,5}\', numbers_mt(1000000000)) settings max_threads=4, distributed_aggregation_memory_efficient=1
0.3600.4220.1720.172visit_param_extract_raw2SELECT count() FROM zeros(2000000) WHERE NOT ignore(visitParamExtractRaw(materialize(\'{"myparam":{"nested_1":"test_string","nested_2":"test_2","nested_1":"test_string","nested_2":"test_2","nested_1":"test_string","nested_2":"test_2"}}\'), \'myparam\'))
0.2500.2940.1720.172round_methods1SELECT count() FROM numbers(100000000) WHERE NOT ignore(roundBankers(toInt64(number), -2))
0.5310.481-0.0930.170random_printable_ascii6SELECT count() FROM zeros(1000000) WHERE NOT ignore(randomPrintableASCII(rand() % 1000))
0.3910.4560.1680.168base647SELECT count() FROM numbers(10000000) WHERE tryBase64Decode(base64Encode(materialize(\'This is a long string to test ClickHouse base64 functions impl..\'))) != materialize(\'This is a long string to test ClickHouse base64 functions impl..\')
0.2460.2870.1660.166codecs_int_select2SELECT count(n) FROM codec_seq_UInt64_ZSTD WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.0820.0950.1650.165codecs_int_select5SELECT count(n) FROM codec_seq_UInt64_DoubleDelta WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.3140.3640.1600.163int_parsing65SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(ParamCurrencyID)) SETTINGS max_threads = 1
0.3310.3840.1600.160parallel_final18SELECT sum(s) FROM collapsing_final_16p_int_keys_ord final group by key1 % 8192 limit 10
0.3530.4090.1580.158ngram_distance12SELECT ngramDistanceUTF8(URL, \'чем занимаешься\') AS distance FROM hits_10m_single FORMAT Null
0.0450.0530.1580.158aggregate_functions_of_group_by_keys0SELECT min(length(URL)), max(length(URL)) FROM hits_10m_single GROUP BY length(URL) FORMAT Null
0.2770.3200.1550.157synthetic_hardware_benchmark39SELECT number % 1000000 AS k FROM numbers( 10000000) GROUP BY k FORMAT Null
0.1160.1220.0490.157decimal_casts10SELECT toInt32(d64), toInt64(d64), toInt128(d64) FROM t FORMAT Null
0.1740.2020.1570.157date_time_649SELECT count() from dt64 where not ignore(toStartOfWeek(x))
0.1720.2000.1570.157codecs_float_select3SELECT count(n) FROM codec_seq_Float64_LZ4 WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.3230.3740.1560.156parallel_final8SELECT sum(s) FROM collapsing_final_16p_ord final group by key1 limit 10
0.2520.2920.1560.156json_extract_simdjson10SELECT \'simdjson-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.0390.0450.1540.154random_string4SELECT count() FROM zeros(10000000) WHERE NOT ignore(randomString(rand() % 10))
0.3550.4100.1540.154ngram_distance11SELECT ngramDistanceUTF8(URL, \'как дела\') AS distance FROM hits_10m_single FORMAT Null
0.2990.3450.1530.154int_parsing16SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(NetMajor)) SETTINGS max_threads = 1
1.1211.1390.0160.153group_array_moving_sum1select k, groupArrayMovingSum(10)(v) from moving_sum_100m group by k format Null
0.2380.2750.1530.153format_date_time0SELECT count() FROM numbers(10000000) WHERE NOT ignore(toDateTime(\'2017-01-01 00:00:00\') + number % 100000000 + rand() % 100000 AS t, formatDateTime(t, \'%F %T\'))
0.1720.1980.1530.153codecs_float_select4SELECT count(n) FROM codec_mon_Float64_LZ4 WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.2370.2730.1520.152synthetic_hardware_benchmark27SELECT number % 256 AS k, count(), sum(number), avg(number) FROM numbers_mt(1600000000) GROUP BY k FORMAT Null
0.5050.5830.1520.152ngram_distance8SELECT ngramDistanceUTF8(Title, URL) AS distance FROM hits_10m_single FORMAT Null
0.1550.1790.1520.152modulo2SELECT number % 256 FROM numbers(300000000) FORMAT Null
0.0550.0640.1520.152date_time_648SELECT count() from dt where not ignore(toStartOfWeek(x))
0.1750.2010.1520.152constant_column_comparison0SELECT count() FROM hits_100m_single WHERE URL < \'\'
0.1440.1660.1510.151questdb_sum_int320SELECT sum(x) FROM `zz_Int32_Memory`
1.1981.3800.1510.151questdb_sum_float323SELECT sum(x) FROM `zz_Float32 NULL_MergeTree ORDER BY tuple()`
0.0780.0900.1510.151concat_hits11SELECT count() FROM hits_100m_single WHERE NOT ignore(format(\'World{}\', SearchPhrase))
0.0680.058-0.1490.150format_date_time4SELECT count() FROM numbers(10000000) WHERE NOT ignore(toDateTime(\'2017-01-01 00:00:00\') + number % 100000000 + rand() % 100000 AS t, formatDateTime(t, \'Hello\'))
0.3490.4020.1490.149ngram_distance13SELECT ngramDistanceCaseInsensitiveUTF8(Title, \'Метрика\') AS distance FROM hits_10m_single FORMAT Null
0.0540.0620.1480.148slices_hits1SELECT count() FROM hits_100m_single WHERE NOT ignore(substring(PageCharset, 1, 2))
0.0300.027-0.0750.148linear_regression1SELECT stochasticLinearRegression(Age, Income, ParamPrice, Robotness, RefererHash) FROM test.hits FORMAT Null
0.0840.0970.1480.148concat_hits17SELECT count() FROM hits_100m_single WHERE NOT ignore(concat(\'Hello\', SearchPhrase, \'World\'))
0.1150.1280.1170.148aggregate_functions_of_group_by_keys1SELECT any(WatchID), anyLast(WatchID) FROM hits_10m_single GROUP BY WatchID FORMAT Null
0.2520.2900.1470.147inserts_arrays_lowcardinality1INSERT INTO lot_of_string_arrays_dst_lowcardinality SELECT rand64() as id, columns(\'^col\') FROM lot_of_string_arrays_src
0.2310.2650.1470.147constant_column_search10select sum(multiSearchAny(URL, [\'yandex\', \'google\', \'http\'])) from hits_100m_single
0.1030.1180.1460.146IPv60SELECT count() FROM ips_v6 WHERE NOT ignore(IPv6StringToNum(materialize(ip)))
0.0420.0490.1450.145sum0SELECT sum(number) FROM numbers(100000000)
0.0900.1030.1450.145parallel_mv0insert into main_table select number from numbers(1000000)
0.0710.0760.0640.144decimal_casts9SELECT toInt32(d32), toInt64(d32), toInt128(d32) FROM t FORMAT Null
0.3610.4120.1410.141order_with_limit2SELECT number AS n FROM numbers_mt(200000000) ORDER BY n DESC LIMIT 1500 FORMAT Null
0.1540.141-0.0840.140questdb_sum_float320SELECT sum(x) FROM `zz_Float32_Memory`
0.3610.3900.0800.139ngram_distance9SELECT ngramDistanceUTF8(Title, SearchPhrase) AS distance FROM hits_10m_single FORMAT Null
0.1950.2220.1390.139base641SELECT count() FROM numbers(10000000) WHERE NOT ignore(base64Encode(materialize(\'This is a long string to test ClickHouse base64 functions impl..\')))
0.2480.2830.1380.138json_extract_simdjson5SELECT \'simdjson-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.4210.4790.1370.137constant_column_search18SELECT count() FROM hits_100m_single WHERE multiMatchAny(URL, [\'about/address\', \'for_woman\', \'^https?://lm-company.ruy/$\', \'ultimateguitar.com\'])
0.3470.3940.1360.136int_parsing15SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(FlashMinor)) SETTINGS max_threads = 1
0.1970.2240.1360.136constant_column_comparison19SELECT count() FROM hits_100m_single WHERE Title < \'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz\'
0.1460.1570.0720.135questdb_sum_float642SELECT sum(x) FROM `zz_Float64 NULL_Memory`
0.1980.2250.1350.135constant_column_comparison20SELECT count() FROM hits_100m_single WHERE Title < \'Какой-то заголовок\'
0.9151.0370.1340.134float_parsing4SELECT count() FROM zeros(10000000) WHERE NOT ignore(toFloat64(toString(0xFFFFFFFF / rand())))
0.1390.130-0.0610.132merge_tree_many_partitions_20SELECT sum(ignore(*)) FROM bad_partitions
0.2540.2870.1310.131json_extract_simdjson7SELECT \'simdjson-8\', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractInt(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.4030.4560.1310.131float_formatting28SELECT count() FROM zeros(10000000) WHERE NOT ignore(toString(toFloat32(rand64())))
0.3840.4340.1310.131constant_column_search7select sum(multiMatchAny(URL, [\'yandex\', \'google\', \'yahoo\', \'pikabu\'])) from hits_100m_single
0.0800.0910.1300.130sort_radix_trivial0SELECT rand32() AS x FROM numbers(1000000) ORDER BY x FORMAT Null
0.0520.0590.1300.130date_time_646SELECT count() from dt where not ignore(toStartOfDay(x))
0.0590.0670.1290.129concat_hits19SELECT count() FROM hits_100m_single WHERE NOT ignore(concat(\'a\', PageCharset, \'b\'))
0.4940.5570.1270.127float_formatting22SELECT count() FROM zeros(10000000) WHERE NOT ignore(toString(1 / rand()))
0.2100.2370.1270.127constant_column_comparison2SELECT count() FROM hits_100m_single WHERE URL < \'http://some_url\'
0.2110.2380.1270.127constant_column_comparison1SELECT count() FROM hits_100m_single WHERE URL < \'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz\'
0.3690.4160.1260.126ngram_distance14SELECT ngramDistanceCaseInsensitiveUTF8(URL, \'как дЕлА\') AS distance FROM hits_10m_single FORMAT Null
0.1740.1970.1260.126if_array_num5SELECT count() FROM zeros(10000000) WHERE NOT ignore(rand() % 2 ? materialize([1, 2, 3]) : materialize([400, 500]))
0.8981.0110.1260.126float_parsing3SELECT count() FROM zeros(10000000) WHERE NOT ignore(toFloat64(toString(rand() / 0xFFFFFFFF)))
0.2340.2640.1250.125parallel_final16SELECT sum(s) FROM collapsing_final_16p_ord final group by key1 % 8192 limit 10
0.2650.2980.1240.124json_extract_simdjson12SELECT \'simdjson-13\', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractBool(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}\'), \'bparam\'))
0.2500.2820.1240.124json_extract_simdjson8SELECT \'simdjson-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.0940.1050.1240.124base640SELECT count() FROM numbers(10000000) WHERE NOT ignore(base64Encode(materialize(\'Hello, world!\')))
0.2860.3210.1230.123int_parsing38SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(IsDownload)) SETTINGS max_threads = 1
1.0511.1760.1190.119questdb_sum_float322SELECT sum(x) FROM `zz_Float32_MergeTree ORDER BY tuple()`
0.5310.499-0.0600.119json_extract_rapidjson7SELECT \'rapidjson-8\', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractInt(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.1350.128-0.0540.118questdb_sum_float640SELECT sum(x) FROM `zz_Float64_Memory`
0.1160.1290.1180.118date_time_6412SELECT count() from dt where not ignore(addDays(x, 1))
0.0940.1050.1160.116round_down3SELECT count() FROM zeros(10000000) WHERE NOT ignore(roundDown(rand() % 100, [0, 1, 18, 25, 35, 45, 55]))
0.1680.1870.1160.116date_time_647SELECT count() from dt64 where not ignore(toStartOfDay(x))
0.3710.4140.1150.115ngram_distance15SELECT ngramDistanceCaseInsensitiveUTF8(URL, \'Чем зАнимаешЬся\') AS distance FROM hits_10m_single FORMAT Null
0.3480.3890.1150.115constant_column_search12select sum(match(URL, \'yandex|google|http\')) FROM hits_100m_single
0.0370.0400.0850.114trim_whitespace3SELECT replaceRegexpOne(value, \'^ *\', \'\') FROM whitespaces LIMIT 10000000 FORMAT Null
0.8650.9640.1140.114synthetic_hardware_benchmark43SELECT number % 10000000 AS k FROM numbers( 10000000) GROUP BY k FORMAT Null
0.5490.6120.1140.114constant_column_search26SELECT sum(multiFuzzyMatchAny(Title, 3, [\'hello$\', \'world$\', \'^hello\'])) FROM hits_100m_single
0.0510.0570.1130.113trim_whitespace4SELECT replaceRegexpOne(value, \' *$\', \'\') FROM whitespaces LIMIT 10000000 FORMAT Null
0.7220.643-0.1100.113parallel_final7SELECT count() FROM collapsing_final_1024p_rnd final
0.0600.0670.1130.113concat_hits25SELECT count() FROM hits_100m_single WHERE NOT ignore(format(\'a{}b\', PageCharset))
0.3140.3500.1120.112bloom_filter0INSERT INTO test_bf SELECT number AS id, [CAST(id, \'String\'), CAST(id + 1, \'String\'), CAST(id + 2, \'String\')] FROM numbers(1000000)
0.1580.1760.1110.111modulo0SELECT number % 128 FROM numbers(300000000) FORMAT Null
0.1720.1910.1110.111generate_table_function16SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'i Array(Nullable(UUID))\', 0, 10, 10) LIMIT 100000000);
1.2081.3410.1090.109questdb_sum_int323SELECT sum(x) FROM `zz_Int32 NULL_MergeTree ORDER BY tuple()`
0.0780.0860.1080.108conditional0SELECT count() FROM zeros(10000000) WHERE NOT ignore(if(rand() % 2, toDateTime(\'2019-02-04 01:24:31\'), toDate(\'2019-02-04\')))
0.1450.1600.1070.107conditional5SELECT count() FROM zeros(10000000) WHERE NOT ignore(multiIf(rand() % 2, toDateTime(rand()), toDate(rand())))
0.4770.430-0.1000.107array_element2SELECT count() FROM numbers(100000000) WHERE NOT ignore([[], []][number % 2 + 2])
0.1330.1480.1040.106codecs_int_select18SELECT count(n) FROM codec_rnd_UInt64_T64 WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.1090.1200.1020.102point_in_polygon_const0\nSELECT count() FROM numbers(10000000) WHERE NOT ignore(\n pointInPolygon((1 / (number % 123), 2 / (number % 1000)),\n [(1,0),(0.9993908270190958,0.03489949670250097),(0.9975640502598242,0.0697564737441253),(0.9945218953682733,0.10452846326765346),(0.9902680687415704,0.13917310096006544),(0.984807753012208,0.17364817766693033),(0.9781476007338057,0.20791169081775931),(0.9702957262759965,0.24192189559966773),(0.9612616959383189,0.27563735581699916),(0.9510565162951535,0.3090169943749474),(0.9396926207859084,0.3420201433256687),(0.9271838545667874,0.374606593415912),(0.9135454576426009,0.40673664307580015),(0.898794046299167,0.4383711467890774),(0.882947592858927,0.4694715627858908),(0.8660254037844387,0.49999999999999994),(0.848048096156426,0.5299192642332049),(0.8290375725550417,0.5591929034707468),(0.8090169943749475,0.5877852522924731),(0.7880107536067219,0.6156614753256583),(0.766044443118978,0.6427876096865393),(0.7431448254773942,0.6691306063588582),(0.7193398003386512,0.69465...(0)
0.1000.094-0.0600.102monotonous_order_by0SELECT * FROM (SELECT CounterID, EventDate FROM hits_10m_single) ORDER BY toFloat32(toFloat64(toFloat32(toFloat64(CounterID)))) FORMAT Null
0.2680.2950.1010.101if_transform_strings_to_enum0SELECT length(URL) > 1000 ? \'LONG\' : \'SHORT\' as x FROM hits_100m_single GROUP BY x FORMAT Null
0.0390.0430.1010.101generate_table_function10SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'i Array(Int8)\', 0, 10, 10) LIMIT 100000000);
0.0840.0920.1010.101functions_geo1SELECT count() FROM numbers(1000000) WHERE NOT ignore(geohashDecode(toString(number % 1000000)))
0.6780.7470.1000.100trim_urls4SELECT count() FROM hits_100m_single WHERE NOT ignore(trim(TRAILING \'/\' FROM URL))
0.0600.0620.0330.100order_by_read_in_order4SELECT * FROM hits_100m_single WHERE UserID=1988954671305023629 ORDER BY CounterID, EventDate LIMIT 100
0.0680.0750.0990.099sum1SELECT sum(toUInt32(number)) FROM numbers(100000000)
0.1780.1960.0990.099if_array_num2SELECT count() FROM zeros(10000000) WHERE NOT ignore(rand() % 2 ? materialize([1, 2, 3]) : materialize([4, 5]))
0.5330.5860.0980.098json_extract_simdjson9SELECT \'simdjson-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.0780.0860.0980.098functions_geo5SELECT count() FROM numbers(1000000) WHERE NOT ignore(geohashDecode(hex(number)))
0.1550.1710.0970.097polymorphic_parts_l1INSERT INTO hits_compact(UserID) SELECT rand() FROM numbers(100000)
0.0340.0370.0970.097order_by_decimals0SELECT toInt32(number) AS n FROM numbers(1000000) ORDER BY n DESC FORMAT Null
0.4360.4780.0960.096parallel_final10SELECT sum(s) FROM collapsing_final_16p_int_keys_ord final group by key1 limit 10
0.2980.3260.0950.095url_hits18SELECT count() FROM hits_100m_single WHERE NOT ignore(cutQueryStringAndFragment(URL))
0.1680.1840.0950.095synthetic_hardware_benchmark34SELECT number % 100000 AS k, count() FROM numbers_mt(160000000) GROUP BY k FORMAT Null
0.3120.3420.0950.095int_parsing22SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(MobilePhone)) SETTINGS max_threads = 1
0.4790.5250.0950.095constant_column_search22SELECT count() FROM hits_100m_single WHERE multiMatchAny(URL, [\'chelyabinsk\\\\.74\\\\.ru\', \'doctor\\\\.74\\\\.ru\', \'transport\\\\.74\\\\.ru\', \'m\\\\.74\\\\.ru\', \'//74\\\\.ru/\', \'chel\\\\.74\\\\.ru\', \'afisha\\\\.74\\\\.ru\', \'diplom\\\\.74\\\\.ru\', \'chelfin\\\\.ru\', \'//chel\\\\.ru\', \'chelyabinsk\\\\.ru\', \'cheldoctor\\\\.ru\', \'//mychel\\\\.ru\', \'cheldiplom\\\\.ru\', \'74\\\\.ru/video\', \'market\', \'poll\', \'mail\', \'conference\', \'consult\', \'contest\', \'tags\', \'feedback\', \'pages\', \'text\'])
0.0640.0700.0880.094order_by_read_in_order3SELECT * FROM hits_100m_single WHERE CounterID IN (152220, 168777, 149234, 149234) ORDER BY CounterID DESC, EventDate DESC LIMIT 100
0.1550.1700.0940.094json_extract_rapidjson4SELECT \'rapidjson-5\', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractFloat(materialize(\'{"sparam":"test_string","nparam": 772}\'), \'fparam\'))
0.0880.0960.0930.093sum10SELECT sum(toNullable(toUInt16(number))) FROM numbers(100000000)
0.0880.0970.0920.092sum11SELECT sum(toNullable(toUInt8(number))) FROM numbers(100000000)
0.5120.5600.0920.092simple_join_query3SELECT COUNT() FROM join_table AS left LEFT JOIN (SELECT A FROM join_table) AS right ON left.A = right.A
0.1240.1350.0870.092json_extract_simdjson3SELECT \'simdjson-4\', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractUInt(materialize(\'{"sparam":"test_string","nparam": 772}\'), \'nparam\'))
0.1560.1710.0920.092json_extract_rapidjson1SELECT \'rapidjson-2\', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractString(materialize(\'{"sparam":"test_string","nparam": 772}\'), \'sparam\', \'nested_1\'))
0.3000.3260.0860.092int_parsing27SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(AdvEngineID)) SETTINGS max_threads = 1
0.3490.3820.0920.092array_fill3SELECT arraySlice(arrayFill(x -> (((x.1) % 2) >= 2), arrayMap(x -> (x, toString(x)), range(10000000))), 1, 10) FORMAT Null
0.2740.2990.0910.091url_hits9SELECT count() FROM hits_100m_single WHERE NOT ignore(fragment(URL))
0.5190.5660.0910.091simple_join_query1SELECT COUNT() FROM join_table LEFT JOIN (SELECT A FROM join_table) AS right USING A
0.2640.2830.0740.091right0SELECT count() FROM hits_100m_single WHERE NOT ignore(right(URL, 16))
0.3330.3640.0910.091ngram_distance10SELECT ngramDistanceUTF8(Title, \'метрика\') AS distance FROM hits_10m_single FORMAT Null
0.2960.3230.0890.089url_hits6SELECT count() FROM hits_100m_single WHERE NOT ignore(path(URL))
0.2460.2680.0890.089url_hits0SELECT count() FROM hits_100m_single WHERE NOT ignore(protocol(URL))
0.5400.528-0.0230.089json_extract_rapidjson8SELECT \'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.2900.3170.0890.089int_parsing42SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(IsOldCounter)) SETTINGS max_threads = 1
0.2970.3230.0870.089int_parsing20SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(JavascriptEnable)) SETTINGS max_threads = 1
0.0440.0460.0530.089fuzz_bits6SELECT count() FROM zeros(10000) WHERE NOT ignore(fuzzBits(randomString(rand() % 1000), 0.7))
0.0830.0900.0890.089fuzz_bits2SELECT count() FROM zeros(10000) WHERE NOT ignore(fuzzBits(randomFixedString(1000), 0.1))
0.0570.0620.0890.089fixed_string160SELECT count() FROM test.hits WHERE ClientIP6 < RemoteIP6
1.2351.3430.0870.087date_time_short3SELECT count() FROM numbers(100000000) WHERE NOT ignore(toDateTime(\'2017-01-01 00:00:00\') + number % 100000000 + rand() % 100000 AS t, toYYYYMMDDhhmmss(t, \'Europe/Moscow\'))
0.7200.7810.0840.084url_hits14SELECT count() FROM hits_100m_single WHERE NOT ignore(URLPathHierarchy(URL))
0.3700.3820.0310.084parallel_final9SELECT sum(s) FROM collapsing_final_16p_rnd final group by key1 limit 10
0.0290.0320.0840.084least_greatest_hits2SELECT count() FROM hits_100m_single WHERE NOT ignore(greatest(ClientIP, RemoteIP))
0.5220.517-0.0110.084json_extract_rapidjson6SELECT \'rapidjson-7\', 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\', \'nested_1\'))
0.0390.036-0.0840.084consistent_hashes2SELECT yandexConsistentHash(number, 32768) FROM numbers(10000000) FORMAT Null
0.1720.1850.0780.084codecs_int_select8SELECT count(n) FROM codec_mon_UInt64_LZ4 WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.4080.4420.0840.084base644SELECT count() FROM numbers(10000000) WHERE base64Decode(base64Encode(materialize(\'This is a long string to test ClickHouse base64 functions impl..\'))) != materialize(\'This is a long string to test ClickHouse base64 functions impl..\')
0.3720.4020.0820.082url_hits12SELECT count() FROM hits_100m_single WHERE NOT ignore(extractURLParameterNames(URL))
0.1730.1870.0820.082generate_table_function5SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'d Date, dt DateTime, dtm DateTime(\\\'Europe/Moscow\\\')\', 0, 10, 10) LIMIT 1000000000);
0.1050.1130.0720.082functions_with_hash_tables3select arrayIntersect(range((1 + number % 100)), range(1, (1 + number % 100) + 1)) from numbers(100000) format Null
0.1650.1780.0820.082codecs_int_select1SELECT count(n) FROM codec_seq_UInt64_LZ4 WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.1830.1980.0810.081questdb_sum_float321SELECT sum(x) FROM `zz_Float32 NULL_Memory`
0.1680.1820.0800.080least_greatest_hits1SELECT count() FROM hits_10m_single WHERE NOT ignore(greatest(URL, Referer, Title))
0.1470.1580.0790.079synthetic_hardware_benchmark36SELECT number % 100000 AS k FROM numbers_mt(160000000) GROUP BY k FORMAT Null
0.1200.119-0.0100.079jit_small_requests2\n SELECT count() FROM numbers(100000000) WHERE NOT ignore(intHash64(number))\n
0.0480.0520.0780.078order_with_limit10SELECT intHash64(number) AS n FROM numbers_mt(200000000) ORDER BY n LIMIT 3000 FORMAT Null
0.3350.3620.0780.078array_fill1SELECT arraySlice(arrayFill(x -> (((x.1) % 2) >= 0), arrayMap(x -> (x, toString(x)), range(10000000))), 1, 10) FORMAT Null
0.2130.2300.0770.077round_methods0SELECT count() FROM numbers(100000000) WHERE NOT ignore(round(toInt64(number), -2))
0.2750.2960.0770.077format_date_time3SELECT count() FROM numbers(10000000) WHERE NOT ignore(toDateTime(\'2017-01-01 00:00:00\') + number % 100000000 + rand() % 100000 AS t, formatDateTime(t, \'%m/%d/%Y %H:%M:%S\'))
0.3490.3760.0770.077bounding_ratio0SELECT boundingRatio(number, number) FROM numbers(100000000)
0.2830.3050.0760.076url_hits1SELECT count() FROM hits_100m_single WHERE NOT ignore(domain(URL))
1.3581.4620.0760.076trim_numbers5SELECT count() FROM numbers(10000000) WHERE NOT ignore(trim(BOTH \'012345\' FROM toString(number)))
0.1250.1340.0760.076json_extract_simdjson0SELECT \'simdjson-1\', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractString(materialize(\'{"sparam":"test_string","nparam": 772}\'), \'sparam\'))
0.5240.5350.0210.076json_extract_rapidjson11SELECT \'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.3960.389-0.0200.076concat_hits10SELECT count() FROM hits_100m_single WHERE NOT ignore(format(\'{}Hello\', URL))
0.2060.192-0.0660.076bigint_arithm4SELECT toInt256(number) + number FROM numbers_mt(100000000) FORMAT Null
0.1250.1260.0090.075redundant_functions_in_order_by0SELECT CounterID, EventDate FROM hits_100m_single ORDER BY CounterID, exp(CounterID), sqrt(CounterID) FORMAT Null
0.1630.1760.0740.074json_extract_rapidjson0SELECT \'rapidjson-1\', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractString(materialize(\'{"sparam":"test_string","nparam": 772}\'), \'sparam\'))
1.1961.2500.0450.074datetime_comparison1SELECT count() FROM numbers(1000000000) WHERE materialize(now()) > toUInt32(toDateTime(\'2020-09-30 00:00:00\'))
0.4390.4720.0730.073constant_column_search11select sum(multiMatchAny(URL, [\'yandex\', \'google\', \'http\'])) from hits_100m_single
0.2660.2850.0710.071if_transform_strings_to_enum2SELECT length(URL) > 1000 ? \'LONG\' : \'SHORT\' as x FROM hits_100m_single GROUP BY x FORMAT Null SETTINGS optimize_if_transform_strings_to_enum = 1
0.4490.4810.0700.070synthetic_hardware_benchmark38SELECT number % 1000000 AS k, count() FROM numbers_mt(160000000) GROUP BY k FORMAT Null
0.5180.5540.0700.070simple_join_query2SELECT COUNT() FROM join_table AS left LEFT JOIN join_table AS right ON left.A = right.A
0.5460.515-0.0570.070json_extract_rapidjson10SELECT \'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.2110.2260.0700.070codecs_float_select8SELECT count(n) FROM codec_rnd_Float64_ZSTD WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.6520.641-0.0170.070array_element1SELECT count() FROM numbers(100000000) WHERE NOT ignore([[], [2]][number % 2 + 2])
0.5540.5920.0690.069parallel_final5SELECT count() FROM collapsing_final_16p_str_keys_rnd final
1.2061.2760.0570.069datetime_comparison0SELECT count() FROM numbers(1000000000) WHERE materialize(now()) > toString(toDateTime(\'2020-09-30 00:00:00\'))
0.2860.3050.0640.068right1SELECT count() FROM hits_100m_single WHERE NOT ignore(substring(URL, greatest(minus(plus(length(URL), 1), 16), 1)))
0.3430.3610.0510.067polymorphic_parts_l0INSERT INTO hits_wide(UserID) SELECT rand() FROM numbers(100000)
1.7701.8760.0590.066synthetic_hardware_benchmark41SELECT number % 10000000 AS k, count() FROM numbers( 10000000) GROUP BY k FORMAT Null
0.5350.5710.0660.066constant_column_search21SELECT count() FROM hits_100m_single WHERE multiMatchAny(URL, [\'chelyabinsk.74.ru\', \'doctor.74.ru\', \'transport.74.ru\', \'m.74.ru\', \'//74.ru/\', \'chel.74.ru\', \'afisha.74.ru\', \'diplom.74.ru\', \'chelfin.ru\', \'//chel.ru\', \'chelyabinsk.ru\', \'cheldoctor.ru\', \'//mychel.ru\', \'cheldiplom.ru\', \'74.ru/video\', \'market\', \'poll\', \'mail\', \'conference\', \'consult\', \'contest\', \'tags\', \'feedback\', \'pages\', \'text\'])
0.1700.1810.0630.063sort4SELECT sum(key) FROM (SELECT * FROM rand_1k_10m_32 ORDER BY key)
0.1290.1380.0630.063functions_geo3SELECT count() FROM zeros(1000000) WHERE NOT ignore(geohashDecode(toString(rand() % 1000000)))
0.1340.1350.0070.063cidr1SELECT count() FROM test.hits WHERE NOT ignore(IPv6CIDRToRange(ClientIP6, rand() % 33))
0.2060.198-0.0410.063bigint_arithm5SELECT toInt256(number) - number FROM numbers_mt(100000000) FORMAT Null
0.3190.3390.0620.062url_hits17SELECT count() FROM hits_100m_single WHERE NOT ignore(cutQueryString(URL))
0.7820.8310.0620.062least_greatest_hits0SELECT count() FROM hits_100m_single WHERE NOT ignore(least(URL, Referer))
0.1240.1320.0620.062json_extract_simdjson2SELECT \'simdjson-3\', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractInt(materialize(\'{"sparam":"test_string","nparam": 772}\'), \'nparam\'))
0.2640.2810.0620.062functions_with_hash_tables4select groupUniqArray(rand() % 100) from numbers(1000 * 1000) group by number / 1000 format Null
0.8590.9130.0620.062constant_column_search3select count(match(URL, \'yandex|google\')) FROM hits_100m_single
0.2250.2380.0570.062codecs_int_select12SELECT count(n) FROM codec_mon_UInt64_DoubleDelta WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.5190.5520.0610.061trim_urls3SELECT count() FROM hits_100m_single WHERE NOT ignore(trim(LEADING \'htpsw:/\' FROM URL))
0.2790.2950.0580.058slices_hits0SELECT count() FROM hits_100m_single WHERE NOT ignore(substring(URL, 10, 20))
0.5260.5560.0580.058simple_join_query0SELECT COUNT() FROM join_table LEFT JOIN join_table USING A
0.3290.311-0.0550.058polymorphic_parts_s2INSERT INTO hits_buffer(UserID) SELECT rand() FROM numbers(100)
0.3380.3570.0580.058distinct_combinator1SELECT x, sum(y) from (SELECT DISTINCT number % 12 AS x, number % 12321 AS y FROM numbers(10000000)) GROUP BY x
0.1340.1420.0570.057parallel_final0SELECT count() FROM collapsing_final_16p_ord final
0.0380.0410.0570.057order_with_limit9SELECT intHash64(number) AS n FROM numbers_mt(200000000) ORDER BY n LIMIT 1500 FORMAT Null
0.0240.0260.0570.057information_value0SELECT categoricalInformationValue(Age < 15, IsMobile) from hits_100m_single
0.1010.1050.0370.057conditional1SELECT count() FROM zeros(10000000) WHERE NOT ignore(multiIf(rand() % 2, toDateTime(\'2019-02-04 01:24:31\'), toDate(\'2019-02-04\')))
0.1640.162-0.0110.056format_date_time1SELECT count() FROM numbers(10000000) WHERE NOT ignore(toDateTime(\'2017-01-01 00:00:00\') + number % 100000000 + rand() % 100000 AS t, formatDateTime(t, \'%H:%M:%S\'))
0.2050.197-0.0410.056bigint_arithm6SELECT toInt256(number) * number FROM numbers_mt(100000000) FORMAT Null
0.4060.4290.0550.055url_hits11SELECT count() FROM hits_100m_single WHERE NOT ignore(extractURLParameters(URL))
0.1900.182-0.0430.055questdb_sum_int321SELECT sum(x) FROM `zz_Int32 NULL_Memory`
0.0940.092-0.0210.055jit_small_requests1\n WITH\n bitXor(number, 0x4CF2D2BAAE6DA887) AS x0,\n bitXor(x0, bitShiftRight(x0, 33)) AS x1,\n x1 * 0xff51afd7ed558ccd AS x2,\n bitXor(x2, bitShiftRight(x2, 33)) AS x3,\n x3 * 0xc4ceb9fe1a85ec53 AS x4,\n bitXor(x4, bitShiftRight(x4, 33)) AS x5\n SELECT count() FROM numbers(100000000) WHERE NOT ignore(x5)\n SETTINGS\n compile_expressions = 1,\n min_count_to_compile_expression = 1\n
0.0470.0500.0550.055insert_select_default_small_block0INSERT INTO insert_small_block_performance (x) SELECT toString(number) FROM numbers(10000);
1.2021.2050.0020.055array_fill4SELECT arraySlice(arrayFill(x -> ((x % 2) = 0), range(100000000)), 1, 10) FORMAT Null
1.0040.999-0.0060.054polymorphic_parts_s1INSERT INTO hits_compact(UserID) SELECT rand() FROM numbers(1000)
0.0940.093-0.0060.054order_by_decimals3SELECT toDecimal64(number, 8) AS n FROM numbers(1000000) ORDER BY n DESC FORMAT Null
0.7810.8020.0270.054json_extract_rapidjson9SELECT \'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.2910.3070.0540.054int_parsing19SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(CookieEnable)) SETTINGS max_threads = 1
0.3030.3200.0540.054if_string_hits1SELECT count() FROM hits_100m_single WHERE NOT ignore(rand() % 2 ? URL : \'\')
0.0890.0890.0010.054fuzz_bits3SELECT count() FROM zeros(1000) WHERE NOT ignore(fuzzBits(randomFixedString(10000), 0.5))
0.4810.5020.0420.053vectorize_aggregation_combinators4SELECT arrayReduce(\'avg\', v) FROM array_data FORMAT Null
0.7710.752-0.0250.053parallel_final23SELECT sum(s) FROM collapsing_final_1024p_rnd final group by key1 % 8192 limit 10
0.0980.1000.0220.053distinct_combinator0SELECT x, sum(DISTINCT y) from (SELECT number % 12 AS x, number % 12321 AS y FROM numbers(10000000)) GROUP BY x
0.1240.120-0.0350.053arithmetic_operations_in_aggr_func0SELECT max(-1 * (((-2 * (number * -3)) * -4) * -5)) FROM numbers(50000000)
0.3100.3260.0520.052int_parsing37SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(IsLink)) SETTINGS max_threads = 1
0.2700.266-0.0120.052bigint_arithm0SELECT toInt128(number) + number FROM numbers_mt(1000000000) FORMAT Null
0.3530.3710.0510.051url_hits8SELECT count() FROM hits_100m_single WHERE NOT ignore(queryString(URL))
0.6620.636-0.0400.051consistent_hashes5SELECT jumpConsistentHash(number, 32768) FROM numbers(10000000) FORMAT Null
0.2030.2130.0500.050removing_group_by_keys0SELECT avg(length(URL)) FROM hits_10m_single GROUP BY WatchID, CounterID FORMAT Null
0.1540.149-0.0300.050order_with_limit20SELECT intHash64(number) AS n FROM numbers_mt(50000000) ORDER BY n, n + 1, n + 2 LIMIT 65535 FORMAT Null
0.0790.0830.0450.050generate_table_function17SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'i FixedString(4)\', 0, 10, 10) LIMIT 1000000000);
0.5910.6210.0500.050date_time_645SELECT count() from dt64 where not ignore(toString(x))
0.2030.197-0.0310.050aggregation_in_order3SELECT avg(length(URL)) as x from hits_10m_single GROUP BY CounterID, EventDate, intHash32(UserID) FORMAT Null

Skipped Tests ?

TestReason
date_time_longTest is tagged as long.
nyc_taxiclickhouse_driver.errors.ServerException: Code: 60. DB::Exception: Table default.trips_mergetree doesn't exist.. Stack trace:

Test Performance Changes ?

TestRatio of speedup (-) or slowdown (+)QueriesTotal not OKChanged perfUnstable
Total+1.109x1256722141581
bit_operations_fixed_string_numbers-1.848x2220
bit_operations_fixed_string-1.634x4440
random_string_utf8-1.556x7770
float_mod-1.421x1110
decimal_casts-1.386x1515114
round_down-1.329x5422
injective_functions_inside_uniq-1.162x2220
complex_array_creation-1.154x2220
array_element-1.099x3312
cidr-1.093x2211
date_time_short-1.090x16972
insert_values_with_expressions-1.089x2110
decimal_aggregates-1.085x20532
array_join-1.085x6220
monotonous_order_by-1.075x2211
random_printable_ascii-1.065x7211
array_reduce-1.064x6330
merge_tree_many_partitions_2-1.064x1101
consistent_hashes-1.061x7532
linear_regression-1.057x5321
array_auc-1.057x1110
arithmetic_operations_in_aggr_func-1.040x6321
arithmetic-1.034x20000
conditional-1.029x8523
distinct_combinator-1.028x4422
polymorphic_parts_s-1.024x3202
if_array_string-1.022x6000
parallel_index-1.021x3000
math-1.017x20211
pre_limit_no_sorting-1.017x1000
redundant_functions_in_order_by-1.015x3101
jit_small_requests-1.014x3202
first_significant_subdomain-1.010x1000
format_date_time-1.008x6514
sort+1.003x10211
collations+1.005x2000
logical_functions_medium+1.005x20101
array_fill+1.008x6523
json_extract_rapidjson+1.012x13909
point_in_polygon+1.012x1000
extract+1.013x5000
bigint_arithm+1.014x8505
polymorphic_parts_m+1.015x3000
if_string_const+1.017x4000
bounding_ratio+1.020x2101
entropy+1.021x9000
trim_urls+1.021x6202
information_value+1.022x2101
h3+1.022x1000
fuzz_bits+1.024x7303
parse_engine_file+1.024x14101
modulo+1.025x3312
scalar+1.027x1000
decimal_parse+1.027x1000
group_array_moving_sum+1.028x12202
analyze_array_tuples+1.030x1000
mingroupby-orderbylimit1+1.035x8000
read_in_order_many_parts+1.036x6000
datetime_comparison+1.039x3202
joins_in_memory+1.041x20000
sum+1.042x161358
removing_group_by_keys+1.043x2101
parallel_final+1.044x2012111
url_hits+1.046x1910010
aggregating_merge_tree+1.049x1000
insert_select_default_small_block+1.056x1101
polymorphic_parts_l+1.056x3202
order_with_limit+1.057x201688
questdb_sum_float32+1.063x4404
select_format+1.067x20000
right+1.069x2202
order_by_read_in_order+1.075x5303
least_greatest_hits+1.075x3303
IPv6+1.078x2101
simple_join_query+1.078x4404
range+1.082x2000
website+1.085x20000
synthetic_hardware_benchmark+1.087x2016412
fixed_string16+1.091x1101
concat_hits+1.092x2013211
functions_with_hash_tables+1.095x6523
questdb_sum_int32+1.096x4404
questdb_sum_float64+1.098x4404
merge_tree_many_partitions+1.099x1000
point_in_polygon_const+1.102x1101
slices_hits+1.102x2202
uniq+1.103x20000
generate_table_function+1.105x1914311
json_extract_simdjson+1.106x1311011
order_by_decimals+1.110x5404
bloom_filter+1.113x1101
column_column_comparison+1.115x19000
set_index+1.119x8000
if_string_hits+1.120x4303
duplicate_order_by_and_distinct+1.121x3211
logical_functions_small+1.122x17716
single_fixed_string_groupby+1.122x2110
aggregation_in_order+1.126x4404
parallel_insert+1.129x1000
great_circle_dist+1.133x2202
string_sort+1.134x20101
materialized_view_parallel_insert+1.136x1000
aggregate_functions_of_group_by_keys+1.137x2202
vectorize_aggregation_combinators+1.139x5514
merge_tree_huge_pk+1.143x4220
parallel_mv+1.146x1101
push_down_limit+1.152x2000
date_time_64+1.152x1815213
general_purpose_hashes_on_UUID+1.155x2020614
cryptographic_hashes+1.156x20000
date_parsing+1.164x1000
trim_whitespace+1.164x6606
distributed_aggregation_memory_efficient+1.173x1101
sort_radix_trivial+1.177x3303
local_replica+1.179x1000
inserts_arrays_lowcardinality+1.184x2202
trim_numbers+1.184x6413
order_by_single_column+1.197x7000
basename+1.204x2202
float_formatting+1.206x2018612
general_purpose_hashes+1.213x20808
round_methods+1.217x151477
array_index_low_cardinality_strings+1.229x1010010
constant_column_search+1.230x2017017
early_constant_folding+1.232x1101
array_index_low_cardinality_numbers+1.242x9808
if_array_num+1.244x6606
codecs_float_insert+1.244x15000
sum_map+1.248x8514
visit_param_extract_raw+1.248x3303
base64_hits+1.250x1212012
base64+1.252x9707
number_formatting_formats+1.262x14505
cpu_synthetic+1.265x2011011
int_parsing+1.281x2020119
prewhere+1.282x1101
constant_column_comparison+1.292x2020416
any_anyLast+1.293x4413
read_from_comp_parts+1.294x5523
if_transform_strings_to_enum+1.297x4404
insert_parallel+1.300x1000
joins_in_memory_pmj+1.308x20312
read_hits_with_aio+1.319x4404
ngram_distance+1.320x1616016
bitCount+1.324x6615
string_join+1.331x3303
columns_hashing+1.331x5303
float_parsing+1.341x1010010
codecs_int_select+1.344x2020317
distributed_aggregation+1.353x4404
merge_table_streams+1.356x1101
set_hits+1.378x6606
functions_geo+1.381x6606
codecs_int_insert+1.395x2015213
string_set+1.405x7716
codecs_float_select+1.407x1515015
empty_string_serialization+1.417x1101
leftpad+1.423x7707
if_to_multiif+1.431x5505
random_string+1.458x7707
set+1.556x1313211
logical_functions_large+1.562x10505
empty_string_deserialization+1.592x1101
rand+1.608x3303
IPv4+1.643x4404
random_fixed_string+1.672x4404
and_function+1.679x2202
functions_coding+1.782x4404

Test Times ?

TestWall clock time, sTotal client time, sTotal queriesLongest query
(sum for all runs), s
Avg wall clock time
(sum for all runs), s
Shortest query
(sum for all runs), s
Total9066.7446601.401125630.4077.2180.307
read_in_order_many_parts305.75226.453610.52350.9580.659
read_from_comp_parts133.40427.19759.44526.6801.348
questdb_sum_float64106.29640.173418.70926.5741.830
array_index_low_cardinality_numbers205.00153.18797.47922.7771.364
datetime_comparison59.36651.405317.27019.78816.872
if_transform_strings_to_enum73.99628.262414.59318.4993.857
set_hits110.57141.332615.38918.4282.195
group_array_moving_sum217.085169.9631220.26418.0907.697
questdb_sum_int3271.48837.790417.59017.8722.180
questdb_sum_float3270.98238.017417.76917.7452.080
point_in_polygon16.0911.58111.58116.0911.581
general_purpose_hashes305.416266.8372027.81515.2703.479
read_hits_with_aio55.52113.02944.56813.8801.945
synthetic_hardware_benchmark274.78994.1952025.76113.7390.725
parallel_mv13.1351.34411.34413.1351.344
if_string_const51.19344.431412.17812.7989.061
prewhere12.46110.458110.45812.46110.458
bitCount74.15411.06863.01312.3591.321
functions_coding48.30741.864418.23412.0764.917
array_fill69.77960.618617.10911.6294.918
joins_in_memory232.164203.9022013.90311.6082.685
joins_in_memory_pmj230.841199.1112016.81711.5424.009
sum_map91.56178.907810.49011.4459.482
first_significant_subdomain11.3909.50219.50211.3909.502
float_parsing110.21396.0251020.28411.0212.082
trim_urls65.73657.190623.39510.9565.322
IPv443.5852.31440.70710.8960.413
concat_hits215.16281.1292010.32610.7580.642
empty_string_serialization10.6708.93118.93110.6708.931
materialized_view_parallel_insert10.4918.66818.66810.4918.668
simple_join_query41.94630.24047.67810.4867.491
parallel_insert10.4798.67418.67410.4798.674
array_index_low_cardinality_strings103.97758.688107.95710.3972.913
empty_string_deserialization9.7581.99011.9909.7581.990
array_element29.00924.89939.3429.6696.328
columns_hashing48.32541.738521.3349.6651.740
basename19.20416.32828.9789.6027.350
date_time_short153.630133.8041618.9349.6014.206
arithmetic190.440164.6752012.0159.5222.528
polymorphic_parts_m28.45923.404314.6339.4864.070
base64_hits113.56098.9321216.2299.4631.379
trim_numbers54.82747.521619.8059.1371.710
polymorphic_parts_s27.28422.304313.9039.0943.859
select_format181.819158.8802015.7089.0902.968
and_function18.10815.437214.1389.0541.298
parallel_index26.90022.069314.5898.9663.696
parallel_final176.154132.0292016.0298.8071.963
codecs_float_insert123.212106.7461510.9088.2143.378
entropy73.14763.374913.0478.1271.945
leftpad56.12348.711710.7258.0175.352
int_parsing155.755135.8602014.6797.7873.798
redundant_functions_in_order_by23.07719.775316.3167.6921.709
general_purpose_hashes_on_UUID152.173132.6812016.8417.6080.494
parse_engine_file106.13284.0521411.8177.5800.949
constant_column_comparison150.238130.920209.6217.5112.429
set95.02982.4601313.2867.3091.777
logical_functions_large72.38862.8481030.4077.2382.314
decimal_aggregates144.69994.2342014.3847.2340.882
string_join20.96214.78236.2196.9873.154
json_extract_rapidjson85.05274.0791310.9776.5422.256
website130.636115.2342022.8466.5310.366
number_formatting_formats90.29276.2491419.1816.4491.868
url_hits122.371106.6661913.7896.4403.612
string_sort127.373110.8442021.1526.3680.421
cpu_synthetic125.778109.4632016.1456.2881.006
functions_with_hash_tables37.20832.09169.1476.2011.512
array_reduce37.16732.04468.0466.1942.559
merge_tree_huge_pk24.74714.95144.0246.1862.903
insert_values_with_expressions12.18710.22225.7776.0934.445
single_fixed_string_groupby12.1858.04324.0226.0924.021
decimal_casts87.96669.7741519.3255.8641.054
bloom_filter5.8484.65814.6585.8484.658
codecs_int_insert116.282100.242208.8775.8141.825
random_printable_ascii40.62534.965713.2675.8031.739
column_column_comparison107.16194.4841916.7175.6401.350
generate_table_function105.76492.0911912.8905.5660.593
least_greatest_hits16.59914.172311.2855.5330.434
uniq109.44994.5862025.2595.4720.617
bounding_ratio10.8959.12525.0625.4474.063
cryptographic_hashes107.89493.8822017.9745.3940.752
polymorphic_parts_l16.06512.96735.6955.3552.289
ngram_distance85.06973.981167.6635.3163.334
string_set36.97628.75876.0135.2822.427
decimal_parse5.2484.15414.1545.2484.154
duplicate_order_by_and_distinct15.55713.168310.1315.1851.321
float_formatting103.21989.904209.4935.1601.079
right9.7448.05924.1714.8723.887
if_string_hits19.44716.60249.6404.8611.007
sort46.31639.751108.3774.6312.259
distinct_combinator18.50915.74744.9104.6271.414
analyze_array_tuples4.5854.03614.0364.5854.036
codecs_float_select68.14043.639155.4634.5421.131
consistent_hashes31.36328.32579.0454.4800.528
jit_small_requests13.39010.52537.4714.4631.343
vectorize_aggregation_combinators22.30118.04256.9074.4600.418
bit_operations_fixed_string_numbers8.8197.27923.7754.4093.503
array_join26.23522.48465.2734.3721.324
math87.40275.995208.9064.3701.594
round_down21.30818.165514.0374.2610.545
collations8.4776.97226.2024.2380.769
base6437.97832.79695.9374.2191.393
logical_functions_medium84.36171.604204.6054.2181.272
extract20.59017.58654.5754.1182.018
aggregation_in_order16.40513.91945.3164.1010.475
modulo11.8079.91635.1753.9352.356
json_extract_simdjson50.97144.167137.9053.9201.766
bigint_arithm31.29526.98683.9113.9112.780
merge_tree_many_partitions_23.9031.97311.9733.9031.973
merge_tree_simple_select3.8511.06411.0643.8511.064
merge_tree_many_partitions3.7991.35011.3503.7991.350
mingroupby-orderbylimit130.28025.24684.6313.7851.481
removing_group_by_keys7.3415.91522.9623.6702.952
range7.2645.94424.2963.6321.647
set_index28.98621.10584.1323.6230.498
format_date_time21.70218.58064.0203.6170.902
local_replica3.6052.73712.7373.6052.737
if_array_string21.43718.33764.3123.5721.873
codecs_int_select71.24847.207205.2423.5621.081
IPv66.8645.40523.8403.4321.565
logical_functions_small57.91149.716174.5663.4062.163
date_time_6460.26251.3971811.0203.3470.532
if_to_multiif16.23113.73956.0543.2460.686
complex_array_creation6.4695.23622.7063.2342.530
inserts_arrays_lowcardinality6.4414.79223.7883.2201.003
aggregating_merge_tree3.1901.53811.5383.1901.538
visit_param_extract_raw9.4757.86535.3533.1580.815
trim_whitespace18.5247.07861.5653.0870.551
slices_hits6.0524.86224.0303.0260.832
round_methods45.17639.113153.7933.0112.110
array_auc2.9562.14712.1472.9562.147
functions_geo17.64215.02564.7412.9401.154
float_mod2.9042.10812.1082.9042.108
distributed_aggregation_memory_efficient2.7962.02812.0282.7962.028
scalar2.7950.96710.9672.7950.967
injective_functions_inside_uniq5.5744.45922.2372.7872.221
order_by_read_in_order13.89911.57356.0062.7790.874
order_with_limit53.80846.585205.9202.6900.307
order_by_single_column18.23215.53175.9072.6040.497
jit_large_requests5.1514.49324.0212.5750.472
conditional20.54817.55783.8462.5681.155
monotonous_order_by4.9943.95522.5982.4971.356
linear_regression12.3219.85754.7272.4640.425
if_array_num14.51212.25162.6332.4181.449
insert_parallel2.3671.69111.6912.3671.691
point_in_polygon_const2.3451.61011.6102.3451.610
early_constant_folding2.2561.22211.2222.2561.222
h32.1571.47411.4742.1571.474
rand6.1994.96433.0942.0660.684
sum33.02328.495163.3222.0630.640
arithmetic_operations_in_aggr_func11.0249.23461.9251.8370.859
date_parsing1.8271.17811.1781.8271.178
sort_radix_trivial5.4584.33231.6311.8191.197
aggregate_functions_of_group_by_keys3.6212.57921.8771.8100.701
merge_table_streams1.6951.04511.0451.6951.045
distributed_aggregation6.7225.43541.7291.6801.223
count1.6480.90010.9001.6480.900
cidr3.2662.45721.8901.6330.567
random_fixed_string6.3065.09841.5991.5760.883
pre_limit_no_sorting1.5410.91410.9141.5410.914
random_string10.5038.77472.5451.5000.591
fixed_string161.4850.83610.8361.4850.836
bit_operations_fixed_string5.6784.52741.2321.4190.876
order_by_decimals6.9365.63351.7101.3870.502
insert_select_default_small_block1.3170.72310.7231.3170.723
fuzz_bits8.6737.17971.4141.2390.638
random_string_utf88.2966.83071.2541.1850.608
push_down_limit2.1211.41721.0191.0600.397
great_circle_dist1.9781.32420.9330.9890.391
any_anyLast3.5532.69940.7170.8880.648
information_value1.6000.97820.6160.8000.362

Metric Changes ?

MetricOld median valueNew median valueRelative differenceTimes difference
MaxPartCountForPartition780.1421.142
MemoryCode2877808643145318400.0921.092
jemalloc.arenas.all.pmuzzy99834.5106397.50.0651.065
jemalloc.arenas.all.pdirty4200584436440.0561.056
jemalloc.mapped34052341763218731008-0.0541.057
jemalloc.resident32649871363074861056-0.0581.061
MemoryShared7372800067698688-0.0811.089
jemalloc.active314624000247394304-0.2131.271
jemalloc.arenas.all.pactive76812.560399-0.2131.271
jemalloc.allocated266246348200704156-0.2461.326