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 Rank Platform Version Run date Geomean query time Geomean Ranking Execution environment Tuning mode Trust label 1 DuckDB v1.3.2 2026-08-26 3.8 ms 3.8 ms Ranked Local, Arm64, Apple silicon No tuning Maintainer Run 2 DataFusion v54.0.0 2026-10-26 5.1 ms 5.1 ms Ranked Local, Arm64, Apple silicon, 16 GB No tuning Maintainer Run 3 ClickHouse Local — 2026-10-28 13 ms 13 ms Ranked Local, Arm64, 9.8 GB No tuning Maintainer Run 4 SQLite v3.53.1 2026-10-26 38 ms 38 ms Ranked Local, Arm64, Apple silicon, 16 GB No tuning Maintainer Run
SF 0.1, power Ranked by geomean query time Rank Platform Version Run date Geomean query time Geomean Ranking Execution environment Tuning mode Trust label 1 DuckDB v1.3.2 2026-08-24 10 ms 10 ms Ranked Local, Arm64, Apple silicon No tuning Maintainer Run 2 ClickHouse Local — 2026-10-28 36 ms 36 ms Ranked Local, Arm64, 9.8 GB No tuning Maintainer Run 3 DataFusion v54.0.0 2026-10-26 45 ms 45 ms Ranked Local, Arm64, Apple silicon, 16 GB No tuning Maintainer Run 4 SQLite v3.53.1 2026-10-26 470 ms 470 ms Ranked Local, Arm64, Apple silicon, 16 GB No tuning Maintainer Run 5 Snowflake v10.33.101 2026-09-19 494 ms 494 ms Ranked Cloud, X-Small No tuning Maintainer Run 6 Databricks v2026.36 2026-10-03 761 ms 761 ms Ranked Cloud, AWS us-east-2, 2X-Small No tuning Maintainer Run 7 BigQuery — 2026-09-19 1.02 s 1.02 s Ranked Cloud, GCP US No tuning Maintainer Run
SF 1, power Ranked by geomean query time Rank Platform Version Run date Geomean query time Geomean Ranking Execution environment Tuning mode Trust label 1 DuckDB v1.3.2 2026-08-26 53 ms 53 ms Ranked Local, Arm64, Apple silicon No tuning Maintainer Run 2 DataFusion v54.0.0 2026-10-26 175 ms 175 ms Ranked Local, Arm64, Apple silicon, 16 GB No tuning Maintainer Run 3 ClickHouse Local — 2026-10-28 238 ms 238 ms Ranked Local, Arm64, 9.8 GB No tuning Maintainer Run 4 Snowflake v10.33.101 2026-09-19 766 ms 766 ms Ranked Cloud, X-Small No tuning Maintainer Run 5 Databricks v2026.36 2026-10-03 1.61 s 1.61 s Ranked Cloud, AWS us-east-2, 2X-Small No tuning Maintainer Run 6 BigQuery — 2026-09-19 1.74 s 1.74 s Ranked Cloud, GCP US No tuning Maintainer Run 7 SQLite v3.53.1 2026-10-26 5.2 s 5.2 s Ranked Local, Arm64, Apple silicon, 16 GB No tuning Maintainer 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 Scale Phase Platform Version Run date Score Geomean Reason not ranked Execution environment Tuning mode Trust label SF 0.01 power ClickHouse Local — 2026-08-24 5.2 ms 5.2 ms Known defective data. Local, Arm64, Apple silicon No tuning Maintainer Run SF 0.01 power DataFusion v53.0.0 2026-08-26 2.9 ms 2.9 ms Known defective data. Local, Arm64, Apple silicon No tuning Maintainer Run SF 0.01 power Pandas v2.3.3 2026-08-26 13 ms 13 ms Validation status excludes this result from ranking. Local, Apple silicon No tuning Maintainer Run SF 0.01 power Polars v1.40.0 2026-08-26 2.7 ms 2.7 ms Validation status excludes this result from ranking. Local, Apple silicon No tuning Maintainer Run SF 0.01 power SQLite v3.53.1 2026-08-26 39 ms 39 ms Known defective data. Local, Arm64, Apple silicon No tuning Maintainer Run SF 0.1 power ClickHouse Local — 2026-08-26 13 ms 13 ms Known defective data. Local, Arm64, Apple silicon No tuning Maintainer Run SF 0.1 power DataFusion v53.0.0 2026-08-24 15 ms 15 ms Known defective data. Local, Arm64, Apple silicon No tuning Maintainer Run SF 0.1 power Pandas v2.3.3 2026-08-26 110 ms 110 ms Validation status excludes this result from ranking. Local, Apple silicon No tuning Maintainer Run SF 0.1 power Polars v1.40.0 2026-08-26 18 ms 18 ms Validation status excludes this result from ranking. Local, Apple silicon No tuning Maintainer Run SF 0.1 power SQLite v3.53.1 2026-08-26 433 ms 433 ms Known defective data. Local, Arm64, Apple silicon No tuning Maintainer Run SF 1 power ClickHouse Local — 2026-08-26 92 ms 92 ms Known defective data. Local, Arm64, Apple silicon No tuning Maintainer Run SF 1 power DataFusion v53.0.0 2026-08-26 93 ms 93 ms Known defective data. Local, Arm64, Apple silicon No tuning Maintainer Run SF 1 power Polars v1.40.0 2026-08-26 141 ms 141 ms Validation status excludes this result from ranking. Local, Apple silicon No tuning Maintainer Run SF 1 power SQLite v3.53.1 2026-08-26 4.52 s 4.52 s Known defective data. Local, Arm64, Apple silicon No tuning Maintainer Run
Results snapshot Published results 467 BenchBox version 0.5.1 Core commit d7197c9c12abCorpus commit 869d6fedc079Snapshot SHA-256 cc71e4d1b0c2Read model 20 Produced 2026-11-22 These figures are generated from the same results snapshot the Results Explorer loads. Results withdrawn upstream are absent after the next site build.