explain.depesz.com

PostgreSQL's explain analyze made readable

Result: akYC

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 949.986 ↓ 0.0 0 1

Update on c_orderline ol (cost=1.12..918,006.96 rows=5,413 width=2,642) (actual time=949.986..949.986 rows=0 loops=1)

  • Total runtime: 950.199 ms
2. 0.002 949.986 ↓ 0.0 0 1

Nested Loop Semi Join (cost=1.12..918,006.96 rows=5,413 width=2,642) (actual time=949.986..949.986 rows=0 loops=1)

3. 949.984 949.984 ↓ 0.0 0 1

Index Scan using em_obpos_deliveredqty on c_orderline ol (cost=0.56..779,221.95 rows=5,413 width=2,636) (actual time=949.984..949.984 rows=0 loops=1)

  • Index Cond: (qtydelivered = 0::numeric)
  • Filter: (returnline IS NOT NULL)
  • Rows Removed by Filter: 36
4. 0.000 0.000 ↓ 0.0 0

Index Scan using c_order_key on c_order (cost=0.56..8.45 rows=1 width=39) (never executed)

  • Index Cond: ((c_order_id)::text = (ol.c_order_id)::text)
  • Filter: (processed = 'Y'::bpchar)
5.          

SubPlan (forNested Loop Semi Join)

6. 0.000 0.000 ↓ 0.0 0

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

7. 0.000 0.000 ↓ 0.0 0

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

8. 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)
9. 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)