Planner — TPC-H
Summary
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 |
Breakdown
Scan Scan | Join Probe Join | Sort Sort | Hash Build Hash | Aggregate Agg | Distribute Dist | |
|---|---|---|---|---|---|---|
| TPCH-Q01 | ||||||
ClickHouse | 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 |
DuckDB | 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 |
PostgreSQL | 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 |
SQL Server | 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 | ||||||
ClickHouse | 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 |
DuckDB | Estimation Error Est Err Row Operations Ops 1,608,711 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,614,263 1.6M Rank | Estimation Error Est Err Row Operations Ops 468 468 Rank | Estimation Error Est Err Row Operations Ops 14,319 14K Rank | Estimation Error Est Err Row Operations Ops 644 644 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
PostgreSQL | Estimation Error Est Err Row Operations Ops 815,923 816K Rank | Estimation Error Est Err Row Operations Ops 826,028 826K Rank | Estimation Error Est Err Row Operations Ops 468 468 Rank | Estimation Error Est Err Row Operations Ops 177,338 177K Rank | Estimation Error Est Err Row Operations Ops 1,267 1.3K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
SQL Server | Estimation Error Est Err Row Operations Ops 810,825 811K Rank | Estimation Error Est Err Row Operations Ops 809,588 810K Rank | Estimation Error Est Err Row Operations Ops 4,308 4.3K Rank | Estimation Error Est Err Row Operations Ops 17,036 17K Rank | Estimation Error Est Err Row Operations Ops 644 644 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q03 | ||||||
ClickHouse | 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 |
DuckDB | Estimation Error Est Err Row Operations Ops 4,111,077 4.1M Rank | Estimation Error Est Err Row Operations Ops 4,080,841 4.1M Rank | Estimation Error Est Err Row Operations Ops - NaN Rank | Estimation Error Est Err Row Operations Ops 276,724 277K Rank | Estimation Error Est Err Row Operations Ops 28,114 28K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
PostgreSQL | 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 |
SQL Server | Estimation Error Est Err Row Operations Ops 744,435 744K Rank | Estimation Error Est Err Row Operations Ops 696,765 697K Rank | Estimation Error Est Err Row Operations Ops 10 10 Rank | Estimation Error Est Err Row Operations Ops 276,724 277K Rank | Estimation Error Est Err Row Operations Ops 28,114 28K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q04 | ||||||
ClickHouse | 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 |
DuckDB | Estimation Error Est Err Row Operations Ops 6,050,773 6.1M Rank | Estimation Error Est Err Row Operations Ops 3,974,931 4M Rank | Estimation Error Est Err Row Operations Ops 5 5 Rank | Estimation Error Est Err Row Operations Ops 231,607 232K Rank | Estimation Error Est Err Row Operations Ops 47,831 48K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
PostgreSQL | 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 |
SQL Server | Estimation Error Est Err Row Operations Ops 260,636 261K Rank | Estimation Error Est Err Row Operations Ops 208,432 208K Rank | Estimation Error Est Err Row Operations Ops 5 5 Rank | Estimation Error Est Err Row Operations Ops 52,204 52K Rank | Estimation Error Est Err Row Operations Ops 47,831 48K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q05 | ||||||
ClickHouse | 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 |
DuckDB | Estimation Error Est Err Row Operations Ops 6,330,085 6.3M Rank | Estimation Error Est Err Row Operations Ops 6,491,163 6.5M Rank | Estimation Error Est Err Row Operations Ops 5 5 Rank | Estimation Error Est Err Row Operations Ops 254,028 254K Rank | Estimation Error Est Err Row Operations Ops 6,988 7K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
PostgreSQL | 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,198 1.1M Rank | Estimation Error Est Err Row Operations Ops 7,015 7K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
SQL Server | Estimation Error Est Err Row Operations Ops 545,134 545K Rank | Estimation Error Est Err Row Operations Ops 434,997 435K Rank | Estimation Error Est Err Row Operations Ops 5 5 Rank | Estimation Error Est Err Row Operations Ops 373,992 374K Rank | Estimation Error Est Err Row Operations Ops 6,993 7K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q06 | ||||||
ClickHouse | 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 |
DuckDB | Estimation Error Est Err Row Operations Ops 121,011 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,011 121K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
PostgreSQL | 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 |
SQL Server | 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 | ||||||
ClickHouse | 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 |
DuckDB | Estimation Error Est Err Row Operations Ops 3,224,816 3.2M Rank | Estimation Error Est Err Row Operations Ops 3,358,906 3.4M Rank | Estimation Error Est Err Row Operations Ops 4 4 Rank | Estimation Error Est Err Row Operations Ops 292,909 293K Rank | Estimation Error Est Err Row Operations Ops 5,457 5.5K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
PostgreSQL | 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 |
SQL Server | Estimation Error Est Err Row Operations Ops 1,670,963 1.7M Rank | Estimation Error Est Err Row Operations Ops 43,844 44K Rank | Estimation Error Est Err Row Operations Ops 4 4 Rank | Estimation Error Est Err Row Operations Ops 1,671,922 1.7M Rank | Estimation Error Est Err Row Operations Ops 10,963 11K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q08 | ||||||
ClickHouse | 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 |
DuckDB | Estimation Error Est Err Row Operations Ops 6,539,428 6.5M Rank | Estimation Error Est Err Row Operations Ops 6,548,845 6.5M Rank | Estimation Error Est Err Row Operations Ops 2 2 Rank | Estimation Error Est Err Row Operations Ops 100,578 101K Rank | Estimation Error Est Err Row Operations Ops 2,323 2.3K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
PostgreSQL | 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 |
SQL Server | Estimation Error Est Err Row Operations Ops 592,128 592K Rank | Estimation Error Est Err Row Operations Ops 21,617 22K Rank | Estimation Error Est Err Row Operations Ops 2 2 Rank | Estimation Error Est Err Row Operations Ops 245,660 246K Rank | Estimation Error Est Err Row Operations Ops 2,325 2.3K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q09 | ||||||
ClickHouse | 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 |
DuckDB | Estimation Error Est Err Row Operations Ops 8,318,877 8.3M Rank | Estimation Error Est Err Row Operations Ops 7,463,459 7.5M Rank | Estimation Error Est Err Row Operations Ops 175 175 Rank | Estimation Error Est Err Row Operations Ops 3,437,615 3.4M Rank | Estimation Error Est Err Row Operations Ops 327,773 328K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
PostgreSQL | Estimation Error Est Err Row Operations Ops 1,772,860 1.8M Rank | Estimation Error Est Err Row Operations Ops 2,111,176 2.1M Rank | Estimation Error Est Err Row Operations Ops 327,772 328K Rank | Estimation Error Est Err Row Operations Ops 1,354,928 1.4M Rank | Estimation Error Est Err Row Operations Ops 328,472 328K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
SQL Server | Estimation Error Est Err Row Operations Ops 2,648,766 2.6M Rank | Estimation Error Est Err Row Operations Ops 1,783,552 1.8M Rank | Estimation Error Est Err Row Operations Ops 175 175 Rank | Estimation Error Est Err Row Operations Ops 1,027,279 1M Rank | Estimation Error Est Err Row Operations Ops 327,948 328K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q10 | ||||||
ClickHouse | 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 |
DuckDB | Estimation Error Est Err Row Operations Ops 1,596,791 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,692,690 1.7M Rank | Estimation Error Est Err Row Operations Ops 30,170 30K Rank | Estimation Error Est Err Row Operations Ops 312,391 312K Rank | Estimation Error Est Err Row Operations Ops 108,325 108K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
PostgreSQL | 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 |
SQL Server | Estimation Error Est Err Row Operations Ops 420,423 420K Rank | Estimation Error Est Err Row Operations Ops 288,495 288K Rank | Estimation Error Est Err Row Operations Ops 30,170 30K Rank | Estimation Error Est Err Row Operations Ops 168,665 169K Rank | Estimation Error Est Err Row Operations Ops 108,325 108K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q11 | ||||||
ClickHouse | 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 |
DuckDB | Estimation Error Est Err Row Operations Ops 1,591,788 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,619,881 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,196 1.2K Rank | Estimation Error Est Err Row Operations Ops 61,294 61K Rank | Estimation Error Est Err Row Operations Ops 59,357 59K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
PostgreSQL | Estimation Error Est Err Row Operations Ops 810,001 810K Rank | Estimation Error Est Err Row Operations Ops 810,000 810K Rank | Estimation Error Est Err Row Operations Ops 30,876 31K Rank | Estimation Error Est Err Row Operations Ops 31,164 31K Rank | Estimation Error Est Err Row Operations Ops 29,680 30K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
SQL Server | Estimation Error Est Err Row Operations Ops 1,620,002 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,621,196 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,196 1.2K Rank | Estimation Error Est Err Row Operations Ops 88,193 88K Rank | Estimation Error Est Err Row Operations Ops 59,356 59K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q12 | ||||||
ClickHouse | 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 |
DuckDB | Estimation Error Est Err Row Operations Ops 2,334,081 2.3M Rank | Estimation Error Est Err Row Operations Ops 1,499,971 1.5M Rank | Estimation Error Est Err Row Operations Ops 2 2 Rank | Estimation Error Est Err Row Operations Ops 29,129 29K Rank | Estimation Error Est Err Row Operations Ops 29,129 29K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
PostgreSQL | 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 |
SQL Server | Estimation Error Est Err Row Operations Ops 2,356,585 2.4M 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 856,585 857K Rank | Estimation Error Est Err Row Operations Ops 29,129 29K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q13 | ||||||
ClickHouse | 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 |
DuckDB | Estimation Error Est Err Row Operations Ops 1,649,945 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,599,945 1.6M Rank | Estimation Error Est Err Row Operations Ops 48 48 Rank | Estimation Error Est Err Row Operations Ops 1,599,945 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,749,945 1.7M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
PostgreSQL | 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,824 2M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
SQL Server | Estimation Error Est Err Row Operations Ops 1,649,945 1.6M Rank | Estimation Error Est Err Row Operations Ops 150,000 150K Rank | Estimation Error Est Err Row Operations Ops 48 48 Rank | Estimation Error Est Err Row Operations Ops 150,000 150K Rank | Estimation Error Est Err Row Operations Ops 1,649,945 1.6M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q14 | ||||||
ClickHouse | 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 |
DuckDB | 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 |
PostgreSQL | 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 |
SQL Server | Estimation Error Est Err Row Operations Ops 268,122 268K Rank | Estimation Error Est Err Row Operations Ops 200,000 200K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 68,122 68K Rank | Estimation Error Est Err Row Operations Ops 68,122 68K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q15 | ||||||
ClickHouse | 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 |
DuckDB | 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 |
PostgreSQL | 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 |
SQL Server | Estimation Error Est Err Row Operations Ops 268,122 268K Rank | Estimation Error Est Err Row Operations Ops 200,000 200K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 68,122 68K Rank | Estimation Error Est Err Row Operations Ops 68,122 68K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q16 | ||||||
ClickHouse | 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 |
DuckDB | Estimation Error Est Err Row Operations Ops 988,701 989K Rank | Estimation Error Est Err Row Operations Ops 1,105,162 1.1M Rank | Estimation Error Est Err Row Operations Ops 18,149 18K Rank | Estimation Error Est Err Row Operations Ops 424,818 425K Rank | Estimation Error Est Err Row Operations Ops 81,838 82K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
PostgreSQL | Estimation Error Est Err Row Operations Ops 580,359 580K Rank | Estimation Error Est Err Row Operations Ops 547,296 547K Rank | Estimation Error Est Err Row Operations Ops 99,989 100K Rank | Estimation Error Est Err Row Operations Ops 81,840 82K Rank | Estimation Error Est Err Row Operations Ops 81,840 82K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
SQL Server | Estimation Error Est Err Row Operations Ops 952,684 953K Rank | Estimation Error Est Err Row Operations Ops 1,039,240 1M Rank | Estimation Error Est Err Row Operations Ops 18,149 18K Rank | Estimation Error Est Err Row Operations Ops 321,078 321K Rank | Estimation Error Est Err Row Operations Ops 163,655 164K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q17 | ||||||
ClickHouse | 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 |
DuckDB | Estimation Error Est Err Row Operations Ops 11,841,430 12M Rank | Estimation Error Est Err Row Operations Ops 11,853,388 12M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 18,442 18K Rank | Estimation Error Est Err Row Operations Ops 6,544 6.5K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
PostgreSQL | 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 |
SQL Server | Estimation Error Est Err Row Operations Ops 12,363 12K Rank | Estimation Error Est Err Row Operations Ops 667 667 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 6,544 6.5K Rank | Estimation Error Est Err Row Operations Ops 6,080 6.1K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q18 | ||||||
ClickHouse | 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 |
DuckDB | Estimation Error Est Err Row Operations Ops 6,710,479 6.7M Rank | Estimation Error Est Err Row Operations Ops 561,666 562K Rank | Estimation Error Est Err Row Operations Ops 5 5 Rank | Estimation Error Est Err Row Operations Ops 150,038 150K Rank | Estimation Error Est Err Row Operations Ops 5,998,855 6M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
PostgreSQL | 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,501,015 7.5M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
SQL Server | Estimation Error Est Err Row Operations Ops 5,998,865 6M Rank | Estimation Error Est Err Row Operations Ops 15 15 Rank | Estimation Error Est Err Row Operations Ops 5 5 Rank | Estimation Error Est Err Row Operations Ops 15 15 Rank | Estimation Error Est Err Row Operations Ops 5,998,855 6M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q19 | ||||||
ClickHouse | 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 |
DuckDB | Estimation Error Est Err Row Operations Ops 1,699,869 1.7M 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,265 214K Rank | Estimation Error Est Err Row Operations Ops 97 97 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
PostgreSQL | 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 |
SQL Server | Estimation Error Est Err Row Operations Ops 209,386 209K Rank | Estimation Error Est Err Row Operations Ops 336 336 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 97 97 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q20 | ||||||
ClickHouse | 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 |
DuckDB | Estimation Error Est Err Row Operations Ops 1,656,797 1.7M Rank | Estimation Error Est Err Row Operations Ops 1,677,128 1.7M Rank | Estimation Error Est Err Row Operations Ops 175 175 Rank | Estimation Error Est Err Row Operations Ops 35,128 35K Rank | Estimation Error Est Err Row Operations Ops 9,062 9.1K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
PostgreSQL | Estimation Error Est Err Row Operations Ops 1,859,523 1.9M Rank | Estimation Error Est Err Row Operations Ops 534,608 535K Rank | Estimation Error Est Err Row Operations Ops 175 175 Rank | Estimation Error Est Err Row Operations Ops 534,936 535K Rank | Estimation Error Est Err Row Operations Ops 800,000 800K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
SQL Server | Estimation Error Est Err Row Operations Ops 812,468 812K Rank | Estimation Error Est Err Row Operations Ops 10,699 11K Rank | Estimation Error Est Err Row Operations Ops 175 175 Rank | Estimation Error Est Err Row Operations Ops 802,889 803K Rank | Estimation Error Est Err Row Operations Ops 360 360 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q21 | ||||||
ClickHouse | 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 |
DuckDB | Estimation Error Est Err Row Operations Ops 18,754,973 19M Rank | Estimation Error Est Err Row Operations Ops 14,924,939 15M Rank | Estimation Error Est Err Row Operations Ops 396 396 Rank | Estimation Error Est Err Row Operations Ops 1,031,358 1M Rank | Estimation Error Est Err Row Operations Ops 4,060 4.1K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
PostgreSQL | 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 |
SQL Server | Estimation Error Est Err Row Operations Ops 1,745,642 1.7M Rank | Estimation Error Est Err Row Operations Ops 1,745,641 1.7M Rank | Estimation Error Est Err Row Operations Ops 396 396 Rank | Estimation Error Est Err Row Operations Ops 451,585 452K 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 | ||||||
ClickHouse | 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 |
DuckDB | Estimation Error Est Err Row Operations Ops 1,576,781 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,745,710 1.7M Rank | Estimation Error Est Err Row Operations Ops 7 7 Rank | Estimation Error Est Err Row Operations Ops 236,163 236K Rank | Estimation Error Est Err Row Operations Ops 48,823 49K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
PostgreSQL | 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 |
SQL Server | Estimation Error Est Err Row Operations Ops 1,576,976 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,518,407 1.5M Rank | Estimation Error Est Err Row Operations Ops 7 7 Rank | Estimation Error Est Err Row Operations Ops 58,743 59K Rank | Estimation Error Est Err Row Operations Ops 48,817 49K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |