explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LEZU

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 126.799 ↓ 0.0 0 1

Update on c_orderline ol (cost=0.97..211,435.10 rows=54 width=2,613) (actual time=126.799..126.799 rows=0 loops=1)

  • Total runtime: 126.921 ms
2. 0.000 126.797 ↓ 0.0 0 1

Nested Loop Semi Join (cost=0.97..211,435.10 rows=54 width=2,613) (actual time=126.797..126.797 rows=0 loops=1)

3. 126.797 126.797 ↓ 0.0 0 1

Index Scan using c_orderline_ret_pending on c_orderline ol (cost=0.42..210,043.52 rows=54 width=2,607) (actual time=126.797..126.797 rows=0 loops=1)

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

Index Scan using c_order_key on c_order (cost=0.56..8.58 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)