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
DuckDB	121,011 rows 121K	0 rows 0	0 rows 0	0 rows 0	121,011 rows 121K	0 rows 0
PostgreSQL	120,990 rows 121K	0 rows 0	0 rows 0	0 rows 0	120,995 rows 121K	0 rows 0
SQL Server	121,014 rows 121K	0 rows 0	0 rows 0	0 rows 0	121,014 rows 121K	0 rows 0

Actual Query Plans

Query Plan

Query Plan per Engine ?
	Query Plan
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')`
DuckDB	`Estimate Actual Operator 1199764 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 388628 121014 PROJECT l_extendedprice * l_discount AS Expr1007 388628 121014 TABLE SCAN lineitem`

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')

DuckDB

Estimate    Actual  Operator
 1199764         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
  388628    121014  PROJECT l_extendedprice * l_discount AS Expr1007
  388628    121014  TABLE SCAN lineitem