BigQuery
Open BigQuery in the Results Explorer
BigQuery on BenchBox: 48 published runs across 19 benchmarks. Latest run 2026-10-03.
Benchmarks
- AMPLab, 2 runs
- ClickBench, 3 runs
- CoffeeShop, 2 runs
- Flight Data, 3 runs
- H2ODB, 2 runs
- JoinOrder, 1 run
- Metadata, 1 run
- NYC Taxi, 3 runs
- Read Primitives, 2 runs
- SSB, 3 runs
- TPC-DS, 3 runs
- TPC-DS-OBT, 1 run
- TPC-H, 3 runs
- TPC-H Data Vault, 4 runs
- TPC-H Skew, 3 runs
- TPC-Havoc, 3 runs
- Transactions, 3 runs
- TSBS DevOps, 3 runs
- Write Primitives, 3 runs
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
| Benchmark | Scale | Phase | Version | Run date | Score | Geomean | Ranking | Execution environment | Tuning mode | Trust label |
|---|---|---|---|---|---|---|---|---|---|---|
| AMPLab | SF 0.1 | power | — | 2026-09-20 | — | 1.01 s | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| AMPLab | SF 1 | power | — | 2026-09-20 | — | 1.26 s | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| ClickBench | SF 1 | power | — | 2026-09-19 | — | 812 ms | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| CoffeeShop | SF 0.1 | power | — | 2026-09-19 | — | 1.02 s | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| CoffeeShop | SF 1 | power | — | 2026-09-19 | — | 1.74 s | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| Flight Data | SF 0.1 | power | — | 2026-09-20 | — | 859 ms | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| Flight Data | SF 1 | power | — | 2026-09-27 | — | 1.12 s | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| Flight Data | SF 10 | power | — | 2026-09-27 | — | 1.22 s | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| H2ODB | SF 0.1 | power | — | 2026-09-19 | — | 836 ms | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| H2ODB | SF 1 | power | — | 2026-09-19 | — | 1.07 s | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| JoinOrder | SF 1 | power | — | 2026-09-20 | — | 3.48 s | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| NYC Taxi | SF 0.1 | power | — | 2026-09-25 | — | 928 ms | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| NYC Taxi | SF 1 | power | — | 2026-09-23 | — | 1.05 s | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| NYC Taxi | SF 10 | power | — | 2026-09-27 | — | 1.02 s | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| SSB | SF 0.1 | power | — | 2026-09-19 | — | 900 ms | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| SSB | SF 1 | power | — | 2026-09-19 | — | 869 ms | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| SSB | SF 10 | power | — | 2026-09-19 | — | 1.23 s | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| TPC-DS | SF 0.1 | power | — | 2026-09-20 | 435.8 | 833 ms | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| TSBS DevOps | SF 0.1 | power | — | 2026-09-29 | — | 766 ms | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| TSBS DevOps | SF 1 | power | — | 2026-09-29 | — | 800 ms | Ranked | Cloud, GCP US | No tuning | Maintainer Run |
| TSBS DevOps | SF 10 | power | — | 2026-10-01 | — | 1.2 s | Ranked | Cloud, GCP US | No tuning | Maintainer 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)
| Benchmark | Scale | Phase | Version | Run date | Score | Geomean | Reason not ranked | Execution environment | Tuning mode | Trust label |
|---|---|---|---|---|---|---|---|---|---|---|
| ClickBench | SF 0.1 | power | — | 2026-09-19 | — | 686 ms | Non-standard runs are unofficial and are not ranked. | Cloud, GCP US | No tuning | Maintainer Run |
| ClickBench | SF 10 | power | — | 2026-09-19 | — | 1.05 s | Non-standard runs are unofficial and are not ranked. | Cloud, GCP US | No tuning | Maintainer Run |
| Metadata | SF 1 | power | — | 2026-09-29 | — | 953 ms | Mismatched query set. | Cloud, GCP US | No tuning | Maintainer Run |
| Read Primitives | SF 0.01 | power | — | 2026-09-30 | — | 904 ms | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| Read Primitives | SF 0.1 | power | — | 2026-09-29 | — | 1.16 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| TPC-DS | SF 1 | power | — | 2026-09-20 | — | 943 ms | Non-standard runs are unofficial and are not ranked. | Cloud, GCP US | No tuning | Maintainer Run |
| TPC-DS | SF 10 | power | — | 2026-09-20 | — | 1.7 s | Non-standard runs are unofficial and are not ranked. | Cloud, GCP US | No tuning | Maintainer Run |
| TPC-DS-OBT | SF 1 | power | — | 2026-09-23 | — | 1.42 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| TPC-H | SF 0.1 | power | — | 2026-10-03 | 369.5 | 970 ms | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| TPC-H | SF 1 | power | — | 2026-10-03 | 3,553 | 1.04 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| TPC-H | SF 10 | power | — | 2026-10-03 | 14,569 | 2.56 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| TPC-H Data Vault | SF 0.1 | power | — | 2026-09-30 | — | 1.18 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| TPC-H Data Vault | SF 0.01 | power | — | 2026-09-27 | — | 979 ms | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| TPC-H Data Vault | SF 1 | power | — | 2026-10-01 | — | 3.01 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| TPC-H Data Vault | SF 10 | power | — | 2026-10-01 | — | 4.9 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| TPC-H Skew | SF 0.1 | power | — | 2026-09-25 | — | 944 ms | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| TPC-H Skew | SF 1 | power | — | 2026-09-25 | — | 978 ms | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| TPC-H Skew | SF 10 | power | — | 2026-09-27 | — | 1.57 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| TPC-Havoc | SF 0.1 | power | — | 2026-09-29 | — | 1.01 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| TPC-Havoc | SF 1 | power | — | 2026-10-01 | — | 1.24 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| TPC-Havoc | SF 10 | power | — | 2026-10-01 | — | 3.42 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| Transactions | SF 0.01 | power | — | 2026-10-01 | — | 5.69 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| Transactions | SF 0.1 | power | — | 2026-10-01 | — | 6.05 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| Transactions | SF 1 | power | — | 2026-10-01 | — | 5.87 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| Write Primitives | SF 0.01 | power | — | 2026-10-01 | — | 1.96 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| Write Primitives | SF 0.1 | power | — | 2026-10-01 | — | 2.31 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |
| Write Primitives | SF 1 | power | — | 2026-10-01 | — | 2.79 s | Known defective data. | Cloud, GCP US | No tuning | Maintainer Run |