explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2heq

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 43,522.966 ↓ 0.0 0 1

Update on c_order o (cost=3,917.09..1,012,141.58 rows=30,333 width=4,276) (actual time=43,522.966..43,522.966 rows=0 loops=1)

2. 0.001 43,522.966 ↓ 0.0 0 1

Hash Anti Join (cost=3,917.09..1,012,141.58 rows=30,333 width=4,276) (actual time=43,522.966..43,522.966 rows=0 loops=1)

  • Hash Cond: ((o.c_order_id)::text = (ol.c_order_id)::text)
3. 43,522.965 43,522.965 ↓ 0.0 0 1

Seq Scan on c_order o (cost=0.00..1,007,839.07 rows=30,336 width=4,270) (actual time=43,522.965..43,522.965 rows=0 loops=1)

  • Filter: ((isdelivered_new = 'N'::bpchar) AND (processed = 'Y'::bpchar))
  • Rows Removed by Filter: 6067140
4. 0.000 0.000 ↓ 0.0 0

Hash (cost=3,908.90..3,908.90 rows=655 width=39) (never executed)

5. 0.000 0.000 ↓ 0.0 0

Index Scan using c_orderline_ret_pending on c_orderline ol (cost=0.67..3,908.90 rows=655 width=39) (never executed)

  • Index Cond: ((returnline IS NOT NULL) AND (obequals(qtyordered, qtydelivered) = 'N'::bpchar))
  • Filter: (c_order_discount_id IS NULL)