explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HOcx

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.021 ↓ 4.0 4 1

Nested Loop (cost=0.71..6.75 rows=1 width=4) (actual time=0.016..0.021 rows=4 loops=1)

2. 0.011 0.011 ↑ 1.0 1 1

Index Scan using mrp_bom_line_pkey on mrp_bom_line (cost=0.42..2.44 rows=1 width=4) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: (id = 559,883)
3. 0.009 0.009 ↓ 1.3 4 1

Index Scan using index_ews_mrp_release_orders_bom_id on ews_mrp_release_orders (cost=0.29..4.28 rows=3 width=8) (actual time=0.005..0.009 rows=4 loops=1)

  • Index Cond: (bom_id = mrp_bom_line.bom_id)
Planning time : 0.336 ms
Execution time : 0.053 ms