explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S7LY

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Finalize GroupAggregate (cost=42,651.53..42,653.34 rows=6 width=68) (actual rows= loops=)

  • Group Key: l_returnflag, l_linestatus
2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=42,651.53..42,652.93 rows=12 width=140) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Sort (cost=41,651.51..41,651.53 rows=6 width=140) (actual rows= loops=)

  • Sort Key: l_returnflag, l_linestatus
4. 0.000 0.000 ↓ 0.0

Partial HashAggregate (cost=41,651.37..41,651.43 rows=6 width=140) (actual rows= loops=)

  • Group Key: l_returnflag, l_linestatus
5. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on lineitem l (cost=0.00..24,986.33 rows=416,626 width=36) (actual rows= loops=)

  • Filter: (l_shipdate <= '1998-12-01'::date)