explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H8z

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

HashAggregate (cost=5.22..5.23 rows=1 width=4) (actual time=0.040..0.040 rows=1 loops=1)

  • Group Key: ews_mrp_release_orders.release_bom_id
2. 0.005 0.037 ↓ 4.0 4 1

Nested Loop (cost=1.00..5.22 rows=1 width=4) (actual time=0.028..0.037 rows=4 loops=1)

  • Join Filter: (mrp_bom_line.bom_id = ews_mrp_release_orders.bom_id)
3. 0.002 0.019 ↑ 1.0 1 1

Nested Loop (cost=0.71..4.76 rows=1 width=8) (actual time=0.019..0.019 rows=1 loops=1)

4. 0.010 0.010 ↑ 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.010 rows=1 loops=1)

  • Index Cond: (id = 559,883)
5. 0.007 0.007 ↑ 1.0 1 1

Index Only Scan using mrp_bom_pkey on mrp_bom (cost=0.29..2.31 rows=1 width=4) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (id = mrp_bom_line.bom_id)
  • Heap Fetches: 1
6. 0.013 0.013 ↓ 1.3 4 1

Index Scan using index_ews_mrp_release_orders_bom_id on ews_mrp_release_orders (cost=0.29..0.42 rows=3 width=8) (actual time=0.006..0.013 rows=4 loops=1)

  • Index Cond: (bom_id = mrp_bom.id)
Planning time : 0.610 ms
Execution time : 0.097 ms