explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t14j

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 3.761 ↑ 1.0 1 1

Aggregate (cost=120.67..120.68 rows=1 width=8) (actual time=3.761..3.761 rows=1 loops=1)

2.          

Initplan (for Aggregate)

3. 0.001 3.758 ↓ 0.0 0 1

Nested Loop (cost=0.55..14,413.23 rows=120 width=0) (actual time=3.758..3.758 rows=0 loops=1)

4. 3.757 3.757 ↓ 0.0 0 1

Index Scan using m_storage_detail_un on m_storage_detail sd (cost=0.55..14,394.75 rows=1,201 width=33) (actual time=3.757..3.757 rows=0 loops=1)

  • Index Cond: (((m_product_id)::text = 'E806E0A84D974CF49ACAC9FF701BEA0F'::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)))
  • Rows Removed by Filter: 4,263
5. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..3.47 rows=1 width=82) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..3.46 rows=1 width=82) (never executed)

  • Join Filter: ((l.m_inventorystatus_id)::text = (invs.m_inventorystatus_id)::text)
7. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_locator l (cost=0.00..2.33 rows=1 width=164) (never executed)

  • Filter: ((m_locator_id)::text = 'B41DC9FF486D470ABD2E7A8B5C96B4C7'::text)
8. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_inventorystatus invs (cost=0.00..1.12 rows=1 width=82) (never executed)

  • Filter: (overissue = 'N'::bpchar)
9. 3.759 3.759 ↓ 0.0 0 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=3.759..3.759 rows=0 loops=1)

  • One-Time Filter: $0
Planning time : 0.399 ms
Execution time : 3.801 ms