Planner — PostgreSQL — 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 79,980,863 80M Rank | Estimation Error Est Err Row Operations Ops 70,658,594 71M Rank | Estimation Error Est Err Row Operations Ops 126,418 126K Rank | Estimation Error Est Err Row Operations Ops 48,026,205 48M Rank | Estimation Error Est Err Row Operations Ops 16,302,272 16M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
 DuckDB | Estimation Error Est Err Row Operations Ops 89,761,923 90M Rank | Estimation Error Est Err Row Operations Ops 68,830,910 69M Rank | Estimation Error Est Err Row Operations Ops 49,283 49K Rank | Estimation Error Est Err Row Operations Ops 7,632,898 7.6M Rank | Estimation Error Est Err Row Operations Ops 14,294,766 14M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
 PostgreSQL | Estimation Error Est Err Row Operations Ops 65,389,535 65M Rank | Estimation Error Est Err Row Operations Ops 43,174,275 43M Rank | Estimation Error Est Err Row Operations Ops 14,013,796 14M Rank | Estimation Error Est Err Row Operations Ops 16,047,732 16M Rank | Estimation Error Est Err Row Operations Ops 16,814,950 17M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
 SQL Server | Estimation Error Est Err Row Operations Ops 75,791,798 76M Rank | Estimation Error Est Err Row Operations Ops 59,322,313 59M Rank | Estimation Error Est Err Row Operations Ops 509,763 510K Rank | Estimation Error Est Err Row Operations Ops 6,653,004 6.7M Rank | Estimation Error Est Err Row Operations Ops 14,289,817 14M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
TPC-H — Full compare
Breakdown — TPC-H — PostgreSQL
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,530 5.6M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 5,642,530 5.6M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 5,642,550 5.6M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q02 | Estimation Error Est Err Row Operations Ops 614,602 615K Rank | Estimation Error Est Err Row Operations Ops 621,442 621K Rank | Estimation Error Est Err Row Operations Ops 346 346 Rank | Estimation Error Est Err Row Operations Ops 133,172 133K Rank | Estimation Error Est Err Row Operations Ops 1,145 1.1K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q03 | Estimation Error Est Err Row Operations Ops 4,111,171 4.1M Rank | Estimation Error Est Err Row Operations Ops 4,080,935 4.1M Rank | Estimation Error Est Err Row Operations Ops 28,125 28K Rank | Estimation Error Est Err Row Operations Ops 276,720 277K Rank | Estimation Error Est Err Row Operations Ops 28,115 28K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q04 | Estimation Error Est Err Row Operations Ops 3,843,516 3.8M Rank | Estimation Error Est Err Row Operations Ops 52,204 52K Rank | Estimation Error Est Err Row Operations Ops 47,832 48K Rank | Estimation Error Est Err Row Operations Ops 3,791,312 3.8M Rank | Estimation Error Est Err Row Operations Ops 47,852 48K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q05 | Estimation Error Est Err Row Operations Ops 6,372,861 6.4M Rank | Estimation Error Est Err Row Operations Ops 7,175,985 7.2M Rank | Estimation Error Est Err Row Operations Ops 6,995 7K Rank | Estimation Error Est Err Row Operations Ops 1,067,194 1.1M Rank | Estimation Error Est Err Row Operations Ops 7,015 7K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q06 | Estimation Error Est Err Row Operations Ops 120,990 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 120,995 121K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q07 | Estimation Error Est Err Row Operations Ops 2,009,312 2M Rank | Estimation Error Est Err Row Operations Ops 2,143,470 2.1M Rank | Estimation Error Est Err Row Operations Ops 5,455 5.5K Rank | Estimation Error Est Err Row Operations Ops 296,055 296K Rank | Estimation Error Est Err Row Operations Ops 5,455 5.5K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q08 | Estimation Error Est Err Row Operations Ops 97,230 97K Rank | Estimation Error Est Err Row Operations Ops 109,936 110K Rank | Estimation Error Est Err Row Operations Ops 2,322 2.3K Rank | Estimation Error Est Err Row Operations Ops 100,590 101K Rank | Estimation Error Est Err Row Operations Ops 2,328 2.3K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q09 | Estimation Error Est Err Row Operations Ops 1,331,549 1.3M Rank | Estimation Error Est Err Row Operations Ops 1,582,052 1.6M Rank | Estimation Error Est Err Row Operations Ops 245,492 245K Rank | Estimation Error Est Err Row Operations Ops 1,014,844 1M Rank | Estimation Error Est Err Row Operations Ops 246,192 246K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q10 | Estimation Error Est Err Row Operations Ops 1,596,845 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,609,400 1.6M Rank | Estimation Error Est Err Row Operations Ops 138,495 138K Rank | Estimation Error Est Err Row Operations Ops 366,650 367K 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 610,001 610K Rank | Estimation Error Est Err Row Operations Ops 610,000 610K Rank | Estimation Error Est Err Row Operations Ops 25,062 25K Rank | Estimation Error Est Err Row Operations Ops 23,740 24K Rank | Estimation Error Est Err Row Operations Ops 22,256 22K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q12 | Estimation Error Est Err Row Operations Ops 58,259 58K Rank | Estimation Error Est Err Row Operations Ops 29,130 29K Rank | Estimation Error Est Err Row Operations Ops 29,130 29K Rank | Estimation Error Est Err Row Operations Ops 29,130 29K Rank | Estimation Error Est Err Row Operations Ops 29,140 29K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q13 | Estimation Error Est Err Row Operations Ops 1,649,944 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,599,944 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,749,992 1.7M Rank | Estimation Error Est Err Row Operations Ops 1,599,944 1.6M Rank | Estimation Error Est Err Row Operations Ops 2,049,848 2M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q14 | Estimation Error Est Err Row Operations Ops 268,120 268K Rank | Estimation Error Est Err Row Operations Ops 68,120 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,125 68K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q15 | Estimation Error Est Err Row Operations Ops 268,120 268K Rank | Estimation Error Est Err Row Operations Ops 68,120 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,125 68K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q16 | Estimation Error Est Err Row Operations Ops 443,535 444K Rank | Estimation Error Est Err Row Operations Ops 410,472 410K Rank | Estimation Error Est Err Row Operations Ops 76,379 76K Rank | Estimation Error Est Err Row Operations Ops 61,216 61K Rank | Estimation Error Est Err Row Operations Ops 61,216 61K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q17 | Estimation Error Est Err Row Operations Ops 6,187,501 6.2M Rank | Estimation Error Est Err Row Operations Ops 5,998,820 6M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 6,080 6.1K Rank | Estimation Error Est Err Row Operations Ops 188,944 189K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q18 | Estimation Error Est Err Row Operations Ops 13,647,640 14M Rank | Estimation Error Est Err Row Operations Ops 7,498,825 7.5M Rank | Estimation Error Est Err Row Operations Ops 5,998,860 6M Rank | Estimation Error Est Err Row Operations Ops 150,040 150K Rank | Estimation Error Est Err Row Operations Ops 7,500,985 7.5M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q19 | Estimation Error Est Err Row Operations Ops 1,026 1K Rank | Estimation Error Est Err Row Operations Ops 513 513 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 513 513 Rank | Estimation Error Est Err Row Operations Ops 99 99 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q20 | Estimation Error Est Err Row Operations Ops 1,396,951 1.4M Rank | Estimation Error Est Err Row Operations Ops 401,023 401K Rank | Estimation Error Est Err Row Operations Ops 145 145 Rank | Estimation Error Est Err Row Operations Ops 403,620 404K Rank | Estimation Error Est Err Row Operations Ops 600,000 600K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q21 | Estimation Error Est Err Row Operations Ops 13,599,420 14M Rank | Estimation Error Est Err Row Operations Ops 7,613,884 7.6M Rank | Estimation Error Est Err Row Operations Ops 4,456 4.5K Rank | Estimation Error Est Err Row Operations Ops 6,308,500 6.3M 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,518,412 1.5M Rank | Estimation Error Est Err Row Operations Ops 1,500,000 1.5M Rank | Estimation Error Est Err Row Operations Ops 12,180 12K Rank | Estimation Error Est Err Row Operations Ops 18,412 18K Rank | Estimation Error Est Err Row Operations Ops 12,180 12K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |