Planner — Databricks — TPC-H
Summary — Comparing other engines
Scan Scan | Seek Seek | Join Probe Join | Sort Sort | Hash Build Hash | Aggregate Agg | Distribute Dist | |
|---|---|---|---|---|---|---|---|
 ClickHouse | Estimation Error Est Err Row Operations Ops 91,072,096 91M Rank | Estimation Error Est Err Row Operations Ops 68,908,091 69M Rank | Estimation Error Est Err Row Operations Ops 1,570,501 1.6M Rank | Estimation Error Est Err Row Operations Ops 50,298,831 50M Rank | Estimation Error Est Err Row Operations Ops 27,792,345 28M Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
 Databricks | Estimation Error Est Err Row Operations Ops 91,151,007 91M Rank | Estimation Error Est Err Row Operations Ops 49,377,786 49M Rank | Estimation Error Est Err Row Operations Ops 58,567 59K Rank | Estimation Error Est Err Row Operations Ops 28,331,654 28M Rank | Estimation Error Est Err Row Operations Ops 34,252,780 34M Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
 DuckDB | Estimation Error Est Err Row Operations Ops 77,318,811 77M Rank | Estimation Error Est Err Row Operations Ops 55,824,756 56M Rank | Estimation Error Est Err Row Operations Ops 58,994 59K Rank | Estimation Error Est Err Row Operations Ops 8,964,925 9M Rank | Estimation Error Est Err Row Operations Ops 14,900,747 15M Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
 PostgreSQL | Estimation Error Est Err Row Operations Ops 42,492,268 42M Rank | Estimation Error Est Err Row Operations Ops 21,702,886 22M Rank | Estimation Error Est Err Row Operations Ops 18,515,347 19M Rank | Estimation Error Est Err Row Operations Ops 1,132,774 1.1M Rank | Estimation Error Est Err Row Operations Ops 5,402,469 5.4M Rank | Estimation Error Est Err Row Operations Ops 26,381,851 26M Rank | Estimation Error Est Err Row Operations Ops 0 Rank |
 SQL Server | Estimation Error Est Err Row Operations Ops 18,288,554 18M Rank | Estimation Error Est Err Row Operations Ops 1 1 Rank | Estimation Error Est Err Row Operations Ops 4,138,813 4.1M Rank | Estimation Error Est Err Row Operations Ops 65,938 66K Rank | Estimation Error Est Err Row Operations Ops 3,506,955 3.5M Rank | Estimation Error Est Err Row Operations Ops 14,837,064 15M Rank | Estimation Error Est Err Row Operations Ops 0 Rank |
TPC-H — Full compare
Breakdown — TPC-H — Databricks
Scan Scan | Seek Seek | Join Probe Join | Sort Sort | Hash Build Hash | Aggregate Agg | Distribute Dist | |
|---|---|---|---|---|---|---|---|
| TPCH-Q01 | Estimation Error Est Err Row Operations Ops 5,962,146 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,962,154 6M Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q02 | Estimation Error Est Err Row Operations Ops 1,606,213 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,724,196 1.7M Rank | Estimation Error Est Err Row Operations Ops 495 495 Rank | Estimation Error Est Err Row Operations Ops 164,116 164K Rank | Estimation Error Est Err Row Operations Ops 276,382 276K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q03 | Estimation Error Est Err Row Operations Ops 3,997,498 4M Rank | Estimation Error Est Err Row Operations Ops 975,174 975K Rank | Estimation Error Est Err Row Operations Ops 11,281 11K Rank | Estimation Error Est Err Row Operations Ops 870,989 871K Rank | Estimation Error Est Err Row Operations Ops 3,264,338 3.3M Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q04 | Estimation Error Est Err Row Operations Ops 3,849,231 3.8M Rank | Estimation Error Est Err Row Operations Ops 3,793,296 3.8M Rank | Estimation Error Est Err Row Operations Ops 5 5 Rank | Estimation Error Est Err Row Operations Ops 55,935 56K Rank | Estimation Error Est Err Row Operations Ops 51,316 51K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q05 | Estimation Error Est Err Row Operations Ops 6,379,570 6.4M Rank | Estimation Error Est Err Row Operations Ops 6,236,972 6.2M Rank | Estimation Error Est Err Row Operations Ops 5 5 Rank | Estimation Error Est Err Row Operations Ops 2,058,483 2.1M Rank | Estimation Error Est Err Row Operations Ops 7,413 7.4K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q06 | Estimation Error Est Err Row Operations Ops 114,114 114K 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 114,116 114K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q07 | Estimation Error Est Err Row Operations Ops 3,474,731 3.5M Rank | Estimation Error Est Err Row Operations Ops 3,456,395 3.5M Rank | Estimation Error Est Err Row Operations Ops 4 4 Rank | Estimation Error Est Err Row Operations Ops 564,808 565K Rank | Estimation Error Est Err Row Operations Ops 5,932 5.9K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q08 | Estimation Error Est Err Row Operations Ops 6,607,232 6.6M Rank | Estimation Error Est Err Row Operations Ops 694,976 695K Rank | Estimation Error Est Err Row Operations Ops 2 2 Rank | Estimation Error Est Err Row Operations Ops 6,090,855 6.1M Rank | Estimation Error Est Err Row Operations Ops 2,649 2.6K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q09 | Estimation Error Est Err Row Operations Ops 8,314,398 8.3M Rank | Estimation Error Est Err Row Operations Ops 7,457,762 7.5M Rank | Estimation Error Est Err Row Operations Ops 175 175 Rank | Estimation Error Est Err Row Operations Ops 12,651,228 13M Rank | Estimation Error Est Err Row Operations Ops 327,498 327K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q10 | Estimation Error Est Err Row Operations Ops 1,681,513 1.7M Rank | Estimation Error Est Err Row Operations Ops 1,681,488 1.7M Rank | Estimation Error Est Err Row Operations Ops 26,475 26K Rank | Estimation Error Est Err Row Operations Ops 229,998 230K Rank | Estimation Error Est Err Row Operations Ops 157,817 158K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q11 | Estimation Error Est Err Row Operations Ops 1,604,219 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,592,469 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,225 1.2K Rank | Estimation Error Est Err Row Operations Ops 66,383 66K Rank | Estimation Error Est Err Row Operations Ops 88,836 89K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q12 | Estimation Error Est Err Row Operations Ops 1,526,820 1.5M Rank | Estimation Error Est Err Row Operations Ops 1,495,983 1.5M Rank | Estimation Error Est Err Row Operations Ops 2 2 Rank | Estimation Error Est Err Row Operations Ops 30,837 31K Rank | Estimation Error Est Err Row Operations Ops 30,839 31K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q13 | Estimation Error Est Err Row Operations Ops 1,649,959 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,549,963 1.5M Rank | Estimation Error Est Err Row Operations Ops 42 42 Rank | Estimation Error Est Err Row Operations Ops 1,549,963 1.5M Rank | Estimation Error Est Err Row Operations Ops 1,700,275 1.7M Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q14 | Estimation Error Est Err Row Operations Ops 268,713 269K Rank | Estimation Error Est Err Row Operations Ops 197,077 197K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 71,636 72K Rank | Estimation Error Est Err Row Operations Ops 71,637 72K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q15 | Estimation Error Est Err Row Operations Ops 228,106 228K Rank | Estimation Error Est Err Row Operations Ops 1 1 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 1,809 1.8K Rank | Estimation Error Est Err Row Operations Ops 256,295 256K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q16 | Estimation Error Est Err Row Operations Ops 826,251 826K Rank | Estimation Error Est Err Row Operations Ops 238,143 238K Rank | Estimation Error Est Err Row Operations Ops 18,282 18K Rank | Estimation Error Est Err Row Operations Ops 915,572 916K Rank | Estimation Error Est Err Row Operations Ops 392,301 392K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q17 | Estimation Error Est Err Row Operations Ops 12,002,826 12M Rank | Estimation Error Est Err Row Operations Ops 265,413 265K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 735 735 Rank | Estimation Error Est Err Row Operations Ops 6,401,948 6.4M Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q18 | Estimation Error Est Err Row Operations Ops 13,332,943 13M Rank | Estimation Error Est Err Row Operations Ops 1,650,010 1.7M Rank | Estimation Error Est Err Row Operations Ops 9 9 Rank | Estimation Error Est Err Row Operations Ops 1,180,531 1.2M Rank | Estimation Error Est Err Row Operations Ops 13,502,440 14M Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q19 | Estimation Error Est Err Row Operations Ops 132,136 132K Rank | Estimation Error Est Err Row Operations Ops 511 511 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 131,625 132K Rank | Estimation Error Est Err Row Operations Ops 129 129 Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q20 | Estimation Error Est Err Row Operations Ops 1,716,911 1.7M Rank | Estimation Error Est Err Row Operations Ops 555,267 555K Rank | Estimation Error Est Err Row Operations Ops 158 158 Rank | Estimation Error Est Err Row Operations Ops 1,348,029 1.3M Rank | Estimation Error Est Err Row Operations Ops 1,587,744 1.6M Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q21 | Estimation Error Est Err Row Operations Ops 14,318,377 14M Rank | Estimation Error Est Err Row Operations Ops 14,312,690 14M Rank | Estimation Error Est Err Row Operations Ops 396 396 Rank | Estimation Error Est Err Row Operations Ops 329,155 329K Rank | Estimation Error Est Err Row Operations Ops 6,263 6.3K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q22 | Estimation Error Est Err Row Operations Ops 1,557,100 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,500,000 1.5M Rank | Estimation Error Est Err Row Operations Ops 7 7 Rank | Estimation Error Est Err Row Operations Ops 18,967 19K Rank | Estimation Error Est Err Row Operations Ops 44,458 44K Rank | Estimation Error Est Err Row Operations Ops 0 Rank |