explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1ZDd

Settings

Optimization(s) for this plan:

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

Finalize GroupAggregate (cost=36,421,558.55..36,421,560.62 rows=6 width=236) (actual rows= loops=)

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

Gather Merge (cost=36,421,558.55..36,421,559.95 rows=12 width=236) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Sort (cost=36,420,558.52..36,420,558.54 rows=6 width=236) (actual rows= loops=)

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

Partial HashAggregate (cost=36,420,558.28..36,420,558.45 rows=6 width=236) (actual rows= loops=)

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

Parallel Seq Scan on lineitem (cost=0.00..21,559,880.00 rows=371,516,957 width=25) (actual rows= loops=)

  • Filter: (l_shipdate <= '1998-09-21 00:00:00'::timestamp without time zone)