explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pEus

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.215 ↓ 0.0 0 1

Nested Loop Semi Join (cost=4.98..49.25 rows=1 width=2,676) (actual time=0.215..0.215 rows=0 loops=1)

2. 0.005 0.212 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.98..38.91 rows=1 width=1,262) (actual time=0.206..0.212 rows=1 loops=1)

  • Join Filter: (alternatives: SubPlan 6 or hashed SubPlan 7)
  • Rows Removed by Join Filter: 2
3. 0.017 0.204 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.98..35.83 rows=1 width=1,258) (actual time=0.198..0.204 rows=1 loops=1)

  • Join Filter: ((itbinquiry17_.itbp_itbh_id = itbinquiry0_.itbh_id) AND ((itbinquiry17_.itbp_pos_id = 0) OR (COALESCE((SubPlan 4), (SubPlan 5)) = 1)))
  • Rows Removed by Join Filter: 6
4. 0.003 0.164 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.98..22.23 rows=1 width=1,250) (actual time=0.159..0.164 rows=1 loops=1)

  • Join Filter: (companycat15_.cocam_cp_id = company16_.cp_id)
  • Rows Removed by Join Filter: 1
5. 0.003 0.157 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.98..21.03 rows=1 width=498) (actual time=0.152..0.157 rows=1 loops=1)

  • Join Filter: (companyent14_.cocom_cocam_id1 = companycat15_.cocam_id)
  • Rows Removed by Join Filter: 1
6. 0.002 0.152 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.98..19.83 rows=1 width=494) (actual time=0.147..0.152 rows=1 loops=1)

  • Join Filter: (companyent14_.cocom_cocam_id1 = itbinquiry0_.itbh_cust_cocam_id)
7. 0.002 0.144 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.98..18.58 rows=1 width=470) (actual time=0.140..0.144 rows=1 loops=1)

  • Join Filter: (itbinquiry0_.itbh_id = localized13_.itbn_itbh_id)
8. 0.003 0.140 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.98..17.54 rows=1 width=452) (actual time=0.136..0.140 rows=1 loops=1)

  • Join Filter: ((itbinquiry0_.itbh_id = localized12_.itbn_itbh_id) AND (localized12_.itbn_lan_id = itbinquiry0_.itbh_deflan_id))
  • Rows Removed by Join Filter: 1
9. 0.001 0.133 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.98..16.48 rows=1 width=438) (actual time=0.129..0.133 rows=1 loops=1)

10. 0.003 0.129 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.83..16.18 rows=1 width=428) (actual time=0.125..0.129 rows=1 loops=1)

11. 0.002 0.119 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.69..15.57 rows=1 width=428) (actual time=0.116..0.119 rows=1 loops=1)

12. 0.002 0.113 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.40..7.13 rows=1 width=378) (actual time=0.110..0.113 rows=1 loops=1)

13. 0.002 0.107 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.26..6.83 rows=1 width=368) (actual time=0.104..0.107 rows=1 loops=1)

14. 0.002 0.099 ↑ 1.0 1 1

Nested Loop Left Join (cost=4.11..6.53 rows=1 width=358) (actual time=0.096..0.099 rows=1 loops=1)

15. 0.004 0.079 ↑ 1.0 1 1

Merge Right Join (cost=3.83..3.98 rows=1 width=308) (actual time=0.077..0.079 rows=1 loops=1)

  • Merge Cond: (region6_.reg_id = company2_.cp_reg_id)
16. 0.014 0.014 ↑ 23.6 5 1

Index Scan using pk_region on region region6_ (cost=0.14..14.91 rows=118 width=8) (actual time=0.012..0.014 rows=5 loops=1)

17. 0.007 0.061 ↑ 1.0 1 1

Sort (cost=3.31..3.31 rows=1 width=308) (actual time=0.060..0.061 rows=1 loops=1)

  • Sort Key: company2_.cp_reg_id
  • Sort Method: quicksort Memory: 25kB
18. 0.012 0.054 ↑ 1.0 1 1

Hash Join (cost=2.16..3.30 rows=1 width=308) (actual time=0.049..0.054 rows=1 loops=1)

  • Hash Cond: (company2_.cp_id = companycat1_.cocam_cp_id)
19. 0.010 0.010 ↑ 1.0 9 1

Seq Scan on company company2_ (cost=0.00..1.09 rows=9 width=12) (actual time=0.006..0.010 rows=9 loops=1)

20. 0.003 0.032 ↑ 1.0 1 1

Hash (cost=2.15..2.15 rows=1 width=300) (actual time=0.032..0.032 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
21. 0.012 0.029 ↑ 1.0 1 1

Hash Join (cost=1.02..2.15 rows=1 width=300) (actual time=0.025..0.029 rows=1 loops=1)

  • Hash Cond: (companycat1_.cocam_id = itbinquiry0_.itbh_cust_cocam_id)
22. 0.006 0.006 ↑ 1.0 9 1

Seq Scan on comp_cat_mtc companycat1_ (cost=0.00..1.09 rows=9 width=8) (actual time=0.003..0.006 rows=9 loops=1)

23. 0.005 0.011 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=296) (actual time=0.011..0.011 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
24. 0.006 0.006 ↑ 1.0 1 1

Seq Scan on itb_head itbinquiry0_ (cost=0.00..1.01 rows=1 width=296) (actual time=0.006..0.006 rows=1 loops=1)

  • Filter: (itbh_id = 100,000,000)
25. 0.003 0.018 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.28..2.55 rows=1 width=58) (actual time=0.017..0.018 rows=1 loops=1)

26. 0.008 0.008 ↑ 1.0 1 1

Index Scan using idx1_party on party party3_ (cost=0.14..1.94 rows=1 width=58) (actual time=0.007..0.008 rows=1 loops=1)

  • Index Cond: (p_id = company2_.cp_buy_p_id)
27. 0.007 0.007 ↑ 1.0 1 1

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

  • Index Cond: (reg_id = party3_.p_reg_id)
28. 0.006 0.006 ↑ 1.0 1 1

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

  • Index Cond: (co_id = region4_.reg_co_id)
29. 0.004 0.004 ↑ 1.0 1 1

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

  • Index Cond: (co_id = region6_.reg_co_id)
30. 0.001 0.004 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.29..8.43 rows=1 width=58) (actual time=0.004..0.004 rows=0 loops=1)

31. 0.003 0.003 ↓ 0.0 0 1

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

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

Index Scan using idx1_party on party party9_ (cost=0.14..0.26 rows=1 width=58) (never executed)

  • Index Cond: (p_id = cafactory8_.caf_p_id)
33. 0.007 0.007 ↓ 0.0 0 1

Index Scan using idx2_region on region region10_ (cost=0.14..0.60 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (reg_id = party9_.p_reg_id)
34. 0.003 0.003 ↓ 0.0 0 1

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

  • Index Cond: (co_id = region10_.reg_co_id)
35. 0.004 0.004 ↑ 1.0 2 1

Seq Scan on itb_head_name localized12_ (cost=0.00..1.02 rows=2 width=26) (actual time=0.003..0.004 rows=2 loops=1)

  • Filter: (itbn_itbh_id = 100,000,000)
36. 0.002 0.002 ↑ 1.0 1 1

Seq Scan on itb_head_name localized13_ (cost=0.00..1.03 rows=1 width=22) (actual time=0.002..0.002 rows=1 loops=1)

  • Filter: ((itbn_itbh_id = 100,000,000) AND (itbn_lan_id = 1))
  • Rows Removed by Filter: 1
37. 0.006 0.006 ↑ 4.0 1 1

Seq Scan on comp_comp_mtc companyent14_ (cost=0.00..1.20 rows=4 width=24) (actual time=0.005..0.006 rows=1 loops=1)

  • Filter: (cocom_cocam_id2 = 100,000,004)
38. 0.002 0.002 ↑ 4.5 2 1

Seq Scan on comp_cat_mtc companycat15_ (cost=0.00..1.09 rows=9 width=8) (actual time=0.002..0.002 rows=2 loops=1)

39. 0.004 0.004 ↑ 4.5 2 1

Seq Scan on company company16_ (cost=0.00..1.09 rows=9 width=756) (actual time=0.004..0.004 rows=2 loops=1)

40. 0.005 0.005 ↑ 1.0 6 1

Seq Scan on itb_pos itbinquiry17_ (cost=0.00..1.07 rows=6 width=8) (actual time=0.003..0.005 rows=6 loops=1)

  • Filter: (itbp_itbh_id = 100,000,000)
41.          

SubPlan (for Nested Loop Left Join)

42. 0.012 0.012 ↓ 0.0 0 6

Seq Scan on itb_cocam_mtc itbinquiry18_ (cost=0.00..1.03 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=6)

  • Filter: ((icm_itbh_id = itbinquiry0_.itbh_id) AND (icm_itbp_pos_id = 1) AND (icm_cocam_id = 100,000,000))
  • Rows Removed by Filter: 2
43. 0.006 0.006 ↓ 0.0 0 6

Seq Scan on itb_cocam_mtc itbinquiry19_ (cost=0.00..1.03 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=6)

  • Filter: ((icm_itbh_id = itbinquiry0_.itbh_id) AND (icm_itbp_pos_id = itbinquiry17_.itbp_pos_id) AND (icm_cocam_id = 100,000,000))
  • Rows Removed by Filter: 2
44. 0.003 0.003 ↑ 1.0 2 1

Seq Scan on itb_cocam_mtc itbinquiry20_ (cost=0.00..1.02 rows=2 width=8) (actual time=0.002..0.003 rows=2 loops=1)

45.          

SubPlan (for Nested Loop Left Join)

46. 0.000 0.000 ↓ 0.0 0 2

Result (cost=0.00..1.02 rows=1 width=0) (actual time=0.000..0.000 rows=0 loops=2)

  • One-Time Filter: (itbinquiry20_.icm_cocam_id = 100,000,000)
47. 0.000 0.000 ↓ 0.0 0

Seq Scan on itb_head itbinquiry21_ (cost=0.00..1.02 rows=1 width=0) (never executed)

  • Filter: (itbh_activ_flag AND (itbinquiry20_.icm_itbh_id = itbh_id) AND (itbh_parent_itbh_id = itbinquiry0_.itbh_id))
48. 0.000 0.000 ↓ 0.0 0

Seq Scan on itb_head itbinquiry21__1 (cost=0.00..1.01 rows=1 width=12) (never executed)

  • Filter: itbh_activ_flag
49. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on itb_cocam_mtc itbinquiry24_ (cost=0.00..1.03 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((icm_itbh_id = 100,000,000) AND (icm_cocam_id = 100,000,000))
  • Rows Removed by Filter: 2
50.          

SubPlan (for Nested Loop Semi Join)

51. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.00..1.07 rows=1 width=1) (never executed)

52. 0.000 0.000 ↓ 0.0 0

Seq Scan on restagset_cocam restagcoca22_ (cost=0.00..1.07 rows=1 width=1) (never executed)

  • Filter: ((rtsc_rta_id = 342) AND (rtsc_cocam_id = itbinquiry0_.itbh_cust_cocam_id) AND (rtsc_rta_fieldnr = 1))
53. 0.000 0.000 ↓ 0.0 0

Index Only Scan using uk_ofh_supplier_inquiry_head on offer_head itbofferhe23_ (cost=0.15..8.17 rows=1 width=0) (never executed)

  • Index Cond: ((ofh_sup_cocam_id = 100,000,000) AND (ofh_itbh_id = itbinquiry0_.itbh_id))
  • Heap Fetches: 0
54. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on offer_head itbofferhe23__1 (cost=4.17..11.28 rows=3 width=4) (never executed)

  • Recheck Cond: (ofh_sup_cocam_id = 100,000,000)
55. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on uk_ofh_supplier_inquiry_head (cost=0.00..4.17 rows=3 width=0) (never executed)

  • Index Cond: (ofh_sup_cocam_id = 100,000,000)
Planning time : 12.063 ms
Execution time : 0.749 ms