Planner — DuckDB — TPC-H
Summary — Comparing other engines
Scan Scan | Join Probe Join | Sort Sort | Hash Build Hash | Aggregate Agg | Distribute Dist | |
|---|---|---|---|---|---|---|
 ClickHouse | Estimation Error Est Err Row Operations Ops 80,842,240 81M Rank | Estimation Error Est Err Row Operations Ops 73,424,030 73M Rank | Estimation Error Est Err Row Operations Ops 137,466 137K Rank | Estimation Error Est Err Row Operations Ops 50,287,350 50M Rank | Estimation Error Est Err Row Operations Ops 16,433,196 16M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
 DuckDB | Estimation Error Est Err Row Operations Ops 92,885,189 93M Rank | Estimation Error Est Err Row Operations Ops 72,163,397 72M Rank | Estimation Error Est Err Row Operations Ops 50,811 51K Rank | Estimation Error Est Err Row Operations Ops 9,120,751 9.1M Rank | Estimation Error Est Err Row Operations Ops 14,414,952 14M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
 PostgreSQL | Estimation Error Est Err Row Operations Ops 66,831,563 67M Rank | Estimation Error Est Err Row Operations Ops 44,378,394 44M Rank | Estimation Error Est Err Row Operations Ops 14,125,652 14M Rank | Estimation Error Est Err Row Operations Ops 16,591,350 17M Rank | Estimation Error Est Err Row Operations Ops 17,125,406 17M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
 SQL Server | Estimation Error Est Err Row Operations Ops 30,928,016 31M Rank | Estimation Error Est Err Row Operations Ops 10,802,620 11M Rank | Estimation Error Est Err Row Operations Ops 54,661 55K Rank | Estimation Error Est Err Row Operations Ops 6,905,358 6.9M Rank | Estimation Error Est Err Row Operations Ops 14,393,287 14M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
TPC-H — Full compare
Breakdown — TPC-H — DuckDB
Scan Scan | Join Probe Join | Sort Sort | Hash Build Hash | Aggregate Agg | Distribute Dist | |
|---|---|---|---|---|---|---|
| TPCH-Q01 | Estimation Error Est Err Row Operations Ops 5,642,532 5.6M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 4 4 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 5,642,532 5.6M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q02 | Estimation Error Est Err Row Operations Ops 1,608,711 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,614,263 1.6M Rank | Estimation Error Est Err Row Operations Ops 468 468 Rank | Estimation Error Est Err Row Operations Ops 14,319 14K Rank | Estimation Error Est Err Row Operations Ops 644 644 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q03 | Estimation Error Est Err Row Operations Ops 4,111,077 4.1M Rank | Estimation Error Est Err Row Operations Ops 4,080,841 4.1M Rank | Estimation Error Est Err Row Operations Ops 18,446,744,073,709,552,000 1844 Rank | Estimation Error Est Err Row Operations Ops 276,724 277K Rank | Estimation Error Est Err Row Operations Ops 28,114 28K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q04 | Estimation Error Est Err Row Operations Ops 6,050,773 6.1M Rank | Estimation Error Est Err Row Operations Ops 3,974,931 4M Rank | Estimation Error Est Err Row Operations Ops 5 5 Rank | Estimation Error Est Err Row Operations Ops 231,607 232K Rank | Estimation Error Est Err Row Operations Ops 47,831 48K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q05 | Estimation Error Est Err Row Operations Ops 6,330,085 6.3M Rank | Estimation Error Est Err Row Operations Ops 6,491,163 6.5M Rank | Estimation Error Est Err Row Operations Ops 5 5 Rank | Estimation Error Est Err Row Operations Ops 254,028 254K Rank | Estimation Error Est Err Row Operations Ops 6,988 7K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q06 | Estimation Error Est Err Row Operations Ops 121,011 121K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 121,011 121K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q07 | Estimation Error Est Err Row Operations Ops 3,224,816 3.2M Rank | Estimation Error Est Err Row Operations Ops 3,358,906 3.4M Rank | Estimation Error Est Err Row Operations Ops 4 4 Rank | Estimation Error Est Err Row Operations Ops 292,909 293K Rank | Estimation Error Est Err Row Operations Ops 5,457 5.5K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q08 | Estimation Error Est Err Row Operations Ops 6,539,428 6.5M Rank | Estimation Error Est Err Row Operations Ops 6,548,845 6.5M Rank | Estimation Error Est Err Row Operations Ops 2 2 Rank | Estimation Error Est Err Row Operations Ops 100,578 101K Rank | Estimation Error Est Err Row Operations Ops 2,323 2.3K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q09 | Estimation Error Est Err Row Operations Ops 8,318,877 8.3M Rank | Estimation Error Est Err Row Operations Ops 7,463,459 7.5M Rank | Estimation Error Est Err Row Operations Ops 175 175 Rank | Estimation Error Est Err Row Operations Ops 3,437,615 3.4M Rank | Estimation Error Est Err Row Operations Ops 327,773 328K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q10 | Estimation Error Est Err Row Operations Ops 1,596,791 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,692,690 1.7M Rank | Estimation Error Est Err Row Operations Ops 30,170 30K Rank | Estimation Error Est Err Row Operations Ops 312,391 312K Rank | Estimation Error Est Err Row Operations Ops 108,325 108K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q11 | Estimation Error Est Err Row Operations Ops 1,591,788 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,619,881 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,196 1.2K Rank | Estimation Error Est Err Row Operations Ops 61,294 61K Rank | Estimation Error Est Err Row Operations Ops 59,357 59K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q12 | Estimation Error Est Err Row Operations Ops 2,334,081 2.3M Rank | Estimation Error Est Err Row Operations Ops 1,499,971 1.5M Rank | Estimation Error Est Err Row Operations Ops 2 2 Rank | Estimation Error Est Err Row Operations Ops 29,129 29K Rank | Estimation Error Est Err Row Operations Ops 29,129 29K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q13 | Estimation Error Est Err Row Operations Ops 1,649,945 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,599,945 1.6M Rank | Estimation Error Est Err Row Operations Ops 48 48 Rank | Estimation Error Est Err Row Operations Ops 1,599,945 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,749,945 1.7M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q14 | Estimation Error Est Err Row Operations Ops 268,122 268K Rank | Estimation Error Est Err Row Operations Ops 68,122 68K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 200,000 200K Rank | Estimation Error Est Err Row Operations Ops 68,122 68K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q15 | Estimation Error Est Err Row Operations Ops 268,122 268K Rank | Estimation Error Est Err Row Operations Ops 68,122 68K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 200,000 200K Rank | Estimation Error Est Err Row Operations Ops 68,122 68K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q16 | Estimation Error Est Err Row Operations Ops 988,701 989K Rank | Estimation Error Est Err Row Operations Ops 1,105,162 1.1M Rank | Estimation Error Est Err Row Operations Ops 18,149 18K Rank | Estimation Error Est Err Row Operations Ops 424,818 425K Rank | Estimation Error Est Err Row Operations Ops 81,838 82K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q17 | Estimation Error Est Err Row Operations Ops 11,841,430 12M Rank | Estimation Error Est Err Row Operations Ops 11,853,388 12M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 18,442 18K Rank | Estimation Error Est Err Row Operations Ops 6,544 6.5K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q18 | Estimation Error Est Err Row Operations Ops 6,710,479 6.7M Rank | Estimation Error Est Err Row Operations Ops 561,666 562K Rank | Estimation Error Est Err Row Operations Ops 5 5 Rank | Estimation Error Est Err Row Operations Ops 150,038 150K Rank | Estimation Error Est Err Row Operations Ops 5,998,855 6M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q19 | Estimation Error Est Err Row Operations Ops 1,699,869 1.7M Rank | Estimation Error Est Err Row Operations Ops 214,265 214K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 214,265 214K Rank | Estimation Error Est Err Row Operations Ops 97 97 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q20 | Estimation Error Est Err Row Operations Ops 1,656,797 1.7M Rank | Estimation Error Est Err Row Operations Ops 1,677,128 1.7M Rank | Estimation Error Est Err Row Operations Ops 175 175 Rank | Estimation Error Est Err Row Operations Ops 35,128 35K Rank | Estimation Error Est Err Row Operations Ops 9,062 9.1K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q21 | Estimation Error Est Err Row Operations Ops 18,754,973 19M Rank | Estimation Error Est Err Row Operations Ops 14,924,939 15M Rank | Estimation Error Est Err Row Operations Ops 396 396 Rank | Estimation Error Est Err Row Operations Ops 1,031,358 1M Rank | Estimation Error Est Err Row Operations Ops 4,060 4.1K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q22 | Estimation Error Est Err Row Operations Ops 1,576,781 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,745,710 1.7M Rank | Estimation Error Est Err Row Operations Ops 7 7 Rank | Estimation Error Est Err Row Operations Ops 236,163 236K Rank | Estimation Error Est Err Row Operations Ops 48,823 49K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |