explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O93d

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

Nested Loop (cost=0.42..15,570.94 rows=2,477 width=134) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Scan using orders_pkey on orders a (cost=0.42..8.44 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (order_id = 5)
3. 0.000 0.000 ↓ 0.0

Seq Scan on order_lines b (cost=0.00..15,537.73 rows=2,477 width=126) (actual rows= loops=)

  • Filter: (order_id = 5)