explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VlH

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

Append (cost=507,236.98..1,710,776.64 rows=996,774 width=3,386) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=507,236.98..1,259,006.37 rows=984,304 width=241) (actual rows= loops=)

  • Hash Cond: (cd.id = cd_1.id)
3. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=311,808.70..1,052,504.55 rows=984,304 width=1,085) (actual rows= loops=)

  • Hash Cond: (cd.wb_user_id = mpcm.wb_user_inhouse)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=311,460.32..1,041,075.10 rows=984,304 width=1,081) (actual rows= loops=)

  • Hash Cond: (((sa.data ->> 'sa1_5'::text))::integer = sam.id)
5. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=303,408.94..1,016,229.54 rows=185,264 width=1,399) (actual rows= loops=)

  • Hash Cond: (c.id = c_2.id)
6. 0.000 0.000 ↓ 0.0

Gather (cost=108,068.33..820,402.61 rows=185,264 width=1,399) (actual rows= loops=)

  • Workers Planned: 4
7. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=107,068.33..800,876.21 rows=46,316 width=1,399) (actual rows= loops=)

  • Hash Cond: (cd.wb_user_id = mpcm_1.wb_user_inhouse)
8. 0.000 0.000 ↓ 0.0

Hash Join (cost=99,035.94..784,939.28 rows=46,316 width=1,367) (actual rows= loops=)

  • Hash Cond: (c.pm_id = wu2.id)
9. 0.000 0.000 ↓ 0.0

Hash Join (cost=92,086.83..777,868.56 rows=46,316 width=1,371) (actual rows= loops=)

  • Hash Cond: (c.subject_area_id = sa.id)
10. 0.000 0.000 ↓ 0.0

Hash Join (cost=91,946.95..777,606.80 rows=46,316 width=1,041) (actual rows= loops=)

  • Hash Cond: (cd.wb_user_id = wu.id)
11. 0.000 0.000 ↓ 0.0

Hash Join (cost=75,691.22..756,463.87 rows=53,018 width=143) (actual rows= loops=)

  • Hash Cond: (cd.process_service_mapping_id = psm.id)
12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=71,696.89..751,738.99 rows=53,518 width=115) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=71,696.46..613,084.70 rows=32,255 width=99) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Hash Join (cost=71,696.04..528,365.56 rows=44,060 width=103) (actual rows= loops=)

  • Hash Cond: (s.service_segment = ss.id)
15. 0.000 0.000 ↓ 0.0

Hash Join (cost=71,694.85..528,162.17 rows=50,354 width=86) (actual rows= loops=)

  • Hash Cond: (c.service_id = s.id)
16. 0.000 0.000 ↓ 0.0

Hash Join (cost=71,688.80..528,017.13 rows=51,186 width=54) (actual rows= loops=)

  • Hash Cond: (c.enquiry_id = e.id)
17. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on component c (cost=0.00..449,386.09 rows=53,041 width=54) (actual rows= loops=)

  • Filter: (active AND (type <> 'test'::component_type) AND (pm_id <> 130) AND (component_type = 'job'::component_entity_type) AND (sent_to_client_date >= (date_trunc('month'::text, (LOCALTIMESTAMP + '05:30:00'::interval)) - '9 mons'::interval)))
18. 0.000 0.000 ↓ 0.0

Hash (cost=47,467.43..47,467.43 rows=1,476,350 width=8) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Seq Scan on enquiry e (cost=0.00..47,467.43 rows=1,476,350 width=8) (actual rows= loops=)

  • Filter: active
20. 0.000 0.000 ↓ 0.0

Hash (cost=4.54..4.54 rows=121 width=40) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Seq Scan on service s (cost=0.00..4.54 rows=121 width=40) (actual rows= loops=)

  • Filter: (active AND (id <> 2))
22. 0.000 0.000 ↓ 0.0

Hash (cost=1.10..1.10 rows=7 width=25) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Seq Scan on service_segment ss (cost=0.00..1.10 rows=7 width=25) (actual rows= loops=)

  • Filter: (id <> 5)
24. 0.000 0.000 ↓ 0.0

Index Scan using eos_user_pkey on eos_user eu (cost=0.42..1.92 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = e.eos_user_id)
  • Filter: (type <> 'test'::user_type)
25. 0.000 0.000 ↓ 0.0

Index Scan using component_detail_component_id_idx on component_detail cd (cost=0.43..4.27 rows=3 width=20) (actual rows= loops=)

  • Index Cond: (component_id = c.id)
26. 0.000 0.000 ↓ 0.0

Hash (cost=3,985.60..3,985.60 rows=698 width=36) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..3,985.60 rows=698 width=36) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Seq Scan on process_service_mapping psm (cost=0.00..27.05 rows=705 width=24) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Index Scan using master_pkey on master m (cost=0.29..5.61 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (id = psm.process_id)
  • Filter: active
30. 0.000 0.000 ↓ 0.0

Hash (cost=13,399.99..13,399.99 rows=22,699 width=902) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Seq Scan on wb_user wu (cost=0.00..13,399.99 rows=22,699 width=902) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Hash (cost=119.39..119.39 rows=1,639 width=338) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Seq Scan on subject_area sa (cost=0.00..119.39 rows=1,639 width=338) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Hash (cost=6,665.38..6,665.38 rows=22,699 width=4) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Index Only Scan using wb_user_pkey on wb_user wu2 (cost=0.29..6,665.38 rows=22,699 width=4) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Hash (cost=8,015.89..8,015.89 rows=1,320 width=36) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Group (cost=7,989.49..8,002.69 rows=1,320 width=36) (actual rows= loops=)

  • Group Key: m_2.name, m2.name, mpcm_1.wb_user_inhouse
38. 0.000 0.000 ↓ 0.0

Sort (cost=7,989.49..7,992.79 rows=1,320 width=36) (actual rows= loops=)

  • Sort Key: m_2.name, m2.name, mpcm_1.wb_user_inhouse
39. 0.000 0.000 ↓ 0.0

Merge Join (cost=7,897.82..7,921.07 rows=1,320 width=36) (actual rows= loops=)

  • Merge Cond: (m_2.id = mpcm_1.coe_name_master_id)
40. 0.000 0.000 ↓ 0.0

Index Scan using master_pkey on master m_2 (cost=0.29..11,556.20 rows=83,272 width=20) (actual rows= loops=)

  • Filter: active
41. 0.000 0.000 ↓ 0.0

Sort (cost=4,193.07..4,196.40 rows=1,332 width=24) (actual rows= loops=)

  • Sort Key: mpcm_1.coe_name_master_id
42. 0.000 0.000 ↓ 0.0

Merge Join (cost=4,103.33..4,123.94 rows=1,332 width=24) (actual rows= loops=)

  • Merge Cond: (m2.id = mpcm_1.coe_team_name_master_id)
43. 0.000 0.000 ↓ 0.0

Index Scan using master_pkey on master m2 (cost=0.29..11,556.20 rows=83,272 width=20) (actual rows= loops=)

  • Filter: active
44. 0.000 0.000 ↓ 0.0

Sort (cost=395.05..398.41 rows=1,345 width=12) (actual rows= loops=)

  • Sort Key: mpcm_1.coe_team_name_master_id
45. 0.000 0.000 ↓ 0.0

Seq Scan on master_pm_coe_mapping mpcm_1 (cost=0.00..325.15 rows=1,345 width=12) (actual rows= loops=)

  • Filter: active
46. 0.000 0.000 ↓ 0.0

Hash (cost=195,137.74..195,137.74 rows=16,230 width=4) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Group (cost=193,064.66..194,975.44 rows=16,230 width=4) (actual rows= loops=)

  • Group Key: c_2.id
48. 0.000 0.000 ↓ 0.0

Gather Merge (cost=193,064.66..194,936.17 rows=15,705 width=4) (actual rows= loops=)

  • Workers Planned: 3
49. 0.000 0.000 ↓ 0.0

Group (cost=192,064.62..192,090.80 rows=5,235 width=4) (actual rows= loops=)

  • Group Key: c_2.id
50. 0.000 0.000 ↓ 0.0

Sort (cost=192,064.62..192,077.71 rows=5,235 width=4) (actual rows= loops=)

  • Sort Key: c_2.id
51. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.86..191,741.26 rows=5,235 width=4) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..149,506.41 rows=37,240 width=4) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on client_direct (cost=0.00..12,640.07 rows=44,911 width=4) (actual rows= loops=)

  • Filter: ((NOT is_quality_check) AND active)
54. 0.000 0.000 ↓ 0.0

Index Scan using component_detail_pkey on component_detail cd_2 (cost=0.43..3.05 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = client_direct.component_detail_id)
  • Filter: active
55. 0.000 0.000 ↓ 0.0

Index Scan using component_pkey on component c_2 (cost=0.43..1.13 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = cd_2.component_id)
  • Filter: (active AND (sent_to_client_date >= (date_trunc('month'::text, (LOCALTIMESTAMP + '05:30:00'::interval)) - '9 mons'::interval)))
56. 0.000 0.000 ↓ 0.0

Hash (cost=8,038.09..8,038.09 rows=1,063 width=20) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Hash Join (cost=7,996.11..8,038.09 rows=1,063 width=20) (actual rows= loops=)

  • Hash Cond: ((m_3.name)::text = (sam.title)::text)
58. 0.000 0.000 ↓ 0.0

Group (cost=7,989.49..7,999.39 rows=1,320 width=32) (actual rows= loops=)

  • Group Key: m_3.name, m3.name
59. 0.000 0.000 ↓ 0.0

Sort (cost=7,989.49..7,992.79 rows=1,320 width=32) (actual rows= loops=)

  • Sort Key: m_3.name, m3.name
60. 0.000 0.000 ↓ 0.0

Merge Join (cost=7,897.82..7,921.07 rows=1,320 width=32) (actual rows= loops=)

  • Merge Cond: (m_3.id = mpcm_2.coe_name_master_id)
61. 0.000 0.000 ↓ 0.0

Index Scan using master_pkey on master m_3 (cost=0.29..11,556.20 rows=83,272 width=20) (actual rows= loops=)

  • Filter: active
62. 0.000 0.000 ↓ 0.0

Sort (cost=4,193.07..4,196.40 rows=1,332 width=20) (actual rows= loops=)

  • Sort Key: mpcm_2.coe_name_master_id
63. 0.000 0.000 ↓ 0.0

Merge Join (cost=4,103.33..4,123.94 rows=1,332 width=20) (actual rows= loops=)

  • Merge Cond: (m3.id = mpcm_2.coe_team_name_master_id)
64. 0.000 0.000 ↓ 0.0

Index Scan using master_pkey on master m3 (cost=0.29..11,556.20 rows=83,272 width=20) (actual rows= loops=)

  • Filter: active
65. 0.000 0.000 ↓ 0.0

Sort (cost=395.05..398.41 rows=1,345 width=8) (actual rows= loops=)

  • Sort Key: mpcm_2.coe_team_name_master_id
66. 0.000 0.000 ↓ 0.0

Seq Scan on master_pm_coe_mapping mpcm_2 (cost=0.00..325.15 rows=1,345 width=8) (actual rows= loops=)

  • Filter: active
67. 0.000 0.000 ↓ 0.0

Hash (cost=4.61..4.61 rows=161 width=27) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Seq Scan on subject_area_mapping sam (cost=0.00..4.61 rows=161 width=27) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Hash (cost=342.06..342.06 rows=506 width=8) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..342.06 rows=506 width=8) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Index Scan using master_pkey on master m_1 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = 26491)
  • Filter: active
72. 0.000 0.000 ↓ 0.0

Seq Scan on master_pm_coe_mapping mpcm (cost=0.00..328.69 rows=506 width=8) (actual rows= loops=)

  • Filter: (active AND (wb_user_role_master_id = 26491))
73. 0.000 0.000 ↓ 0.0

Hash (cost=195,427.78..195,427.78 rows=40 width=30) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Gather (cost=164,767.54..195,427.78 rows=40 width=30) (actual rows= loops=)

  • Workers Planned: 3
75. 0.000 0.000 ↓ 0.0

Nested Loop (cost=163,767.54..194,423.78 rows=13 width=30) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

Hash Join (cost=163,767.11..194,217.80 rows=93 width=34) (actual rows= loops=)

  • Hash Cond: ((direct.component_detail_id = cd_1.id) AND (direct.wb_user_id = cd_1.wb_user_id))
77. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on client_direct direct (cost=0.00..12,640.07 rows=235,545 width=34) (actual rows= loops=)

  • Filter: active
78. 0.000 0.000 ↓ 0.0

Hash (cost=111,273.34..111,273.34 rows=2,640,118 width=12) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Seq Scan on component_detail cd_1 (cost=0.00..111,273.34 rows=2,640,118 width=12) (actual rows= loops=)

  • Filter: active
80. 0.000 0.000 ↓ 0.0

Index Scan using component_pkey on component c_1 (cost=0.43..2.21 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = cd_1.component_id)
  • Filter: (active AND (sent_to_client_date >= (date_trunc('month'::text, (LOCALTIMESTAMP + '05:30:00'::interval)) - '9 mons'::interval)))
81. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=24,427.04..441,927.23 rows=12,470 width=271) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Hash Join (cost=24,427.04..441,771.35 rows=12,470 width=267) (actual rows= loops=)

  • Hash Cond: ((sam_1.title)::text = (subquery_sa.coe)::text)
83. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=16,397.95..433,207.66 rows=1,889 width=1,060) (actual rows= loops=)

  • Hash Cond: (cd_3.wb_user_id = mpcm_4.wb_user_inhouse)
84. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,365.56..424,852.88 rows=1,889 width=1,028) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8,365.28..423,752.31 rows=1,889 width=1,032) (actual rows= loops=)

86. 0.000 0.000 ↓ 0.0

Hash Join (cost=8,364.99..423,048.92 rows=2,163 width=138) (actual rows= loops=)

  • Hash Cond: (cd_3.wb_user_id = mpcm_3.wb_user_inhouse)
87. 0.000 0.000 ↓ 0.0

Gather (cost=8,016.61..422,506.96 rows=17,195 width=130) (actual rows= loops=)

  • Workers Planned: 4
88. 0.000 0.000 ↓ 0.0

Hash Join (cost=7,016.61..419,787.46 rows=4,299 width=130) (actual rows= loops=)

  • Hash Cond: (((sa_1.data ->> 'sa1_5'::text))::integer = sam_1.id)
89. 0.000 0.000 ↓ 0.0

Hash Join (cost=7,009.98..419,764.42 rows=5,340 width=441) (actual rows= loops=)

  • Hash Cond: (cd_3.process_service_mapping_id = psm_1.id)
90. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6,974.12..419,714.45 rows=5,340 width=429) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Hash Join (cost=6,973.69..378,024.51 rows=3,882 width=421) (actual rows= loops=)

  • Hash Cond: (c_3.subject_area_id = sa_1.id)
92. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6,833.81..377,874.42 rows=3,882 width=91) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6,833.39..373,971.48 rows=5,302 width=95) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Hash Join (cost=6,832.96..348,727.76 rows=5,494 width=95) (actual rows= loops=)

  • Hash Cond: (s_1.service_segment = ss_1.id)
95. 0.000 0.000 ↓ 0.0

Hash Join (cost=6,831.78..348,701.36 rows=6,279 width=78) (actual rows= loops=)

  • Hash Cond: (c_3.service_id = s_1.id)
96. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on component c_3 (cost=6,825.73..348,677.98 rows=6,383 width=46) (actual rows= loops=)

  • Recheck Cond: (component_type = 'question'::component_entity_type)
  • Filter: (active AND (pm_id <> 130) AND (sent_to_client_date >= (date_trunc('month'::text, (LOCALTIMESTAMP + '05:30:00'::interval)) - '9 mons'::interval)))
97. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on component_status_type (cost=0.00..6,819.34 rows=186,522 width=0) (actual rows= loops=)

  • Index Cond: (component_type = 'question'::component_entity_type)
98. 0.000 0.000 ↓ 0.0

Hash (cost=4.54..4.54 rows=121 width=40) (actual rows= loops=)

99. 0.000 0.000 ↓ 0.0

Seq Scan on service s_1 (cost=0.00..4.54 rows=121 width=40) (actual rows= loops=)

  • Filter: (active AND (id <> 2))
100. 0.000 0.000 ↓ 0.0

Hash (cost=1.10..1.10 rows=7 width=25) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

Seq Scan on service_segment ss_1 (cost=0.00..1.10 rows=7 width=25) (actual rows= loops=)

  • Filter: (active AND (id <> 5))
102. 0.000 0.000 ↓ 0.0

Index Scan using enquiry_pkey on enquiry e_1 (cost=0.43..4.59 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = c_3.enquiry_id)
  • Filter: active
103. 0.000 0.000 ↓ 0.0

Index Scan using eos_user_pkey on eos_user eu_1 (cost=0.42..0.74 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = e_1.eos_user_id)
  • Filter: (type <> 'test'::user_type)
104. 0.000 0.000 ↓ 0.0

Hash (cost=119.39..119.39 rows=1,639 width=338) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

Seq Scan on subject_area sa_1 (cost=0.00..119.39 rows=1,639 width=338) (actual rows= loops=)

  • Filter: active
106. 0.000 0.000 ↓ 0.0

Index Scan using component_detail_component_id_idx on component_detail cd_3 (cost=0.43..10.71 rows=3 width=16) (actual rows= loops=)

  • Index Cond: (component_id = c_3.id)
  • Filter: active
107. 0.000 0.000 ↓ 0.0

Hash (cost=27.05..27.05 rows=705 width=20) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

Seq Scan on process_service_mapping psm_1 (cost=0.00..27.05 rows=705 width=20) (actual rows= loops=)

  • Filter: active
109. 0.000 0.000 ↓ 0.0

Hash (cost=4.61..4.61 rows=161 width=27) (actual rows= loops=)

110. 0.000 0.000 ↓ 0.0

Seq Scan on subject_area_mapping sam_1 (cost=0.00..4.61 rows=161 width=27) (actual rows= loops=)

  • Filter: active
111. 0.000 0.000 ↓ 0.0

Hash (cost=342.06..342.06 rows=506 width=8) (actual rows= loops=)

112. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..342.06 rows=506 width=8) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

Index Scan using master_pkey on master m_4 (cost=0.29..8.31 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = 26491)
  • Filter: active
114. 0.000 0.000 ↓ 0.0

Seq Scan on master_pm_coe_mapping mpcm_3 (cost=0.00..328.69 rows=506 width=8) (actual rows= loops=)

  • Filter: (active AND (wb_user_role_master_id = 26491))
115. 0.000 0.000 ↓ 0.0

Index Scan using wb_user_pkey on wb_user wu_1 (cost=0.29..0.33 rows=1 width=902) (actual rows= loops=)

  • Index Cond: (id = cd_3.wb_user_id)
116. 0.000 0.000 ↓ 0.0

Index Only Scan using wb_user_pkey on wb_user wu2_1 (cost=0.29..0.58 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = c_3.pm_id)
117. 0.000 0.000 ↓ 0.0

Hash (cost=8,015.89..8,015.89 rows=1,320 width=36) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

Group (cost=7,989.49..8,002.69 rows=1,320 width=36) (actual rows= loops=)

  • Group Key: m_5.name, m2_1.name, mpcm_4.wb_user_inhouse
119. 0.000 0.000 ↓ 0.0

Sort (cost=7,989.49..7,992.79 rows=1,320 width=36) (actual rows= loops=)

  • Sort Key: m_5.name, m2_1.name, mpcm_4.wb_user_inhouse
120. 0.000 0.000 ↓ 0.0

Merge Join (cost=7,897.82..7,921.07 rows=1,320 width=36) (actual rows= loops=)

  • Merge Cond: (m_5.id = mpcm_4.coe_name_master_id)
121. 0.000 0.000 ↓ 0.0

Index Scan using master_pkey on master m_5 (cost=0.29..11,556.20 rows=83,272 width=20) (actual rows= loops=)

  • Filter: active
122. 0.000 0.000 ↓ 0.0

Sort (cost=4,193.07..4,196.40 rows=1,332 width=24) (actual rows= loops=)

  • Sort Key: mpcm_4.coe_name_master_id
123. 0.000 0.000 ↓ 0.0

Merge Join (cost=4,103.33..4,123.94 rows=1,332 width=24) (actual rows= loops=)

  • Merge Cond: (m2_1.id = mpcm_4.coe_team_name_master_id)
124. 0.000 0.000 ↓ 0.0

Index Scan using master_pkey on master m2_1 (cost=0.29..11,556.20 rows=83,272 width=20) (actual rows= loops=)

  • Filter: active
125. 0.000 0.000 ↓ 0.0

Sort (cost=395.05..398.41 rows=1,345 width=12) (actual rows= loops=)

  • Sort Key: mpcm_4.coe_team_name_master_id
126. 0.000 0.000 ↓ 0.0

Seq Scan on master_pm_coe_mapping mpcm_4 (cost=0.00..325.15 rows=1,345 width=12) (actual rows= loops=)

  • Filter: active
127. 0.000 0.000 ↓ 0.0

Hash (cost=8,012.59..8,012.59 rows=1,320 width=32) (actual rows= loops=)

128. 0.000 0.000 ↓ 0.0

Subquery Scan on subquery_sa (cost=7,989.49..8,012.59 rows=1,320 width=32) (actual rows= loops=)

129. 0.000 0.000 ↓ 0.0

Group (cost=7,989.49..7,999.39 rows=1,320 width=32) (actual rows= loops=)

  • Group Key: m_6.name, m3_1.name
130. 0.000 0.000 ↓ 0.0

Sort (cost=7,989.49..7,992.79 rows=1,320 width=32) (actual rows= loops=)

  • Sort Key: m_6.name, m3_1.name
131. 0.000 0.000 ↓ 0.0

Merge Join (cost=7,897.82..7,921.07 rows=1,320 width=32) (actual rows= loops=)

  • Merge Cond: (m_6.id = mpcm_5.coe_name_master_id)
132. 0.000 0.000 ↓ 0.0

Index Scan using master_pkey on master m_6 (cost=0.29..11,556.20 rows=83,272 width=20) (actual rows= loops=)

  • Filter: active
133. 0.000 0.000 ↓ 0.0

Sort (cost=4,193.07..4,196.40 rows=1,332 width=20) (actual rows= loops=)

  • Sort Key: mpcm_5.coe_name_master_id
134. 0.000 0.000 ↓ 0.0

Merge Join (cost=4,103.33..4,123.94 rows=1,332 width=20) (actual rows= loops=)

  • Merge Cond: (m3_1.id = mpcm_5.coe_team_name_master_id)
135. 0.000 0.000 ↓ 0.0

Index Scan using master_pkey on master m3_1 (cost=0.29..11,556.20 rows=83,272 width=20) (actual rows= loops=)

  • Filter: active
136. 0.000 0.000 ↓ 0.0

Sort (cost=395.05..398.41 rows=1,345 width=8) (actual rows= loops=)

  • Sort Key: mpcm_5.coe_team_name_master_id
137. 0.000 0.000 ↓ 0.0

Seq Scan on master_pm_coe_mapping mpcm_5 (cost=0.00..325.15 rows=1,345 width=8) (actual rows= loops=)

  • Filter: active