CoffeeShop

Open CoffeeShop in the Results Explorer

CoffeeShop on BenchBox: 32 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 0.01, power

Ranked by geomean query time
RankPlatformVersionRun dateGeomean query timeGeomeanRankingExecution environmentTuning modeTrust label
1DuckDBv1.3.22026-08-263.8 ms3.8 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
2DataFusionv54.0.02026-10-265.1 ms5.1 msRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
3ClickHouse Local—2026-10-2813 ms13 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
4SQLitev3.53.12026-10-2638 ms38 msRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run

SF 0.1, power

Ranked by geomean query time
RankPlatformVersionRun dateGeomean query timeGeomeanRankingExecution environmentTuning modeTrust label
1DuckDBv1.3.22026-08-2410 ms10 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
2ClickHouse Local—2026-10-2836 ms36 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
3DataFusionv54.0.02026-10-2645 ms45 msRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
4SQLitev3.53.12026-10-26470 ms470 msRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
5Snowflakev10.33.1012026-09-19494 ms494 msRankedCloud, X-SmallNo tuningMaintainer Run
6Databricksv2026.362026-10-03761 ms761 msRankedCloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run
7BigQuery—2026-09-191.02 s1.02 sRankedCloud, GCP USNo tuningMaintainer Run

SF 1, power

Ranked by geomean query time
RankPlatformVersionRun dateGeomean query timeGeomeanRankingExecution environmentTuning modeTrust label
1DuckDBv1.3.22026-08-2653 ms53 msRankedLocal, Arm64, Apple siliconNo tuningMaintainer Run
2DataFusionv54.0.02026-10-26175 ms175 msRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
3ClickHouse Local—2026-10-28238 ms238 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
4Snowflakev10.33.1012026-09-19766 ms766 msRankedCloud, X-SmallNo tuningMaintainer Run
5Databricksv2026.362026-10-031.61 s1.61 sRankedCloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run
6BigQuery—2026-09-191.74 s1.74 sRankedCloud, GCP USNo tuningMaintainer Run
7SQLitev3.53.12026-10-265.2 s5.2 sRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run

Runs not included in rankings

14 runs are published with their numbers and receipt but are not ranked. Reason: Known defective data. (9); Validation status excludes this result from ranking. (5)

Runs excluded from ranking
ScalePhasePlatformVersionRun dateScoreGeomeanReason not rankedExecution environmentTuning modeTrust label
SF 0.01powerClickHouse Local—2026-08-245.2 ms5.2 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.01powerDataFusionv53.0.02026-08-262.9 ms2.9 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.01powerPandasv2.3.32026-08-2613 ms13 msValidation status excludes this result from ranking.Local, Apple siliconNo tuningMaintainer Run
SF 0.01powerPolarsv1.40.02026-08-262.7 ms2.7 msValidation status excludes this result from ranking.Local, Apple siliconNo tuningMaintainer Run
SF 0.01powerSQLitev3.53.12026-08-2639 ms39 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerClickHouse Local—2026-08-2613 ms13 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerDataFusionv53.0.02026-08-2415 ms15 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerPandasv2.3.32026-08-26110 ms110 msValidation status excludes this result from ranking.Local, Apple siliconNo tuningMaintainer Run
SF 0.1powerPolarsv1.40.02026-08-2618 ms18 msValidation status excludes this result from ranking.Local, Apple siliconNo tuningMaintainer Run
SF 0.1powerSQLitev3.53.12026-08-26433 ms433 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerClickHouse Local—2026-08-2692 ms92 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerDataFusionv53.0.02026-08-2693 ms93 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerPolarsv1.40.02026-08-26141 ms141 msValidation status excludes this result from ranking.Local, Apple siliconNo tuningMaintainer Run
SF 1powerSQLitev3.53.12026-08-264.52 s4.52 sKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run