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

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)

Runs excluded from ranking
ScalePhasePlatformVersionRun dateScoreGeomeanReason not rankedExecution environmentTuning modeTrust label
SF 0.01powerBigQuery—2026-09-30904 ms904 msKnown defective data.Cloud, GCP USNo tuningMaintainer Run
SF 0.01powerClickHouse Local—2026-08-261.8 ms1.8 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.01powerClickHouse Local—2026-10-265.6 ms5.6 msKnown defective data.Local, Arm64, 9.8 GBNo tuningMaintainer Run
SF 0.01powerClickHouse Local—2026-11-125.9 ms5.9 msMismatched query set.Local, Arm64, 5.9 GBNo tuningMaintainer Run
SF 0.01powerDatabricksv2026.362026-10-01436 ms436 msKnown defective data.Cloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run
SF 0.01powerDataFusionv53.0.02026-08-251.4 ms1.4 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.01powerDataFusionv54.0.02026-10-282 ms2 msMismatched query set.Local, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
SF 0.01powerDuckDBv1.3.22026-08-250.7 ms0.7 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.01powerPandasv2.3.32026-08-261.6 ms1.6 msKnown defective data.Local, Apple siliconNo tuningMaintainer Run
SF 0.01powerPolarsv1.40.02026-08-261.3 ms1.3 msKnown defective data.Local, Apple siliconNo tuningMaintainer Run
SF 0.01powerSnowflakev10.35.1012026-10-01358 ms358 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
SF 0.01powerSQLitev3.53.12026-08-261.6 ms1.6 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.01powerSQLitev3.53.12026-10-281.3 ms1.3 msOne or more queries failed.Local, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
SF 0.1powerBigQuery—2026-09-291.16 s1.16 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
SF 0.1powerClickHouse Local—2026-08-254.5 ms4.5 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerClickHouse Local—2026-10-2610 ms10 msKnown defective data.Local, Arm64, 9.8 GBNo tuningMaintainer Run
SF 0.1powerClickHouse Local—2026-11-129.3 ms9.3 msMismatched query set.Local, Arm64, 5.9 GBNo tuningMaintainer Run
SF 0.1powerDatabricksv2026.362026-10-01516 ms516 msKnown defective data.Cloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run
SF 0.1powerDataFusionv53.0.02026-08-2612 ms12 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerDataFusionv54.0.02026-10-283.9 ms3.9 msMismatched query set.Local, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
SF 0.1powerDuckDBv1.3.22026-08-262.2 ms2.2 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerPandasv2.3.32026-08-268.2 ms8.2 msKnown defective data.Local, Apple siliconNo tuningMaintainer Run
SF 0.1powerPolarsv1.40.02026-08-264 ms4 msKnown defective data.Local, Apple siliconNo tuningMaintainer Run
SF 0.1powerSnowflakev10.35.1012026-10-01405 ms405 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
SF 0.1powerSQLitev3.53.12026-08-2617 ms17 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerSQLitev3.53.12026-10-2818 ms18 msOne or more queries failed.Local, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run