explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NKvE

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.047 ↑ 1.0 1 1

Aggregate (cost=8.91..8.92 rows=1 width=4) (actual time=0.046..0.047 rows=1 loops=1)

2. 0.002 0.041 ↓ 2.0 2 1

Nested Loop (cost=0.85..8.91 rows=1 width=4) (actual time=0.030..0.041 rows=2 loops=1)

3. 0.003 0.029 ↓ 2.0 2 1

Nested Loop (cost=0.57..6.59 rows=1 width=8) (actual time=0.022..0.029 rows=2 loops=1)

4. 0.016 0.016 ↓ 2.0 2 1

Index Scan using ews_mrp_release_orders_release_bom_id_index on ews_mrp_release_orders (cost=0.29..4.28 rows=1 width=14) (actual time=0.012..0.016 rows=2 loops=1)

  • Index Cond: (release_bom_id = 16,745)
  • Filter: (active AND (release_state_id = ANY ('{3,4}'::integer[])))
  • Rows Removed by Filter: 2
5. 0.010 0.010 ↑ 1.0 1 2

Index Scan using mrp_bom_pkey on mrp_bom (cost=0.29..2.31 rows=1 width=6) (actual time=0.005..0.005 rows=1 loops=2)

  • Index Cond: (id = ews_mrp_release_orders.bom_id)
  • Filter: ((ews_mrp_release_orders.release_bom_type)::text = (bom_type)::text)
6. 0.010 0.010 ↑ 1.0 1 2

Index Scan using ews_release_detail_type_pkey on ews_release_detail_type (cost=0.28..2.30 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=2)

  • Index Cond: (id = ews_mrp_release_orders.detail_type)
  • Filter: ((name)::text ~~* '%(atc)%'::text)
Planning time : 0.679 ms
Execution time : 0.087 ms