explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1snC

Settings
# exclusive inclusive rows x rows loops node
1. 3,228.656 6,944.362 ↑ 1.0 7,381,883 1

Merge Join (cost=69.01..665,203.08 rows=7,400,599 width=2,065) (actual time=0.042..6,944.362 rows=7,381,883 loops=1)

  • Merge Cond: (oi.id = oii.order_id)
2. 749.709 749.709 ↓ 1.0 1,353,699 1

Index Scan using order_pkey on "order" oi (cost=0.43..216,142.43 rows=1,343,414 width=1,257) (actual time=0.018..749.709 rows=1,353,699 loops=1)

3. 2,965.997 2,965.997 ↑ 1.0 7,381,883 1

Index Scan using order_item_order_id_idx on order_item oii (cost=0.43..354,259.12 rows=7,400,599 width=808) (actual time=0.020..2,965.997 rows=7,381,883 loops=1)

Planning time : 0.270 ms
Execution time : 7,232.549 ms