Planner — DuckDB — 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 — DuckDB
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,146 6M Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q02 | Estimation Error Est Err Row Operations Ops 1,620,960 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,626,036 1.6M Rank | Estimation Error Est Err Row Operations Ops 495 495 Rank | Estimation Error Est Err Row Operations Ops 14,334 14K Rank | Estimation Error Est Err Row Operations Ops 689 689 Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q03 | Estimation Error Est Err Row Operations Ops 809,889 810K Rank | Estimation Error Est Err Row Operations Ops 779,940 780K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 290,432 290K Rank | Estimation Error Est Err Row Operations Ops 29,857 30K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q04 | Estimation Error Est Err Row Operations Ops 6,057,030 6.1M Rank | Estimation Error Est Err Row Operations Ops 3,990,214 4M Rank | Estimation Error Est Err Row Operations Ops 5 5 Rank | Estimation Error Est Err Row Operations Ops 248,261 248K Rank | Estimation Error Est Err Row Operations Ops 51,276 51K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q05 | Estimation Error Est Err Row Operations Ops 585,359 585K Rank | Estimation Error Est Err Row Operations Ops 759,742 760K Rank | Estimation Error Est Err Row Operations Ops 5 5 Rank | Estimation Error Est Err Row Operations Ops 270,783 271K Rank | Estimation Error Est Err Row Operations Ops 7,403 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,114 114K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q07 | Estimation Error Est Err Row Operations Ops 2,121,009 2.1M Rank | Estimation Error Est Err Row Operations Ops 2,279,841 2.3M Rank | Estimation Error Est Err Row Operations Ops 4 4 Rank | Estimation Error Est Err Row Operations Ops 316,220 316K Rank | Estimation Error Est Err Row Operations Ops 5,924 5.9K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q08 | Estimation Error Est Err Row Operations Ops 6,041,438 6M Rank | Estimation Error Est Err Row Operations Ops 6,056,314 6.1M Rank | Estimation Error Est Err Row Operations Ops 2 2 Rank | Estimation Error Est Err Row Operations Ops 104,959 105K Rank | Estimation Error Est Err Row Operations Ops 2,647 2.6K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q09 | Estimation Error Est Err Row Operations Ops 8,322,111 8.3M Rank | Estimation Error Est Err Row Operations Ops 7,465,475 7.5M Rank | Estimation Error Est Err Row Operations Ops 175 175 Rank | Estimation Error Est Err Row Operations Ops 3,437,148 3.4M Rank | Estimation Error Est Err Row Operations Ops 327,148 327K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q10 | Estimation Error Est Err Row Operations Ops 220,628 221K Rank | Estimation Error Est Err Row Operations Ops 220,603 221K Rank | Estimation Error Est Err Row Operations Ops 38,182 38K Rank | Estimation Error Est Err Row Operations Ops 215,372 215K Rank | Estimation Error Est Err Row Operations Ops 115,050 115K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q11 | Estimation Error Est Err Row Operations Ops 870,321 870K Rank | Estimation Error Est Err Row Operations Ops 838,515 839K Rank | Estimation Error Est Err Row Operations Ops 1,225 1.2K Rank | Estimation Error Est Err Row Operations Ops 31,762 32K Rank | Estimation Error Est Err Row Operations Ops 60,321 60K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q12 | Estimation Error Est Err Row Operations Ops 920,591 921K Rank | Estimation Error Est Err Row Operations Ops 34,818 35K 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,837 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,699,963 1.7M Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q14 | Estimation Error Est Err Row Operations Ops 271,636 272K Rank | Estimation Error Est Err Row Operations Ops 71,636 72K 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 71,636 72K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q15 | Estimation Error Est Err Row Operations Ops 246,298 246K Rank | Estimation Error Est Err Row Operations Ops 10,001 10K Rank | Estimation Error Est Err Row Operations Ops 1 1 Rank | Estimation Error Est Err Row Operations Ops 2 2 Rank | Estimation Error Est Err Row Operations Ops 236,298 236K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q16 | Estimation Error Est Err Row Operations Ops 985,560 986K Rank | Estimation Error Est Err Row Operations Ops 1,104,648 1.1M Rank | Estimation Error Est Err Row Operations Ops 18,282 18K Rank | Estimation Error Est Err Row Operations Ops 423,748 424K Rank | Estimation Error Est Err Row Operations Ops 119,043 119K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q17 | Estimation Error Est Err Row Operations Ops 11,995,356 12M Rank | Estimation Error Est Err Row Operations Ops 12,007,216 12M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 18,285 18K Rank | Estimation Error Est Err Row Operations Ops 6,566 6.6K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q18 | Estimation Error Est Err Row Operations Ops 6,151,569 6.2M Rank | Estimation Error Est Err Row Operations Ops 364 364 Rank | Estimation Error Est Err Row Operations Ops 9 9 Rank | Estimation Error Est Err Row Operations Ops 150,071 150K Rank | Estimation Error Est Err Row Operations Ops 6,001,278 6M Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q19 | Estimation Error Est Err Row Operations Ops 1,700,048 1.7M Rank | Estimation Error Est Err Row Operations Ops 214,377 214K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 214,377 214K Rank | Estimation Error Est Err Row Operations Ops 127 127 Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q20 | Estimation Error Est Err Row Operations Ops 935,208 935K Rank | Estimation Error Est Err Row Operations Ops 956,803 957K Rank | Estimation Error Est Err Row Operations Ops 158 158 Rank | Estimation Error Est Err Row Operations Ops 37,470 37K Rank | Estimation Error Est Err Row Operations Ops 10,030 10K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q21 | Estimation Error Est Err Row Operations Ops 18,157,536 18M Rank | Estimation Error Est Err Row Operations Ops 14,106,623 14M Rank | Estimation Error Est Err Row Operations Ops 396 396 Rank | Estimation Error Est Err Row Operations Ops 1,175,886 1.2M Rank | Estimation Error Est Err Row Operations Ops 3,935 3.9K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q22 | Estimation Error Est Err Row Operations Ops 1,580,045 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,751,627 1.8M Rank | Estimation Error Est Err Row Operations Ops 7 7 Rank | Estimation Error Est Err Row Operations Ops 235,015 235K Rank | Estimation Error Est Err Row Operations Ops 44,459 44K Rank | Estimation Error Est Err Row Operations Ops 0 Rank |