explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rl3v

Settings

Optimization(s) for this plan:

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

Finalize GroupAggregate (cost=76,851.93..76,899.30 rows=5 width=24) (actual rows= loops=)

  • Group Key: orders.o_orderpriority
2. 0.000 0.000 ↓ 0.0

Gather Merge (cost=76,851.93..76,899.20 rows=10 width=24) (actual rows= loops=)

  • Workers Planned: 2
3. 0.000 0.000 ↓ 0.0

Partial GroupAggregate (cost=75,851.90..75,898.03 rows=5 width=24) (actual rows= loops=)

  • Group Key: orders.o_orderpriority
4. 0.000 0.000 ↓ 0.0

Sort (cost=75,851.90..75,867.26 rows=6,143 width=16) (actual rows= loops=)

  • Sort Key: orders.o_orderpriority
5. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=1,346.33..75,465.36 rows=6,143 width=16) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on orders (cost=1,345.90..28,560.21 rows=24,288 width=20) (actual rows= loops=)

  • Recheck Cond: ((o_orderdate >= '1995-02-01'::date) AND (o_orderdate < '1995-05-01'::date))
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on orders_o_orderdate_o_orderkey_idx (cost=0.00..1,331.33 rows=58,290 width=0) (actual rows= loops=)

  • Index Cond: ((o_orderdate >= '1995-02-01'::date) AND (o_orderdate < '1995-05-01'::date))
8. 0.000 0.000 ↓ 0.0

Index Only Scan using lineitem_l_orderkey_idx_part1 on lineitem (cost=0.43..6.93 rows=5 width=4) (actual rows= loops=)

  • Index Cond: (l_orderkey = orders.o_orderkey)