explain.depesz.com

A tool for finding a real cause for slow queries.

Result: paOF : test

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Merge Join (cost=58,862.12..67,288.43 rows=301,231 width=142) (actual time=.. rows= loops=)

  • Merge Cond: (item.i_id = order_line.ol_i_id)
2. 0.000 0.000 ↓ 0.0

Index Scan using pk_item on item (cost=0.00..3,659.26 rows=100,000 width=72) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0

Materialize (cost=58,861.10..62,626.49 rows=301,231 width=70) (actual time=.. rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=58,861.10..59,614.18 rows=301,231 width=70) (actual time=.. rows= loops=)

  • Sort Key: order_line.ol_i_id
5. 0.000 0.000 ↓ 0.0

Seq Scan on order_line (cost=0.00..6,731.31 rows=301,231 width=70) (actual time=.. rows= loops=)