explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D8IV

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 43,479.103 ↓ 0.0 0 1

Update on c_order o (cost=0.56..51,365,340.69 rows=1 width=4,282) (actual time=43,479.103..43,479.103 rows=0 loops=1)

  • Total runtime: 43479.226 ms
2. 0.001 43,479.101 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.56..51,365,340.69 rows=1 width=4,282) (actual time=43,479.101..43,479.101 rows=0 loops=1)

3. 43,479.100 43,479.100 ↓ 0.0 0 1

Seq Scan on c_order o (cost=0.00..51,365,084.47 rows=1 width=4,276) (actual time=43,479.100..43,479.100 rows=0 loops=1)

  • Filter: ((isdelivered = 'N'::bpchar) AND (processed = 'Y'::bpchar) AND ((issotrx = 'Y'::bpchar) OR ((issotrx = 'N'::bpchar) AND ((SubPlan 1) = 'Y'::bpchar))))
  • Rows Removed by Filter: 6067140
4.          

SubPlan (forSeq Scan)

5. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((o.c_doctypetarget_id)::text = (c_doctype_id)::text)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using em_obpos_orderedqty on c_orderline ol (cost=0.56..128.39 rows=1 width=39) (never executed)

  • Index Cond: ((o.c_order_id)::text = (c_order_id)::text)
  • Filter: ((c_order_discount_id IS NULL) AND (obequals(qtyordered, qtydelivered) = 'N'::bpchar))