DuckDB
Open DuckDB in the Results Explorer
DuckDB on BenchBox: 91 published runs across 15 benchmarks. Latest run 2026-11-11.
Benchmarks
- AMPLab, 4 runs
- ClickBench, 9 runs
- CoffeeShop, 3 runs
- Flight Data, 3 runs
- H2ODB, 3 runs
- JoinOrder, 2 runs
- NYC Taxi, 3 runs
- Read Primitives, 2 runs
- SSB, 15 runs
- TPC-DS, 12 runs
- TPC-DS-OBT, 4 runs
- TPC-H, 23 runs
- TPC-H Data Vault, 2 runs
- TPC-H Skew, 3 runs
- TPC-Havoc, 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.
- 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.
Ranked runs
| Benchmark | Scale | Phase | Version | Run date | Score | Geomean | Ranking | Execution environment | Tuning mode | Trust label |
|---|---|---|---|---|---|---|---|---|---|---|
| AMPLab | SF 0.1 | power | v1.3.2 | 2026-08-26 | — | 1.2 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| AMPLab | SF 0.01 | power | v1.3.2 | 2026-08-26 | — | 0.4 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| AMPLab | SF 1 | power | v1.3.2 | 2026-08-29 | — | 7.7 ms | Ranked | Local, Arm64, Apple silicon | Tuned | Maintainer Run |
| AMPLab | SF 1 | power | v1.3.2 | 2026-08-24 | — | 5.7 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| ClickBench | SF 1 | power | v1.3.2 | 2026-08-29 | — | 2.2 ms | Ranked | Local, Arm64, Apple silicon | Tuned | Maintainer Run |
| ClickBench | SF 1 | power | v1.3.2 | 2026-08-26 | — | 2.1 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| CoffeeShop | SF 0.01 | power | v1.3.2 | 2026-08-26 | — | 3.8 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| CoffeeShop | SF 0.1 | power | v1.3.2 | 2026-08-24 | — | 10 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| CoffeeShop | SF 1 | power | v1.3.2 | 2026-08-26 | — | 53 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| Flight Data | SF 0.1 | power | v1.3.2 | 2026-08-26 | — | 17 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| Flight Data | SF 0.01 | power | v1.3.2 | 2026-08-26 | — | 6.8 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| Flight Data | SF 1 | power | v1.3.2 | 2026-08-26 | — | 142 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| H2ODB | SF 0.1 | power | v1.3.2 | 2026-08-26 | — | 1.1 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| H2ODB | SF 0.01 | power | v1.3.2 | 2026-08-26 | — | 0.5 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| H2ODB | SF 1 | power | v1.3.2 | 2026-08-26 | — | 9.4 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| JoinOrder | SF 1 | power | v1.3.2 | 2026-08-29 | — | 55 ms | Ranked | Local, Arm64, Apple silicon | Tuned | Maintainer Run |
| JoinOrder | SF 1 | power | v1.3.2 | 2026-08-26 | — | 76 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| NYC Taxi | SF 0.01 | power | v1.3.2 | 2026-08-26 | — | 0.6 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| NYC Taxi | SF 0.1 | power | v1.3.2 | 2026-08-26 | — | 1.5 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| NYC Taxi | SF 1 | power | v1.3.2 | 2026-08-26 | — | 5.9 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SSB | SF 0.1 | power | v1.5.5 | 2026-10-01 | — | 5 ms | Ranked | Local, x86-64, AMD EPYC, 15.6 GB | No tuning | Maintainer Run |
| SSB | SF 0.01 | power | v1.5.5 | 2026-10-01 | — | 2.5 ms | Ranked | Local, x86-64, Intel Xeon, 15.6 GB | No tuning | Maintainer Run |
| SSB | SF 0.1 | power | v1.3.2 | 2026-09-01 | — | 5.9 ms | Ranked | Local, x86-64, AMD EPYC, 15.6 GB | No tuning | Maintainer Run |
| SSB | SF 0.01 | power | v1.3.2 | 2026-09-01 | — | 2.4 ms | Ranked | Local, x86-64, Intel Xeon, 15.6 GB | No tuning | Maintainer Run |
| SSB | SF 0.1 | power | v1.3.2 | 2026-08-26 | — | 1.6 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SSB | SF 0.01 | power | v1.3.2 | 2026-08-25 | — | 0.6 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SSB | SF 1 | power | v1.3.2 | 2026-08-29 | — | 8.2 ms | Ranked | Local, Arm64, Apple silicon | Tuned | Maintainer Run |
| SSB | SF 1 | power | v1.3.2 | 2026-08-26 | — | 6.8 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SSB | SF 10 | power | v1.1.3 | 2026-08-29 | — | 63 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SSB | SF 10 | power | v1.2.2 | 2026-08-29 | — | 86 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SSB | SF 10 | power | v2.0.0-alpha38615 | 2026-08-29 | — | 34 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SSB | SF 10 | power | v1.5.5 | 2026-08-29 | — | 50 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SSB | SF 10 | power | v1.4.4 | 2026-08-29 | — | 60 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SSB | SF 10 | power | v1.3.2 | 2026-08-29 | — | 67 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| SSB | SF 10 | power | v1.0.0 | 2026-08-29 | — | 88 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-DS | SF 1 | power | v1.5.5 | 2026-10-01 | 114,649 | 32 ms | Ranked | Local, x86-64, AMD EPYC, 15.6 GB | No tuning | Maintainer Run |
| TPC-DS | SF 1 | power | v1.3.2 | 2026-09-01 | 79,639 | 45 ms | Ranked | Local, x86-64, AMD EPYC, 15.6 GB | No tuning | Maintainer Run |
| TPC-DS | SF 1 | power | v1.3.2 | 2026-08-23 | 269,803 | 13 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-DS | SF 10 | power | v1.3.2 | 2026-08-23 | 497,999 | 105 ms | Ranked | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-DS-OBT | SF 0.01 | power | v1.5.5 | 2026-11-11 | — | 2 ms | Ranked | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| TPC-DS-OBT | SF 0.1 | power | v1.5.5 | 2026-11-11 | — | 4.5 ms | Ranked | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| TPC-DS-OBT | SF 1 | power | v1.5.5 | 2026-10-26 | — | 20 ms | Ranked | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| TPC-H | SF 0.1 | power | v1.5.5 | 2026-11-11 | 52,188 | 6.6 ms | Ranked | Local, Arm64, Apple silicon, 16 GB | Not recorded | Maintainer Run |
| TPC-H | SF 0.01 | power | v1.5.5 | 2026-10-13 | 4,503 | 7.9 ms | Ranked | Local, x86-64, AMD EPYC, 15.6 GB | No tuning | Maintainer Run |
| TPC-H | SF 0.1 | power | v1.5.5 | 2026-10-13 | 24,801 | 14 ms | Ranked | Local, x86-64, AMD EPYC, 15.6 GB | No tuning | Maintainer Run |
| TPC-H | SF 0.1 | power | v1.5.5 | 2026-10-01 | 32,421 | 11 ms | Ranked | Local, x86-64, Intel Xeon, 15.6 GB | No tuning | Maintainer Run |
| TPC-H | SF 0.01 | power | v1.5.5 | 2026-10-01 | 4,302 | 7.9 ms | Ranked | Local, x86-64, AMD EPYC, 15.6 GB | No tuning | Maintainer Run |
| TPC-H | SF 0.01 | power | v1.3.2 | 2026-09-01 | 6,130 | 5.9 ms | Ranked | Local, x86-64, Intel Xeon, 15.6 GB | No tuning | Maintainer Run |
| TPC-H | SF 0.1 | power | v1.3.2 | 2026-09-01 | 24,750 | 14 ms | Ranked | Local, x86-64, AMD EPYC, 15.6 GB | No tuning | Maintainer Run |
| TPC-H | SF 1 | throughput (3 streams) | v1.5.5 | 2026-10-07 | 297,653 | 29 ms | Ranked | Local, Arm64, Apple silicon, 16 GB | No tuning | Maintainer Run |
| TPC-H | SF 1 | power | v1.3.2 | 2026-09-01 | 93,781 | 39 ms | Ranked | Local, x86-64, AMD EPYC, 15.6 GB | No tuning | Maintainer Run |
Runs not included in rankings
40 runs are published with their numbers and receipt but are not ranked. Reason: Non-standard runs are unofficial and are not ranked. (17); Known defective data. (23)
| Benchmark | Scale | Phase | Version | Run date | Score | Geomean | Reason not ranked | Execution environment | Tuning mode | Trust label |
|---|---|---|---|---|---|---|---|---|---|---|
| ClickBench | SF 10 | power | v1.1.3 | 2026-08-29 | — | 15 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| ClickBench | SF 10 | power | v1.3.2 | 2026-08-29 | — | 14 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| ClickBench | SF 10 | power | v1.0.0 | 2026-08-29 | — | 17 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| ClickBench | SF 10 | power | v1.2.2 | 2026-08-29 | — | 19 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| ClickBench | SF 10 | power | v2.0.0-alpha38615 | 2026-08-29 | — | 8.6 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| ClickBench | SF 10 | power | v1.5.5 | 2026-08-29 | — | 10 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| ClickBench | SF 10 | power | v1.4.4 | 2026-08-29 | — | 10 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| Read Primitives | SF 0.1 | power | v1.3.2 | 2026-08-26 | — | 2.2 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| Read Primitives | SF 0.01 | power | v1.3.2 | 2026-08-25 | — | 0.7 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-DS | SF 1 | power | v1.3.2 | 2026-08-25 | — | 12 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-DS | SF 10 | power | v2.0.0-alpha38615 | 2026-08-29 | — | 46 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-DS | SF 10 | power | v1.5.5 | 2026-08-29 | — | 54 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-DS | SF 10 | power | v1.4.4 | 2026-08-29 | — | 62 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-DS | SF 10 | power | v1.3.2 | 2026-08-29 | — | 68 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-DS | SF 10 | power | v1.2.2 | 2026-08-29 | — | 71 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-DS | SF 10 | power | v1.1.3 | 2026-08-29 | — | 63 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-DS | SF 10 | power | v1.0.0 | 2026-08-29 | — | 92 ms | Non-standard runs are unofficial and are not ranked. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-DS-OBT | SF 1 | power | v1.3.2 | 2026-08-26 | — | 7.5 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H | SF 0.01 | power | v1.3.2 | 2026-08-26 | 5,161 | 6.9 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H | SF 0.1 | power | v1.3.2 | 2026-08-26 | 24,448 | 15 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H | SF 1 | power | v1.5.5 | 2026-10-13 | — | 31 ms | Non-standard runs are unofficial and are not ranked. | Local, x86-64, AMD EPYC, 15.6 GB | No tuning | Maintainer Run |
| TPC-H | SF 1 | power | v1.5.5 | 2026-10-01 | — | 50 ms | Non-standard runs are unofficial and are not ranked. | Local, x86-64, AMD EPYC, 15.6 GB | No tuning | Maintainer Run |
| TPC-H | SF 1 | power | v1.3.2 | 2026-08-29 | 56,415 | 64 ms | Known defective data. | Local, Arm64, Apple silicon | Tuned | Maintainer Run |
| TPC-H | SF 1 | power | v1.3.2 | 2026-08-28 | 100,368 | 35 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H | SF 1 | power | v1.3.2 | 2026-08-26 | 93,186 | 38 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H | SF 10 | power | v2.0.0-alpha38615 | 2026-08-29 | 281,041 | 128 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H | SF 10 | power | v1.5.5 | 2026-08-29 | 236,191 | 152 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H | SF 10 | power | v1.4.4 | 2026-08-29 | 213,021 | 168 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H | SF 10 | power | v1.3.2 | 2026-08-29 | 198,175 | 189 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H | SF 10 | power | v1.2.2 | 2026-08-29 | 228,201 | 160 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H | SF 10 | power | v1.0.0 | 2026-08-29 | 173,508 | 208 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H | SF 10 | power | v1.1.3 | 2026-08-29 | 212,540 | 170 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H Data Vault | SF 0.01 | power | v1.3.2 | 2026-08-26 | — | 5.3 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H Data Vault | SF 0.1 | power | v1.3.2 | 2026-08-26 | — | 19 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H Skew | SF 0.1 | power | v1.3.2 | 2026-08-24 | — | 3 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H Skew | SF 0.01 | power | v1.3.2 | 2026-08-24 | — | 1.2 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-H Skew | SF 1 | power | v1.3.2 | 2026-08-26 | — | 12 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-Havoc | SF 0.1 | power | v1.3.2 | 2026-08-26 | — | 3.9 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-Havoc | SF 0.01 | power | v1.3.2 | 2026-08-26 | — | 1.3 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |
| TPC-Havoc | SF 1 | power | v1.3.2 | 2026-08-26 | — | 19 ms | Known defective data. | Local, Arm64, Apple silicon | No tuning | Maintainer Run |