explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iOr0

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 28,991.176 ↓ 0.0 0 1

Update on c_orderline ol (cost=1.39..878,768.25 rows=1 width=2,651) (actual time=28,991.176..28,991.176 rows=0 loops=1)

  • Total runtime: 28991.412 ms
2. 0.035 28,991.174 ↓ 0.0 0 1

Nested Loop Semi Join (cost=1.39..878,768.25 rows=1 width=2,651) (actual time=28,991.174..28,991.174 rows=0 loops=1)

3. 28,983.975 28,983.975 ↑ 154.7 36 1

Index Scan using em_obpos_deliveredqty on c_orderline ol (cost=0.56..785,383.94 rows=5,568 width=2,639) (actual time=3,242.597..28,983.975 rows=36 loops=1)

  • Index Cond: (qtydelivered = 0::numeric)
4. 0.072 7.164 ↓ 0.0 0 36

Nested Loop (cost=0.83..16.76 rows=1 width=45) (actual time=0.199..0.199 rows=0 loops=36)

5. 7.092 7.092 ↓ 0.0 0 36

Index Scan using c_order_key on c_order o (cost=0.56..8.45 rows=1 width=72) (actual time=0.197..0.197 rows=0 loops=36)

  • Index Cond: ((c_order_id)::text = (ol.c_order_id)::text)
  • Filter: ((processed = 'Y'::bpchar) AND (issotrx = 'N'::bpchar))
  • Rows Removed by Filter: 1
6. 0.000 0.000 ↓ 0.0 0

Index Scan using c_doctype_key on c_doctype dt (cost=0.28..8.30 rows=1 width=38) (never executed)

  • Index Cond: ((c_doctype_id)::text = (o.c_doctypetarget_id)::text)
  • Filter: (isreturn = 'Y'::bpchar)
7.          

SubPlan (forNested Loop Semi Join)

8. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=17.17..17.18 rows=1 width=5) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=1.12..17.17 rows=1 width=5) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Index Scan using m_inoutline_orderline on m_inoutline iol (cost=0.56..8.58 rows=1 width=38) (never executed)

  • Index Cond: ((c_orderline_id)::text = (ol.c_orderline_id)::text)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using m_inout_key on m_inout io (cost=0.56..8.58 rows=1 width=33) (never executed)

  • Index Cond: ((m_inout_id)::text = (iol.m_inout_id)::text)
  • Filter: (processed = 'Y'::bpchar)