explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q41D

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 220.876 ↑ 2,477.0 1 1

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

2. 0.044 0.044 ↑ 1.0 1 1

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

  • Index Cond: (order_id = 5)
3. 220.829 220.829 ↑ 2,477.0 1 1

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

  • Filter: (order_id = 5)
  • Rows Removed by Filter: 999999