ClickHouse Local
Open ClickHouse Local in the Results Explorer
ClickHouse Local on BenchBox: 64 published runs across 15 benchmarks. Latest run 2026-11-12.
Benchmarks
- AMPLab, 3 runs
- ClickBench, 1 run
- CoffeeShop, 6 runs
- Flight Data, 6 runs
- H2ODB, 3 runs
- JoinOrder, 1 run
- NYC Taxi, 6 runs
- Read Primitives, 6 runs
- SSB, 3 runs
- TPC-DS, 3 runs
- TPC-DS-OBT, 2 runs
- TPC-H, 8 runs
- TPC-H Data Vault, 4 runs
- TPC-H Skew, 6 runs
- TPC-Havoc, 6 runs
Score definitions
- Power score
- Power@Size: scale factor × 3600 divided by the geometric mean of the query times of the final iteration, in seconds. Unit: queries per hour at scale factor size; higher is better. Definition in the benchmark methodology.
- Geomean query time
- Geometric mean of the displayed per-query times of the run. Unit: milliseconds, shown as seconds from 1,000 ms; lower is better. Definition in the benchmark methodology.
Ranked runs
| Benchmark | Scale | Phase | Version | Run date | Score | Geomean | Ranking | Execution environment | Tuning mode | Trust label |
|---|---|---|---|---|---|---|---|---|---|---|
| AMPLab | SF 0.1 | power | — | 2026-08-26 | — | 3.9 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| AMPLab | SF 0.01 | power | — | 2026-08-25 | — | 2 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| AMPLab | SF 1 | power | — | 2026-08-24 | — | 26 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| ClickBench | SF 1 | power | — | 2026-08-26 | — | 6.4 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| CoffeeShop | SF 0.1 | power | — | 2026-10-28 | — | 36 ms | Ranked | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| CoffeeShop | SF 0.01 | power | — | 2026-10-28 | — | 13 ms | Ranked | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| CoffeeShop | SF 1 | power | — | 2026-10-28 | — | 238 ms | Ranked | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| Flight Data | SF 0.1 | power | — | 2026-10-26 | — | 59 ms | Ranked | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| Flight Data | SF 0.01 | power | — | 2026-10-26 | — | 32 ms | Ranked | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| Flight Data | SF 0.01 | power | — | 2026-08-26 | — | 18 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| Flight Data | SF 0.1 | power | — | 2026-08-26 | — | 36 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| Flight Data | SF 1 | power | — | 2026-10-26 | — | 524 ms | Ranked | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| Flight Data | SF 1 | power | — | 2026-08-26 | — | 369 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| H2ODB | SF 0.1 | power | — | 2026-08-26 | — | 3.3 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| H2ODB | SF 0.01 | power | — | 2026-08-26 | — | 1.8 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| H2ODB | SF 1 | power | — | 2026-08-25 | — | 20 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| JoinOrder | SF 1 | power | — | 2026-08-25 | — | 122 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| NYC Taxi | SF 0.01 | power | — | 2026-10-26 | — | 6.8 ms | Ranked | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| NYC Taxi | SF 0.1 | power | — | 2026-10-26 | — | 10 ms | Ranked | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| NYC Taxi | SF 0.01 | power | — | 2026-08-26 | — | 2.8 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| NYC Taxi | SF 0.1 | power | — | 2026-08-26 | — | 5.6 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| NYC Taxi | SF 1 | power | — | 2026-10-26 | — | 61 ms | Ranked | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| NYC Taxi | SF 1 | power | — | 2026-08-26 | — | 29 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SSB | SF 0.1 | power | — | 2026-08-26 | — | 9 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SSB | SF 0.01 | power | — | 2026-08-25 | — | 3.1 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SSB | SF 1 | power | — | 2026-08-25 | — | 67 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H | SF 0.1 | power | — | 2026-10-26 | 8,171 | 46 ms | Ranked | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| TPC-H | SF 0.01 | power | — | 2026-10-26 | 2,407 | 16 ms | Ranked | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| TPC-H Data Vault | SF 0.1 | power | — | 2026-10-26 | — | 127 ms | Ranked | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| TPC-H Data Vault | SF 0.01 | power | — | 2026-10-26 | — | 35 ms | Ranked | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| TPC-H Skew | SF 0.1 | power | — | 2026-10-26 | — | 16 ms | Ranked | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| TPC-H Skew | SF 0.01 | power | — | 2026-10-26 | — | 9.4 ms | Ranked | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| TPC-H Skew | SF 1 | power | — | 2026-10-26 | — | 128 ms | Ranked | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
Runs not included in rankings
31 runs are published with their numbers and receipt but are not ranked. Reason: Known defective data. (26); Mismatched query set. (2); Non-standard runs are unofficial and are not ranked. (2); One or more queries failed. (1)
| Benchmark | Scale | Phase | Version | Run date | Score | Geomean | Reason not ranked | Execution environment | Tuning mode | Trust label |
|---|---|---|---|---|---|---|---|---|---|---|
| CoffeeShop | SF 0.1 | power | — | 2026-08-26 | — | 13 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| CoffeeShop | SF 0.01 | power | — | 2026-08-24 | — | 5.2 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| CoffeeShop | SF 1 | power | — | 2026-08-26 | — | 92 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| Read Primitives | SF 0.01 | power | — | 2026-11-12 | — | 5.9 ms | Mismatched query set. | Local, Arm64, 5.9 GB | No tuning | Maintainer Run |
| Read Primitives | SF 0.1 | power | — | 2026-11-12 | — | 9.3 ms | Mismatched query set. | Local, Arm64, 5.9 GB | No tuning | Maintainer Run |
| Read Primitives | SF 0.1 | power | — | 2026-10-26 | — | 10 ms | Known defective data. | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| Read Primitives | SF 0.01 | power | — | 2026-10-26 | — | 5.6 ms | Known defective data. | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| Read Primitives | SF 0.01 | power | — | 2026-08-26 | — | 1.8 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| Read Primitives | SF 0.1 | power | — | 2026-08-25 | — | 4.5 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-DS | SF 1 | power | — | 2026-10-26 | — | 190 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| TPC-DS | SF 1 | power | — | 2026-10-01 | 35,782 | 94 ms | Known defective data. | Local, x86-64, AMD EPYC, 15.6 GB | No tuning | Maintainer Run |
| TPC-DS | SF 1 | power | — | 2026-08-26 | — | 59 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-DS-OBT | SF 1 | power | — | 2026-10-26 | — | 271 ms | One or more queries failed. | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| TPC-DS-OBT | SF 1 | power | — | 2026-08-26 | — | 79 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H | SF 0.01 | power | — | 2026-08-26 | 2,591 | 13 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H | SF 0.1 | power | — | 2026-08-26 | 14,042 | 26 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H | SF 1 | power | — | 2026-10-26 | — | 215 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| TPC-H | SF 1 | power | — | 2026-10-13 | — | 92 ms | Known defective data. | Local, x86-64, Intel Xeon, 15.6 GB | No tuning | Maintainer Run |
| TPC-H | SF 1 | power | — | 2026-10-01 | — | 119 ms | Known defective data. | Local, x86-64, AMD EPYC, 15.6 GB | No tuning | Maintainer Run |
| TPC-H | SF 1 | power | — | 2026-08-25 | 50,828 | 70 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H Data Vault | SF 0.01 | power | — | 2026-08-26 | — | 11 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H Data Vault | SF 0.1 | power | — | 2026-08-26 | — | 48 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H Skew | SF 0.1 | power | — | 2026-08-26 | — | 12 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H Skew | SF 0.01 | power | — | 2026-08-24 | — | 4.1 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H Skew | SF 1 | power | — | 2026-08-25 | — | 40 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-Havoc | SF 0.1 | power | — | 2026-10-26 | — | 20 ms | Known defective data. | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| TPC-Havoc | SF 0.01 | power | — | 2026-10-26 | — | 11 ms | Known defective data. | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| TPC-Havoc | SF 0.1 | power | — | 2026-08-26 | — | 13 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-Havoc | SF 0.01 | power | — | 2026-08-26 | — | 5.2 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-Havoc | SF 1 | power | — | 2026-10-26 | — | 183 ms | Known defective data. | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| TPC-Havoc | SF 1 | power | — | 2026-08-26 | — | 93 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |