explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rjKa

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

Nested Loop Left Join (cost=0.00..401,499.02 rows=1 width=65) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.00..401,490.71 rows=1 width=64) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..401,481.74 rows=1 width=60) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..401,473.53 rows=1 width=65) (actual rows= loops=)

  • Join Filter: (((mss.case_seq_no)::text = (msc.case_seq_no)::text) AND ((mmm.model_cd)::text = (msc.model_cd)::text))
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..401,459.64 rows=1 width=110) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using mz_model_mst_p1 on mz_model_mst mmm (cost=0.00..1,493.71 rows=571 width=12) (actual rows= loops=)

  • Index Cond: ((sys_owner_cd)::text = '6548'::text)
  • Filter: ((model_type3)::text = ANY ('{0,3}'::text[]))
7. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..399,958.80 rows=1 width=98) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..399,958.79 rows=1 width=98) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..399,954.38 rows=1 width=101) (actual rows= loops=)

  • Join Filter: ((mss.case_seq_no)::text = (msi.case_seq_no)::text)
10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..337,703.89 rows=6,931 width=48) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Scan using me_shipment_i2 on me_shipment ms (cost=0.00..44,528.72 rows=558 width=12) (actual rows= loops=)

  • Index Cond: (((sys_owner_cd)::text = '6548'::text) AND ((from_point_cd)::text = 'W002'::text) AND ((shipping_subject)::text = '03'::text) AND ((shipping_date)::text >= '20180101'::text) AND ((shipping_date)::text <= '20180131'::text))
  • Filter: ((shipping_sts)::text <> '99'::text)
12. 0.000 0.000 ↓ 0.0

Index Scan using me_shipment_serial_p1 on me_shipment_serial mss (cost=0.00..521.90 rows=280 width=36) (actual rows= loops=)

  • Index Cond: (((sys_owner_cd)::text = '6548'::text) AND (shipping_seq_no = ms.shipping_seq_no))
13. 0.000 0.000 ↓ 0.0

Index Scan using me_serial_information_p1 on me_serial_information msi (cost=0.00..8.97 rows=1 width=57) (actual rows= loops=)

  • Index Cond: (((sys_owner_cd)::text = '6548'::text) AND (serial_seq_no = mss.serial_seq_no))
14. 0.000 0.000 ↓ 0.0

Seq Scan on mz_point_mst mpm (cost=0.00..4.40 rows=1 width=8) (actual rows= loops=)

  • Filter: (((sys_owner_cd)::text = '6548'::text) AND ((point_cd)::text = 'W002'::text) AND ((trade_type)::text = '1'::text))
15. 0.000 0.000 ↓ 0.0

Index Scan using me_shipment_case_i3 on me_shipment_case msc (cost=0.00..13.87 rows=1 width=49) (actual rows= loops=)

  • Index Cond: (((sys_owner_cd)::text = '6548'::text) AND (shipping_seq_no = ms.shipping_seq_no) AND ((waybill_no)::text = (mss.waybill_no)::text))
  • Filter: ((consignee_cd)::text = 'VA2301'::text)
16. 0.000 0.000 ↓ 0.0

Index Scan using md_sales_order_p1 on md_sales_order mso (cost=0.00..8.19 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (((sys_owner_cd)::text = '6548'::text) AND ((order_no)::text = (msc.order_no)::text))
  • Filter: ((territory_cd)::text = 'MD14'::text)
17. 0.000 0.000 ↓ 0.0

Index Scan using me_loaded_serial_p1 on me_loaded_serial_information mlsi (cost=0.00..8.96 rows=1 width=22) (actual rows= loops=)

  • Index Cond: (((sys_owner_cd)::text = '6548'::text) AND ((sys_owner_cd)::text = (msi.sys_owner_cd)::text) AND (serial_seq_no = msi.serial_seq_no))
18. 0.000 0.000 ↓ 0.0

Index Scan using mz_local_product_mst_p1 on mz_local_product_mst mlpm (cost=0.00..8.28 rows=1 width=35) (actual rows= loops=)

  • Index Cond: (((sys_owner_cd)::text = '6548'::text) AND ((sys_owner_cd)::text = (msc.sys_owner_cd)::text) AND ((model_cd)::text = (msc.model_cd)::text) AND ((spec_cd)::text = (msc.spec_cd)::text))