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 80,842,240 81M Rank | Estimation Error Est Err Row Operations Ops 73,424,030 73M Rank | Estimation Error Est Err Row Operations Ops 137,466 137K Rank | Estimation Error Est Err Row Operations Ops 50,287,350 50M Rank | Estimation Error Est Err Row Operations Ops 16,433,196 16M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
 DuckDB | Estimation Error Est Err Row Operations Ops 92,885,189 93M Rank | Estimation Error Est Err Row Operations Ops 72,163,397 72M Rank | Estimation Error Est Err Row Operations Ops 50,811 51K Rank | Estimation Error Est Err Row Operations Ops 9,120,751 9.1M Rank | Estimation Error Est Err Row Operations Ops 14,414,952 14M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
 PostgreSQL | Estimation Error Est Err Row Operations Ops 66,831,563 67M Rank | Estimation Error Est Err Row Operations Ops 44,378,394 44M Rank | Estimation Error Est Err Row Operations Ops 14,125,652 14M Rank | Estimation Error Est Err Row Operations Ops 16,591,350 17M Rank | Estimation Error Est Err Row Operations Ops 17,125,406 17M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
 SQL Server | Estimation Error Est Err Row Operations Ops 30,928,016 31M Rank | Estimation Error Est Err Row Operations Ops 10,802,620 11M Rank | Estimation Error Est Err Row Operations Ops 54,661 55K Rank | Estimation Error Est Err Row Operations Ops 6,905,358 6.9M Rank | Estimation Error Est Err Row Operations Ops 14,393,287 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,620,854 1.6M Rank | Estimation Error Est Err Row Operations Ops 3,210,110 3.2M Rank | Estimation Error Est Err Row Operations Ops 644 644 Rank | Estimation Error Est Err Row Operations Ops 1,897,001 1.9M Rank | Estimation Error Est Err Row Operations Ops 161,166 161K 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,319,731 8.3M Rank | Estimation Error Est Err Row Operations Ops 17,429,499 17M Rank | Estimation Error Est Err Row Operations Ops 175 175 Rank | Estimation Error Est Err Row Operations Ops 11,726,288 12M Rank | Estimation Error Est Err Row Operations Ops 295,609 296K 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 810,001 810K Rank | Estimation Error Est Err Row Operations Ops 1,599,921 1.6M Rank | Estimation Error Est Err Row Operations Ops 32,493 32K Rank | Estimation Error Est Err Row Operations Ops 834,478 834K Rank | Estimation Error Est Err Row Operations Ops 34,557 35K 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 272,228 272K Rank | Estimation Error Est Err Row Operations Ops 242,358 242K Rank | Estimation Error Est Err Row Operations Ops 15,560 16K Rank | Estimation Error Est Err Row Operations Ops 36,132 36K Rank | Estimation Error Est Err Row Operations Ops 36,132 36K 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 4,339 4.3K Rank | Estimation Error Est Err Row Operations Ops 4,338 4.3K Rank | Estimation Error Est Err Row Operations Ops 180 180 Rank | Estimation Error Est Err Row Operations Ops 180 180 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 |