Read Primitives
Open Read Primitives in the Results Explorer
Read Primitives on BenchBox: 26 published runs across 9 platforms. Latest run 2026-11-12.
Platforms
- BigQuery, 2 runs
- ClickHouse Local, 6 runs
- Databricks, 2 runs
- DataFusion, 4 runs
- DuckDB, 2 runs
- Pandas, 2 runs
- Polars, 2 runs
- Snowflake, 2 runs
- SQLite, 4 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.
Runs not included in rankings
26 runs are published with their numbers and receipt but are not ranked. Reason: Known defective data. (20); Mismatched query set. (4); One or more queries failed. (2)
| Scale | Phase | Platform | Version | Run date | Score | Geomean | Reason not ranked | Execution environment | Tuning mode | Trust label |
|---|---|---|---|---|---|---|---|---|---|---|
| SF 0.01 | power | BigQuery | — | 2026-09-30 | 904 ms | 904 ms | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| SF 0.01 | power | ClickHouse Local | — | 2026-08-26 | 1.8 ms | 1.8 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 0.01 | power | ClickHouse Local | — | 2026-10-26 | 5.6 ms | 5.6 ms | Known defective data. | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| SF 0.01 | power | ClickHouse Local | — | 2026-11-12 | 5.9 ms | 5.9 ms | Mismatched query set. | Local, Arm64, 5.9 GB | No tuning | Maintainer Run |
| SF 0.01 | power | Databricks | v2026.36 | 2026-10-01 | 436 ms | 436 ms | Known defective data. | Cloud, AWS us-east-2, 2X-Small | No tuning | Maintainer Run |
| SF 0.01 | power | DataFusion | v53.0.0 | 2026-08-25 | 1.4 ms | 1.4 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 0.01 | power | DataFusion | v54.0.0 | 2026-10-28 | 2 ms | 2 ms | Mismatched query set. | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| SF 0.01 | power | DuckDB | v1.3.2 | 2026-08-25 | 0.7 ms | 0.7 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 0.01 | power | Pandas | v2.3.3 | 2026-08-26 | 1.6 ms | 1.6 ms | Known defective data. | Local, Apple silicon | No tuning | Maintainer Run |
| SF 0.01 | power | Polars | v1.40.0 | 2026-08-26 | 1.3 ms | 1.3 ms | Known defective data. | Local, Apple silicon | No tuning | Maintainer Run |
| SF 0.01 | power | Snowflake | v10.35.101 | 2026-10-01 | 358 ms | 358 ms | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| SF 0.01 | power | SQLite | v3.53.1 | 2026-08-26 | 1.6 ms | 1.6 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 0.01 | power | SQLite | v3.53.1 | 2026-10-28 | 1.3 ms | 1.3 ms | One or more queries failed. | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| SF 0.1 | power | BigQuery | — | 2026-09-29 | 1.16 s | 1.16 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| SF 0.1 | power | ClickHouse Local | — | 2026-08-25 | 4.5 ms | 4.5 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 0.1 | power | ClickHouse Local | — | 2026-10-26 | 10 ms | 10 ms | Known defective data. | Local, Arm64, 9.8 GB | No tuning | Maintainer Run |
| SF 0.1 | power | ClickHouse Local | — | 2026-11-12 | 9.3 ms | 9.3 ms | Mismatched query set. | Local, Arm64, 5.9 GB | No tuning | Maintainer Run |
| SF 0.1 | power | Databricks | v2026.36 | 2026-10-01 | 516 ms | 516 ms | Known defective data. | Cloud, AWS us-east-2, 2X-Small | No tuning | Maintainer Run |
| SF 0.1 | power | DataFusion | v53.0.0 | 2026-08-26 | 12 ms | 12 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 0.1 | power | DataFusion | v54.0.0 | 2026-10-28 | 3.9 ms | 3.9 ms | Mismatched query set. | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| SF 0.1 | power | DuckDB | v1.3.2 | 2026-08-26 | 2.2 ms | 2.2 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 0.1 | power | Pandas | v2.3.3 | 2026-08-26 | 8.2 ms | 8.2 ms | Known defective data. | Local, Apple silicon | No tuning | Maintainer Run |
| SF 0.1 | power | Polars | v1.40.0 | 2026-08-26 | 4 ms | 4 ms | Known defective data. | Local, Apple silicon | No tuning | Maintainer Run |
| SF 0.1 | power | Snowflake | v10.35.101 | 2026-10-01 | 405 ms | 405 ms | Known defective data. | Cloud, AWS AWS_US_EAST_2, X-Small | No tuning | Maintainer Run |
| SF 0.1 | power | SQLite | v3.53.1 | 2026-08-26 | 17 ms | 17 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SF 0.1 | power | SQLite | v3.53.1 | 2026-10-28 | 18 ms | 18 ms | One or more queries failed. | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |