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

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

BenchmarkScalePhaseVersionRun dateScoreGeomeanRankingExecution environmentTuning modeTrust label
AMPLabSF 0.1power—2026-08-26—3.9 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
AMPLabSF 0.01power—2026-08-25—2 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
AMPLabSF 1power—2026-08-24—26 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
ClickBenchSF 1power—2026-08-26—6.4 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
CoffeeShopSF 0.1power—2026-10-28—36 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
CoffeeShopSF 0.01power—2026-10-28—13 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
CoffeeShopSF 1power—2026-10-28—238 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
Flight DataSF 0.1power—2026-10-26—59 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
Flight DataSF 0.01power—2026-10-26—32 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
Flight DataSF 0.01power—2026-08-26—18 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
Flight DataSF 0.1power—2026-08-26—36 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
Flight DataSF 1power—2026-10-26—524 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
Flight DataSF 1power—2026-08-26—369 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
H2ODBSF 0.1power—2026-08-26—3.3 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
H2ODBSF 0.01power—2026-08-26—1.8 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
H2ODBSF 1power—2026-08-25—20 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
JoinOrderSF 1power—2026-08-25—122 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
NYC TaxiSF 0.01power—2026-10-26—6.8 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
NYC TaxiSF 0.1power—2026-10-26—10 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
NYC TaxiSF 0.01power—2026-08-26—2.8 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
NYC TaxiSF 0.1power—2026-08-26—5.6 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
NYC TaxiSF 1power—2026-10-26—61 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
NYC TaxiSF 1power—2026-08-26—29 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
SSBSF 0.1power—2026-08-26—9 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
SSBSF 0.01power—2026-08-25—3.1 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
SSBSF 1power—2026-08-25—67 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
TPC-HSF 0.1power—2026-10-268,17146 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
TPC-HSF 0.01power—2026-10-262,40716 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
TPC-H Data VaultSF 0.1power—2026-10-26—127 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
TPC-H Data VaultSF 0.01power—2026-10-26—35 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
TPC-H SkewSF 0.1power—2026-10-26—16 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
TPC-H SkewSF 0.01power—2026-10-26—9.4 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
TPC-H SkewSF 1power—2026-10-26—128 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer 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)

BenchmarkScalePhaseVersionRun dateScoreGeomeanReason not rankedExecution environmentTuning modeTrust label
CoffeeShopSF 0.1power—2026-08-26—13 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
CoffeeShopSF 0.01power—2026-08-24—5.2 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
CoffeeShopSF 1power—2026-08-26—92 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
Read PrimitivesSF 0.01power—2026-11-12—5.9 msMismatched query set.Local, Arm64, 5.9 GBNo tuningMaintainer Run
Read PrimitivesSF 0.1power—2026-11-12—9.3 msMismatched query set.Local, Arm64, 5.9 GBNo tuningMaintainer Run
Read PrimitivesSF 0.1power—2026-10-26—10 msKnown defective data.Local, Arm64, 9.8 GBNo tuningMaintainer Run
Read PrimitivesSF 0.01power—2026-10-26—5.6 msKnown defective data.Local, Arm64, 9.8 GBNo tuningMaintainer Run
Read PrimitivesSF 0.01power—2026-08-26—1.8 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
Read PrimitivesSF 0.1power—2026-08-25—4.5 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
TPC-DSSF 1power—2026-10-26—190 msNon-standard runs are unofficial and are not ranked.Local, Arm64, 9.8 GBNo tuningMaintainer Run
TPC-DSSF 1power—2026-10-0135,78294 msKnown defective data.Local, x86-64, AMD EPYC, 15.6 GBNo tuningMaintainer Run
TPC-DSSF 1power—2026-08-26—59 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
TPC-DS-OBTSF 1power—2026-10-26—271 msOne or more queries failed.Local, Arm64, 9.8 GBNo tuningMaintainer Run
TPC-DS-OBTSF 1power—2026-08-26—79 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
TPC-HSF 0.01power—2026-08-262,59113 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
TPC-HSF 0.1power—2026-08-2614,04226 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
TPC-HSF 1power—2026-10-26—215 msNon-standard runs are unofficial and are not ranked.Local, Arm64, 9.8 GBNo tuningMaintainer Run
TPC-HSF 1power—2026-10-13—92 msKnown defective data.Local, x86-64, Intel Xeon, 15.6 GBNo tuningMaintainer Run
TPC-HSF 1power—2026-10-01—119 msKnown defective data.Local, x86-64, AMD EPYC, 15.6 GBNo tuningMaintainer Run
TPC-HSF 1power—2026-08-2550,82870 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
TPC-H Data VaultSF 0.01power—2026-08-26—11 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
TPC-H Data VaultSF 0.1power—2026-08-26—48 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
TPC-H SkewSF 0.1power—2026-08-26—12 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
TPC-H SkewSF 0.01power—2026-08-24—4.1 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
TPC-H SkewSF 1power—2026-08-25—40 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
TPC-HavocSF 0.1power—2026-10-26—20 msKnown defective data.Local, Arm64, 9.8 GBNo tuningMaintainer Run
TPC-HavocSF 0.01power—2026-10-26—11 msKnown defective data.Local, Arm64, 9.8 GBNo tuningMaintainer Run
TPC-HavocSF 0.1power—2026-08-26—13 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
TPC-HavocSF 0.01power—2026-08-26—5.2 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
TPC-HavocSF 1power—2026-10-26—183 msKnown defective data.Local, Arm64, 9.8 GBNo tuningMaintainer Run
TPC-HavocSF 1power—2026-08-26—93 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run