explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rKKO

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 448.329 ↑ 1.0 1 1

Nested Loop (cost=0.42..21,854.45 rows=1 width=49) (actual time=0.035..448.329 rows=1 loops=1)

2. 0.012 0.012 ↑ 1.0 1 1

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

  • Index Cond: (order_id = 5)
3. 448.314 448.314 ↑ 1.0 1 1

Seq Scan on order_lines b (cost=0.00..21,846.00 rows=1 width=41) (actual time=0.025..448.314 rows=1 loops=1)

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