explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VyRw

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

Nested Loop Left Join (cost=2.70..600.52 rows=15 width=2,973) (actual rows= loops=)

  • Join Filter: (alternatives: SubPlan 6 or hashed SubPlan 7)
2. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=2.70..99.12 rows=1 width=4,031) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.56..90.96 rows=1 width=4,031) (actual rows= loops=)

  • Join Filter: ((itbinquiry17_.itbp_itbh_id = itbinquiry0_.itbh_id) AND ((itbinquiry17_.itbp_pos_id = 0) OR (COALESCE((SubPlan 4), (SubPlan 5)) = 1)))
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.42..66.46 rows=1 width=4,023) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.13..58.07 rows=1 width=3,027) (actual rows= loops=)

  • Join Filter: (companyent14_.cocom_cocam_id1 = itbinquiry0_.itbh_cust_cocam_id)
6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.00..49.91 rows=1 width=3,003) (actual rows= loops=)

  • Join Filter: (itbinquiry0_.itbh_id = localized13_.itbn_itbh_id)
7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.85..41.73 rows=1 width=2,369) (actual rows= loops=)

  • Join Filter: ((itbinquiry0_.itbh_id = localized12_.itbn_itbh_id) AND (localized12_.itbn_lan_id = itbinquiry0_.itbh_deflan_id))
8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.71..33.56 rows=1 width=1,739) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.14..23.65 rows=1 width=1,057) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.85..21.58 rows=1 width=1,047) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..16.55 rows=1 width=365) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.30..16.34 rows=1 width=357) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Index Scan using idx1_itb_head on itb_head itbinquiry0_ (cost=0.14..8.16 rows=1 width=353) (actual rows= loops=)

  • Index Cond: (itbh_id = 100,000,000)
14. 0.000 0.000 ↓ 0.0

Index Scan using idx3_comp_cat_m on comp_cat_mtc companycat1_ (cost=0.15..8.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (cocam_id = itbinquiry0_.itbh_cust_cocam_id)
15. 0.000 0.000 ↓ 0.0

Index Scan using idx7_company on company company2_ (cost=0.14..0.19 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (cp_id = companycat1_.cocam_cp_id)
16. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.42..5.02 rows=1 width=690) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Index Scan using idx1_party on party party3_ (cost=0.14..3.75 rows=1 width=680) (actual rows= loops=)

  • Index Cond: (p_id = company2_.cp_buy_p_id)
18. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.29..1.26 rows=1 width=18) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Index Scan using idx2_region on region region4_ (cost=0.14..0.96 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (reg_id = party3_.p_reg_id)
20. 0.000 0.000 ↓ 0.0

Index Scan using pk_country on country country5_ (cost=0.14..0.30 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (co_id = region4_.reg_co_id)
21. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.29..2.06 rows=1 width=18) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Index Scan using idx2_region on region region6_ (cost=0.14..1.76 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (reg_id = company2_.cp_reg_id)
23. 0.000 0.000 ↓ 0.0

Index Scan using pk_country on country country7_ (cost=0.14..0.30 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (co_id = region6_.reg_co_id)
24. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.57..9.90 rows=1 width=690) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Index Scan using pk_ca_factory on ca_factory cafactory8_ (cost=0.14..8.16 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (caf_id = itbinquiry0_.itbh_factory_id)
26. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.42..1.72 rows=1 width=690) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Index Scan using idx1_party on party party9_ (cost=0.14..0.46 rows=1 width=680) (actual rows= loops=)

  • Index Cond: (p_id = cafactory8_.caf_p_id)
28. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.29..1.26 rows=1 width=18) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Index Scan using idx2_region on region region10_ (cost=0.14..0.96 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (reg_id = party9_.p_reg_id)
30. 0.000 0.000 ↓ 0.0

Index Scan using pk_country on country country11_ (cost=0.14..0.30 rows=1 width=18) (actual rows= loops=)

  • Index Cond: (co_id = region10_.reg_co_id)
31. 0.000 0.000 ↓ 0.0

Index Scan using pk_itb_head_name on itb_head_name localized12_ (cost=0.14..8.16 rows=1 width=642) (actual rows= loops=)

  • Index Cond: (itbn_itbh_id = 100,000,000)
32. 0.000 0.000 ↓ 0.0

Index Scan using pk_itb_head_name on itb_head_name localized13_ (cost=0.14..8.16 rows=1 width=638) (actual rows= loops=)

  • Index Cond: ((itbn_itbh_id = 100,000,000) AND (itbn_lan_id = 1))
33. 0.000 0.000 ↓ 0.0

Index Scan using idx9_comp_comp_mtc on comp_comp_mtc companyent14_ (cost=0.14..8.15 rows=1 width=24) (actual rows= loops=)

  • Index Cond: (cocom_cocam_id2 = 100,000,004)
34. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.29..8.37 rows=1 width=1,000) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Index Scan using idx3_comp_cat_m on comp_cat_mtc companycat15_ (cost=0.15..8.17 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (cocam_id = companyent14_.cocom_cocam_id1)
36. 0.000 0.000 ↓ 0.0

Index Scan using idx7_company on company company16_ (cost=0.14..0.19 rows=1 width=996) (actual rows= loops=)

  • Index Cond: (cp_id = companycat15_.cocam_cp_id)
37. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_itb_pos on itb_pos itbinquiry17_ (cost=0.14..8.16 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (itbp_itbh_id = 100,000,000)
38.          

SubPlan (for Nested Loop Left Join)

39. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_itb_cocam_mtc on itb_cocam_mtc itbinquiry18_ (cost=0.14..8.16 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((icm_cocam_id = 100,000,000) AND (icm_itbh_id = itbinquiry0_.itbh_id) AND (icm_itbp_pos_id = 1))
40. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_itb_cocam_mtc on itb_cocam_mtc itbinquiry19_ (cost=0.14..8.16 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((icm_cocam_id = 100,000,000) AND (icm_itbh_id = itbinquiry0_.itbh_id) AND (icm_itbp_pos_id = itbinquiry17_.itbp_pos_id))
41. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_itb_cocam_mtc on itb_cocam_mtc itbinquiry24_ (cost=0.14..8.16 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((icm_cocam_id = 100,000,000) AND (icm_itbh_id = 100,000,000))
42. 0.000 0.000 ↓ 0.0

Seq Scan on itb_cocam_mtc itbinquiry20_ (cost=0.00..10.30 rows=30 width=8) (actual rows= loops=)

43.          

SubPlan (for Nested Loop Left Join)

44. 0.000 0.000 ↓ 0.0

Limit (cost=0.14..8.17 rows=1 width=1) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_restagset_cocam on restagset_cocam restagcoca22_ (cost=0.14..8.17 rows=1 width=1) (actual rows= loops=)

  • Index Cond: ((rtsc_cocam_id = itbinquiry0_.itbh_cust_cocam_id) AND (rtsc_rta_fieldnr = 1) AND (rtsc_rta_id = 342))