explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UtQd

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 1,332.699 ↑ 2,477.0 1 1

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

2. 0.069 0.069 ↑ 1.0 1 1

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

  • Index Cond: (order_id = 5)
3. 1,332.623 1,332.623 ↑ 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.064..1,332.623 rows=1 loops=1)

  • Filter: (order_id = 5)
  • Rows Removed by Filter: 999999
Planning time : 0.289 ms
Execution time : 1,332.778 ms