Planner — TPC-H — TPCH-Q06

Engine Compare

Accuracy chart, rows processed ?
	Scan Scan	Join Probe Join	Sort Sort	Hash Build Hash	Aggregate Agg	Distribute Dist
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

Query Plan per Engine ?
	Query Plan
ClickHouse	`Estimate Actual Operator - 1 PROJECT SUM(l_extendedprice * l_discount) - 1 GROUP BY HASH AGGREGATE SUM(l_extendedprice * l_discount) - 121014 PROJECT l_extendedprice * l_discount - 121014 TABLE SCAN lineitem WHERE (l_shipdate >= '1994-01-01') AND (l_shipdate < '1995-01-01') AND (l_discount >= 0.04) AND (l_discount <= 0.06) AND (l_quantity < 24)`
DuckDB	`Estimate Actual Operator - 1 GROUP BY SIMPLE AGGREGATE sum_no_overflow #0 1199764 121011 PROJECT l_extendedprice * l_discount 1199764 121011 TABLE SCAN lineitem WHERE l_shipdate >= '1994-01-01' AND l_shipdate < '1995-01-01' AND l_discount >= 0.040 AND l_discount <= 0.060 AND l_quantity < 24.000`
SQL Server	`Estimate Actual Operator 1 1 PROJECT CASE WHEN Expr1012 = 0 THEN NULL ELSE Expr1013 END AS Expr1003 1 1 GROUP BY HASH AGGREGATE COUNT(Expr1007) AS Expr1012, SUM(Expr1007) AS Expr1013 385065 121014 PROJECT l_extendedprice * l_discount AS Expr1007 385065 121014 TABLE SCAN lineitem WHERE l_shipdate >= CONVERT_IMPLICIT(date,@1,0) AND l_shipdate < CONVERT_IMPLICIT(date,@2,0) AND l_discount >= @3 AND l_discount <= @4 AND l_quantity < CONVERT_IMPLICIT(decimal(15,2),@5,0)`
PostgreSQL	`Estimate Actual Operator 1 1 GROUP BY SIMPLE AGGREGATE SUM(l_extendedprice * l_discount) 5 5 GROUP BY SIMPLE AGGREGATE PARTIALSUM(l_extendedprice * l_discount) 154135 120990 TABLE SCAN lineitem WHERE (l_shipdate >= '1994-01-01') AND (l_shipdate < '1995-01-01') AND (l_discount >= 0.04) AND (l_discount <= 0.06) AND (l_quantity < '24')`