ClickHouse is an open-source, high performance OLAP data management system. This test profile uses ClickHouse's standard benchmark recommendations per https://clickhouse.com/docs/en/operations/performance-test/ / https://github.com/ClickHouse/ClickBench/tree/main/clickhouse with the 100 million rows web analytics dataset. The reported value is the query processing time using the geometric mean of all separate queries performed as an aggregate.
Below is an overview of the generalized performance for components where there is sufficient statistically significant data based upon user-uploaded results. It is important to keep in mind particularly in the Linux/open-source space there can be vastly different OS configurations, with this overview intended to offer just general guidance as to the performance expectations.
Component
Details
Percentile Rank
# Compatible Public Results
Queries Per Minute, Geo Mean (Average)
Zen 5 [128 Cores / 256 Threads]
100th
3
839
Zen 5 [64 Cores / 128 Threads]
100th
7
806 +/- 5
Zen 5 [96 Cores / 192 Threads]
100th
14
769 +/- 16
Zen 5 [96 Cores / 192 Threads]
100th
8
768 +/- 5
Zen 5 [192 Cores / 384 Threads]
99th
5
744 +/- 4
Zen 5 [128 Cores / 256 Threads]
97th
14
723 +/- 6
Zen 5 [256 Cores / 512 Threads]
95th
14
628 +/- 77
Zen 4 [128 Cores / 256 Threads]
95th
7
622 +/- 19
Zen 5 [192 Cores / 384 Threads]
94th
3
598
Zen 4 [96 Cores / 192 Threads]
93rd
18
581 +/- 14
Zen 4 [96 Cores / 192 Threads]
93rd
26
580 +/- 30
Zen 4 [64 Cores / 128 Threads]
92nd
4
569 +/- 5
Zen 4 [192 Cores / 384 Threads]
90th
25
550 +/- 37
Zen 5 [384 Cores / 768 Threads]
86th
3
510
Sapphire Rapids [60 Cores / 120 Threads]
82nd
17
482 +/- 4
Sapphire Rapids [56 Cores / 112 Threads]
81st
6
477 +/- 1
Sapphire Rapids [48 Cores / 96 Threads]
80th
7
474 +/- 13
Sapphire Rapids [48 Cores / 96 Threads]
79th
5
463 +/- 52
Emerald Rapids [64 Cores / 128 Threads]
78th
13
460 +/- 4
Zen 3 [64 Cores / 128 Threads]
77th
5
453 +/- 7
Zen 4 [128 Cores / 256 Threads]
77th
17
452 +/- 6
Zen 4 [96 Cores / 192 Threads]
76th
3
450 +/- 52
Zen 3 [64 Cores / 128 Threads]
73rd
4
437
Zen 3 [32 Cores / 64 Threads]
73rd
4
433 +/- 4
Zen 4 [256 Cores / 512 Threads]
73rd
16
429 +/- 17
Zen 3 [32 Cores / 64 Threads]
71st
3
425
Ice Lake [48 Cores / 96 Threads]
71st
3
425
Granite Rapids [128 Cores / 256 Threads]
71st
7
425 +/- 11
Sapphire Rapids [52 Cores / 104 Threads]
70th
3
412 +/- 1
Sierra Forest [144 Cores / 144 Threads]
68th
5
401
Ice Lake [80 Cores / 160 Threads]
67th
9
395 +/- 57
Sapphire Rapids [32 Cores / 64 Threads]
66th
5
382 +/- 35
Sierra Forest [144 Cores / 144 Threads]
65th
5
380
Zen 3 [32 Cores / 64 Threads]
64th
7
379 +/- 1
Ice Lake [32 Cores / 64 Threads]
64th
3
379
Zen 3 [64 Cores / 128 Threads]
64th
6
378 +/- 3
Zen 3 [128 Cores / 256 Threads]
64th
18
373 +/- 50
Zen 4 [64 Cores / 128 Threads]
64th
6
370 +/- 22
Zen 3 [22 Cores / 48 Threads]
63rd
3
361
Zen 4 [32 Cores / 64 Threads]
62nd
3
356 +/- 7
Zen 3 [64 Cores / 128 Threads]
61st
4
345 +/- 15
Ice Lake [40 Cores / 80 Threads]
61st
4
344 +/- 2
Zen 4 [64 Cores / 128 Threads]
59th
14
337 +/- 4
Zen 4 [64 Cores / 128 Threads]
59th
8
335 +/- 4
Zen 5 [8 Cores / 16 Threads]
57th
6
323 +/- 4
Sierra Forest [288 Cores / 288 Threads]
57th
3
321
Raptor Lake [24 Cores / 32 Threads]
54th
28
308 +/- 4
Zen 4 [16 Cores / 32 Threads]
53rd
29
304 +/- 11
Raptor Lake [24 Cores / 32 Threads]
52nd
8
301 +/- 1
Zen 5 [12 Cores / 24 Threads]
51st
7
300 +/- 1
Zen 3 [24 Cores / 48 Threads]
50th
4
299 +/- 1
Zen 4 [12 Cores / 24 Threads]
47th
4
292
Zen 5 [16 Cores / 32 Threads]
46th
22
291 +/- 6
Zen 4 [16 Cores / 32 Threads]
46th
4
291
Zen 4 [12 Cores / 24 Threads]
46th
20
291 +/- 10
Arrow Lake [24 Cores / 24 Threads]
45th
8
287 +/- 4
Zen 4 [12 Cores / 24 Threads]
42nd
22
276 +/- 9
Raptor Lake [14 Cores / 20 Threads]
42nd
3
275
Raptor Lake [14 Cores / 20 Threads]
40th
7
273 +/- 2
Zen 4 [8 Cores / 16 Threads]
39th
18
270 +/- 5
Zen 4 [16 Cores / 32 Threads]
38th
26
268 +/- 9
Zen 5 [8 Cores / 16 Threads]
37th
8
265 +/- 5
Zen 4 [12 Cores / 24 Threads]
35th
3
259
Zen 4 [12 Cores / 24 Threads]
32nd
14
251 +/- 16
Zen 4 [16 Cores / 32 Threads]
32nd
5
250 +/- 4
Zen 5 [6 Cores / 12 Threads]
32nd
10
250 +/- 3
Raptor Lake [8 Cores / 16 Threads]
30th
8
245 +/- 5
Arrow Lake [14 Cores / 14 Threads]
30th
5
244 +/- 1
Zen 4 [8 Cores / 16 Threads]
30th
16
243 +/- 10
Zen 4 [8 Cores / 16 Threads]
29th
9
239 +/- 9
Zen 4 [8 Cores / 16 Threads]
28th
3
233
Zen 4 [8 Cores / 16 Threads]
27th
4
232 +/- 2
Zen 2 [32 Cores / 64 Threads]
27th
3
231 +/- 4
Raptor Lake [14 Cores / 20 Threads]
25th
7
224
Raptor Lake [10 Cores / 16 Threads]
25th
7
222 +/- 4
Zen 4 [6 Cores / 12 Threads]
24th
7
221 +/- 4
Zen 4 [6 Cores / 12 Threads]
24th
15
220 +/- 6
Granite Rapids [256 Cores / 512 Threads]
22nd
10
215 +/- 4
Zen 4 [6 Cores / 12 Threads]
22nd
3
214
Zen 4 [8 Cores / 16 Threads]
19th
7
210 +/- 2
Raptor Lake [10 Cores / 16 Threads]
19th
5
210
Cascade Lake [48 Cores / 96 Threads]
19th
6
209 +/- 2
Zen 4 [6 Cores / 12 Threads]
18th
4
201
Zen 4 [6 Cores / 12 Threads]
17th
9
197 +/- 5
Zen 2 [64 Cores / 128 Threads]
16th
4
190 +/- 2
Zen 2 [24 Cores / 48 Threads]
16th
4
190 +/- 2
Zen 3 [8 Cores / 16 Threads]
15th
15
187 +/- 16
Alder Lake [10 Cores / 16 Threads]
13th
3
172 +/- 1
Zen 4 [4 Cores / 8 Threads]
12th
4
168 +/- 1
Raptor Lake [4 Cores / 8 Threads]
12th
8
164 +/- 2
Alder Lake [14 Cores / 20 Threads]
11th
3
160 +/- 1
Zen 3 [12 Cores / 24 Threads]
11th
8
156 +/- 18
Zen 3 [8 Cores / 16 Threads]
11th
9
154 +/- 15
Cascade Lake [18 Cores / 36 Threads]
10th
4
148 +/- 4
Zen 3 [6 Cores / 12 Threads]
10th
5
146 +/- 12
Zen 3 [6 Cores / 12 Threads]
9th
3
141 +/- 2
Zen 2 [6 Cores / 12 Threads]
8th
3
134 +/- 1
Zen 3 [6 Cores / 12 Threads]
7th
6
126 +/- 5
Zen 3 [8 Cores / 16 Threads]
6th
4
119 +/- 4
Rocket Lake [8 Cores / 16 Threads]
5th
7
113 +/- 1
Tiger Lake [4 Cores / 8 Threads]
4th
4
105 +/- 5
Rocket Lake [6 Cores / 12 Threads]
4th
5
104
Zen 3 [8 Cores / 16 Threads]
4th
3
102 +/- 1
Zen 3 [8 Cores / 16 Threads]
4th
3
91 +/- 1
Zen 2 [6 Cores / 12 Threads]
3rd
4
79 +/- 1
Zen 2 [6 Cores / 6 Threads]
3rd
3
69 +/- 1
Zen 2 [8 Cores / 8 Threads]
3rd
3
69 +/- 1
Zen 2 [8 Cores / 16 Threads]
2nd
3
46 +/- 2
