ClickBench

Open ClickBench in the Results Explorer

ClickBench on BenchBox: 25 published runs across 9 platforms. Latest run 2026-10-28.

Platforms

Score definitions

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.

SF 1, power

Ranked by geomean query time
RankPlatformVersionRun dateGeomean query timeGeomeanRankingExecution environmentTuning modeTrust label
1DuckDBv1.3.22026-08-262.1 ms2.1 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
2DuckDBv1.3.22026-08-292.2 ms2.2 msRankedLocal, Arm64, Apple siliconTunedMaintainer Run
3ClickHouse Local—2026-08-266.4 ms6.4 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
4DataFusionv54.0.02026-10-2826 ms26 msRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
5SQLitev3.53.12026-10-26207 ms207 msRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
6Snowflakev10.33.1012026-09-20259 ms259 msRankedCloud, X-SmallNo tuningMaintainer Run
7BigQuery—2026-09-19812 ms812 msRankedCloud, GCP USNo tuningMaintainer Run

Runs not included in rankings

18 runs are published with their numbers and receipt but are not ranked. Reason: Non-standard runs are unofficial and are not ranked. (11); Known defective data. (5); Validation status excludes this result from ranking. (2)

Runs excluded from ranking
ScalePhasePlatformVersionRun dateScoreGeomeanReason not rankedExecution environmentTuning modeTrust label
SF 0.1powerBigQuery—2026-09-19686 ms686 msNon-standard runs are unofficial and are not ranked.Cloud, GCP USNo tuningMaintainer Run
SF 0.1powerDatabricksv2026.362026-10-03360 ms360 msKnown defective data.Cloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run
SF 0.1powerSnowflakev10.33.1012026-09-20258 ms258 msNon-standard runs are unofficial and are not ranked.Cloud, X-SmallNo tuningMaintainer Run
SF 1powerDatabricksv2026.362026-10-03567 ms567 msKnown defective data.Cloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run
SF 1powerDataFusionv53.0.02026-08-2621 ms21 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerPandasv2.3.32026-08-2633 ms33 msValidation status excludes this result from ranking.Local, Apple siliconNo tuningMaintainer Run
SF 1powerPolarsv1.40.02026-08-268.4 ms8.4 msValidation status excludes this result from ranking.Local, Apple siliconNo tuningMaintainer Run
SF 1powerSQLitev3.53.12026-08-24192 ms192 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerBigQuery—2026-09-191.05 s1.05 sNon-standard runs are unofficial and are not ranked.Cloud, GCP USNo tuningMaintainer Run
SF 10powerDatabricksv2026.362026-10-03603 ms603 msKnown defective data.Cloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run
SF 10powerDuckDBv1.0.02026-08-2917 ms17 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerDuckDBv1.1.32026-08-2915 ms15 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerDuckDBv1.2.22026-08-2919 ms19 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerDuckDBv1.3.22026-08-2914 ms14 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerDuckDBv1.4.42026-08-2910 ms10 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerDuckDBv1.5.52026-08-2910 ms10 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerDuckDBv2.0.0-alpha386152026-08-298.6 ms8.6 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerSnowflakev10.33.1012026-09-19341 ms341 msNon-standard runs are unofficial and are not ranked.Cloud, X-SmallNo tuningMaintainer Run