explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9HRU

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

Hash Right Join (cost=32,726.00..122,775.72 rows=4,961,257 width=4) (actual rows= loops=)

  • Hash Cond: (line_items.order_id = orders.id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on line_items (cost=0.00..71,433.55 rows=4,976,518 width=4) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=29,969.62..29,969.62 rows=787,539 width=16) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on orders (cost=0.00..29,969.62 rows=787,539 width=16) (actual rows= loops=)