BigQuery

Open BigQuery in the Results Explorer

BigQuery on BenchBox: 48 published runs across 19 benchmarks. Latest run 2026-10-03.

Benchmarks

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.
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.

Ranked runs

BenchmarkScalePhaseVersionRun dateScoreGeomeanRankingExecution environmentTuning modeTrust label
AMPLabSF 0.1power—2026-09-20—1.01 sRankedCloud, GCP USNo tuningMaintainer Run
AMPLabSF 1power—2026-09-20—1.26 sRankedCloud, GCP USNo tuningMaintainer Run
ClickBenchSF 1power—2026-09-19—812 msRankedCloud, GCP USNo tuningMaintainer Run
CoffeeShopSF 0.1power—2026-09-19—1.02 sRankedCloud, GCP USNo tuningMaintainer Run
CoffeeShopSF 1power—2026-09-19—1.74 sRankedCloud, GCP USNo tuningMaintainer Run
Flight DataSF 0.1power—2026-09-20—859 msRankedCloud, GCP USNo tuningMaintainer Run
Flight DataSF 1power—2026-09-27—1.12 sRankedCloud, GCP USNo tuningMaintainer Run
Flight DataSF 10power—2026-09-27—1.22 sRankedCloud, GCP USNo tuningMaintainer Run
H2ODBSF 0.1power—2026-09-19—836 msRankedCloud, GCP USNo tuningMaintainer Run
H2ODBSF 1power—2026-09-19—1.07 sRankedCloud, GCP USNo tuningMaintainer Run
JoinOrderSF 1power—2026-09-20—3.48 sRankedCloud, GCP USNo tuningMaintainer Run
NYC TaxiSF 0.1power—2026-09-25—928 msRankedCloud, GCP USNo tuningMaintainer Run
NYC TaxiSF 1power—2026-09-23—1.05 sRankedCloud, GCP USNo tuningMaintainer Run
NYC TaxiSF 10power—2026-09-27—1.02 sRankedCloud, GCP USNo tuningMaintainer Run
SSBSF 0.1power—2026-09-19—900 msRankedCloud, GCP USNo tuningMaintainer Run
SSBSF 1power—2026-09-19—869 msRankedCloud, GCP USNo tuningMaintainer Run
SSBSF 10power—2026-09-19—1.23 sRankedCloud, GCP USNo tuningMaintainer Run
TPC-DSSF 0.1power—2026-09-20435.8833 msRankedCloud, GCP USNo tuningMaintainer Run
TSBS DevOpsSF 0.1power—2026-09-29—766 msRankedCloud, GCP USNo tuningMaintainer Run
TSBS DevOpsSF 1power—2026-09-29—800 msRankedCloud, GCP USNo tuningMaintainer Run
TSBS DevOpsSF 10power—2026-10-01—1.2 sRankedCloud, GCP USNo tuningMaintainer Run

Runs not included in rankings

27 runs are published with their numbers and receipt but are not ranked. Reason: Non-standard runs are unofficial and are not ranked. (4); Mismatched query set. (1); Known defective data. (22)

BenchmarkScalePhaseVersionRun dateScoreGeomeanReason not rankedExecution environmentTuning modeTrust label
ClickBenchSF 0.1power—2026-09-19—686 msNon-standard runs are unofficial and are not ranked.Cloud, GCP USNo tuningMaintainer Run
ClickBenchSF 10power—2026-09-19—1.05 sNon-standard runs are unofficial and are not ranked.Cloud, GCP USNo tuningMaintainer Run
MetadataSF 1power—2026-09-29—953 msMismatched query set.Cloud, GCP USNo tuningMaintainer Run
Read PrimitivesSF 0.01power—2026-09-30—904 msKnown defective data.Cloud, GCP USNo tuningMaintainer Run
Read PrimitivesSF 0.1power—2026-09-29—1.16 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
TPC-DSSF 1power—2026-09-20—943 msNon-standard runs are unofficial and are not ranked.Cloud, GCP USNo tuningMaintainer Run
TPC-DSSF 10power—2026-09-20—1.7 sNon-standard runs are unofficial and are not ranked.Cloud, GCP USNo tuningMaintainer Run
TPC-DS-OBTSF 1power—2026-09-23—1.42 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
TPC-HSF 0.1power—2026-10-03369.5970 msKnown defective data.Cloud, GCP USNo tuningMaintainer Run
TPC-HSF 1power—2026-10-033,5531.04 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
TPC-HSF 10power—2026-10-0314,5692.56 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
TPC-H Data VaultSF 0.1power—2026-09-30—1.18 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
TPC-H Data VaultSF 0.01power—2026-09-27—979 msKnown defective data.Cloud, GCP USNo tuningMaintainer Run
TPC-H Data VaultSF 1power—2026-10-01—3.01 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
TPC-H Data VaultSF 10power—2026-10-01—4.9 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
TPC-H SkewSF 0.1power—2026-09-25—944 msKnown defective data.Cloud, GCP USNo tuningMaintainer Run
TPC-H SkewSF 1power—2026-09-25—978 msKnown defective data.Cloud, GCP USNo tuningMaintainer Run
TPC-H SkewSF 10power—2026-09-27—1.57 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
TPC-HavocSF 0.1power—2026-09-29—1.01 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
TPC-HavocSF 1power—2026-10-01—1.24 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
TPC-HavocSF 10power—2026-10-01—3.42 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
TransactionsSF 0.01power—2026-10-01—5.69 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
TransactionsSF 0.1power—2026-10-01—6.05 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
TransactionsSF 1power—2026-10-01—5.87 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
Write PrimitivesSF 0.01power—2026-10-01—1.96 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
Write PrimitivesSF 0.1power—2026-10-01—2.31 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run
Write PrimitivesSF 1power—2026-10-01—2.79 sKnown defective data.Cloud, GCP USNo tuningMaintainer Run