explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gdao

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

Aggregate (cost=13.15..13.16 rows=1 width=8) (actual time=32.248..32.248 rows=1 loops=1)

2.          

Initplan (for Aggregate)

3. 0.000 32.242 ↓ 0.0 0 1

Nested Loop (cost=0.28..13.14 rows=1 width=0) (actual time=32.242..32.242 rows=0 loops=1)

  • Join Filter: ((l.m_inventorystatus_id)::text = (invs.m_inventorystatus_id)::text)
4. 0.001 32.242 ↓ 0.0 0 1

Nested Loop (cost=0.28..11.91 rows=1 width=12) (actual time=32.242..32.242 rows=0 loops=1)

5. 32.241 32.241 ↓ 0.0 0 1

Index Scan using m_storage_detail_un on m_storage_detail sd (cost=0.28..8.30 rows=1 width=33) (actual time=32.241..32.241 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)))
6. 0.000 0.000 ↓ 0.0 0

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

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

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

  • Filter: (overissue = 'N'::bpchar)
8. 32.245 32.245 ↓ 0.0 0 1

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

  • One-Time Filter: $0
Planning time : 797.071 ms
Execution time : 32.385 ms