explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rmQl

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 452.458 ↑ 2,477.0 1 1

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

2. 0.031 0.031 ↑ 1.0 1 1

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

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

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