explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 27k0

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.011 ↓ 0.0 0 1

Limit (cost=571,058.93..576,598.79 rows=101 width=1,121) (actual time=0.011..0.011 rows=0 loops=1)

2. 0.001 0.011 ↓ 0.0 0 1

Result (cost=571,058.93..601,007.09 rows=546 width=1,121) (actual time=0.011..0.011 rows=0 loops=1)

3. 0.005 0.010 ↓ 0.0 0 1

Sort (cost=571,058.93..571,060.29 rows=546 width=811) (actual time=0.010..0.010 rows=0 loops=1)

  • Sort Key: locator2_.value
  • Sort Method: quicksort Memory: 25kB
4. 0.000 0.005 ↓ 0.0 0 1

Nested Loop Left Join (cost=668.22..571,038.02 rows=546 width=811) (actual time=0.005..0.005 rows=0 loops=1)

5. 0.000 0.005 ↓ 0.0 0 1

Nested Loop Left Join (cost=667.81..570,801.10 rows=546 width=941) (actual time=0.005..0.005 rows=0 loops=1)

  • Join Filter: ((materialmg0_.c_uom_id)::text = (uom5_.c_uom_id)::text)
6. 0.001 0.005 ↓ 0.0 0 1

Nested Loop Left Join (cost=667.81..570,545.29 rows=546 width=693) (actual time=0.004..0.005 rows=0 loops=1)

7. 0.000 0.004 ↓ 0.0 0 1

Nested Loop Left Join (cost=667.25..569,537.81 rows=546 width=693) (actual time=0.004..0.004 rows=0 loops=1)

  • Join Filter: ((locator2_.m_warehouse_id)::text = (warehouse3_.m_warehouse_id)::text)
8. 0.000 0.004 ↓ 0.0 0 1

Nested Loop (cost=667.25..569,528.56 rows=546 width=408) (actual time=0.004..0.004 rows=0 loops=1)

9. 0.000 0.004 ↓ 0.0 0 1

Nested Loop (cost=666.97..569,363.88 rows=548 width=252) (actual time=0.004..0.004 rows=0 loops=1)

10. 0.004 0.004 ↓ 0.0 0 1

Index Only Scan using m_product_upc_id on m_product product1_ (cost=0.12..8.14 rows=1 width=111) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (upc = 'are'::text)
  • Heap Fetches: 0
11. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on m_storage_detail materialmg0_ (cost=666.84..569,294.95 rows=6,079 width=174) (never executed)

  • Recheck Cond: ((m_product_id)::text = (product1_.m_product_id)::text)
  • Filter: ((qtyonhand > '0'::numeric) AND ((qtyonhand - (SubPlan 5)) > '0'::numeric))
12. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on m_storage_detail_product (cost=0.00..665.32 rows=18,236 width=0) (never executed)

  • Index Cond: ((m_product_id)::text = (product1_.m_product_id)::text)
13.          

SubPlan (for Bitmap Heap Scan)

14. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=28.42..28.43 rows=1 width=32) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Index Scan using obawo_task_storagedetail_ix on obawo_task obawo_task12_ (cost=0.28..28.40 rows=6 width=32) (never executed)

  • Index Cond: (((m_storage_detail_id)::text = (materialmg0_.m_storage_detail_id)::text) AND ((status)::text = 'AV'::text))
16. 0.000 0.000 ↓ 0.0 0

Index Scan using m_locator_key on m_locator locator2_ (cost=0.28..0.30 rows=1 width=189) (never executed)

  • Index Cond: ((m_locator_id)::text = (materialmg0_.m_locator_id)::text)
  • Filter: ((m_warehouse_id)::text = 'FCA81F56E9E643E096E86F5F379459FB'::text)
17. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.07 rows=1 width=318) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_warehouse warehouse3_ (cost=0.00..1.06 rows=1 width=318) (never executed)

  • Filter: ((m_warehouse_id)::text = 'FCA81F56E9E643E096E86F5F379459FB'::text)
19. 0.000 0.000 ↓ 0.0 0

Index Only Scan using m_attributesetinstance_key on m_attributesetinstance attributes4_ (cost=0.56..1.85 rows=1 width=33) (never executed)

  • Index Cond: (m_attributesetinstance_id = (materialmg0_.m_attributesetinstance_id)::text)
  • Heap Fetches: 0
20. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.48 rows=32 width=252) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Seq Scan on c_uom uom5_ (cost=0.00..1.32 rows=32 width=252) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Index Scan using m_refinventory_key on m_refinventory materialmg6_ (cost=0.41..0.43 rows=1 width=42) (never executed)

  • Index Cond: ((materialmg0_.m_refinventory_id)::text = (m_refinventory_id)::text)
23.          

SubPlan (for Result)

24. 0.000 0.000 ↓ 0.0 0

Index Scan using m_product_aum_product_id on m_product_aum productaum7_ (cost=0.14..8.16 rows=1 width=82) (never executed)

  • Index Cond: ((m_product_id)::text = (product1_.m_product_id)::text)
  • Filter: ((logistics)::text = 'P'::text)
25. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=8.17..9.59 rows=1 width=138) (never executed)

  • Hash Cond: ((uom9_.c_uom_id)::text = (productaum8_.c_uom_id)::text)
26. 0.000 0.000 ↓ 0.0 0

Seq Scan on c_uom uom9_ (cost=0.00..1.32 rows=32 width=220) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Hash (cost=8.16..8.16 rows=1 width=82) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Index Scan using m_product_aum_unq on m_product_aum productaum8_ (cost=0.14..8.16 rows=1 width=82) (never executed)

  • Index Cond: ((m_product_id)::text = (product1_.m_product_id)::text)
  • Filter: ((logistics)::text = 'P'::text)
29. 0.000 0.000 ↓ 0.0 0

Index Scan using m_product_aum_product_id on m_product_aum productaum10_ (cost=0.14..8.16 rows=1 width=32) (never executed)

  • Index Cond: ((m_product_id)::text = (product1_.m_product_id)::text)
  • Filter: ((logistics)::text = 'P'::text)
30. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=28.42..28.43 rows=1 width=32) (never executed)

31. 0.000 0.000 ↓ 0.0 0

Index Scan using obawo_task_storagedetail_ix on obawo_task obawo_task11_ (cost=0.28..28.40 rows=6 width=32) (never executed)

  • Index Cond: (((m_storage_detail_id)::text = (materialmg0_.m_storage_detail_id)::text) AND ((status)::text = 'AV'::text))
Planning time : 4.037 ms
Execution time : 0.173 ms