ClickHouse performance comparison

Tested Commits ?

OldNew
commit 51b9aaf4d8ee9ec7c6959854b598dd2dcf452f27 (origin/master)
Merge: 4578d8981 79f510d63
Author: Alexander Kuzmenkov <36882414+akuzm@users.noreply.github.com>
Date:   Mon Sep 28 20:03:32 2020 +0300

    Merge pull request #15363 from ClickHouse/format-regexp-raw
    
    Add support for "Raw" column format for Regexp format
commit 81afc197d50544fb4ac816c6722894070364b494
Author: Alexander Kuzmenkov 
Date:   Mon Sep 28 21:53:28 2020 +0300

    restart

Real tested commit is:
commit cd963c19f8de17ee9d9155967f639c47718e5ffc (HEAD -> master, pr)
Merge: 51b9aaf4d 81afc197d
Author: alesapin 
Date:   Mon Sep 28 18:53:51 2020 +0000

    Merge 81afc197d50544fb4ac816c6722894070364b494 into 51b9aaf4d8ee9ec7c6959854b598dd2dcf452f27

Error Summary ?

Description
Some queries have unexpected duration
The query no. 6 of test 'array_index_low_cardinality_numbers' has slowed down
The query no. 1 of test 'bitCount' has slowed down
The query no. 1 of test 'merge_tree_huge_pk' has slowed down
The query no. 2 of test 'merge_tree_huge_pk' has slowed down
The query no. 26 of test 'int_parsing' has slowed down
The query no. 3 of test 'IPv4' has slowed down
The query no. 18 of test 'concat_hits' has slowed down
The query no. 2 of test 'trim_whitespace' has slowed down
The query no. 17 of test 'constant_column_search' 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

Unexpected Query Duration ?

ProblemMarked as "short"?Run time, sTest#Query
normal queries must run longer than 0.1 s00.012general_purpose_hashes_on_UUID45SELECT count() from numbers(1000000) where not ignore(farmHash64(toDecimal128(number, 23)))
normal queries must run longer than 0.1 s00.0145general_purpose_hashes_on_UUID46SELECT count() from numbers(1000000) where not ignore(metroHash64(toDecimal128(number, 23)))
normal queries must run longer than 0.1 s00.0113general_purpose_hashes_on_UUID47SELECT count() from numbers(1000000) where not ignore(murmurHash2_32(toDecimal128(number, 23)))
normal queries must run longer than 0.1 s00.0128general_purpose_hashes_on_UUID49SELECT count() from numbers(1000000) where not ignore(murmurHash3_32(toDecimal128(number, 23)))
normal queries must run longer than 0.1 s00.0158general_purpose_hashes_on_UUID52SELECT count() from numbers(1000000) where not ignore(hiveHash(toDecimal128(number, 23)))
normal queries must run longer than 0.1 s00.0133round_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.0540.011-4.814x-0.7920.791general_purpose_hashes_on_UUID47SELECT count() from numbers(1000000) where not ignore(murmurHash2_32(toDecimal128(number, 23)))
0.1830.038-4.748x-0.7900.789general_purpose_hashes_on_UUID59SELECT count() from numbers_mt(100000000) where not ignore(murmurHash2_64(toDecimal128(number, 23)))
0.0630.013-4.751x-0.7900.789round_down2SELECT count() FROM zeros(10000000) WHERE NOT ignore(roundAge(rand() % 100))
0.0570.012-4.453x-0.7760.775general_purpose_hashes_on_UUID49SELECT count() from numbers(1000000) where not ignore(murmurHash3_32(toDecimal128(number, 23)))
0.0510.012-4.308x-0.7670.766general_purpose_hashes_on_UUID45SELECT count() from numbers(1000000) where not ignore(farmHash64(toDecimal128(number, 23)))
0.0530.014-3.710x-0.7310.730general_purpose_hashes_on_UUID46SELECT count() from numbers(1000000) where not ignore(metroHash64(toDecimal128(number, 23)))
0.1900.051-3.692x-0.7290.728general_purpose_hashes_on_UUID57SELECT count() from numbers_mt(100000000) where not ignore(metroHash64(toDecimal128(number, 23)))
0.4130.121-3.410x-0.7070.706bit_operations_fixed_string_numbers1SELECT count() FROM numbers(100000000) WHERE NOT ignore(bitXor(reinterpretAsFixedString(number), reinterpretAsFixedString(0xabcd0123cdef4567)))
0.1750.053-3.299x-0.6970.696general_purpose_hashes_on_UUID63SELECT count() from numbers_mt(100000000) where not ignore(hiveHash(toDecimal128(number, 23)))
0.0510.015-3.246x-0.6910.690general_purpose_hashes_on_UUID52SELECT count() from numbers(1000000) where not ignore(hiveHash(toDecimal128(number, 23)))
0.1840.057-3.211x-0.6890.688general_purpose_hashes_on_UUID64SELECT count() from numbers_mt(100000000) where not ignore(xxHash32(toDecimal128(number, 23)))
0.3450.115-2.990x-0.6660.665decimal_casts3SELECT toUInt64(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t FORMAT Null
0.1400.054-2.591x-0.6140.613decimal_aggregates19SELECT varPop(d64), varSamp(d64), stddevPop(d64) FROM (SELECT * FROM t LIMIT 1000000)
0.3800.175-2.172x-0.5400.539decimal_casts11SELECT toInt32(d128), toInt64(d128), toInt128(d128) FROM t FORMAT Null
0.0740.035-2.125x-0.5290.528any_anyLast1SELECT anyLast(-1 * (((-2 * (number * -3)) * -4) * -5)) FROM numbers(120000000)
0.1460.072-2.029x-0.5080.507decimal_aggregates20SELECT varPop(d128), varSamp(d128), stddevPop(d128) FROM (SELECT * FROM t LIMIT 1000000)
0.9070.453-2.001x-0.5010.500general_purpose_hashes_on_UUID21SELECT count() from zeros(100000000) where not ignore(murmurHash3_32(generateUUIDv4()))
0.2340.119-1.957x-0.4890.488logical_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.1330.071-1.881x-0.4690.468decimal_casts12SELECT toFloat32(d32), toFloat32(d64), toFloat32(d128) FROM t FORMAT Null
0.1970.106-1.859x-0.4620.461decimal_casts1SELECT toInt32(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t FORMAT Null
0.2000.111-1.793x-0.4430.442decimal_casts0SELECT toUInt32(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t FORMAT Null
0.3690.208-1.768x-0.4350.434ngram_distance14SELECT ngramDistanceCaseInsensitiveUTF8(URL, \'как дЕлА\') AS distance FROM hits_10m_single FORMAT Null
0.1450.082-1.759x-0.4320.431decimal_casts13SELECT toFloat64(d32), toFloat64(d64), toFloat64(d128) FROM t FORMAT Null
0.1040.059-1.754x-0.4300.429bit_operations_fixed_string2SELECT count() FROM test.hits WHERE NOT ignore(bitXor(toFixedString(ClientIP6, 16), IPv6StringToNum(\'ffff:ffff:ffff:0000:0000:0000:0000:0000\')))
0.3720.213-1.746x-0.4280.427ngram_distance15SELECT ngramDistanceCaseInsensitiveUTF8(URL, \'Чем зАнимаешЬся\') AS distance FROM hits_10m_single FORMAT Null
0.1080.062-1.743x-0.4270.426bit_operations_fixed_string0SELECT count() FROM test.hits WHERE NOT ignore(bitAnd(toFixedString(ClientIP6, 16), IPv6StringToNum(\'ffff:ffff:ffff:0000:0000:0000:0000:0000\')))
0.2010.116-1.722x-0.4200.419decimal_casts2SELECT toInt64(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t FORMAT Null
0.3600.213-1.690x-0.4090.408ngram_distance11SELECT ngramDistanceUTF8(URL, \'как дела\') AS distance FROM hits_10m_single FORMAT Null
0.3560.211-1.686x-0.4080.407ngram_distance12SELECT ngramDistanceUTF8(URL, \'чем занимаешься\') AS distance FROM hits_10m_single FORMAT Null
0.1060.063-1.686x-0.4080.407random_string_utf83SELECT count() FROM zeros(1000) WHERE NOT ignore(randomStringUTF8(10000))
0.1010.061-1.648x-0.3930.392bit_operations_fixed_string1SELECT count() FROM test.hits WHERE NOT ignore(bitOr(toFixedString(ClientIP6, 16), IPv6StringToNum(\'ffff:ffff:ffff:0000:0000:0000:0000:0000\')))
0.0540.033-1.634x-0.3880.387random_string_utf85SELECT count() FROM zeros(100000) WHERE NOT ignore(randomStringUTF8(rand() % 100))
0.1020.062-1.624x-0.3850.384random_string_utf81SELECT count() FROM zeros(100000) WHERE NOT ignore(randomStringUTF8(100))
0.1060.066-1.598x-0.3750.374random_string_utf82SELECT count() FROM zeros(10000) WHERE NOT ignore(randomStringUTF8(1000))
0.0530.033-1.586x-0.3700.369random_string_utf86SELECT count() FROM zeros(10000) WHERE NOT ignore(randomStringUTF8(rand() % 1000))
0.1010.064-1.577x-0.3660.365random_string_utf80SELECT count() FROM zeros(1000000) WHERE NOT ignore(randomStringUTF8(10))
0.4140.566+1.365x0.3650.363array_index_low_cardinality_numbers6SELECT count() FROM perf_lc_num WHERE indexOf(arr, num) > 0
0.2150.140-1.529x-0.3460.345decimal_casts4SELECT toInt128(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t FORMAT Null
0.3870.254-1.525x-0.3450.344date_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.0610.040-1.511x-0.3380.337random_string_utf84SELECT count() FROM zeros(1000000) WHERE NOT ignore(randomStringUTF8(rand() % 10))
0.3830.261-1.468x-0.3190.318date_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.0940.123+1.315x0.3140.312bitCount1SELECT bitCount(toUInt32(number)) FROM numbers(100000000) FORMAT Null
0.0340.044+1.313x0.3120.241merge_tree_huge_pk1SELECT count() FROM huge_pk WHERE c001 in (2,3) and c400 in (10,0) and c100 < 2
0.0500.034-1.448x-0.3100.309cidr0SELECT count() FROM test.hits WHERE NOT ignore(IPv4CIDRToRange(ClientIP, rand() % 33))
0.0110.015+1.305x0.3050.210merge_tree_huge_pk2SELECT count() FROM huge_pk WHERE c700 > 10
0.4960.348-1.427x-0.3000.299ngram_distance8SELECT ngramDistanceUTF8(Title, URL) AS distance FROM hits_10m_single FORMAT Null
0.3650.257-1.419x-0.2960.295date_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.7680.994+1.293x0.2930.283int_parsing26SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(SearchPhrase)) SETTINGS max_threads = 1
0.0880.062-1.412x-0.2920.291synthetic_hardware_benchmark11SELECT count() FROM numbers_mt(1600000000) WHERE NOT ignore(number / 7)
0.1750.125-1.398x-0.2850.284decimal_casts8SELECT toFloat64(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t FORMAT Null
0.1750.126-1.382x-0.2770.273float_mod0SELECT count() FROM numbers(100000000) WHERE NOT ignore(number % 1.1)
0.1200.087-1.369x-0.2700.269conditional4SELECT count() FROM zeros(10000000) WHERE NOT ignore(if(rand() % 2, toDateTime(rand()), toDate(rand())))
0.2270.166-1.368x-0.2690.268format_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\'))
1.1490.842-1.364x-0.2680.267round_down4SELECT count() FROM numbers(10000000) WHERE NOT ignore(roundDown(rand() % 65536, (SELECT groupArray(number) FROM numbers(65536))))
0.3460.254-1.361x-0.2660.265ngram_distance13SELECT ngramDistanceCaseInsensitiveUTF8(Title, \'Метрика\') AS distance FROM hits_10m_single FORMAT Null
0.3700.276-1.339x-0.2540.252date_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.4420.331-1.334x-0.2500.250math4SELECT count() FROM numbers(100000000) WHERE NOT ignore(exp10(toFloat64(number)))
0.0640.048-1.332x-0.2490.248format_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.3160.238-1.327x-0.2470.246parallel_index0select sum(x) from test_parallel_index where toStartOfDay(toStartOfDay(toStartOfDay(toStartOfDay(toStartOfDay(toStartOfDay(toStartOfDay(toDateTime(x)))))))) in (select toDateTime(number * 8) from numbers(131072));
0.2690.203-1.324x-0.2460.245format_date_time2SELECT count() FROM numbers(10000000) WHERE NOT ignore(toDateTime(\'2017-01-01 00:00:00\') + number % 100000000 + rand() % 100000 AS t, formatDateTime(t, \'%Y-%m-%d %H:%M:%S\'))
0.0930.071-1.297x-0.2290.228codecs_int_insert5INSERT INTO codec_seq_UInt64_DoubleDelta (n) SELECT number FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.3130.241-1.295x-0.2280.227codecs_int_insert6INSERT INTO codec_seq_UInt64_Gorilla (n) SELECT number FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.1770.137-1.284x-0.2220.221codecs_int_select4SELECT count(n) FROM codec_seq_UInt64_T64 WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.1670.130-1.281x-0.2200.219codecs_int_insert3INSERT INTO codec_seq_UInt64_Delta (n) SELECT number FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.4140.325-1.271x-0.2140.213codecs_int_insert13INSERT INTO codec_mon_UInt64_Gorilla (n) SELECT number*512+(intHash64(number)%512) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.6790.534-1.270x-0.2140.213date_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.0280.034+1.211x0.2130.210IPv43SELECT count() FROM ips_v4 WHERE NOT ignore(IPv4ToIPv6(IPv4StringToNum(materialize(ip)))) SETTINGS max_threads=1
0.1610.127-1.266x-0.2110.210codecs_int_insert0INSERT INTO codec_seq_UInt64_NONE (n) SELECT number FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.6660.526-1.265x-0.2100.209date_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.1630.128-1.266x-0.2100.209bitCount2SELECT bitCount(toUInt16(number)) FROM numbers(100000000) FORMAT Null
0.6680.529-1.263x-0.2090.208date_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))
0.3450.274-1.256x-0.2050.204ngram_distance9SELECT ngramDistanceUTF8(Title, SearchPhrase) AS distance FROM hits_10m_single FORMAT Null
0.3260.259-1.257x-0.2050.204ngram_distance10SELECT ngramDistanceUTF8(Title, \'метрика\') AS distance FROM hits_10m_single FORMAT Null
0.2720.217-1.255x-0.2040.203format_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.3550.283-1.252x-0.2020.201insert_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.1640.131-1.250x-0.2010.195decimal_casts7SELECT toFloat32(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t FORMAT Null
0.2520.201-1.250x-0.2010.200bit_operations_fixed_string_numbers0SELECT count() FROM numbers(100000000) WHERE NOT ignore(bitXor(reinterpretAsFixedString(number), reinterpretAsFixedString(number + 1)))
0.1910.153-1.247x-0.1990.184codecs_int_insert17INSERT INTO codec_rnd_UInt64_Delta (n) SELECT intHash64(number) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.1040.083-1.246x-0.1980.197generate_table_function11SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'i Array(Nullable(Int32))\', 0, 10, 10) LIMIT 100000000);
0.4420.357-1.238x-0.1930.192general_purpose_hashes_on_UUID4SELECT count() from zeros(100000000) where not ignore(farmHash64(materialize(toUUID(\'61f0c404-5cb3-11e7-907b-a6006ad3dba0\'))))
0.2190.177-1.238x-0.1930.192synthetic_hardware_benchmark20SELECT number % 10 AS k, count() FROM numbers(100000000) GROUP BY k FORMAT Null
0.0870.104+1.190x0.1900.182concat_hits18SELECT count() FROM hits_100m_single WHERE NOT ignore(concat(MobilePhoneModel, \'Hello\', PageCharset))
0.4150.337-1.229x-0.1870.186float_formatting10SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(number / 3))
0.4890.398-1.227x-0.1860.185float_formatting22SELECT count() FROM zeros(10000000) WHERE NOT ignore(toString(1 / rand()))
0.2400.195-1.226x-0.1860.185codecs_int_insert7INSERT INTO codec_mon_UInt64_NONE (n) SELECT number*512+(intHash64(number)%512) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.1930.157-1.227x-0.1850.184array_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.1830.149-1.225x-0.1840.183codecs_int_select11SELECT count(n) FROM codec_mon_UInt64_T64 WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.1390.113-1.223x-0.1830.182generate_table_function9SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'i Tuple(Int32, Int64)\', 0, 10, 10) LIMIT 1000000000);
0.1110.091-1.222x-0.1830.182sum5SELECT sum(toFloat64(number)) FROM numbers(100000000)
0.5030.411-1.221x-0.1820.181float_formatting11SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(number / 7))
0.1830.150-1.218x-0.1800.179codecs_int_insert14INSERT INTO codec_rnd_UInt64_NONE (n) SELECT intHash64(number) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.1670.137-1.219x-0.1800.179generate_table_function15SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'i UUID\', 0, 10, 10) LIMIT 1000000000);
0.5900.485-1.215x-0.1780.177float_formatting23SELECT count() FROM zeros(10000000) WHERE NOT ignore(toString(rand() / 0xFFFFFFFF))
0.1940.160-1.213x-0.1770.176codecs_int_insert15INSERT INTO codec_rnd_UInt64_LZ4 (n) SELECT intHash64(number) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.2190.180-1.212x-0.1760.175complex_array_creation1SELECT count() FROM zeros(10000000) WHERE NOT ignore([[], [zero]])
0.3890.323-1.205x-0.1710.170float_formatting9SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(number / 2))
0.2460.205-1.202x-0.1690.168codecs_int_insert4INSERT INTO codec_seq_UInt64_T64 (n) SELECT number FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.4170.347-1.202x-0.1690.168modulo1SELECT number % 255 FROM numbers(300000000) FORMAT Null
0.2740.229-1.196x-0.1650.164generate_table_function8SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'d32 Decimal32(4), d64 Decimal64(8), d128 Decimal128(16)\', 0, 10, 10) LIMIT 1000000000);
0.1320.110-1.197x-0.1650.164generate_table_function7SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'f32 Float32, f64 Float64\', 0, 10, 10) LIMIT 1000000000);
0.1010.118+1.163x0.1630.153set9SELECT count() FROM zeros_mt(100000000) WHERE rand64() IN (SELECT number FROM system.numbers LIMIT 1048576)
0.1410.118-1.192x-0.1620.161codecs_int_select18SELECT count(n) FROM codec_rnd_UInt64_T64 WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.1380.116-1.190x-0.1610.160synthetic_hardware_benchmark14SELECT count() FROM numbers( 100000000) WHERE NOT ignore(number % 34908756)
0.1610.135-1.190x-0.1600.159format_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.2430.204-1.189x-0.1600.159conditional6SELECT count() FROM zeros(10000000) WHERE NOT ignore(if(rand() % 2, [toDateTime(rand())], [toDate(rand())]))
0.4830.406-1.188x-0.1590.158random_printable_ascii6SELECT count() FROM zeros(1000000) WHERE NOT ignore(randomPrintableASCII(rand() % 1000))
0.3600.303-1.188x-0.1590.158generate_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.2370.200-1.187x-0.1580.157codecs_int_insert10INSERT INTO codec_mon_UInt64_Delta (n) SELECT number*512+(intHash64(number)%512) FROM system.numbers LIMIT 20000000 SETTINGS max_threads=1
0.1150.097-1.183x-0.1560.155math36SELECT count() FROM numbers(10000000) WHERE NOT ignore(atan(toFloat64(number)))
0.3600.305-1.179x-0.1530.152generate_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.1740.148-1.174x-0.1490.148generate_table_function16SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'i Array(Nullable(UUID))\', 0, 10, 10) LIMIT 100000000);
0.1810.154-1.173x-0.1490.148generate_table_function5SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'d Date, dt DateTime, dtm DateTime(\\\'Europe/Moscow\\\')\', 0, 10, 10) LIMIT 1000000000);
0.1720.146-1.172x-0.1480.147injective_functions_inside_uniq1SELECT uniq(hex(hex(number))) FROM numbers(50000000)
0.1080.093-1.166x-0.1440.143array_index_low_cardinality_numbers0SELECT count() FROM perf_lc_num WHERE num = 42
0.0330.028-1.161x-0.1400.139linear_regression1SELECT stochasticLinearRegression(Age, Income, ParamPrice, Robotness, RefererHash) FROM test.hits FORMAT Null
0.0920.079-1.161x-0.1390.138order_by_decimals3SELECT toDecimal64(number, 8) AS n FROM numbers(1000000) ORDER BY n DESC FORMAT Null
0.5970.515-1.157x-0.1370.136float_formatting7SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(toFloat64(number % 100 + 0.123)))
0.0990.086-1.153x-0.1340.133array_join0SELECT count() FROM (SELECT [number] a, [number * 2] b FROM numbers(10000000)) AS t ARRAY JOIN a, b WHERE NOT ignore(a + b)
0.2230.193-1.151x-0.1320.131generate_table_function4SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'i Nullable(Enum16(\\\'h\\\' = 1, \\\'w\\\' = 5 , \\\'o\\\' = -200))\', 0, 10, 10) LIMIT 1000000000);
0.9760.850-1.148x-0.1300.129array_fill0SELECT arraySlice(arrayFill(x -> ((x % 2) >= 0), range(100000000)), 1, 10) FORMAT Null
0.1580.138-1.148x-0.1300.129array_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.9760.851-1.147x-0.1290.128questdb_sum_float321SELECT sum(x) FROM `zz_Float32_MergeTree ORDER BY tuple()`
0.4100.358-1.145x-0.1280.127synthetic_hardware_benchmark26SELECT number % 256 AS k, count(), sum(number), avg(number) FROM numbers(100000000) GROUP BY k FORMAT Null
0.6040.529-1.142x-0.1260.125float_formatting12SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(number / 16))
0.0640.056-1.142x-0.1260.125codecs_float_select5SELECT count(n) FROM codec_mon_Float64_NONE WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.1500.131-1.143x-0.1260.125generate_table_function3SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'i Array(Nullable(Enum8(\\\'hello\\\' = 1, \\\'world\\\' = 5)))\', 0, 10, 10) LIMIT 100000000);
0.3560.312-1.141x-0.1250.124date_time_6413SELECT count() from dt64 where not ignore(addDays(x, 1))
0.0980.110+1.125x0.1250.119trim_whitespace2SELECT trimBoth(value) FROM whitespaces FORMAT Null
0.1640.143-1.141x-0.1240.123round_methods5SELECT count() FROM numbers(100000000) WHERE NOT ignore(round(toFloat64(number), -2))
0.1310.115-1.140x-0.1240.123sum13SELECT sum(toNullable(toFloat64(number))) FROM numbers(100000000)
0.1660.146-1.138x-0.1220.121injective_functions_inside_uniq0SELECT uniq(negate(negate(negate(number)))) FROM numbers(50000000)
0.0890.078-1.135x-0.1190.118order_with_limit16SELECT intHash64(number) AS n FROM numbers_mt(200000000) ORDER BY n, n + 1, n + 2 LIMIT 1500 FORMAT Null
0.6250.551-1.134x-0.1190.118float_formatting30SELECT count() FROM zeros(10000000) WHERE NOT ignore(toString(reinterpretAsFloat64(reinterpretAsString(rand64()))))
0.0730.064-1.136x-0.1190.118sum8SELECT sum(toNullable(number)) FROM numbers(100000000)
0.4950.437-1.132x-0.1170.116vectorize_aggregation_combinators4SELECT arrayReduce(\'avg\', v) FROM array_data FORMAT Null
0.0810.072-1.131x-0.1170.116sum3SELECT sum(toUInt8(number)) FROM numbers(100000000)
0.6040.534-1.130x-0.1160.115array_reduce5SELECT arrayReduceInRanges(\'sum\', arrayZip(range(1000000), range(1000000)), range(100000000))[123456]
1.1691.034-1.130x-0.1160.115questdb_sum_int323SELECT sum(x) FROM `zz_Int32 NULL_MergeTree ORDER BY tuple()`
0.0730.064-1.129x-0.1150.114order_by_read_in_order3SELECT * FROM hits_100m_single WHERE CounterID IN (152220, 168777, 149234, 149234) ORDER BY CounterID DESC, EventDate DESC LIMIT 100
0.1600.142-1.127x-0.1130.112round_methods9SELECT count() FROM numbers(100000000) WHERE NOT ignore(trunc(toFloat64(number), -2))
0.6580.586-1.124x-0.1110.110array_element1SELECT count() FROM numbers(100000000) WHERE NOT ignore([[], [2]][number % 2 + 2])
0.0230.020-1.120x-0.1100.109order_with_limit8SELECT intHash64(number) AS n FROM numbers_mt(200000000) ORDER BY n LIMIT 100 FORMAT Null
0.1590.142-1.123x-0.1100.109round_methods8SELECT count() FROM numbers(100000000) WHERE NOT ignore(ceil(toFloat64(number), -2))
0.1070.095-1.123x-0.1100.109order_with_limit17SELECT intHash64(number) AS n FROM numbers_mt(200000000) ORDER BY n, n + 1, n + 2 LIMIT 3000 FORMAT Null
0.3350.299-1.121x-0.1090.108url_hits2SELECT count() FROM hits_100m_single WHERE NOT ignore(domainWithoutWWW(URL))
0.3600.321-1.120x-0.1080.107date_time_short6SELECT count() FROM numbers(100000000) WHERE NOT ignore(toDate(\'2017-01-01\') + number % 1000 + rand() % 10 AS t, toMonday(t))
0.4130.369-1.119x-0.1080.102base644SELECT 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.6770.604-1.121x-0.1080.107array_element0SELECT count() FROM numbers(100000000) WHERE NOT ignore([[1], [2]][number % 2 + 2])
0.9180.820-1.119x-0.1070.106constant_column_search19SELECT count() FROM hits_100m_single WHERE match(URL, \'about/address|for_woman|^https?://lm-company.ruy/$|ultimateguitar.com\')
0.1590.142-1.118x-0.1070.106round_methods6SELECT count() FROM numbers(100000000) WHERE NOT ignore(roundBankers(toFloat64(number), -2))
0.1320.118-1.117x-0.1060.105arithmetic_operations_in_aggr_func0SELECT max(-1 * (((-2 * (number * -3)) * -4) * -5)) FROM numbers(50000000)
0.1190.106-1.116x-0.1050.104duplicate_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.0380.034-1.113x-0.1030.096consistent_hashes1SELECT yandexConsistentHash(number, 500) FROM numbers(10000000) FORMAT Null
0.8210.737-1.114x-0.1030.102polymorphic_parts_s1INSERT INTO hits_compact(UserID) SELECT rand() FROM numbers(1000)
0.2350.211-1.115x-0.1030.102base648SELECT count() FROM numbers(10000000) WHERE tryBase64Decode(base64Encode(toString(number))) != toString(number)
0.2990.269-1.112x-0.1020.101date_time_short9SELECT count() FROM numbers(100000000) WHERE NOT ignore(toDate(\'2017-01-01\') + number % 1000 + rand() % 10 AS t, toUnixTimestamp(t))
0.3470.383+1.102x0.1020.101constant_column_search17select sum(multiSearchFirstIndex(URL, [\'yandex\', \'google\', \'http\', \'facebook\', \'google\'])) from hits_100m_single
0.2250.202-1.113x-0.1020.101linear_regression2SELECT stochasticLinearRegressionState(0.0001, 0, 15, \'Momentum\')(Age, Income, ParamPrice, Robotness, RefererHash) FROM hits_100m_single FORMAT Null
0.0390.035-1.112x-0.1010.100rand0SELECT count() FROM (SELECT rand() FROM zeros(100000000))
0.3760.339-1.111x-0.1010.100distinct_combinator2SELECT sumIf(DISTINCT number % 10, number % 5 = 2) FROM numbers(100000000)
0.0860.078-1.110x-0.1000.099duplicate_order_by_and_distinct1SELECT DISTINCT * FROM (SELECT DISTINCT CounterID, EventDate FROM hits_10m_single) FORMAT Null
0.0650.059-1.111x-0.1000.099rand1SELECT count() FROM (SELECT rand64() FROM zeros(100000000))
0.7070.638-1.108x-0.0990.098float_formatting6SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(toFloat64(number % 100 + 0.5)))
0.3250.294-1.106x-0.0970.096linear_regression3SELECT stochasticLinearRegressionState(0.0001, 0, 15, \'Nesterov\')(Age, Income, ParamPrice, Robotness, RefererHash) FROM hits_100m_single FORMAT Null
0.2180.197-1.106x-0.0970.085codecs_float_select12SELECT count(n) FROM codec_rnd_Float64_ZSTD WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.5860.530-1.105x-0.0960.095array_reduce4SELECT arrayReduceInRanges(\'count\', arrayZip(range(1000000), range(1000000)), range(100000000))[123456]
0.2530.277+1.094x0.0950.082codecs_float_select14SELECT count(n) FROM codec_rnd_Float64_Gorilla WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.1570.142-1.104x-0.0950.094round_methods7SELECT count() FROM numbers(100000000) WHERE NOT ignore(floor(toFloat64(number), -2))
0.1340.121-1.105x-0.0950.094base642SELECT count() FROM numbers(10000000) WHERE NOT ignore(base64Encode(toString(number)))
0.5850.530-1.103x-0.0940.093date_time_short0SELECT count() FROM numbers(100000000) WHERE NOT ignore(toDateTime(\'2017-01-01 00:00:00\') + number % 100000000 + rand() % 100000 AS t, toDayOfWeek(t, \'Europe/Moscow\'))
0.0950.086-1.101x-0.0930.092sort_radix_trivial1SELECT rand64() AS x FROM numbers(1000000) ORDER BY x FORMAT Null
0.0460.041-1.103x-0.0930.092order_with_limit7SELECT intHash64(number) AS n FROM numbers_mt(500000000) ORDER BY n LIMIT 10 FORMAT Null
0.2170.197-1.099x-0.0910.090sum15SELECT sumKahan(toNullable(toFloat64(number))) FROM numbers(100000000)
0.4050.369-1.098x-0.0900.089array_reduce3SELECT arrayReduceInRanges(\'sum\', [(1, 100000000)], range(100000000))
0.0810.073-1.099x-0.0900.089date_time_643SELECT max(x) FROM dt64
0.2730.249-1.097x-0.0890.088IPv61SELECT count() FROM ips_v6 WHERE NOT ignore(IPv6NumToString(IPv6StringToNum(materialize(ip))))
0.0380.034-1.097x-0.0890.054consistent_hashes0SELECT yandexConsistentHash(number, 2) FROM numbers(10000000) FORMAT Null
0.9680.883-1.096x-0.0890.087generate_table_function6SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'dt64 DateTime64, dts64 DateTime64(6), dtms64 DateTime64(6 ,\\\'Europe/Moscow\\\')\', 0, 10, 10) LIMIT 1000000000);
0.4050.369-1.096x-0.0890.088base647SELECT 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.2860.261-1.097x-0.0890.088bounding_ratio1SELECT (argMax(number, number) - argMin(number, number)) / (max(number) - min(number)) FROM numbers(100000000)
0.1040.095-1.097x-0.0880.087sort_radix_trivial2SELECT 1 / rand64() AS x FROM numbers(1000000) ORDER BY x FORMAT Null
0.6070.554-1.095x-0.0880.087json_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.1620.148-1.094x-0.0870.086synthetic_hardware_benchmark12SELECT count() FROM numbers( 100000000) WHERE NOT ignore(number % 7)
0.3660.334-1.094x-0.0860.081array_fill3SELECT arraySlice(arrayFill(x -> (((x.1) % 2) >= 2), arrayMap(x -> (x, toString(x)), range(10000000))), 1, 10) FORMAT Null
0.2180.199-1.093x-0.0860.085round_methods2SELECT count() FROM numbers(100000000) WHERE NOT ignore(floor(toInt64(number), -2))
0.1200.110-1.092x-0.0850.084redundant_functions_in_order_by0SELECT CounterID, EventDate FROM hits_100m_single ORDER BY CounterID, exp(CounterID), sqrt(CounterID) FORMAT Null
0.4550.417-1.091x-0.0840.083array_fill5SELECT arraySlice(arrayFill(x -> (((x.1) % 2) = 0), arrayMap(x -> (x, toString(x)), range(10000000))), 1, 10) FORMAT Null
0.3390.311-1.089x-0.0830.082array_fill1SELECT arraySlice(arrayFill(x -> (((x.1) % 2) >= 0), arrayMap(x -> (x, toString(x)), range(10000000))), 1, 10) FORMAT Null
0.2030.186-1.090x-0.0830.082base646SELECT count() FROM numbers(10000000) WHERE tryBase64Decode(base64Encode(materialize(\'Hello, world!\'))) != materialize(\'Hello, world!\')
0.1650.151-1.089x-0.0830.082sort0SELECT sum(key) FROM (SELECT * FROM rand_unlimited_10m_8 ORDER BY key)
0.8340.766-1.088x-0.0820.081if_string_const3SELECT count() FROM zeros(100000000) WHERE NOT ignore(rand() % 2 ? \'\' : toFixedString(\'world\', 5))
0.2630.242-1.088x-0.0810.080functions_with_hash_tables0select arrayUniq(range(1 + (number % 100) * 10)) from numbers(100000) format Null
0.0380.035-1.088x-0.0810.080consistent_hashes2SELECT yandexConsistentHash(number, 32768) FROM numbers(10000000) FORMAT Null
0.2360.217-1.087x-0.0810.076base645SELECT count() FROM numbers(10000000) WHERE base64Decode(base64Encode(toString(number))) != toString(number)
1.0620.977-1.087x-0.0810.080array_fill2SELECT arraySlice(arrayFill(x -> ((x % 2) >= 2), range(100000000)), 1, 10) FORMAT Null
0.1060.098-1.087x-0.0810.080aggregating_merge_tree0OPTIMIZE TABLE test FINAL
0.2610.241-1.085x-0.0790.078format_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.0760.070-1.084x-0.0780.061sum2SELECT sum(toUInt16(number)) FROM numbers(100000000)
0.0770.071-1.083x-0.0770.076date_time_641SELECT count() FROM dt64 where not ignore(x)
0.0530.049-1.083x-0.0760.075date_time_646SELECT count() from dt where not ignore(toStartOfDay(x))
0.1430.132-1.082x-0.0760.075synthetic_hardware_benchmark32SELECT number % 1000 AS k FROM numbers_mt(1600000000) GROUP BY k FORMAT Null
0.1090.101-1.080x-0.0750.074arithmetic_operations_in_aggr_func3SELECT min(-1 + (((-2 + (number + -3)) + -4) + -5)) FROM numbers(50000000)
0.1850.172-1.080x-0.0740.073round_methods4SELECT count() FROM numbers(100000000) WHERE NOT ignore(trunc(toInt64(number), -2))
0.8870.823-1.078x-0.0730.072polymorphic_parts_m1INSERT INTO hits_compact(UserID) SELECT rand() FROM numbers(100000)
0.7370.683-1.077x-0.0730.072generate_table_function12SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'i Tuple(Int32, Array(Int64))\', 0, 10, 10) LIMIT 1000000000);
0.4150.386-1.076x-0.0710.070url_hits7SELECT count() FROM hits_100m_single WHERE NOT ignore(pathFull(URL))
0.0960.102+1.070x0.0710.068distinct_combinator0SELECT x, sum(DISTINCT y) from (SELECT number % 12 AS x, number % 12321 AS y FROM numbers(10000000)) GROUP BY x
0.3210.299-1.075x-0.0710.070date_time_short5SELECT count() FROM numbers(100000000) WHERE NOT ignore(toDate(\'2017-01-01\') + number % 1000 + rand() % 10 AS t, toDayOfWeek(t))
0.0670.062-1.076x-0.0710.070order_with_limit18SELECT intHash64(number) AS n FROM numbers_mt(100000000) ORDER BY n, n + 1, n + 2 LIMIT 5000 FORMAT Null
0.1970.184-1.073x-0.0690.068base643SELECT count() FROM numbers(10000000) WHERE base64Decode(base64Encode(materialize(\'Hello, world!\'))) != materialize(\'Hello, world!\')
0.0950.102+1.069x0.0690.066round_down3SELECT count() FROM zeros(10000000) WHERE NOT ignore(roundDown(rand() % 100, [0, 1, 18, 25, 35, 45, 55]))
0.2030.189-1.073x-0.0690.068ngram_distance6SELECT ngramDistanceCaseInsensitive(Title, \'BABY DonT hUrT me\') AS distance FROM hits_10m_single FORMAT Null
0.0430.046+1.068x0.0670.027consistent_hashes6SELECT sumburConsistentHash(toUInt32(number), 2) FROM numbers(10000000) FORMAT Null
0.0910.085-1.069x-0.0660.065linear_regression4WITH (SELECT state FROM test_model) AS model SELECT evalMLMethod(model, Income, ParamPrice, Robotness, RefererHash) FROM hits_100m_single FORMAT Null
0.0450.042-1.068x-0.0650.064order_with_limit15SELECT intHash64(number) AS n FROM numbers_mt(200000000) ORDER BY n, n + 1, n + 2 LIMIT 100 FORMAT Null
0.2930.274-1.068x-0.0650.064date_time_short7SELECT count() FROM numbers(100000000) WHERE NOT ignore(toDate(\'2017-01-01\') + number % 1000 + rand() % 10 AS t, toRelativeDayNum(t))
0.1890.177-1.068x-0.0650.064monotonous_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.1880.176-1.068x-0.0650.064json_extract_rapidjson2SELECT \'rapidjson-3\', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractInt(materialize(\'{"sparam":"test_string","nparam": 772}\'), \'nparam\'))
0.0860.081-1.068x-0.0650.064order_with_limit12SELECT intHash64(number) AS n FROM numbers_mt(200000000) ORDER BY n LIMIT 10000 FORMAT Null
0.0730.068-1.068x-0.0640.063generate_table_function17SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'i FixedString(4)\', 0, 10, 10) LIMIT 1000000000);
0.4580.431-1.062x-0.0600.059array_element2SELECT count() FROM numbers(100000000) WHERE NOT ignore([[], []][number % 2 + 2])
0.2020.190-1.063x-0.0600.059ngram_distance7SELECT ngramDistanceCaseInsensitive(Title, \'nO MOrE\') AS distance FROM hits_10m_single FORMAT Null
0.2730.257-1.062x-0.0590.058polymorphic_parts_s0INSERT INTO hits_wide(UserID) SELECT rand() FROM numbers(100)
0.0940.088-1.062x-0.0590.058order_with_limit19SELECT intHash64(number) AS n FROM numbers_mt(100000000) ORDER BY n, n + 1, n + 2 LIMIT 10000 FORMAT Null
0.3530.332-1.061x-0.0590.058url_hits4SELECT count() FROM hits_100m_single WHERE NOT ignore(firstSignificantSubdomain(URL))
0.1520.143-1.061x-0.0590.058generate_table_function2SELECT sum(NOT ignore(*)) FROM (SELECT * FROM generateRandom(\'i Enum8(\\\'hello\\\' = 1, \\\'world\\\' = 5)\', 0, 10, 10) LIMIT 1000000000);
0.0920.086-1.062x-0.0590.058base640SELECT count() FROM numbers(10000000) WHERE NOT ignore(base64Encode(materialize(\'Hello, world!\')))
0.0200.019-1.057x-0.0590.028read_from_comp_parts0SELECT count() FROM mt_comp_parts WHERE NOT ignore(c1)
0.0590.056-1.062x-0.0580.057order_with_limit11SELECT intHash64(number) AS n FROM numbers_mt(200000000) ORDER BY n LIMIT 5000 FORMAT Null
0.0340.032-1.059x-0.0570.056order_by_decimals0SELECT toInt32(number) AS n FROM numbers(1000000) ORDER BY n DESC FORMAT Null
0.2100.198-1.059x-0.0570.056sort3SELECT sum(key) FROM (SELECT * FROM rand_unlimited_10m_16 ORDER BY key)
0.3600.340-1.060x-0.0570.056url_hits5SELECT count() FROM hits_100m_single WHERE NOT ignore(cutToFirstSignificantSubdomain(URL))
0.2110.199-1.059x-0.0570.056round_methods3SELECT count() FROM numbers(100000000) WHERE NOT ignore(ceil(toInt64(number), -2))
0.2030.192-1.059x-0.0570.056ngram_distance5SELECT ngramDistanceCaseInsensitive(Title, \'wHAt Is lovE\') AS distance FROM hits_10m_single FORMAT Null
0.6790.641-1.059x-0.0560.055functions_with_hash_tables5select entropy(number / 10) from numbers(1000 * 1000) group by number / 1000 format Null
0.1870.177-1.059x-0.0560.055base641SELECT count() FROM numbers(10000000) WHERE NOT ignore(base64Encode(materialize(\'This is a long string to test ClickHouse base64 functions impl..\')))
0.2810.266-1.058x-0.0560.055json_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.2100.198-1.057x-0.0550.051sort2SELECT sum(key) FROM (SELECT * FROM rand_100k_10m_16 ORDER BY key)
0.3050.288-1.057x-0.0550.054float_formatting21SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(toFloat32(number % 1000 + 0.123456)))
0.0430.040-1.056x-0.0540.053information_value1SELECT categoricalInformationValue(Age < 15, Age >= 15 and Age < 30, Age >= 30 and Age < 45, Age >= 45 and Age < 60, Age >= 60, IsMobile) from hits_100m_single
0.1700.161-1.053x-0.0510.050sort1SELECT sum(key) FROM (SELECT * FROM rand_1k_10m_16 ORDER BY key)
0.0560.053-1.054x-0.0510.050random_fixed_string3SELECT count() FROM zeros(10000) WHERE NOT ignore(randomFixedString(10000))
0.0740.071-1.052x-0.0500.049sort_radix_trivial0SELECT rand32() AS x FROM numbers(1000000) ORDER BY x FORMAT Null

Unstable Queries ?

Old, sNew, sRelative difference (new - old)/oldp < 0.01 thresholdTest#Query
0.4044.0458.9938.993logical_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.1630.3901.3911.391logical_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.1650.3881.3551.355logical_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.1190.2441.0471.047round_methods14SELECT count() FROM numbers(10000000) WHERE NOT ignore(trunc(toDecimal128(number, 0), -2))
0.1230.2450.9910.991round_methods12SELECT count() FROM numbers(10000000) WHERE NOT ignore(floor(toDecimal128(number, 0), -2))
0.1410.2820.9880.988functions_geo4SELECT count() FROM numbers(1000000) WHERE NOT ignore(geohashEncode(number + 91.0, number + 181.0))
0.1380.2730.9830.983functions_geo2SELECT count() FROM zeros(1000000) WHERE NOT ignore(geohashEncode(1.0/rand(), 2.0/rand()))
0.0260.0520.9510.951if_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.1260.2460.9450.945round_methods13SELECT count() FROM numbers(10000000) WHERE NOT ignore(ceil(toDecimal128(number, 0), -2))
0.1310.2540.9430.943general_purpose_hashes_on_UUID30SELECT count() from zeros_mt(1000000000) where not ignore(javaHash(materialize(toUUID(\'61f0c404-5cb3-11e7-907b-a6006ad3dba0\'))))
0.1370.2650.9380.938round_methods11SELECT count() FROM numbers(10000000) WHERE NOT ignore(roundBankers(toDecimal128(number, 0), -2))
0.0390.0750.9070.907any_anyLast2SELECT any(number * 2) as n, n * 3 FROM numbers(120000000)
0.1260.2400.9000.900round_methods10SELECT count() FROM numbers(10000000) WHERE NOT ignore(round(toDecimal128(number, 0), -2))
0.0420.0790.8790.879any_anyLast3SELECT any(number * round(toInt64(number), -2)) FROM numbers(120000000)
0.1700.3180.8620.862logical_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.0270.0510.8320.832if_to_multiif1 WITH number AS x SELECT any(x < 1 ? \'1\' : (x < 5 ? \'2\' : \'3\')) FROM numbers(100000000)
0.1320.2430.8290.829logical_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.4730.8590.8150.815general_purpose_hashes_on_UUID29SELECT count() from zeros(100000000) where not ignore(javaHash(generateUUIDv4()))
0.1830.3280.7850.785general_purpose_hashes_on_UUID35SELECT count() from zeros_mt(1000000000) where not ignore(hiveHash(generateUUIDv4()))
0.0670.1190.7550.755and_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.0480.0590.2300.746set_index0SELECT count() FROM test_in WHERE a IN (SELECT rand(1) FROM numbers(200000)) SETTINGS max_rows_to_read = 1, read_overflow_mode = \'break\'
0.1350.2330.7280.728logical_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.7431.2660.7030.703and_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.3490.5860.6760.676leftpad6SELECT max(length(UTMSource)) FROM hits_100m_single
0.3690.5950.6120.612leftpad0SELECT max(length(MobilePhoneModel)) FROM hits_100m_single
0.0440.0720.6040.604any_anyLast0SELECT any(-1 * (((-2 * (number * -3)) * -4) * -5)) FROM numbers(120000000)
0.1540.2480.6030.603logical_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.3480.5560.5960.596leftpad1SELECT max(length(Params)) FROM hits_100m_single
0.0720.1130.5610.561bitCount0SELECT bitCount(number) FROM numbers(100000000) FORMAT Null
0.1140.1770.5570.557empty_string_deserialization0SELECT count() FROM empty_strings WHERE NOT ignore(s)
0.4280.6520.5220.522constant_column_comparison9SELECT count() FROM hits_100m_single WHERE MobilePhoneModel < \'\' SETTINGS max_threads = 1
0.1370.2070.5130.513logical_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.4530.6820.5030.503constant_column_comparison11SELECT count() FROM hits_100m_single WHERE MobilePhoneModel < \'model\' SETTINGS max_threads = 1
0.4500.6720.4940.494constant_column_comparison10SELECT count() FROM hits_100m_single WHERE MobilePhoneModel < \'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz\' SETTINGS max_threads = 1
0.1360.1750.2870.492logical_functions_small1SELECT count() FROM test_logical_functions._2_0_UInt8 WHERE NOT ignore(and(x1,x2))
0.1240.1840.4820.482logical_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.4970.7310.4710.471empty_string_serialization0INSERT INTO empty_strings SELECT \'\' FROM zeros(100000000);
0.1370.2010.4670.467sum12SELECT sum(toNullable(toFloat32(number))) FROM numbers(100000000)
0.0940.1090.1600.457insert_parallel0INSERT INTO t SELECT * FROM numbers_mt(1000000000)
0.3650.350-0.0430.456decimal_aggregates14SELECT quantile(d128), quantileExact(d128), quantileExactWeighted(d128, 2) FROM (SELECT * FROM t LIMIT 1000000)
0.0440.0640.4320.432visit_param_extract_raw0SELECT count() FROM zeros(2000000) WHERE NOT ignore(visitParamExtractRaw(materialize(\'{"myparam":"test_string"}\'), \'myparam\'))
0.1030.1450.4040.404visit_param_extract_raw1SELECT count() FROM zeros(2000000) WHERE NOT ignore(visitParamExtractRaw(materialize(\'{"myparam":{"nested_1":"test_string","nested_2":"test_2"}}\'), \'myparam\'))
0.0790.1110.4030.403if_array_num0SELECT count() FROM zeros(10000000) WHERE NOT ignore(rand() % 2 ? [1, 2, 3] : [4, 5])
0.3790.5320.4010.401array_index_low_cardinality_numbers3SELECT count() FROM perf_lc_num WHERE indexOf(arr, 42) > 0
1.3611.8980.3940.394decimal_casts5SELECT toInt256(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t LIMIT 10000000 FORMAT Null
0.0930.1280.3770.377bitCount3SELECT bitCount(toUInt8(number)) FROM numbers(100000000) FORMAT Null
1.4041.9300.3740.374decimal_casts6SELECT toUInt256(x) y, toDecimal32(y, 1), toDecimal64(y, 5), toDecimal128(y, 6) FROM t LIMIT 10000000 FORMAT Null
0.5800.7970.3740.374constant_column_comparison14SELECT count() FROM hits_100m_single WHERE notEmpty(MobilePhoneModel) AND MobilePhoneModel < \'model\' SETTINGS max_threads = 1
0.2780.3810.3680.368functions_geo0SELECT count() FROM numbers(1000000) WHERE NOT ignore(geohashEncode((number % 150)*1.1 - 75, (number * 3.14 % 300)*1.1 - 150))
0.3550.4840.3640.364array_index_low_cardinality_numbers2SELECT count() FROM perf_lc_num WHERE has(arr, 42)
0.5760.7820.3570.357constant_column_comparison13SELECT count() FROM hits_100m_single WHERE notEmpty(MobilePhoneModel) AND MobilePhoneModel < \'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz\' SETTINGS max_threads = 1
0.5010.6770.3500.350constant_column_comparison12SELECT count() FROM hits_100m_single WHERE notEmpty(MobilePhoneModel) AND MobilePhoneModel < \'\' SETTINGS max_threads = 1
0.1190.1610.3450.345sum4SELECT sum(toFloat32(number)) FROM numbers(100000000)
0.0640.0860.3410.341order_by_decimals1SELECT toDecimal32(number, 0) AS n FROM numbers(1000000) ORDER BY n FORMAT Null
0.1890.2530.3350.335float_parsing0SELECT count() FROM numbers(10000000) WHERE NOT ignore(toFloat64(toString(number)))
0.5920.7870.3280.328sum_map7SELECT sumMapWithOverflow((key, val)) FROM sum_map_1000000 FORMAT Null
0.1780.2360.3250.325if_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.3490.4610.3220.322array_index_low_cardinality_numbers5SELECT count() FROM perf_lc_num WHERE has(arr, num)
0.3980.5240.3170.317array_index_low_cardinality_numbers1SELECT count() FROM perf_lc_num WHERE arr[1] = 42
0.1990.2630.3160.316sum6SELECT sumKahan(toFloat32(number)) FROM numbers(100000000)
0.1300.1720.3130.313float_parsing1SELECT count() FROM numbers(10000000) WHERE NOT ignore(toFloat64(toString(number % 10)))
0.3700.4850.3110.311array_index_low_cardinality_numbers7SELECT count() FROM perf_lc_num WHERE has(arr, num * 10)
0.3480.4570.3100.310if_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.0670.0880.3070.307order_by_decimals2SELECT toDecimal32(number, 0) AS n FROM numbers(1000000) ORDER BY n DESC FORMAT Null
0.1270.1660.3060.306general_purpose_hashes_on_UUID2SELECT count() from zeros_mt(1000000000) where not ignore(cityHash64(materialize(toUUID(\'61f0c404-5cb3-11e7-907b-a6006ad3dba0\'))))
0.0900.1170.3000.300if_array_num3SELECT count() FROM zeros(10000000) WHERE NOT ignore(rand() % 2 ? [1, 2, 3] : [400, 500])
0.6340.8210.2950.295sum_map5SELECT maxMap((key, val)) FROM sum_map_1000000 FORMAT Null
0.5850.7530.2860.286sum_map4SELECT minMap((key, val)) FROM sum_map_1000000 FORMAT Null
0.1910.2460.2860.286if_to_multiif0 WITH number AS x SELECT sum(x < 1 ? 1 : (x < 5 ? 2 : 3)) FROM numbers(100000000)
0.0950.1220.2860.286bitCount4SELECT bitCount(toInt32(number)) FROM numbers(100000000) FORMAT Null
0.2610.3360.2840.284float_parsing5SELECT count() FROM zeros(10000000) WHERE NOT ignore(toFloat64(toString(rand())))
0.5970.7650.2820.282sum_map6SELECT sumMap((key, val)) FROM sum_map_1000000 FORMAT Null
0.1300.107-0.1800.280if_array_string5SELECT count() FROM zeros(1000000) WHERE NOT ignore(rand() % 2 ? materialize([\'https://github.com/ClickHouse/ClickHouse/pull/1070\', \'https://www.google.ru/search?newwindow=1&site=&source=hp&q=zookeeper+wire+protocol+exists&oq=zookeeper+wire+protocol+exists&gs_l=psy-ab.3...330.6300.0.6687.33.28.0.0.0.0.386.4838.0j5j9j5.19.0....0...1.1.64.psy-ab..14.17.4448.0..0j35i39k1j0i131k1j0i22i30k1j0i19k1j33i21k1.r_3uFoNOrSU\']) : emptyArrayString())
0.0760.0970.2780.278distributed_aggregation3select count(sipHash64(zero)) from remote(\'127.0.0.{2,3}\', zeros_mt(100000000))
0.6670.8500.2730.273leftpad3SELECT max(length(PageCharset)) FROM hits_100m_single
0.0730.0920.2720.272distributed_aggregation1select count(sipHash64(zero)) from remote(\'127.0.0.{1,1}\', zeros_mt(100000000))
0.6430.8160.2690.269sum_map1SELECT maxMap(key, val) FROM sum_map_1000000 FORMAT Null
0.5870.7430.2650.265sum_map0SELECT minMap(key, val) FROM sum_map_1000000 FORMAT Null
0.4450.5600.2580.258array_index_low_cardinality_numbers4SELECT count() FROM perf_lc_num WHERE arr[1] = num
0.2880.3610.2550.255general_purpose_hashes_on_UUID39SELECT count() from zeros_mt(1000000000) where not ignore(xxHash32(generateUUIDv4()))
0.0380.0480.2540.254IPv41SELECT count() FROM ips_v4 WHERE NOT ignore(IPv4NumToString(IPv4StringToNum(materialize(ip)))) SETTINGS max_threads=1
0.0730.0920.2520.252distributed_aggregation2select count(sipHash64(zero)) from remote(\'127.0.0.{1,2}\', zeros_mt(100000000))
0.5810.7270.2500.250float_parsing7SELECT count() FROM zeros(10000000) WHERE NOT ignore(toFloat64(concat(toString(rand(1)), \'.\', toString(rand(2)))))
0.0780.0970.2440.244base64_hits1SELECT count() FROM hits_10m_single WHERE NOT ignore(base64Encode(MobilePhoneModel))
0.1240.1540.2420.242if_array_num1SELECT count() FROM zeros(10000000) WHERE NOT ignore(rand() % 2 ? [1, 2, 3] : materialize([4, 5]))
0.0230.0290.2390.239IPv40SELECT count() FROM ips_v4 WHERE NOT ignore(IPv4StringToNum(materialize(ip))) SETTINGS max_threads=1
0.3650.4510.2340.234constant_column_comparison15SELECT count() FROM hits_100m_single WHERE PageCharset < \'\' SETTINGS max_threads = 2
0.4280.5290.2330.233constant_column_comparison16SELECT count() FROM hits_100m_single WHERE PageCharset < \'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz\' SETTINGS max_threads = 2
0.4800.5910.2290.229constant_column_comparison3SELECT count() FROM hits_100m_single WHERE SearchPhrase < \'\' SETTINGS max_threads = 2
0.1090.1340.2250.225base64_hits9SELECT count() FROM hits_10m_single WHERE tryBase64Decode(base64Encode(MobilePhoneModel)) != MobilePhoneModel
0.1830.172-0.0580.217questdb_sum_int322SELECT sum(x) FROM `zz_Int32 NULL_Memory`
0.3550.4320.2150.215order_with_limit4SELECT number AS n FROM numbers_mt(200000000) ORDER BY n DESC LIMIT 5000 FORMAT Null
0.2580.3120.2090.209read_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.5360.6470.2060.206constant_column_comparison5SELECT count() FROM hits_100m_single WHERE SearchPhrase < \'поисковая фраза\' SETTINGS max_threads = 2
0.1080.1300.2050.205distributed_aggregation0select count() from (select sipHash64(zero) from zeros_mt(100000000) union all select sipHash64(zero) from zeros_mt(100000000))
0.0480.0580.2050.205concat_hits5SELECT count() FROM hits_100m_single WHERE NOT ignore(concat(MobilePhoneModel, \'Hello\'))
0.4870.5880.2050.205array_index_low_cardinality_numbers8SELECT count() FROM perf_lc_num WHERE has(arr, (num * 1000 + 20) % 137)
1.1251.3560.2040.204date_time_short8SELECT count() FROM numbers(100000000) WHERE NOT ignore(toDate(\'2017-01-01\') + number % 1000 + rand() % 10 AS t, toYYYYMMDDhhmmss(t))
0.1300.1560.2020.202codecs_float_select3SELECT count(n) FROM codec_seq_Float64_DoubleDelta WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.1510.133-0.1170.201merge_tree_many_partitions_20SELECT sum(ignore(*)) FROM bad_partitions
0.0950.1140.1960.196concat_hits2SELECT count() FROM hits_100m_single WHERE NOT ignore(concat(MobilePhoneModel, SearchPhrase))
0.1310.1570.1930.193if_array_num4SELECT count() FROM zeros(10000000) WHERE NOT ignore(rand() % 2 ? [1, 2, 3] : materialize([400, 500]))
0.4310.5140.1930.193constant_column_comparison17SELECT count() FROM hits_100m_single WHERE PageCharset < \'utf-8\' SETTINGS max_threads = 2
0.1420.1690.1920.192bitCount5SELECT bitCount(toFloat64(number)) FROM numbers(100000000) FORMAT Null
0.5130.6100.1880.188constant_column_comparison6SELECT count() FROM hits_100m_single WHERE notEmpty(SearchPhrase) AND SearchPhrase < \'\' SETTINGS max_threads = 2
0.2300.2740.1860.186codecs_float_select8SELECT count(n) FROM codec_mon_Float64_DoubleDelta WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.2130.2530.1840.184sum14SELECT sumKahan(toNullable(toFloat32(number))) FROM numbers(100000000)
0.3560.4210.1820.182order_with_limit5SELECT number AS n FROM numbers_mt(200000000) ORDER BY n DESC LIMIT 10000 FORMAT Null
0.4620.5460.1810.181float_parsing8SELECT count() FROM zeros(10000000) WHERE NOT ignore(toFloat64(concat(toString(rand(1)), \'e\', toString(rand(2) % 100))))
0.1850.2190.1800.180set8SELECT count() FROM zeros(10000000) WHERE rand64() IN (SELECT number FROM system.numbers LIMIT 1048576)
0.1620.134-0.1720.180questdb_sum_float320SELECT sum(x) FROM `zz_Float32_Memory`
0.0360.0420.1780.178IPv42SELECT count() FROM ips_v4 WHERE NOT ignore(IPv4NumToStringClassC(IPv4StringToNum(materialize(ip)))) SETTINGS max_threads=1
0.3390.3990.1750.175visit_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.3100.3640.1750.175int_parsing35SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(SilverlightVersion4)) SETTINGS max_threads = 1
0.0710.064-0.0970.175codecs_int_select3SELECT count(n) FROM codec_seq_UInt64_Delta WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.1010.1190.1740.174if_string_hits2SELECT count() FROM hits_100m_single WHERE NOT ignore(rand() % 2 ? SearchPhrase : MobilePhoneModel)
0.1450.1700.1730.173questdb_sum_int320SELECT sum(x) FROM `zz_Int32_Memory`
0.0700.0750.0650.173decimal_casts9SELECT toInt32(d32), toInt64(d32), toInt128(d32) FROM t FORMAT Null
0.5870.6890.1730.173constant_column_comparison7SELECT count() FROM hits_100m_single WHERE notEmpty(SearchPhrase) AND SearchPhrase < \'zzzzzzzzzzzzzzzzzzzzzzzzzzzzzz\' SETTINGS max_threads = 2
0.1580.1850.1710.171codecs_int_select13SELECT count(n) FROM codec_mon_UInt64_Gorilla WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.3710.4340.1680.168order_with_limit3SELECT number AS n FROM numbers_mt(200000000) ORDER BY n DESC LIMIT 3000 FORMAT Null
0.6250.7280.1660.166constant_column_comparison8SELECT count() FROM hits_100m_single WHERE notEmpty(SearchPhrase) AND SearchPhrase < \'поисковая фраза\' SETTINGS max_threads = 2
0.2490.2900.1650.165codecs_int_select20SELECT count(n) FROM codec_rnd_UInt64_Gorilla WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.0410.0480.1640.164concat_hits12SELECT count() FROM hits_100m_single WHERE NOT ignore(format(\'{}Hello\', MobilePhoneModel))
0.2500.2910.1620.162round_methods1SELECT count() FROM numbers(100000000) WHERE NOT ignore(roundBankers(toInt64(number), -2))
0.0410.0480.1600.160sum0SELECT sum(number) FROM numbers(100000000)
0.0960.1110.1600.160concat_hits9SELECT count() FROM hits_100m_single WHERE NOT ignore(format(\'{}{}\', MobilePhoneModel, SearchPhrase))
0.1730.2000.1550.155if_array_num5SELECT count() FROM zeros(10000000) WHERE NOT ignore(rand() % 2 ? materialize([1, 2, 3]) : materialize([400, 500]))
0.1290.1440.1140.153questdb_sum_float642SELECT sum(x) FROM `zz_Float64 NULL_Memory`
0.4590.5290.1530.153float_parsing6SELECT count() FROM zeros(10000000) WHERE NOT ignore(toFloat64(toString(rand64())))
0.0810.0940.1530.153codecs_int_select5SELECT count(n) FROM codec_seq_UInt64_DoubleDelta WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.0640.0730.1410.150concat_hits19SELECT count() FROM hits_100m_single WHERE NOT ignore(concat(\'a\', PageCharset, \'b\'))
0.0590.0680.1490.150codecs_int_select0SELECT count(n) FROM codec_seq_UInt64_NONE WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.0890.1010.1420.142concat_hits24SELECT count() FROM hits_100m_single WHERE NOT ignore(format(\'{}Hello{}\', MobilePhoneModel, PageCharset))
0.2660.3030.1410.141if_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.1640.1870.1380.138modulo0SELECT number % 128 FROM numbers(300000000) FORMAT Null
0.0670.058-0.1270.138codecs_int_select7SELECT count(n) FROM codec_mon_UInt64_NONE WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.1400.1600.1380.138codecs_int_select6SELECT count(n) FROM codec_seq_UInt64_Gorilla WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.1660.1890.1370.137modulo2SELECT number % 256 FROM numbers(300000000) FORMAT Null
0.1630.1860.1360.136if_array_num2SELECT count() FROM zeros(10000000) WHERE NOT ignore(rand() % 2 ? materialize([1, 2, 3]) : materialize([4, 5]))
0.1060.1150.0840.135trim_numbers2SELECT count() FROM numbers(10000000) WHERE NOT ignore(rtrim(toString(number)))
0.1410.138-0.0220.133questdb_sum_float640SELECT sum(x) FROM `zz_Float64_Memory`
0.3710.368-0.0070.133parallel_final9SELECT sum(s) FROM collapsing_final_16p_rnd final group by key1 limit 10
0.1700.1910.1230.130questdb_sum_float322SELECT sum(x) FROM `zz_Float32 NULL_Memory`
1.1891.3400.1270.127float_parsing9SELECT count() FROM zeros(10000000) WHERE NOT ignore(toFloat64(concat(toString(rand64(1)), toString(rand64(2)), toString(rand64(3)))))
0.1120.1270.1260.126base64_hits5SELECT count() FROM hits_10m_single WHERE base64Decode(base64Encode(MobilePhoneModel)) != MobilePhoneModel
0.0920.1030.1240.124trim_whitespace0SELECT trimLeft(value) FROM whitespaces FORMAT Null
0.4090.4600.1240.124date_time_6416SELECT sum(toDateTime(toString(x)) != x) FROM dt
0.0860.0970.1210.121sum10SELECT sum(toNullable(toUInt16(number))) FROM numbers(100000000)
0.2750.2760.0060.121functions_with_hash_tables4select groupUniqArray(rand() % 100) from numbers(1000 * 1000) group by number / 1000 format Null
0.3880.4350.1200.120order_by_read_in_order2SELECT * FROM hits_100m_single ORDER BY CounterID, EventDate, URL LIMIT 100
0.0460.0500.0850.120insert_select_default_small_block0INSERT INTO insert_small_block_performance (x) SELECT toString(number) FROM numbers(10000);
0.2010.2260.1200.120codecs_float_select7SELECT count(n) FROM codec_mon_Float64_ZSTD WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.1680.1880.1190.119rand2SELECT count() FROM (SELECT generateUUIDv4() FROM zeros(100000000))
0.0640.0710.1170.117inserts_arrays_lowcardinality0INSERT INTO lot_of_string_arrays_dst SELECT rand64() as id, columns(\'^col\') FROM lot_of_string_arrays_src
0.3210.3590.1160.116date_time_644SELECT count() from dt where not ignore(toString(x))
0.2250.2510.1130.113codecs_float_select4SELECT count(n) FROM codec_seq_Float64_Gorilla WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
1.0621.1820.1120.112parallel_final12SELECT sum(s) FROM collapsing_final_16p_str_keys_ord final group by key1 limit 10
0.1000.1110.1120.112IPv60SELECT count() FROM ips_v6 WHERE NOT ignore(IPv6StringToNum(materialize(ip)))
0.1070.1090.0120.109trim_numbers1SELECT count() FROM numbers(10000000) WHERE NOT ignore(ltrim(toString(number)))
0.5520.6120.1090.109read_from_comp_parts1SELECT count() FROM mt_comp_parts WHERE NOT ignore(c2, s1, arr1, s2)
0.9390.916-0.0250.109questdb_sum_int321SELECT sum(x) FROM `zz_Int32_MergeTree ORDER BY tuple()`
0.0510.0560.1090.109order_with_limit0SELECT number AS n FROM numbers_mt(200000000) ORDER BY n DESC LIMIT 10 FORMAT Null
0.3700.4100.1080.108order_with_limit2SELECT number AS n FROM numbers_mt(200000000) ORDER BY n DESC LIMIT 1500 FORMAT Null
0.1850.183-0.0110.107least_greatest_hits1SELECT count() FROM hits_10m_single WHERE NOT ignore(greatest(URL, Referer, Title))
0.1400.1550.1060.107distributed_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.1080.1180.0990.105point_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.6690.643-0.0400.104parallel_final7SELECT count() FROM collapsing_final_1024p_rnd final
0.1380.130-0.0610.104order_by_read_in_order1SELECT * FROM hits_100m_single ORDER BY CounterID DESC, toStartOfWeek(EventDate) DESC LIMIT 100
0.0780.0860.1040.104float_formatting3SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(toFloat64(number % 100)))
0.1990.2200.1040.104codecs_float_select2SELECT count(n) FROM codec_seq_Float64_ZSTD WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.0630.0690.1020.102concat_hits25SELECT count() FROM hits_100m_single WHERE NOT ignore(format(\'a{}b\', PageCharset))
0.0960.1060.1000.100trim_whitespace1SELECT trimRight(value) FROM whitespaces FORMAT Null
0.0600.0660.1000.100round_down0SELECT count() FROM zeros(10000000) WHERE NOT ignore(roundDuration(rand() % 65536))
0.1290.1290.0000.100read_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.0630.0690.1000.100float_formatting1SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(toFloat64(number % 2)))
0.3770.339-0.1000.100array_reduce2SELECT arrayReduceInRanges(\'count\', [(1, 100000000)], range(100000000))
0.2260.219-0.0300.099string_set5SELECT 1 FROM hits_10m_words WHERE word IN (SELECT short FROM strings) FORMAT Null
0.5570.6120.0990.099read_from_comp_parts4SELECT count() FROM mt_comp_parts WHERE NOT ignore(*)
0.5540.6100.0990.099int_parsing30SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(WindowClientHeight)) SETTINGS max_threads = 1
0.2400.2640.0980.098codecs_int_select2SELECT count(n) FROM codec_seq_UInt64_ZSTD WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.5230.516-0.0140.097synthetic_hardware_benchmark44SELECT number % 10000000 AS k FROM numbers_mt(80000000) GROUP BY k FORMAT Null
0.1710.1820.0650.097string_set4SELECT 1 FROM strings WHERE long IN (SELECT short FROM strings) FORMAT Null
0.0520.0570.0960.096slices_hits1SELECT count() FROM hits_100m_single WHERE NOT ignore(substring(PageCharset, 1, 2))
0.4050.383-0.0540.094string_join0SELECT 1 FROM hits_10m_words AS l ANY LEFT JOIN hits_10m_words AS r USING (word) FORMAT Null
0.0640.061-0.0510.092codecs_int_select14SELECT count(n) FROM codec_rnd_UInt64_NONE WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.1120.1150.0250.091trim_numbers0SELECT count() FROM numbers(10000000) WHERE NOT ignore(trim(toString(number)))
0.0590.0650.0910.091concat_hits13SELECT count() FROM hits_100m_single WHERE NOT ignore(format(\'{}a\', PageCharset))
0.2970.3240.0890.089vectorize_aggregation_combinators2SELECT sumArray(v) FROM array_data FORMAT Null
0.3210.3310.0290.088string_set0SELECT 1 FROM hits_10m_words WHERE word IN (SELECT word FROM hits_10m_words) FORMAT Null
0.8310.794-0.0450.087parallel_final15SELECT sum(s) FROM collapsing_final_1024p_rnd final group by key1 limit 10
0.0640.0700.0870.087merge_table_streams0SELECT UserID FROM merge(default, \'^(hits_100m_single|merge_table_streams_\\\\d)$\') WHERE UserID = 12345678901234567890
0.5910.565-0.0450.084json_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.0350.033-0.0720.083vectorize_aggregation_combinators0SELECT countMerge(v) FROM (SELECT countState() v FROM zeros(1000000000)) FORMAT Null
0.0530.0570.0830.083trim_whitespace4SELECT replaceRegexpOne(value, \' *$\', \'\') FROM whitespaces LIMIT 10000000 FORMAT Null
0.0990.091-0.0820.083synthetic_hardware_benchmark13SELECT count() FROM numbers_mt(1600000000) WHERE NOT ignore(number % 7)
0.3910.4240.0820.082bounding_ratio0SELECT boundingRatio(number, number) FROM numbers(100000000)
0.5530.535-0.0330.081json_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.0870.0940.0800.080sum11SELECT sum(toNullable(toUInt8(number))) FROM numbers(100000000)
0.1090.1160.0620.080functions_with_hash_tables3select arrayIntersect(range((1 + number % 100)), range(1, (1 + number % 100) + 1)) from numbers(100000) format Null
0.1010.098-0.0240.080conditional1SELECT count() FROM zeros(10000000) WHERE NOT ignore(multiIf(rand() % 2, toDateTime(\'2019-02-04 01:24:31\'), toDate(\'2019-02-04\')))
0.0740.0800.0800.080conditional0SELECT count() FROM zeros(10000000) WHERE NOT ignore(if(rand() % 2, toDateTime(\'2019-02-04 01:24:31\'), toDate(\'2019-02-04\')))
0.2120.2300.0800.080codecs_float_select9SELECT count(n) FROM codec_mon_Float64_Gorilla WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.9210.860-0.0670.079url_hits13SELECT count() FROM hits_100m_single WHERE NOT ignore(URLHierarchy(URL))
0.2750.2810.0230.079string_set2SELECT 1 FROM strings WHERE long IN (SELECT long FROM strings) FORMAT Null
0.0760.0780.0220.079random_fixed_string1SELECT count() FROM zeros(10000000) WHERE NOT ignore(randomFixedString(100))
0.0870.081-0.0750.077read_from_comp_parts3SELECT count() FROM mt_comp_parts WHERE NOT ignore(c1, c2, c3)
0.2580.2720.0550.077inserts_arrays_lowcardinality1INSERT INTO lot_of_string_arrays_dst_lowcardinality SELECT rand64() as id, columns(\'^col\') FROM lot_of_string_arrays_src
0.0720.0770.0750.076early_constant_folding0SELECT count(JavaEnable) FROM hits_100m_single WHERE WatchID = 1 OR Title = \'next\' OR URL = \'prev\' OR OriginalURL = \'???\' OR 1
0.0660.0700.0580.075sum1SELECT sum(toUInt32(number)) FROM numbers(100000000)
0.0930.1000.0750.075round_down1SELECT count() FROM zeros(10000000) WHERE NOT ignore(roundDown(rand() % 65536, [0, 1, 10, 30, 60, 120, 180, 240, 300, 600, 1200, 1800, 3600, 7200, 18000, 36000]))
0.0930.092-0.0110.074sum9SELECT sum(toNullable(toUInt32(number))) FROM numbers(100000000)
0.1960.2100.0730.073base64_hits0SELECT count() FROM hits_10m_single WHERE NOT ignore(base64Encode(SearchPhrase))
0.0890.083-0.0610.072random_fixed_string0SELECT count() FROM zeros(100000000) WHERE NOT ignore(randomFixedString(10))
0.1910.2040.0700.070read_from_comp_parts2SELECT count() FROM mt_comp_parts WHERE NOT ignore(c1, s1, c3)
0.0830.0830.0000.070parallel_mv0insert into main_table select number from numbers(1000000)
0.8270.807-0.0250.070parallel_final23SELECT sum(s) FROM collapsing_final_1024p_rnd final group by key1 % 8192 limit 10
0.1430.139-0.0280.070float_formatting25SELECT count() FROM zeros(10000000) WHERE NOT ignore(toString(toFloat64(rand())))
0.0800.0860.0700.070float_formatting16SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(toFloat32(number % 100)))
0.3010.3170.0540.069string_set6SELECT 1 FROM hits_10m_words WHERE word IN (SELECT long FROM strings) FORMAT Null
0.2780.2970.0690.069read_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.1270.1310.0280.069functions_geo3SELECT count() FROM zeros(1000000) WHERE NOT ignore(geohashDecode(toString(rand() % 1000000)))
0.0670.063-0.0590.069codecs_float_select0SELECT count(n) FROM codec_seq_Float64_NONE WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.1290.1360.0560.068read_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.1730.166-0.0410.068codecs_int_select1SELECT count(n) FROM codec_seq_UInt64_LZ4 WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.0950.090-0.0610.066synthetic_hardware_benchmark33SELECT number % 100000 AS k, count() FROM numbers( 10000000) GROUP BY k FORMAT Null
0.2410.241-0.0020.066parallel_final3SELECT count() FROM collapsing_final_16p_int_keys_rnd final
0.5650.6020.0660.066constant_column_search26SELECT sum(multiFuzzyMatchAny(Title, 3, [\'hello$\', \'world$\', \'^hello\'])) FROM hits_100m_single
0.2000.2130.0650.065constant_column_search24SELECT DISTINCT Title, multiFuzzyMatchAny(Title, 2, [\'^metrika\\\\.ry$\']) AS distance FROM hits_100m_single WHERE distance = 1
0.0830.0880.0650.065concat_hits17SELECT count() FROM hits_100m_single WHERE NOT ignore(concat(\'Hello\', SearchPhrase, \'World\'))
0.3030.300-0.0100.064set_hits4SELECT count() FROM hits_10m_single WHERE URL IN (SELECT URL FROM hits_10m_single WHERE SearchEngineID != 0)
0.3250.3460.0640.064leftpad5SELECT max(length(URL)) FROM hits_10m_single
0.0670.0720.0610.064if_string_hits3SELECT count() FROM hits_100m_single WHERE NOT ignore(rand() % 2 ? \'\' : PageCharset)
0.5550.5900.0620.064basename1SELECT count() FROM hits_10m_single WHERE NOT ignore(basename(Referer))
0.1410.133-0.0600.064arithmetic_operations_in_aggr_func1SELECT min(-1 * (((-2 * (number * -3)) * -4) * -5)) FROM numbers(50000000)
0.0270.025-0.0550.063vectorize_aggregation_combinators1SELECT countMerge(v) FROM (SELECT number % 1024 k, countState() v FROM numbers(10000000) GROUP BY k) FORMAT Null
0.1330.1390.0410.063set_hits1SELECT count() FROM hits_10m_single WHERE UserID IN (SELECT UserID FROM hits_10m_single)
0.3210.301-0.0620.063polymorphic_parts_s2INSERT INTO hits_buffer(UserID) SELECT rand() FROM numbers(100)
0.5340.5620.0510.063json_extract_rapidjson5SELECT \'rapidjson-6\', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractString(materialize(\'{"sparam":{"nested_1":"test_string","nested_2":"test_2"}, "nparam":8495, "fparam":{"nested_1":91.15,"nested_2":[334, 89.05, 1000.01]}, "bparam":false}\'), \'sparam\'))
0.1080.107-0.0080.063h30SELECT count() FROM zeros(100000) WHERE NOT ignore(geoToH3(37.62 + rand(1) / 0x100000000, 55.75 + rand(2) / 0x100000000, 15))
0.1340.1430.0620.063conditional5SELECT count() FROM zeros(10000000) WHERE NOT ignore(multiIf(rand() % 2, toDateTime(rand()), toDate(rand())))
0.1370.129-0.0610.062synthetic_hardware_benchmark36SELECT number % 100000 AS k FROM numbers_mt(160000000) GROUP BY k FORMAT Null
0.2230.2320.0360.062round_methods0SELECT count() FROM numbers(100000000) WHERE NOT ignore(round(toInt64(number), -2))
0.2090.2220.0620.062constant_column_search25SELECT DISTINCT Title, multiFuzzyMatchAny(Title, 5, [\'^metrika\\\\.ry$\']) AS distance FROM hits_100m_single WHERE distance = 1
0.4170.4430.0620.062constant_column_search18SELECT count() FROM hits_100m_single WHERE multiMatchAny(URL, [\'about/address\', \'for_woman\', \'^https?://lm-company.ruy/$\', \'ultimateguitar.com\'])
0.0830.0880.0620.062concat_hits23SELECT count() FROM hits_100m_single WHERE NOT ignore(format(\'Hello{}World\', SearchPhrase))
0.8030.782-0.0260.061json_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.8060.8540.0590.061if_string_const0SELECT count() FROM zeros(100000000) WHERE NOT ignore(rand() % 2 ? \'hello\' : \'world\')
0.3910.4120.0520.061float_formatting28SELECT count() FROM zeros(10000000) WHERE NOT ignore(toString(toFloat32(rand64())))
0.6350.6740.0610.061base64_hits3SELECT count() FROM hits_10m_single WHERE NOT ignore(base64Encode(Title))
0.3540.337-0.0490.060url_hits8SELECT count() FROM hits_100m_single WHERE NOT ignore(queryString(URL))
0.9120.9680.0600.060float_parsing4SELECT count() FROM zeros(10000000) WHERE NOT ignore(toFloat64(toString(0xFFFFFFFF / rand())))
0.5400.535-0.0100.059json_extract_rapidjson12SELECT \'rapidjson-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.3210.3410.0590.059int_parsing21SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(IsMobile)) SETTINGS max_threads = 1
0.8830.9350.0590.059float_parsing3SELECT count() FROM zeros(10000000) WHERE NOT ignore(toFloat64(toString(rand() / 0xFFFFFFFF)))
1.2721.224-0.0380.059date_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.2910.3070.0550.059constant_column_search6select sum(multiSearchAny(URL, [\'yandex\', \'google\', \'yahoo\', \'pikabu\'])) from hits_100m_single
1.0251.0620.0350.059base64_hits11SELECT count() FROM hits_10m_single WHERE tryBase64Decode(base64Encode(Title)) != Title
0.5200.490-0.0580.058trim_numbers3SELECT count() FROM numbers(10000000) WHERE NOT ignore(trim(LEADING \'012345\' FROM toString(number)))
0.0630.063-0.0010.058order_by_read_in_order4SELECT * FROM hits_100m_single WHERE UserID=1988954671305023629 ORDER BY CounterID, EventDate LIMIT 100
0.1230.117-0.0460.058jit_small_requests2\n SELECT count() FROM numbers(100000000) WHERE NOT ignore(intHash64(number))\n
0.1000.097-0.0340.058jit_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.0940.1000.0580.058float_formatting4SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(toFloat64(number % 1000)))
0.0340.033-0.0350.058date_time_642SELECT max(x) FROM dt
0.5250.513-0.0240.058concat_hits22SELECT count() FROM hits_100m_single WHERE NOT ignore(format(\'{}Hello{}\', URL, URL))
0.0280.027-0.0480.057linear_regression0SELECT stochasticLinearRegressionState(0.0001, 0, 15)(Age, Income, ParamPrice, Robotness, RefererHash) FROM test.hits FORMAT Null
0.4080.4170.0210.057functions_coding3SELECT count() FROM zeros_mt(1000000000) WHERE NOT ignore(MACStringToNum(MACNumToString(rand64())))
0.0320.031-0.0430.057date_time_640SELECT count() FROM dt where not ignore(x)
0.3170.3350.0570.057base64_hits8SELECT count() FROM hits_10m_single WHERE tryBase64Decode(base64Encode(SearchPhrase)) != SearchPhrase
0.2080.199-0.0400.057aggregation_in_order3SELECT avg(length(URL)) as x from hits_10m_single GROUP BY CounterID, EventDate, intHash32(UserID) FORMAT Null
0.3800.359-0.0540.056trim_urls1SELECT count() FROM hits_100m_single WHERE NOT ignore(ltrim(URL))
0.1320.127-0.0370.056synthetic_hardware_benchmark4SELECT count() FROM numbers( 100000000) WHERE NOT ignore(intHash32(number))
0.2820.270-0.0440.056sort8SELECT sum(key) FROM (SELECT * FROM rand_100k_10m_64 ORDER BY key)
0.5610.534-0.0500.056date_time_short2SELECT count() FROM numbers(100000000) WHERE NOT ignore(toDateTime(\'2017-01-01 00:00:00\') + number % 100000000 + rand() % 100000 AS t, toRelativeDayNum(t, \'Europe/Moscow\'))
0.2540.2660.0450.056codecs_int_select9SELECT count(n) FROM codec_mon_UInt64_ZSTD WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.1750.170-0.0330.055sort4SELECT sum(key) FROM (SELECT * FROM rand_1k_10m_32 ORDER BY key)
0.3300.312-0.0550.055polymorphic_parts_m2INSERT INTO hits_buffer(UserID) SELECT rand() FROM numbers(10000)
0.5360.514-0.0400.055json_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.5450.5700.0460.055json_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.3250.3410.0490.055int_parsing69SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(CLID)) SETTINGS max_threads = 1
0.9601.0070.0480.055constant_column_search27SELECT count() FROM hits_100m_single WHERE multiFuzzyMatchAny(URL, 2, [\'about/address\', \'for_woman\', \'^https?://lm-company.ruy/$\', \'ultimateguitar.com\'])
0.1400.136-0.0320.054synthetic_hardware_benchmark18SELECT number % 256 AS k FROM numbers(100000000) GROUP BY k FORMAT Null
0.1110.1160.0420.054point_in_polygon0SELECT pointInPolygon((100, 100), polygon) FROM polygons FORMAT Null
0.2790.2940.0540.054int_parsing43SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(IsEvent)) SETTINGS max_threads = 1
0.3280.3460.0540.054int_parsing39SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(IsNotBounce)) SETTINGS max_threads = 1
0.3740.356-0.0500.054concat_hits10SELECT count() FROM hits_100m_single WHERE NOT ignore(format(\'{}Hello\', URL))
0.0690.066-0.0340.054codecs_int_select17SELECT count(n) FROM codec_rnd_UInt64_Delta WHERE ignore(n) == 0 LIMIT 20000000 SETTINGS max_threads=1
0.4010.4210.0500.053leftpad4SELECT max(length(Referer)) FROM hits_10m_single
0.6210.6340.0210.053datetime_comparison2SELECT count() FROM numbers(1000000000) WHERE materialize(now()) > toDateTime(\'2020-09-30 00:00:00\')
0.2700.2700.0010.053conditional7SELECT count() FROM zeros(10000000) WHERE NOT ignore(multiIf(rand() % 2, [toDateTime(rand())], [toDate(rand())]))
0.5670.5800.0210.053base64_hits2SELECT count() FROM hits_10m_single WHERE NOT ignore(base64Encode(URL))
0.0350.0370.0410.052trim_whitespace3SELECT replaceRegexpOne(value, \'^ *\', \'\') FROM whitespaces LIMIT 10000000 FORMAT Null
0.5570.539-0.0340.052sort6SELECT sum(key) FROM (SELECT * FROM rand_unlimited_10m_32 ORDER BY key)
1.1991.187-0.0100.052questdb_sum_float643SELECT sum(x) FROM `zz_Float64 NULL_MergeTree ORDER BY tuple()`
0.1890.180-0.0460.052json_extract_rapidjson0SELECT \'rapidjson-1\', count() FROM zeros(1000000) WHERE NOT ignore(JSONExtractString(materialize(\'{"sparam":"test_string","nparam": 772}\'), \'sparam\'))
0.8550.821-0.0400.052int_parsing52SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(RemoteIP)) SETTINGS max_threads = 1
0.5690.567-0.0040.052int_parsing31SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(ClientTimeZone)) SETTINGS max_threads = 1
0.6140.595-0.0310.052if_string_const2SELECT count() FROM zeros(100000000) WHERE NOT ignore(rand() % 2 ? toFixedString(\'hello\', 5) : toFixedString(\'world\', 5))
0.0580.055-0.0490.052fixed_string160SELECT count() FROM test.hits WHERE ClientIP6 < RemoteIP6
0.2660.2730.0230.051slices_hits0SELECT count() FROM hits_100m_single WHERE NOT ignore(substring(URL, 10, 20))
0.2920.3070.0510.051int_parsing19SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(CookieEnable)) SETTINGS max_threads = 1
0.0730.0770.0510.051float_formatting2SELECT count() FROM numbers(10000000) WHERE NOT ignore(toString(toFloat64(number % 10)))
0.4890.4910.0030.051basename0SELECT count() FROM hits_10m_single WHERE NOT ignore(basename(URL))
0.5220.5480.0500.050trim_urls3SELECT count() FROM hits_100m_single WHERE NOT ignore(trim(LEADING \'htpsw:/\' FROM URL))
0.1330.1350.0130.050order_by_read_in_order0SELECT * FROM hits_100m_single ORDER BY CounterID, EventDate LIMIT 100
0.3430.3600.0500.050int_parsing2SELECT count() FROM hits_100m_single WHERE NOT ignore(toString(GoodEvent)) SETTINGS max_threads = 1
0.4940.5200.0500.050constant_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\'])

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.001x1248550243307
bit_operations_fixed_string_numbers-2.065x2220
general_purpose_hashes_on_UUID-1.704x2016115
random_string_utf8-1.602x7770
bit_operations_fixed_string-1.502x4330
decimal_casts-1.412x1513103
round_down-1.386x5532
float_mod-1.382x1110
format_date_time-1.255x6660
ngram_distance-1.252x1611110
merge_tree_many_partitions-1.222x1000
cidr-1.221x2110
date_time_short-1.173x1615123
codecs_int_insert-1.170x2011110
injective_functions_inside_uniq-1.155x2220
array_auc-1.148x1110
merge_tree_many_partitions_2-1.132x1101
complex_array_creation-1.126x2110
codecs_float_insert-1.124x15000
generate_table_function-1.120x1915150
insert_values_with_expressions-1.116x2110
random_printable_ascii-1.112x7110
decimal_aggregates-1.110x20321
array_element-1.102x3330
linear_regression-1.099x5541
parallel_index-1.099x3110
base64-1.089x9990
aggregating_merge_tree-1.087x1110
array_reduce-1.086x6431
sort_radix_trivial-1.083x3330
array_join-1.081x6220
polymorphic_parts_s-1.080x3321
array_fill-1.079x6550
duplicate_order_by_and_distinct-1.076x3220
local_replica-1.074x1000
synthetic_hardware_benchmark-1.073x201266
if_array_string-1.073x6101
float_formatting-1.057x2017107
math-1.051x20220
pre_limit_no_sorting-1.051x1000
arithmetic_operations_in_aggr_func-1.050x6321
fixed_string16-1.050x1101
polymorphic_parts_m-1.049x3211
materialized_view_parallel_insert-1.047x1000
joins_in_memory_pmj-1.045x20000
conditional-1.045x8624
information_value-1.044x2110
monotonous_order_by-1.044x2110
questdb_sum_float32-1.043x4312
sort-1.042x10743
consistent_hashes-1.040x7440
redundant_functions_in_order_by-1.037x3110
parallel_insert-1.037x1000
scalar-1.034x1000
distinct_combinator-1.033x4220
general_purpose_hashes-1.033x20000
rand-1.033x3321
vectorize_aggregation_combinators-1.031x5413
jit_small_requests-1.031x3202
group_array_moving_sum-1.028x12000
random_fixed_string-1.025x4312
json_extract_rapidjson-1.024x13927
random_string-1.024x7000
date_time_64-1.024x18844
arithmetic-1.022x20000
url_hits-1.022x19642
logical_functions_medium-1.022x20000
joins_in_memory-1.019x20000
decimal_parse-1.018x1000
functions_with_hash_tables-1.017x6422
json_extract_simdjson-1.017x13211
functions_coding-1.017x4101
mingroupby-orderbylimit1-1.016x8000
string_join-1.014x3101
if_string_const-1.011x4312
questdb_sum_int32-1.011x4413
order_by_read_in_order-1.011x5514
least_greatest_hits-1.011x3101
aggregation_in_order-1.010x4101
fuzz_bits-1.009x7000
website-1.008x20000
bloom_filter-1.008x1000
h3-1.007x1101
bounding_ratio-1.006x2211
right-1.006x2000
order_with_limit-1.005x201495
parallel_final-1.004x20606
codecs_int_select-1.003x2015312
parallel_mv-1.000x1101
trim_urls+1.000x6202
set_index+1.003x8101
IPv6+1.006x2211
select_format+1.009x20000
datetime_comparison+1.010x3101
parse_engine_file+1.011x14000
set_hits+1.013x6202
removing_group_by_keys+1.014x2000
questdb_sum_float64+1.014x4303
trim_numbers+1.016x6404
cpu_synthetic+1.016x20000
collations+1.019x2000
if_transform_strings_to_enum+1.022x4101
constant_column_search+1.023x20927
analyze_array_tuples+1.023x1000
extract+1.024x5000
modulo+1.024x3312
string_set+1.026x7505
read_from_comp_parts+1.026x5514
great_circle_dist+1.028x2000
array_index_low_cardinality_strings+1.031x10000
basename+1.032x2202
simple_join_query+1.033x4000
codecs_float_select+1.036x151037
range+1.037x2000
columns_hashing+1.041x5000
column_column_comparison+1.041x19000
point_in_polygon+1.042x1101
sum+1.047x161569
int_parsing+1.048x2011110
jit_large_requests+1.048x2000
string_sort+1.056x20000
slices_hits+1.059x2202
concat_hits+1.064x2013112
if_string_hits+1.066x4202
cryptographic_hashes+1.066x20000
base64_hits+1.069x12808
number_formatting_formats+1.072x14000
order_by_decimals+1.073x5422
early_constant_folding+1.075x1101
read_hits_with_aio+1.081x4404
trim_whitespace+1.084x6514
insert_select_default_small_block+1.085x1101
inserts_arrays_lowcardinality+1.085x2202
merge_table_streams+1.086x1101
set+1.092x13211
point_in_polygon_const+1.099x1101
distributed_aggregation_memory_efficient+1.106x1101
merge_tree_simple_select+1.125x1000
push_down_limit+1.127x2000
logical_functions_small+1.135x17716
order_by_single_column+1.143x7000
merge_tree_huge_pk+1.144x4220
date_parsing+1.150x1000
insert_parallel+1.160x1101
float_parsing+1.175x10909
round_methods+1.201x151587
constant_column_comparison+1.208x2014014
IPv4+1.221x4413
bitCount+1.227x6624
if_array_num+1.235x6606
distributed_aggregation+1.252x4404
array_index_low_cardinality_numbers+1.255x9927
sum_map+1.270x8606
any_anyLast+1.283x4413
leftpad+1.299x7606
visit_param_extract_raw+1.333x3303
functions_geo+1.339x6404
empty_string_serialization+1.471x1101
if_to_multiif+1.516x5505
empty_string_deserialization+1.557x1101
logical_functions_large+1.590x10404
and_function+1.729x2202

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
read_in_order_many_parts265.34427.601610.64244.2230.812
group_array_moving_sum281.888161.9501219.14723.4907.424
sum_map176.59377.850810.19322.0749.377
array_index_low_cardinality_numbers192.99953.34597.59021.4441.426
empty_string_serialization20.5428.63418.63420.5418.634
array_fill118.71159.783617.02519.7854.562
simple_join_query78.37329.73247.50519.5937.393
read_from_comp_parts97.61724.61558.29219.5231.252
general_purpose_hashes383.721245.7282025.13119.1862.651
parallel_insert19.0717.88317.88319.0707.883
questdb_sum_float3276.04833.464416.05019.0112.119
array_element56.46223.90938.92018.8206.215
materialized_view_parallel_insert18.7657.81817.81818.7647.818
questdb_sum_float6474.33735.538416.49518.5841.856
float_parsing182.96188.1371017.75918.2962.136
questdb_sum_int3272.5132.760415.32118.1272.190
point_in_polygon17.8811.57011.57017.8811.570
joins_in_memory354.84185.0082013.76517.7412.301
if_string_const70.28342.507411.62817.5708.522
date_time_short254.878127.8421617.64615.9293.943
trim_urls91.47556.260623.29415.2455.149
polymorphic_parts_s45.51219.020310.90215.1703.719
leftpad106.09846.563710.61715.1564.728
and_function29.79915.348214.04314.8991.304
constant_column_comparison283.398128.261209.62714.1692.255
codecs_float_insert211.75192.4561510.08314.1162.394
polymorphic_parts_m41.84520.347311.89213.9483.937
empty_string_deserialization13.9112.05712.05713.9112.057
basename27.21114.95728.13213.6056.825
int_parsing262.837130.7722012.82213.1414.078
array_reduce76.61531.71568.04912.7692.476
joins_in_memory_pmj252.948175.8672017.20412.6474.016
functions_coding49.76830.662414.16912.4423.215
if_transform_strings_to_enum49.14125.197413.45712.2853.836
trim_numbers73.2746.685619.64712.2111.487
parallel_final244.183128.0622015.74512.2091.803
parse_engine_file170.30481.4141411.35512.1640.939
array_index_low_cardinality_strings120.36253.349107.45112.0362.511
set156.35668.8941311.48312.0271.541
base64_hits143.19388.5391214.65511.9321.208
set_hits71.52134.690612.51211.9201.909
logical_functions_large118.50862.1741030.89211.8502.306
select_format226.914127.7652010.54211.3452.425
columns_hashing56.14937.181517.92211.2291.415
bounding_ratio22.3649.53425.66911.1823.865
prewhere11.0129.18219.18211.0129.182
redundant_functions_in_order_by32.9119.384316.16910.9691.575
entropy97.58962.453913.02310.8431.827
parallel_index32.51222.651315.05710.8373.672
decimal_casts161.53678.2231523.33310.7691.055
first_significant_subdomain10.7198.88418.88410.7188.884
random_printable_ascii74.52734.932713.57110.6461.775
datetime_comparison31.10526.81139.17810.3688.792
decimal_aggregates202.88692.9682015.21510.1441.102
float_formatting193.65485.251209.5189.6820.935
functions_with_hash_tables57.98830.56669.3019.6641.590
url_hits183.572101.7451912.4069.6613.373
collations19.047.17826.4419.5200.736
generate_table_function176.66984.5831912.9579.2980.583
least_greatest_hits27.84213.765310.6979.2800.414
distinct_combinator36.89115.80744.9959.2221.401
column_column_comparison174.01391.7361916.2069.1581.306
string_sort179.524107.3912019.5198.9760.776
general_purpose_hashes_on_UUID178.80876.4022013.4058.9400.451
number_formatting_formats124.51670.7841418.6788.8931.786
arithmetic177.589128.120209.7508.8792.394
json_extract_rapidjson114.35778.7911311.2838.7962.484
insert_values_with_expressions17.47310.30725.8518.7364.456
codecs_int_insert165.95178.935208.3508.2971.154
bit_operations_fixed_string_numbers16.3986.90223.6988.1993.204
modulo24.0910.33235.3398.0302.495
ngram_distance126.7256.981165.9367.9202.529
array_join47.33322.23765.2567.8881.310
if_string_hits31.38417.030410.0927.8460.983
logical_functions_medium155.86572.701204.9847.7931.252
base6465.88128.19095.4587.3201.255
extract36.21817.43354.5807.2431.964
round_down36.16318.091513.9287.2320.540
synthetic_hardware_benchmark144.27281.7672025.6207.2130.610
range14.4146.07724.3287.2061.748
uniq143.52594.5762017.4207.1760.556
vectorize_aggregation_combinators33.5316.73156.5626.7050.370
cryptographic_hashes133.98457.0262017.1326.6990.650
sort66.36238.813108.2246.6362.235
math132.56670.4792012.2296.6281.559
website130.1295.6092023.3326.5050.415
complex_array_creation12.9295.34622.8026.4642.543
duplicate_order_by_and_distinct18.86813.311310.5696.2891.158
read_hits_with_aio25.0511.63844.0346.2621.777
format_date_time37.57815.98363.5326.2620.795
string_join18.67713.13135.5126.2252.912
logical_functions_small105.61649.636174.5756.2122.106
IPv612.4125.09823.6366.2051.462
codecs_float_select91.71137.673154.7326.1140.840
local_replica6.1142.39012.3906.1132.390
if_to_multiif29.84612.76255.7015.9690.549
consistent_hashes41.43628.33579.0825.9190.513
visit_param_extract_raw17.6337.56935.0745.8770.766
concat_hits116.55671.443209.1355.8270.625
merge_tree_huge_pk23.30614.89744.0335.8262.832
inserts_arrays_lowcardinality11.5864.60023.6545.7930.946
round_methods86.74638.994153.7815.7832.102
linear_regression28.7769.42854.3555.7550.397
json_extract_simdjson74.7941.148137.4195.7531.681
single_fixed_string_groupby11.4258.05424.0295.7124.025
bloom_filter5.5164.35814.3585.5154.358
injective_functions_inside_uniq10.7324.45022.2415.3662.209
date_time_6496.44849.2271810.8515.3580.447
float_mod5.3572.11812.1185.3562.118
order_by_single_column37.13515.00375.8005.3040.481
array_auc5.2812.09112.0915.2812.091
cpu_synthetic105.09867.233208.3795.2540.720
functions_geo31.35614.54964.6265.2261.065
decimal_parse5.2254.10514.1055.2244.105
jit_small_requests15.45710.62137.5115.1521.408
mingroupby-orderbylimit141.07124.84384.6895.1331.458
if_array_string30.74218.72264.5135.1231.638
order_with_limit101.64642.968205.6655.0820.310
polymorphic_parts_l15.20712.24335.4845.0681.957
monotonous_order_by10.1223.92122.5795.0601.342
analyze_array_tuples4.964.04414.0444.9604.044
aggregation_in_order19.68613.46545.1074.9210.448
order_by_read_in_order24.57911.46555.8324.9150.884
aggregating_merge_tree4.8181.43511.4354.8171.435
right9.3317.71723.9864.6653.731
codecs_int_select93.30442.581204.8724.6650.865
if_array_num27.66811.76962.5894.6111.348
string_set30.56523.54474.5914.3662.077
merge_tree_many_partitions_24.1522.03912.0394.1512.039
point_in_polygon_const4.1251.59511.5954.1251.595
trim_whitespace24.0176.67061.4634.0020.517
bitCount23.85410.15262.1853.9751.312
scalar3.8590.95410.9543.8580.954
set_index30.41122.20184.1073.8010.929
sum60.75728.321163.2763.7970.636
conditional29.27916.92883.7433.6591.093
merge_tree_many_partitions3.6271.20911.2093.6271.209
removing_group_by_keys7.1885.80022.9263.5942.873
distributed_aggregation14.1235.23841.6793.5301.169
arithmetic_operations_in_aggr_func20.9369.30161.9243.4890.862
slices_hits6.8314.52223.7543.4150.767
date_parsing3.3031.19311.1933.3021.193
merge_tree_simple_select3.3011.01011.0103.3011.010
rand9.5213.90532.4863.1730.535
cidr6.2282.43321.8193.1140.614
sort_radix_trivial9.1023.69631.4013.0341.022
distributed_aggregation_memory_efficient2.8932.09012.0902.8922.090
early_constant_folding2.8651.04611.0462.8651.046
merge_table_streams2.6850.94310.9432.6840.943
jit_large_requests5.3574.50724.0122.6780.495
pre_limit_no_sorting2.520.84110.8412.5190.841
bit_operations_fixed_string9.5474.34541.1962.3860.842
fixed_string162.2910.79210.7922.2900.792
order_by_decimals11.2865.49751.6562.2570.466
random_string_utf815.7456.64371.2102.2490.587
insert_parallel2.2461.56311.5632.2461.563
h32.1751.48011.4802.1741.480
random_string14.0477.03472.0622.0060.537
push_down_limit4.0071.42021.0102.0030.410
any_anyLast7.7183.20940.8211.9290.766
parallel_mv1.9211.16711.1671.9211.167
aggregate_functions_of_group_by_keys2.9932.15521.5731.4960.581
count1.4880.78910.7891.4880.789
random_fixed_string5.6713.76441.2421.4170.678
fuzz_bits9.4637.11171.3321.3510.648
IPv45.2711.99840.6141.3170.379
insert_select_default_small_block1.2790.68910.6891.2790.689
great_circle_dist2.2970.95420.6181.1480.336
information_value2.2830.93820.5891.1410.349

Metric Changes ?

MetricOld median valueNew median valueRelative differenceTimes difference
jemalloc.resident285775462432338452480.1311.131
jemalloc.mapped302053376033851064320.1201.120
jemalloc.arenas.all.pdirty3762844169930.1081.108
MemoryCode2873671683148840960.0951.095
MemoryShared7569817666834432-0.1171.132
jemalloc.active320536576242147328-0.2441.323
jemalloc.arenas.all.pactive7825659118-0.2441.323
jemalloc.allocated273217240197770696-0.2761.381