Planner — ClickHouse — 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 — ClickHouse
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,220,854 1.2M Rank | Estimation Error Est Err Row Operations Ops 2,407,934 2.4M Rank | Estimation Error Est Err Row Operations Ops 516 516 Rank | Estimation Error Est Err Row Operations Ops 1,425,587 1.4M Rank | Estimation Error Est Err Row Operations Ops 120,875 121K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q03 | Estimation Error Est Err Row Operations Ops 4,111,316 4.1M Rank | Estimation Error Est Err Row Operations Ops 4,798,963 4.8M Rank | Estimation Error Est Err Row Operations Ops 71,365 71K Rank | Estimation Error Est Err Row Operations Ops 1,683,020 1.7M Rank | Estimation Error Est Err Row Operations Ops 278,907 279K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q04 | Estimation Error Est Err Row Operations Ops 3,843,682 3.8M Rank | Estimation Error Est Err Row Operations Ops 52,371 52K Rank | Estimation Error Est Err Row Operations Ops 5 5 Rank | Estimation Error Est Err Row Operations Ops 3,791,311 3.8M Rank | Estimation Error Est Err Row Operations Ops 52,371 52K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q05 | Estimation Error Est Err Row Operations Ops 6,373,251 6.4M Rank | Estimation Error Est Err Row Operations Ops 7,608,212 7.6M Rank | Estimation Error Est Err Row Operations Ops 5 5 Rank | Estimation Error Est Err Row Operations Ops 1,615,345 1.6M Rank | Estimation Error Est Err Row Operations Ops 5,953 6K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q06 | Estimation Error Est Err Row Operations Ops 121,014 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,014 121K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q07 | Estimation Error Est Err Row Operations Ops 3,375,198 3.4M Rank | Estimation Error Est Err Row Operations Ops 7,916,027 7.9M Rank | Estimation Error Est Err Row Operations Ops 50 50 Rank | Estimation Error Est Err Row Operations Ops 7,738,029 7.7M Rank | Estimation Error Est Err Row Operations Ops 1,537,150 1.5M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q08 | Estimation Error Est Err Row Operations Ops 6,589,154 6.6M Rank | Estimation Error Est Err Row Operations Ops 7,592,360 7.6M Rank | Estimation Error Est Err Row Operations Ops 2 2 Rank | Estimation Error Est Err Row Operations Ops 1,735,198 1.7M Rank | Estimation Error Est Err Row Operations Ops 2,400 2.4K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q09 | Estimation Error Est Err Row Operations Ops 8,119,731 8.1M Rank | Estimation Error Est Err Row Operations Ops 15,927,596 16M Rank | Estimation Error Est Err Row Operations Ops 175 175 Rank | Estimation Error Est Err Row Operations Ops 10,151,467 10M Rank | Estimation Error Est Err Row Operations Ops 222,691 223K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q10 | Estimation Error Est Err Row Operations Ops 1,596,967 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,484,360 1.5M Rank | Estimation Error Est Err Row Operations Ops 16,492 16K Rank | Estimation Error Est Err Row Operations Ops 250,000 250K Rank | Estimation Error Est Err Row Operations Ops 45,806 46K 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 1,199,941 1.2M Rank | Estimation Error Est Err Row Operations Ops 24,359 24K Rank | Estimation Error Est Err Row Operations Ops 625,860 626K Rank | Estimation Error Est Err Row Operations Ops 25,919 26K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q12 | Estimation Error Est Err Row Operations Ops 1,529,129 1.5M Rank | Estimation Error Est Err Row Operations Ops 29,129 29K Rank | Estimation Error Est Err Row Operations Ops 2 2 Rank | Estimation Error Est Err Row Operations Ops 1,500,000 1.5M Rank | Estimation Error Est Err Row Operations Ops 26,389 26K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q13 | Estimation Error Est Err Row Operations Ops 1,649,939 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,599,915 1.6M Rank | Estimation Error Est Err Row Operations Ops 50 50 Rank | Estimation Error Est Err Row Operations Ops 1,599,915 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,749,915 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 211,639 212K Rank | Estimation Error Est Err Row Operations Ops 181,769 182K Rank | Estimation Error Est Err Row Operations Ops 12,804 13K Rank | Estimation Error Est Err Row Operations Ops 29,870 30K Rank | Estimation Error Est Err Row Operations Ops 27,055 27K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q17 | Estimation Error Est Err Row Operations Ops 11,997,873 12M Rank | Estimation Error Est Err Row Operations Ops 6,005,807 6M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 206,987 207K Rank | Estimation Error Est Err Row Operations Ops 6,005,807 6M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q18 | Estimation Error Est Err Row Operations Ops 6,148,825 6.1M Rank | Estimation Error Est Err Row Operations Ops 5,998,855 6M Rank | Estimation Error Est Err Row Operations Ops 5 5 Rank | Estimation Error Est Err Row Operations Ops 150,035 150K Rank | Estimation Error Est Err Row Operations Ops 35 35 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q19 | Estimation Error Est Err Row Operations Ops 414,265 414K 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,264 214K Rank | Estimation Error Est Err Row Operations Ops 214,264 214K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q20 | Estimation Error Est Err Row Operations Ops 3,551 3.6K Rank | Estimation Error Est Err Row Operations Ops 3,550 3.6K Rank | Estimation Error Est Err Row Operations Ops 150 150 Rank | Estimation Error Est Err Row Operations Ops 150 150 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q21 | Estimation Error Est Err Row Operations Ops 14,367,450 14M Rank | Estimation Error Est Err Row Operations Ops 7,483,048 7.5M Rank | Estimation Error Est Err Row Operations Ops 427 427 Rank | Estimation Error Est Err Row Operations Ops 13,409,167 13M Rank | Estimation Error Est Err Row Operations Ops 68,697 69K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q22 | Estimation Error Est Err Row Operations Ops 1,518,248 1.5M Rank | Estimation Error Est Err Row Operations Ops 18,248 18K Rank | Estimation Error Est Err Row Operations Ops 7 7 Rank | Estimation Error Est Err Row Operations Ops 1,500,000 1.5M Rank | Estimation Error Est Err Row Operations Ops 18,248 18K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |