ClickBench
Open ClickBench in the Results Explorer
ClickBench on BenchBox: 25 published runs across 9 platforms. Latest run 2026-10-28.
Platforms
- BigQuery, 3 runs
- ClickHouse Local, 1 run
- Databricks, 3 runs
- DataFusion, 2 runs
- DuckDB, 9 runs
- Pandas, 1 run
- Polars, 1 run
- Snowflake, 3 runs
- SQLite, 2 runs
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
| Rank | Platform | Version | Run date | Geomean query time | Geomean | Ranking | Execution environment | Tuning mode | Trust label |
|---|---|---|---|---|---|---|---|---|---|
| 1 | DuckDB | v1.3.2 | 2026-08-26 | 2.1 ms | 2.1 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| 2 | DuckDB | v1.3.2 | 2026-08-29 | 2.2 ms | 2.2 ms | Ranked | Local, Arm64, Apple silicon | Tuned | Maintainer Run |
| 3 | ClickHouse Local | — | 2026-08-26 | 6.4 ms | 6.4 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| 4 | DataFusion | v54.0.0 | 2026-10-28 | 26 ms | 26 ms | Ranked | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| 5 | SQLite | v3.53.1 | 2026-10-26 | 207 ms | 207 ms | Ranked | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| 6 | Snowflake | v10.33.101 | 2026-09-20 | 259 ms | 259 ms | Ranked | Cloud, X-Small | No tuning | Maintainer Run |
| 7 | BigQuery | — | 2026-09-19 | 812 ms | 812 ms | Ranked | Cloud, GCP US | No tuning | Maintainer 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)
| Scale | Phase | Platform | Version | Run date | Score | Geomean | Reason not ranked | Execution environment | Tuning mode | Trust label |
|---|---|---|---|---|---|---|---|---|---|---|
| SF 0.1 | power | BigQuery | — | 2026-09-19 | 686 ms | 686 ms | Non-standard runs are unofficial and are not ranked. | Cloud, GCP US | No tuning | Maintainer Run |
| SF 0.1 | power | Databricks | v2026.36 | 2026-10-03 | 360 ms | 360 ms | Known defective data. | Cloud, AWS us-east-2, 2X-Small | No tuning | Maintainer Run |
| SF 0.1 | power | Snowflake | v10.33.101 | 2026-09-20 | 258 ms | 258 ms | Non-standard runs are unofficial and are not ranked. | Cloud, X-Small | No tuning | Maintainer Run |
| SF 1 | power | Databricks | v2026.36 | 2026-10-03 | 567 ms | 567 ms | Known defective data. | Cloud, AWS us-east-2, 2X-Small | No tuning | Maintainer Run |
| SF 1 | power | DataFusion | v53.0.0 | 2026-08-26 | 21 ms | 21 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 1 | power | Pandas | v2.3.3 | 2026-08-26 | 33 ms | 33 ms | Validation status excludes this result from ranking. | Local, Apple silicon | No tuning | Maintainer Run |
| SF 1 | power | Polars | v1.40.0 | 2026-08-26 | 8.4 ms | 8.4 ms | Validation status excludes this result from ranking. | Local, Apple silicon | No tuning | Maintainer Run |
| SF 1 | power | SQLite | v3.53.1 | 2026-08-24 | 192 ms | 192 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 10 | power | BigQuery | — | 2026-09-19 | 1.05 s | 1.05 s | Non-standard runs are unofficial and are not ranked. | Cloud, GCP US | No tuning | Maintainer Run |
| SF 10 | power | Databricks | v2026.36 | 2026-10-03 | 603 ms | 603 ms | Known defective data. | Cloud, AWS us-east-2, 2X-Small | No tuning | Maintainer Run |
| SF 10 | power | DuckDB | v1.0.0 | 2026-08-29 | 17 ms | 17 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 10 | power | DuckDB | v1.1.3 | 2026-08-29 | 15 ms | 15 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 10 | power | DuckDB | v1.2.2 | 2026-08-29 | 19 ms | 19 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 10 | power | DuckDB | v1.3.2 | 2026-08-29 | 14 ms | 14 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 10 | power | DuckDB | v1.4.4 | 2026-08-29 | 10 ms | 10 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 10 | power | DuckDB | v1.5.5 | 2026-08-29 | 10 ms | 10 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 10 | power | DuckDB | v2.0.0-alpha38615 | 2026-08-29 | 8.6 ms | 8.6 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 10 | power | Snowflake | v10.33.101 | 2026-09-19 | 341 ms | 341 ms | Non-standard runs are unofficial and are not ranked. | Cloud, X-Small | No tuning | Maintainer Run |