TPC-H

Open TPC-H in the Results Explorer

TPC-H on BenchBox: 79 published runs across 17 platforms. Latest run 2026-11-11.

Platforms

Score definitions

Power score
Power@Size: scale factor × 3600 divided by the geometric mean of the query times of the final iteration, in seconds. Unit: queries per hour at scale factor size; higher is better. Definition in the benchmark methodology.
Throughput@Size
Throughput@Size: number of queries run across all streams × scale factor × 3600 divided by the elapsed throughput time, in seconds. Unit: queries per hour at scale factor size; higher is better. Definition in the benchmark methodology.
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 power score
RankPlatformVersionRun datePower scoreGeomeanRankingExecution environmentTuning modeTrust label
1DuckDBv1.3.22026-09-016,1305.9 msRankedLocal, x86-64, Intel Xeon, 15.6 GBNo tuningMaintainer Run
2DuckDBv1.5.52026-10-134,5037.9 msRankedLocal, x86-64, AMD EPYC, 15.6 GBNo tuningMaintainer Run
3DuckDBv1.5.52026-10-014,3027.9 msRankedLocal, x86-64, AMD EPYC, 15.6 GBNo tuningMaintainer Run
4DataFusionv54.0.02026-10-133,35211 msRankedLocal, x86-64, Intel Xeon, 15.6 GBNo tuningMaintainer Run
5DataFusionv54.0.02026-10-013,12311 msRankedLocal, x86-64, Intel Xeon, 15.6 GBNo tuningMaintainer Run
6SQLitev3.53.12026-10-262,87013 msRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
7DataFusionv53.0.02026-09-012,46015 msRankedLocal, x86-64, AMD EPYC, 15.6 GBNo tuningMaintainer Run
8ClickHouse Local—2026-10-262,40716 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
9DataFusionv54.0.02026-10-262,39815 msRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run

SF 0.1, power

Ranked by power score
RankPlatformVersionRun datePower scoreGeomeanRankingExecution environmentTuning modeTrust label
1DuckDBv1.5.52026-11-1152,1886.6 msRankedLocal, Arm64, Apple silicon, 16 GBNot recordedMaintainer Run
2Polarsv1.44.22026-11-1133,22711 msRankedLocal, Arm64, Apple silicon, 16 GBNot recordedMaintainer Run
3DuckDBv1.5.52026-10-0132,42111 msRankedLocal, x86-64, Intel Xeon, 15.6 GBNo tuningMaintainer Run
4DuckDBv1.5.52026-10-1324,80114 msRankedLocal, x86-64, AMD EPYC, 15.6 GBNo tuningMaintainer Run
5DuckDBv1.3.22026-09-0124,75014 msRankedLocal, x86-64, AMD EPYC, 15.6 GBNo tuningMaintainer Run
6DataFusionv54.0.02026-10-0121,05217 msRankedLocal, x86-64, Intel Xeon, 15.6 GBNo tuningMaintainer Run
7DataFusionv54.0.02026-10-2616,77022 msRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
8DataFusionv54.0.02026-10-1314,75825 msRankedLocal, x86-64, AMD EPYC, 15.6 GBNo tuningMaintainer Run
9DataFusionv53.0.02026-09-0113,47826 msRankedLocal, x86-64, AMD EPYC, 15.6 GBNo tuningMaintainer Run
10ClickHouse Local—2026-10-268,17146 msRankedLocal, Arm64, 9.8 GBNo tuningMaintainer Run
11SQLitev3.53.12026-10-265,46463 msRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run

SF 1, power

Ranked by power score
RankPlatformVersionRun datePower scoreGeomeanRankingExecution environmentTuning modeTrust label
1DuckDBv1.3.22026-09-0193,78139 msRankedLocal, x86-64, AMD EPYC, 15.6 GBNo tuningMaintainer Run

SF 1, throughput (3 streams)

Ranked by throughput@size
RankPlatformVersionRun dateThroughput@SizeGeomeanRankingExecution environmentTuning modeTrust label
1DuckDBv1.5.52026-10-07297,65329 msRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
2Apache Dorisv4.0.3-rc032026-10-0725,666356 msRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
3Sparkv4.2.02026-10-071,5425.54 sRankedLocal, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run

Runs not included in rankings

55 runs are published with their numbers and receipt but are not ranked. Reason: Known defective data. (48); Validation status excludes this result from ranking. (2); Non-standard runs are unofficial and are not ranked. (5)

Runs excluded from ranking
ScalePhasePlatformVersionRun dateScoreGeomeanReason not rankedExecution environmentTuning modeTrust label
SF 0.01powerCedarDB—2026-08-253,8588.8 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.01powerClickHouse Local—2026-08-262,59113 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.01powerClickHouse Server—2026-08-252,25515 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.01powerDataFusionv53.0.02026-08-263,02811 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.01powerDuckDBv1.3.22026-08-265,1616.9 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.01powerLakeSailv4.1.12026-08-251,69421 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.01powerPandasv2.3.32026-08-269,2263.9 msKnown defective data.Local, Apple siliconNo tuningMaintainer Run
SF 0.01powerPolarsv1.40.02026-09-016,9935.1 msValidation status excludes this result from ranking.Local, x86-64, AMD EPYC, 15.6 GBNo tuningMaintainer Run
SF 0.01powerPolarsv1.40.02026-08-24—3 msKnown defective data.Local, Apple siliconNo tuningMaintainer Run
SF 0.01powerPySparkv4.1.12026-08-2553.67684 msKnown defective data.Local, Apple siliconNo tuningMaintainer Run
SF 0.01powerSparkv4.1.12026-08-26127.6263 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.01powerSQLitev3.53.12026-08-253,8209.4 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.01powerStarRocksv8.0.332026-08-251,38426 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerBigQuery—2026-10-03369.5970 msKnown defective data.Cloud, GCP USNo tuningMaintainer Run
SF 0.1powerClickHouse Local—2026-08-2614,04226 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerDatabricksv2026.362026-10-03364.3923 msKnown defective data.Cloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run
SF 0.1powerDataFusionv53.0.02026-08-2419,80819 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerDuckDBv1.3.22026-08-2624,44815 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerPandasv2.3.32026-08-2617,47521 msKnown defective data.Local, Apple siliconNo tuningMaintainer Run
SF 0.1powerPolarsv1.40.02026-09-0124,45514 msValidation status excludes this result from ranking.Local, x86-64, AMD EPYC, 15.6 GBNo tuningMaintainer Run
SF 0.1powerPolarsv1.40.02026-08-2661,1616 msKnown defective data.Local, Apple siliconNo tuningMaintainer Run
SF 0.1powerSnowflakev10.35.1012026-10-03372904 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
SF 0.1powerSparkv4.1.12026-08-261,074350 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 0.1powerSQLitev3.53.12026-08-267,05952 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerBigQuery—2026-10-033,5531.04 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
SF 1powerClickHouse Local—2026-10-01—119 msKnown defective data.Local, x86-64, AMD EPYC, 15.6 GBNo tuningMaintainer Run
SF 1powerClickHouse Local—2026-10-13—92 msKnown defective data.Local, x86-64, Intel Xeon, 15.6 GBNo tuningMaintainer Run
SF 1powerClickHouse Local—2026-08-2550,82870 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerClickHouse Local—2026-10-26—215 msNon-standard runs are unofficial and are not ranked.Local, Arm64, 9.8 GBNo tuningMaintainer Run
SF 1powerDatabricksv2026.362026-10-033,843956 msKnown defective data.Cloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run
SF 1powerDataFusionv53.0.02026-08-2577,39247 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerDataFusionv54.0.02026-10-26—59 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
SF 1powerDuckDBv1.5.52026-10-01—50 msNon-standard runs are unofficial and are not ranked.Local, x86-64, AMD EPYC, 15.6 GBNo tuningMaintainer Run
SF 1powerDuckDBv1.5.52026-10-13—31 msNon-standard runs are unofficial and are not ranked.Local, x86-64, AMD EPYC, 15.6 GBNo tuningMaintainer Run
SF 1powerDuckDBv1.3.22026-08-2693,18638 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerDuckDBv1.3.22026-08-28100,36835 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerDuckDBv1.3.22026-08-2956,41564 msKnown defective data.Local, Arm64, Apple siliconTunedMaintainer Run
SF 1powerDuckLakev1.3.22026-08-2899,54936 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerPolarsv1.40.02026-08-2499,30936 msKnown defective data.Local, Apple siliconNo tuningMaintainer Run
SF 1powerPolarsv1.40.02026-08-2598,08937 msKnown defective data.Local, Apple siliconNo tuningMaintainer Run
SF 1powerPySparkv4.1.12026-08-251,9301.9 sKnown defective data.Local, Apple siliconNo tuningMaintainer Run
SF 1powerSnowflakev10.35.1012026-10-033,645943 msKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run
SF 1powerSparkv4.1.12026-08-264,805719 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerSQLitev3.53.12026-08-257,238494 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 1powerSQLitev3.53.12026-10-26—547 msNon-standard runs are unofficial and are not ranked.Local, Arm64, Apple silicon, 16 GBNo tuningMaintainer Run
SF 10powerBigQuery—2026-10-0314,5692.56 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
SF 10powerDatabricksv2026.362026-10-0327,9141.29 sKnown defective data.Cloud, AWS us-east-2, 2X-SmallNo tuningMaintainer Run
SF 10powerDuckDBv1.0.02026-08-29173,508208 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerDuckDBv1.1.32026-08-29212,540170 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerDuckDBv1.2.22026-08-29228,201160 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerDuckDBv1.3.22026-08-29198,175189 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerDuckDBv1.4.42026-08-29213,021168 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerDuckDBv1.5.52026-08-29236,191152 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerDuckDBv2.0.0-alpha386152026-08-29281,041128 msKnown defective data.Local, Arm64, Apple siliconNo tuningMaintainer Run
SF 10powerSnowflakev10.35.1012026-10-0329,8761.25 sKnown defective data.Cloud, AWS AWS_US_EAST_2, X-SmallNo tuningMaintainer Run