explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l6dy

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 127.080 ↑ 2,477.0 1 1

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

2. 0.035 0.035 ↑ 1.0 1 1

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

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

  • Filter: (order_id = 5)
  • Rows Removed by Filter: 999999
Planning time : 0.082 ms
Execution time : 127.115 ms