explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YWkW

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.021 ↓ 0.0 0 1

Nested Loop (cost=527.03..20,176.40 rows=220 width=4) (actual time=0.021..0.021 rows=0 loops=1)

2. 0.002 0.020 ↓ 0.0 0 1

Nested Loop (cost=0.00..3.46 rows=1 width=82) (actual time=0.020..0.020 rows=0 loops=1)

  • Join Filter: ((l.m_inventorystatus_id)::text = (invs.m_inventorystatus_id)::text)
  • Rows Removed by Join Filter: 8
3. 0.012 0.012 ↑ 1.0 1 1

Seq Scan on m_locator l (cost=0.00..2.33 rows=1 width=164) (actual time=0.009..0.012 rows=1 loops=1)

  • Filter: ((m_locator_id)::text = 'B41DC9FF486D470ABD2E7A8B5C96B4C7'::text)
  • Rows Removed by Filter: 25
4. 0.006 0.006 ↓ 8.0 8 1

Seq Scan on m_inventorystatus invs (cost=0.00..1.12 rows=1 width=82) (actual time=0.004..0.006 rows=8 loops=1)

  • Filter: (overissue = 'N'::bpchar)
  • Rows Removed by Filter: 2
5. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on m_storage_detail sd (cost=527.03..20,150.94 rows=2,199 width=33) (never executed)

  • Recheck Cond: (((m_product_id)::text = '3E8FFC905C674105904AAB2724E138E2'::text) AND ((m_locator_id)::text = 'B41DC9FF486D470ABD2E7A8B5C96B4C7'::text))
  • Filter: (((ad_client_id)::text = '86F69592CF6F405E8E7004128655A71A'::text) AND ((qtyonhand < '0'::numeric) OR (COALESCE(qtyorderonhand, '0'::numeric) < '0'::numeric)))
6. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on m_storage_detail_un (cost=0.00..526.48 rows=6,593 width=0) (never executed)

  • Index Cond: (((m_product_id)::text = '3E8FFC905C674105904AAB2724E138E2'::text) AND ((m_locator_id)::text = 'B41DC9FF486D470ABD2E7A8B5C96B4C7'::text))
Planning time : 0.547 ms
Execution time : 0.090 ms