explain.depesz.com

PostgreSQL's explain analyze made readable

Result: waVH

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

Aggregate (cost=119.97..119.98 rows=1 width=8) (actual time=7.572..7.572 rows=1 loops=1)

2.          

Initplan (for Aggregate)

3. 0.001 7.566 ↓ 0.0 0 1

Nested Loop (cost=0.55..15,165.19 rows=127 width=0) (actual time=7.566..7.566 rows=0 loops=1)

4. 7.565 7.565 ↓ 0.0 0 1

Index Scan using m_storage_detail_un on m_storage_detail sd (cost=0.55..15,145.90 rows=1,266 width=33) (actual time=7.565..7.565 rows=0 loops=1)

  • Index Cond: (((m_product_id)::text = '31789A61757F47B69E39007E17E88E32'::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: 5,751
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. 7.568 7.568 ↓ 0.0 0 1

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

  • One-Time Filter: $0
Planning time : 0.539 ms
Execution time : 7.638 ms