explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wpR7

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 113,508.072 ↓ 0.0 0 1

Nested Loop (cost=697,770.52..697,795.74 rows=1 width=33) (actual time=113,508.072..113,508.072 rows=0 loops=1)

2. 0.001 113,508.071 ↓ 0.0 0 1

HashAggregate (cost=697,769.96..697,769.97 rows=1 width=33) (actual time=113,508.071..113,508.071 rows=0 loops=1)

3. 0.001 113,508.070 ↓ 0.0 0 1

Nested Loop (cost=0.00..697,769.96 rows=1 width=33) (actual time=113,508.070..113,508.070 rows=0 loops=1)

  • Join Filter: ((o.c_doctypetarget_id)::text = (dt.c_doctype_id)::text)
4. 113,508.069 113,508.069 ↓ 0.0 0 1

Seq Scan on c_order o (cost=0.00..697,722.22 rows=1 width=66) (actual time=113,508.069..113,508.069 rows=0 loops=1)

  • Filter: ((processed = 'Y'::bpchar) AND (issotrx = 'N'::bpchar))
  • Rows Removed by Filter: 6067138
5. 0.000 0.000 ↓ 0.0 0

Seq Scan on c_doctype dt (cost=0.00..44.35 rows=271 width=32) (never executed)

  • Filter: (isreturn = 'Y'::bpchar)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using em_obpos_deliveredqty on c_orderline ol (cost=0.56..8.58 rows=1 width=66) (never executed)

  • Index Cond: (((c_order_id)::text = (o.c_order_id)::text) AND (qtydelivered = 0::numeric))
7.          

SubPlan (forNested Loop)

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)