explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yiGn

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 10.903 ↓ 0.0 0 1

Nested Loop Anti Join (cost=0.28..9,296.79 rows=1 width=4,078) (actual time=10.903..10.903 rows=0 loops=1)

2. 0.873 10.809 ↑ 56.0 5 1

Seq Scan on c_order o (cost=0.00..8,617.64 rows=280 width=4,078) (actual time=3.246..10.809 rows=5 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: 1099
3.          

SubPlan (forSeq Scan)

4. 9.936 9.936 ↑ 1.0 1 552

Seq Scan on c_doctype dt (cost=0.00..7.70 rows=1 width=2) (actual time=0.005..0.018 rows=1 loops=552)

  • Filter: ((o.c_doctypetarget_id)::text = (c_doctype_id)::text)
  • Rows Removed by Filter: 131
5. 0.080 0.080 ↑ 6.0 1 5

Index Scan using c_orderline_order2 on c_orderline ol (cost=0.28..7.59 rows=6 width=33) (actual time=0.016..0.016 rows=1 loops=5)

  • Index Cond: ((o.c_order_id)::text = (c_order_id)::text)
  • Filter: ((c_order_discount_id IS NULL) AND (qtyordered <> qtydelivered))
  • Rows Removed by Filter: 3