Planner — PostgreSQL — 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 — PostgreSQL
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 12 12 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 5,962,158 6M Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q02 | Estimation Error Est Err Row Operations Ops 177,353 177K Rank | Estimation Error Est Err Row Operations Ops 176,523 177K Rank | Estimation Error Est Err Row Operations Ops 177,351 177K Rank | Estimation Error Est Err Row Operations Ops 495 495 Rank | Estimation Error Est Err Row Operations Ops 331,671 332K Rank | Estimation Error Est Err Row Operations Ops 1,375 1.4K Rank | Estimation Error Est Err Row Operations Ops 0 Rank |
| TPCH-Q03 | Estimation Error Est Err Row Operations Ops 902,470 902K Rank | Estimation Error Est Err Row Operations Ops 145,216 145K Rank | Estimation Error Est Err Row Operations Ops 872,521 873K Rank | Estimation Error Est Err Row Operations Ops 29,866 30K Rank | Estimation Error Est Err Row Operations Ops 96,810 97K Rank | Estimation Error Est Err Row Operations Ops 29,856 30K Rank | Estimation Error Est Err Row Operations Ops 0 Rank |
| TPCH-Q04 | Estimation Error Est Err Row Operations Ops 111,870 112K Rank | Estimation Error Est Err Row Operations Ops 55,935 56K Rank | Estimation Error Est Err Row Operations Ops 55,935 56K Rank | Estimation Error Est Err Row Operations Ops 51,276 51K Rank | Estimation Error Est Err Row Operations Ops 55,935 56K Rank | Estimation Error Est Err Row Operations Ops 51,291 51K Rank | Estimation Error Est Err Row Operations Ops 0 Rank |
| TPCH-Q05 | Estimation Error Est Err Row Operations Ops 390,553 391K Rank | Estimation Error Est Err Row Operations Ops 230,527 231K Rank | Estimation Error Est Err Row Operations Ops 564,994 565K Rank | Estimation Error Est Err Row Operations Ops 7,408 7.4K Rank | Estimation Error Est Err Row Operations Ops 250,651 251K Rank | Estimation Error Est Err Row Operations Ops 7,418 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,117 114K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q07 | Estimation Error Est Err Row Operations Ops 738,478 738K Rank | Estimation Error Est Err Row Operations Ops 588,476 588K Rank | Estimation Error Est Err Row Operations Ops 832,162 832K Rank | Estimation Error Est Err Row Operations Ops 5,924 5.9K Rank | Estimation Error Est Err Row Operations Ops 1,029,544 1M 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 101,107 101K Rank | Estimation Error Est Err Row Operations Ops 99,653 100K Rank | Estimation Error Est Err Row Operations Ops 115,237 115K Rank | Estimation Error Est Err Row Operations Ops 2,646 2.6K Rank | Estimation Error Est Err Row Operations Ops 101,429 101K Rank | Estimation Error Est Err Row Operations Ops 2,646 2.6K Rank | Estimation Error Est Err Row Operations Ops 0 Rank |
| TPCH-Q09 | Estimation Error Est Err Row Operations Ops 1,891,770 1.9M Rank | Estimation Error Est Err Row Operations Ops 370,838 371K Rank | Estimation Error Est Err Row Operations Ops 1,929,008 1.9M Rank | Estimation Error Est Err Row Operations Ops 327,147 327K Rank | Estimation Error Est Err Row Operations Ops 727,009 727K Rank | Estimation Error Est Err Row Operations Ops 327,672 328K Rank | Estimation Error Est Err Row Operations Ops 0 Rank |
| TPCH-Q10 | Estimation Error Est Err Row Operations Ops 322,447 322K Rank | Estimation Error Est Err Row Operations Ops 114,948 115K Rank | Estimation Error Est Err Row Operations Ops 284,208 284K Rank | Estimation Error Est Err Row Operations Ops 153,232 153K Rank | Estimation Error Est Err Row Operations Ops 191,682 192K 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 61,076 61K Rank | Estimation Error Est Err Row Operations Ops 61,074 61K Rank | Estimation Error Est Err Row Operations Ops 61,074 61K Rank | Estimation Error Est Err Row Operations Ops 1,225 1.2K Rank | Estimation Error Est Err Row Operations Ops 61,074 61K Rank | Estimation Error Est Err Row Operations Ops 60,320 60K Rank | Estimation Error Est Err Row Operations Ops 0 Rank |
| TPCH-Q12 | Estimation Error Est Err Row Operations Ops 1,530,837 1.5M Rank | Estimation Error Est Err Row Operations Ops 1,500,000 1.5M 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 30,843 31K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q13 | Estimation Error Est Err Row Operations Ops 1,649,958 1.6M Rank | Estimation Error Est Err Row Operations Ops 150,000 150K Rank | Estimation Error Est Err Row Operations Ops 1,499,958 1.5M Rank | Estimation Error Est Err Row Operations Ops 344,568 345K Rank | Estimation Error Est Err Row Operations Ops 516,654 517K Rank | Estimation Error Est Err Row Operations Ops 1,011,181 1M 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 23,881 24K Rank | Estimation Error Est Err Row Operations Ops 0 Rank | |
| TPCH-Q15 | Estimation Error Est Err Row Operations Ops 236,298 236K Rank | Estimation Error Est Err Row Operations Ops 1 1 Rank | Estimation Error Est Err Row Operations Ops 1 1 Rank | Estimation Error Est Err Row Operations Ops 29,985 30K Rank | Estimation Error Est Err Row Operations Ops 1 1 Rank | Estimation Error Est Err Row Operations Ops 266,282 266K Rank | Estimation Error Est Err Row Operations Ops 0 Rank |
| TPCH-Q16 | Estimation Error Est Err Row Operations Ops 829,467 829K Rank | Estimation Error Est Err Row Operations Ops 799,680 800K Rank | Estimation Error Est Err Row Operations Ops 1,599,360 1.6M Rank | Estimation Error Est Err Row Operations Ops 137,325 137K Rank | Estimation Error Est Err Row Operations Ops 839,361 839K 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 6,191,386 6.2M Rank | Estimation Error Est Err Row Operations Ops 189,973 190K Rank | Estimation Error Est Err Row Operations Ops 6,001,215 6M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 537 537 Rank | Estimation Error Est Err Row Operations Ops 190,510 191K Rank | Estimation Error Est Err Row Operations Ops 0 Rank |
| TPCH-Q18 | Estimation Error Est Err Row Operations Ops 19,650,905 20M Rank | Estimation Error Est Err Row Operations Ops 18,150,905 18M Rank | Estimation Error Est Err Row Operations Ops 1,647,260 1.6M Rank | Estimation Error Est Err Row Operations Ops 18 18 Rank | Estimation Error Est Err Row Operations Ops 99 99 Rank | Estimation Error Est Err Row Operations Ops 18,003,708 18M Rank | Estimation Error Est Err Row Operations Ops 0 Rank |
| TPCH-Q19 | Estimation Error Est Err Row Operations Ops 1,021 1K Rank | Estimation Error Est Err Row Operations Ops 511 511 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 510 510 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 18,680 19K Rank | Estimation Error Est Err Row Operations Ops 16,455 16K Rank | Estimation Error Est Err Row Operations Ops 21,328 21K Rank | Estimation Error Est Err Row Operations Ops 158 158 Rank | Estimation Error Est Err Row Operations Ops 12,807 13K Rank | Estimation Error Est Err Row Operations Ops 10,052 10K Rank | Estimation Error Est Err Row Operations Ops 0 Rank |
| TPCH-Q21 | Estimation Error Est Err Row Operations Ops 1,262,610 1.3M Rank | Estimation Error Est Err Row Operations Ops 533,196 533K Rank | Estimation Error Est Err Row Operations Ops 1,262,613 1.3M Rank | Estimation Error Est Err Row Operations Ops 4,331 4.3K Rank | Estimation Error Est Err Row Operations Ops 936,883 937K 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 76,086 76K Rank | Estimation Error Est Err Row Operations Ops 18,975 19K Rank | Estimation Error Est Err Row Operations Ops 18,975 19K Rank | Estimation Error Est Err Row Operations Ops 6,321 6.3K Rank | Estimation Error Est Err Row Operations Ops 18,975 19K Rank | Estimation Error Est Err Row Operations Ops 44,460 44K Rank | Estimation Error Est Err Row Operations Ops 0 Rank |