TPC-H Skew

Open TPC-H Skew in the Results Explorer

TPC-H Skew on BenchBox: 33 published runs across 8 platforms. Latest run 2026-10-26.

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
1SQLitev3.53.12026-10-262.2 ms2.2 msRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
2DataFusionv54.0.02026-10-267.2 ms7.2 msRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
3ClickHouse Local—2026-10-269.4 ms9.4 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run

SF 0.1, power

Ranked by geomean query time
RankPlatformVersionRun dateGeomean query timeGeomeanRankingExecution environmentTuning modeTrust label
1ClickHouse Local—2026-10-2616 ms16 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
2DataFusionv54.0.02026-10-2616 ms16 msRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
3SQLitev3.53.12026-10-2637 ms37 msRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run

SF 1, power

Ranked by geomean query time
RankPlatformVersionRun dateGeomean query timeGeomeanRankingExecution environmentTuning modeTrust label
1DataFusionv54.0.02026-10-2653 ms53 msRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
2ClickHouse Local—2026-10-26128 ms128 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
3SQLitev3.53.12026-10-26494 ms494 msRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run

Runs not included in rankings

24 runs are published with their numbers and receipt but are not ranked. Reason: Known defective data. (24)

Runs excluded from ranking
ScalePhasePlatformVersionRun dateScoreGeomeanReason not rankedExecution environmentTuning modeTrust label
SF 0.01powerClickHouse Local—2026-08-244.1 ms4.1 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.01powerDataFusionv53.0.02026-08-243.7 ms3.7 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.01powerDuckDBv1.3.22026-08-241.2 ms1.2 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.01powerPolarsv1.40.02026-08-241.7 ms1.7 msKnown defective data.Local, Apple siliconNo tuningMaintainer Run
SF 0.01powerSQLitev3.53.12026-08-262.3 ms2.3 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerBigQuery—2026-09-25944 ms944 msKnown defective data.Cloud, GCP USNo tuningMaintainer Run
SF 0.1powerClickHouse Local—2026-08-2612 ms12 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerDatabricksv2026.362026-10-01788 ms788 msKnown defective data.Cloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run
SF 0.1powerDataFusionv53.0.02026-08-258.8 ms8.8 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerDuckDBv1.3.22026-08-243 ms3 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerPolarsv1.40.02026-08-266 ms6 msKnown defective data.Local, Apple siliconNo tuningMaintainer Run
SF 0.1powerSnowflakev10.34.1012026-09-25345 ms345 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
SF 0.1powerSQLitev3.53.12026-08-2655 ms55 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerBigQuery—2026-09-25978 ms978 msKnown defective data.Cloud, GCP USNo tuningMaintainer Run
SF 1powerClickHouse Local—2026-08-2540 ms40 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerDatabricksv2026.362026-10-01946 ms946 msKnown defective data.Cloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run
SF 1powerDataFusionv53.0.02026-08-2634 ms34 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerDuckDBv1.3.22026-08-2612 ms12 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerPolarsv1.40.02026-08-2635 ms35 msKnown defective data.Local, Apple siliconNo tuningMaintainer Run
SF 1powerSnowflakev10.34.1012026-09-25389 ms389 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
SF 1powerSQLitev3.53.12026-08-26437 ms437 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerBigQuery—2026-09-271.57 s1.57 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
SF 10powerDatabricksv2026.362026-10-011.34 s1.34 sKnown defective data.Cloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run
SF 10powerSnowflakev10.35.1012026-09-29805 ms805 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run