ClickHouse Benchmark - OpenBenchmarking.org

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/ with the 100 million rows web analytics dataset. The reported value is the query processing time using the geometric mean of all queries performed.

To run this test with the Phoronix Test Suite, the basic command is: phoronix-test-suite benchmark clickhouse.

* Uploading of benchmark result data to OpenBenchmarking.org is always optional (opt-in) via the Phoronix Test Suite for users wishing to share their results publicly.
** Data based on those opting to upload their test results to OpenBenchmarking.org and users enabling the opt-in anonymous statistics reporting while running benchmarks from an Internet-connected platform.
Data current as of 8 August 2022.

Performance Metrics

ClickHouse

100M Rows Web Analytics Dataset, Second Run

OpenBenchmarking.org metrics for this test profile configuration based on 194 public results since 25 June 2022 with the latest data as of 10 August 2022.

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

Percentile Rank

# Compatible Public Results

Queries Per Minute, Geo Mean (Average)

2 x AMD EPYC 7773X 64-Core

97th

420 ^{+/- 3}

AMD EPYC 7773X 64-Core

97th

418 ^{+/- 8}

2 x AMD EPYC 7713 64-Core

92nd

405 ^{+/- 10}

2 x AMD EPYC 7763 64-Core

89th

396 ^{+/- 1}

AMD EPYC 7713 64-Core

84th

387 ^{+/- 1}

2 x AMD EPYC 75F3 32-Core

82nd

385 ^{+/- 13}

Intel Xeon Platinum 8380

78th

347 ^{+/- 6}

Mid-Tier

75th

< 318

AMD Ryzen Threadripper PRO 5965WX 24-Cores

70th

307 ^{+/- 19}

AMD Ryzen Threadripper 3970X 32-Core

70th

306 ^{+/- 20}

2 x AMD EPYC 7742 64-Core

67th

274 ^{+/- 14}

AMD Ryzen Threadripper 3990X 64-Core

64th

262 ^{+/- 6}

2 x AMD EPYC 7601 32-Core

62nd

260 ^{+/- 6}

Intel Core i9-12900K

60th

257 ^{+/- 3}

2 x Intel Xeon Platinum 8280

55th

240 ^{+/- 9}

AMD Ryzen Threadripper 3960X 24-Core

53rd

235 ^{+/- 4}

Median

50th

227

AMD EPYC 72F3 8-Core

45th

197 ^{+/- 8}

AMD Ryzen 9 5950X 16-Core

44th

192 ^{+/- 4}

Intel Xeon Gold 6226R

39th

186 ^{+/- 5}

Intel Core i9-10980XE

38th

183 ^{+/- 5}

Intel Core i5-12600K

34th

175 ^{+/- 1}

AMD Ryzen 9 3900XT 12-Core

27th

163 ^{+/- 1}

Low-Tier

25th

< 162

AMD Ryzen 9 3900X 12-Core

25th

159

Intel Core i5-12400

22nd

133 ^{+/- 6}

AMD Ryzen 7 PRO 5850U

19th

114 ^{+/- 2}

AMD Ryzen 9 5900HX

17th

111 ^{+/- 2}

Intel Core i3-12100

14th

97 ^{+/- 2}

AMD Ryzen 7 1700 Eight-Core

12th

AMD Ryzen 5 5500U

11th

85 ^{+/- 1}

Intel Core i7-1165G7

8th

79 ^{+/- 1}

Intel Core i7-1185G7

7th

78 ^{+/- 2}

Intel Core i7-1065G7

5th

67 ^{+/- 1}

AMD Ryzen 7 4800U

3rd

59 ^{+/- 2}

Based on OpenBenchmarking.org data, the selected test / test configuration (ClickHouse - 100M Rows Web Analytics Dataset, Second Run) has an average run-time of 13 minutes. By default this test profile is set to run at least 3 times but may increase if the standard deviation exceeds pre-defined defaults or other calculations deem additional runs necessary for greater statistical accuracy of the result.

Based on public OpenBenchmarking.org results, the selected test / test configuration has an average standard deviation of 0.8%.

Notable Instruction Set Usage

Notable instruction set extensions supported by this test, based on an automatic analysis by the Phoronix Test Suite / OpenBenchmarking.org analytics engine.

Instruction Set

Support

Instructions Detected

Last automated analysis: 27 June 2022

Tested CPU Architectures

This benchmark has been successfully tested on the below mentioned architectures. The CPU architectures listed is where successful OpenBenchmarking.org result uploads occurred, namely for helping to determine if a given test is compatible with various alternative CPU architectures.

Core i9 10980XE Linux Ubuntu 3 Systems - 11 Benchmark Results	Intel Core i9-10980XE - ASRock X299 Steel Legend - Intel Sky Lake-E DMI3 Registers Ubuntu 22.04 - 5.19.0-051900rc7-generic - GNOME Shell 42.2
AMD Ryzen Threadripper 3990X 2 Systems - 620 Benchmark Results	AMD Ryzen Threadripper 3990X 64-Core - Gigabyte TRX40 AORUS PRO WIFI - AMD Starship Ubuntu 22.04 - 5.19.0-051900rc7-generic - GNOME Shell 42.2
AMD Ryzen Threadripper 3990X 1 System - 611 Benchmark Results	AMD Ryzen Threadripper 3990X 64-Core - Gigabyte TRX40 AORUS PRO WIFI - AMD Starship Ubuntu 22.04 - 5.19.0-051900rc7-generic - GNOME Shell 42.2
TR 3990X 1 System - 645 Benchmark Results	AMD Ryzen Threadripper 3990X 64-Core - Gigabyte TRX40 AORUS PRO WIFI - AMD Starship Ubuntu 22.04 - 5.19.0-051900rc7-generic - GNOME Shell 42.2
xeon 4 Systems - 149 Benchmark Results	Intel Xeon E3-1260L v5 - ASRock E3V5 WS - Intel Xeon E3-1200 v5 Ubuntu 22.04 - 5.15.0-41-generic - GNOME Shell 42.2
Xeon Platinum 8380 2 Systems - 122 Benchmark Results	Intel Xeon Platinum 8380 - Intel M50CYP2SB2U - Intel Device 0998 Ubuntu 22.04 - 5.19.0-051900rc4daily20220628-generic - GNOME Shell 42.2
icelake ospray studio clickhouse 2 Systems - 21 Benchmark Results	2 x Intel Xeon Platinum 8380 - Intel M50CYP2SB2U - Intel Device 0998 Ubuntu 22.04 - 5.15.0-40-generic - GNOME Shell 42.2
amd epyc extra 6 Systems - 53 Benchmark Results	AMD EPYC 7773X 64-Core - AMD DAYTONA_X - AMD Starship Ubuntu 22.04 - 5.19.0-051900rc4daily20220628-generic - GNOME Shell 42.2
amd epyc extra 5 Systems - 69 Benchmark Results	2 x AMD EPYC 7713 64-Core - AMD DAYTONA_X - AMD Starship Ubuntu 22.04 - 5.19.0-051900rc4daily20220628-generic - GNOME Shell 42.2
ryzen 7 4800u MGLRU Linux 2 Systems - 46 Benchmark Results	AMD Ryzen 7 4800U - ASRock 4X4-4000 - AMD Renoir Ubuntu 22.04 - 5.19.0-rc2-phx-mglru-v12 - GNOME Shell 42.2
Core i5 12600K Kernel Build Optimizations Featured Kernel Comparison	5.19.0-rc4-phx-two - 5.19.0-rc4-phx-three - 5.19.0-rc4-phx-three-native
epyc extra 3 Systems - 69 Benchmark Results	2 x AMD EPYC 7763 64-Core - AMD DAYTONA_X - AMD Starship Ubuntu 22.04 - 5.19.0-051900rc4daily20220628-generic - GNOME Shell 42.2
4800u kernel 3 Systems - 221 Benchmark Results	AMD Ryzen 7 4800U - ASRock 4X4-4000 - AMD Renoir Ubuntu 22.04 - 5.15.0-25-generic - GNOME Shell 42.2
5700G June 3 Systems - 93 Benchmark Results	AMD Ryzen 7 5700G - ASUS TUF GAMING B550M-PLUS - AMD Renoir Ubuntu 22.04 - 5.17.4-051704-generic - GNOME Shell 42.2
june skylake 3 Systems - 110 Benchmark Results	Intel Xeon E3-1280 v5 - MSI Z170A SLI PLUS - Intel Xeon E3-1200 v5 Ubuntu 20.04 - 5.13.0-051300-generic - GNOME Shell 3.36.9

ClickHouse

Project Site

Source Repository

Test Created

Test Maintainer

Test Type

Average Install Time

Average Run Time

Supported Platforms

Supported Architectures

Revision History

Suites Using This Test

Database Test Suite

Server

Performance Metrics

ClickHouse

100M Rows Web Analytics Dataset, Second Run

Notable Instruction Set Usage

Tested CPU Architectures

Recent Test Results

Compare

Core i9 10980XE Linux Ubuntu

AMD Ryzen Threadripper 3990X

AMD Ryzen Threadripper 3990X

TR 3990X

xeon

Xeon Platinum 8380

icelake ospray studio clickhouse

amd epyc extra

amd epyc extra

ryzen 7 4800u MGLRU Linux

Core i5 12600K Kernel Build Optimizations

epyc extra

4800u kernel

5700G June

june skylake

Most Popular Test Results