explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s6Xo

Settings

Optimization(s) for this plan:

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

Sort (cost=417,263.23..417,263.26 rows=14 width=729) (actual rows= loops=)

  • Sort Key: ""UnionAll4"".""C2"", ""UnionAll4"".""C3"", ""UnionAll4"".""C4"", ""UnionAll4"".""C5"", ""UnionAll4"".""C6"", ""UnionAll4"".""C7"", ""UnionAll4"".""C8"", ""UnionAll4"".""C9"", ""UnionAll4"".""C10"", ""UnionAll4"".""C11"", ""UnionAll4"".""C12"", ""UnionAll4"".""C13"", ""UnionAll4"".""C14"", ""UnionAll4"".""C15"", ""UnionAll4"".""C16"", ""UnionAll4"".""C1"
2. 0.000 0.000 ↓ 0.0

Subquery Scan on UnionAll4 (cost=12,207.54..417,262.96 rows=14 width=729) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Append (cost=12,207.54..417,262.82 rows=14 width=729) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Append (cost=12,207.54..347,006.23 rows=13 width=729) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1 (cost=12,207.54..70,258.22 rows=7 width=596) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12,207.54..70,258.15 rows=7 width=586) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Limit (cost=12,206.84..70,196.81 rows=7 width=420) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12,206.84..70,196.81 rows=7 width=420) (actual rows= loops=)

  • Join Filter: ("Extent9".old_drop_reason_id = "Extent10".id)
9. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12,206.84..70,129.25 rows=7 width=357) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12,206.55..70,112.64 rows=7 width=325) (actual rows= loops=)

  • Join Filter: ("Extent1".location_id = "Extent8".id)
11. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12,206.55..70,031.32 rows=7 width=306) (actual rows= loops=)

  • Join Filter: ("Extent1".interest_id = "Extent7".id)
12. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12,206.55..69,884.13 rows=7 width=271) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12,206.27..69,881.36 rows=7 width=234) (actual rows= loops=)

  • Join Filter: ("Extent4".category_id = "Extent5".id)
14. 0.000 0.000 ↓ 0.0

Seq Scan on categories "Extent5" (cost=0.00..68.60 rows=260 width=21) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Materialize (cost=12,206.27..69,785.48 rows=7 width=213) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12,206.27..69,785.44 rows=7 width=213) (actual rows= loops=)

  • Join Filter: ("Extent1".channel_id = "Extent4".id)
17. 0.000 0.000 ↓ 0.0

Seq Scan on channels "Extent4" (cost=0.00..28.16 rows=1,116 width=37) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Materialize (cost=12,206.27..69,640.12 rows=7 width=176) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12,206.27..69,640.09 rows=7 width=176) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Hash Join (cost=12,205.84..69,584.31 rows=7 width=163) (actual rows= loops=)

  • Hash Cond: ("Extent1".old_candidate_id = "Extent2".id)
21. 0.000 0.000 ↓ 0.0

Index Scan using ix_enquiries_organization_id on enquiries "Extent1" (cost=0.43..57,369.15 rows=2,580 width=88) (actual rows= loops=)

  • Index Cond: (organization_id = 35)
  • Filter: ((dropped_id IS NULL) AND ((channel_id = 748) OR (alternatives: SubPlan 8 or hashed SubPlan 9)))
22.          

SubPlan (forIndex Scan)

23. 0.000 0.000 ↓ 0.0

Index Scan using ix_enqury_cross_channel_events_channel_id_enquiry_id on cross_channel_events "Extent11" (cost=0.42..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((channel_id = 748) AND ("Extent1".id = enquiry_id))
  • Filter: ("Extent1".organization_id = organization_id)
24. 0.000 0.000 ↓ 0.0

Index Scan using ix_enqury_cross_channel_events_channel_id_enquiry_id on cross_channel_events "Extent11_1" (cost=0.42..100.89 rows=31 width=12) (actual rows= loops=)

  • Index Cond: (channel_id = 748)
25. 0.000 0.000 ↓ 0.0

Hash (cost=12,157.10..12,157.10 rows=3,865 width=75) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on candidates "Extent2" (cost=118.32..12,157.10 rows=3,865 width=75) (actual rows= loops=)

  • Recheck Cond: (organization_id = 35)
  • Filter: ((NOT is_hidden) AND (anonymized_date IS NULL))
27. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ix_candidates_organization_id (cost=0.00..117.36 rows=4,093 width=0) (actual rows= loops=)

  • Index Cond: ((organization_id = 35) AND (is_hidden = false))
28. 0.000 0.000 ↓ 0.0

Index Scan using pk__applicat__3214ec0722b5168e on applications "Extent3" (cost=0.43..7.96 rows=1 width=21) (actual rows= loops=)

  • Index Cond: ("Extent1".application_id = id)
  • Filter: ((type_id = '2'::smallint) OR (type_id = '1'::smallint))
29. 0.000 0.000 ↓ 0.0

Index Scan using pk_education on educations "Extent6" (cost=0.28..0.39 rows=1 width=37) (actual rows= loops=)

  • Index Cond: ("Extent1".education_id = id)
30. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..31.88 rows=1,125 width=35) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Seq Scan on interests "Extent7" (cost=0.00..26.25 rows=1,125 width=35) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..15.62 rows=641 width=19) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Seq Scan on locations "Extent8" (cost=0.00..12.41 rows=641 width=19) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Index Scan using pk__dropped__3214ec072a563856 on dropped "Extent9" (cost=0.29..2.36 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ("Extent1".dropped_id = id)
35. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..11.60 rows=240 width=31) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Seq Scan on institute_drop_reasons "Extent10" (cost=0.00..10.40 rows=240 width=31) (actual rows= loops=)

37.          

SubPlan (forNested Loop Left Join)

38. 0.000 0.000 ↓ 0.0

Aggregate (cost=4.45..4.46 rows=1 width=4) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Index Only Scan using ix_enquiry_enquiries_organization_id_old_candidate_id on enquiries "Extent12" (cost=0.43..4.45 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((organization_id = "Extent1".organization_id) AND (old_candidate_id = "Extent1".old_candidate_id))
40. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.69..8.74 rows=1 width=38) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Index Scan using ix_enquiry_tags_organization_id_enquiry_id on tags "Extent13" (cost=0.42..8.44 rows=1 width=16) (actual rows= loops=)

  • Index Cond: (("Extent1".organization_id = organization_id) AND ("Extent1".id = enquiry_id))
42. 0.000 0.000 ↓ 0.0

Index Scan using pk__tags__3214ec0730e33a54 on tags "Extent14" (cost=0.27..0.29 rows=1 width=26) (actual rows= loops=)

  • Index Cond: (id = "Extent13".tag_id)
43. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2_1 (cost=79,113.53..276,748.02 rows=6 width=596) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=79,113.53..276,747.96 rows=6 width=598) (actual rows= loops=)

  • Join Filter: (("Extent27".section_collection_id = "Extent28".id) AND ("Extent27".organization_id = "Extent28".organization_id))
45. 0.000 0.000 ↓ 0.0

Hash Join (cost=70,196.98..258,710.10 rows=6 width=432) (actual rows= loops=)

  • Hash Cond: (("Extent27".organization_id = "Alias4".organization_id) AND ("Extent27".enquiry_id = "Alias4".id))
46. 0.000 0.000 ↓ 0.0

Seq Scan on receivers "Extent27" (cost=0.00..131,624.89 rows=7,585,089 width=20) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Hash (cost=70,196.88..70,196.88 rows=7 width=420) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Subquery Scan on Alias4 (cost=12,206.84..70,196.88 rows=7 width=420) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Limit (cost=12,206.84..70,196.81 rows=7 width=420) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12,206.84..70,196.81 rows=7 width=420) (actual rows= loops=)

  • Join Filter: ("Extent23".old_drop_reason_id = "Extent24".id)
51. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12,206.84..70,129.25 rows=7 width=357) (actual rows= loops=)

52. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12,206.55..70,112.64 rows=7 width=325) (actual rows= loops=)

  • Join Filter: ("Extent15".location_id = "Extent22".id)
53. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12,206.55..70,031.32 rows=7 width=306) (actual rows= loops=)

  • Join Filter: ("Extent15".interest_id = "Extent21".id)
54. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12,206.55..69,884.13 rows=7 width=271) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12,206.27..69,881.36 rows=7 width=234) (actual rows= loops=)

  • Join Filter: ("Extent18".category_id = "Extent19".id)
56. 0.000 0.000 ↓ 0.0

Seq Scan on categories "Extent19" (cost=0.00..68.60 rows=260 width=21) (actual rows= loops=)

57. 0.000 0.000 ↓ 0.0

Materialize (cost=12,206.27..69,785.48 rows=7 width=213) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12,206.27..69,785.44 rows=7 width=213) (actual rows= loops=)

  • Join Filter: ("Extent15".channel_id = "Extent18".id)
59. 0.000 0.000 ↓ 0.0

Seq Scan on channels "Extent18" (cost=0.00..28.16 rows=1,116 width=37) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Materialize (cost=12,206.27..69,640.12 rows=7 width=176) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12,206.27..69,640.09 rows=7 width=176) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Hash Join (cost=12,205.84..69,584.31 rows=7 width=163) (actual rows= loops=)

  • Hash Cond: ("Extent15".old_candidate_id = "Extent16".id)
63. 0.000 0.000 ↓ 0.0

Index Scan using ix_enquiries_organization_id on enquiries "Extent15" (cost=0.43..57,369.15 rows=2,580 width=88) (actual rows= loops=)

  • Index Cond: (organization_id = 35)
  • Filter: ((dropped_id IS NULL) AND ((channel_id = 748) OR (alternatives: SubPlan 5 or hashed SubPlan 6)))
64.          

SubPlan (forIndex Scan)

65. 0.000 0.000 ↓ 0.0

Index Scan using ix_enqury_cross_channel_events_channel_id_enquiry_id on cross_channel_events "Extent25" (cost=0.42..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((channel_id = 748) AND ("Extent15".id = enquiry_id))
  • Filter: ("Extent15".organization_id = organization_id)
66. 0.000 0.000 ↓ 0.0

Index Scan using ix_enqury_cross_channel_events_channel_id_enquiry_id on cross_channel_events "Extent25_1" (cost=0.42..100.89 rows=31 width=12) (actual rows= loops=)

  • Index Cond: (channel_id = 748)
67. 0.000 0.000 ↓ 0.0

Hash (cost=12,157.10..12,157.10 rows=3,865 width=75) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on candidates "Extent16" (cost=118.32..12,157.10 rows=3,865 width=75) (actual rows= loops=)

  • Recheck Cond: (organization_id = 35)
  • Filter: ((NOT is_hidden) AND (anonymized_date IS NULL))
69. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ix_candidates_organization_id (cost=0.00..117.36 rows=4,093 width=0) (actual rows= loops=)

  • Index Cond: ((organization_id = 35) AND (is_hidden = false))
70. 0.000 0.000 ↓ 0.0

Index Scan using pk__applicat__3214ec0722b5168e on applications "Extent17" (cost=0.43..7.96 rows=1 width=21) (actual rows= loops=)

  • Index Cond: ("Extent15".application_id = id)
  • Filter: ((type_id = '2'::smallint) OR (type_id = '1'::smallint))
71. 0.000 0.000 ↓ 0.0

Index Scan using pk_education on educations "Extent20" (cost=0.28..0.39 rows=1 width=37) (actual rows= loops=)

  • Index Cond: ("Extent15".education_id = id)
72. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..31.88 rows=1,125 width=35) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Seq Scan on interests "Extent21" (cost=0.00..26.25 rows=1,125 width=35) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..15.62 rows=641 width=19) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Seq Scan on locations "Extent22" (cost=0.00..12.41 rows=641 width=19) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

Index Scan using pk__dropped__3214ec072a563856 on dropped "Extent23" (cost=0.29..2.36 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ("Extent15".dropped_id = id)
77. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..11.60 rows=240 width=31) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Seq Scan on institute_drop_reasons "Extent24" (cost=0.00..10.40 rows=240 width=31) (actual rows= loops=)

79.          

SubPlan (forNested Loop Left Join)

80. 0.000 0.000 ↓ 0.0

Aggregate (cost=4.45..4.46 rows=1 width=4) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Index Only Scan using ix_enquiry_enquiries_organization_id_old_candidate_id on enquiries "Extent26" (cost=0.43..4.45 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((organization_id = "Extent15".organization_id) AND (old_candidate_id = "Extent15".old_candidate_id))
82. 0.000 0.000 ↓ 0.0

Materialize (cost=8,916.55..17,946.12 rows=895 width=46) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Hash Join (cost=8,916.55..17,941.65 rows=895 width=46) (actual rows= loops=)

  • Hash Cond: (("Extent28".id = "Extent31".id) AND ("Extent28".organization_id = "Extent31".organization_id))
84. 0.000 0.000 ↓ 0.0

Append (cost=0.00..4,353.37 rows=179,037 width=12) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

Seq Scan on manual "Extent28" (cost=0.00..4,294.73 rows=175,873 width=12) (actual rows= loops=)

86. 0.000 0.000 ↓ 0.0

Seq Scan on section_collection_filter "Extent29" (cost=0.00..27.48 rows=1,748 width=12) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Seq Scan on template "Extent30" (cost=0.00..31.16 rows=1,416 width=12) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

Hash (cost=4,667.22..4,667.22 rows=178,622 width=46) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

Seq Scan on section_collection "Extent31" (cost=0.00..4,667.22 rows=178,622 width=46) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=12,207.54..70,256.33 rows=1 width=596) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12,207.54..70,256.32 rows=1 width=585) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12,207.26..70,256.01 rows=1 width=428) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Limit (cost=12,206.84..70,196.81 rows=7 width=420) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12,206.84..70,196.81 rows=7 width=420) (actual rows= loops=)

  • Join Filter: ("Extent42".old_drop_reason_id = "Extent43".id)
95. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12,206.84..70,129.25 rows=7 width=357) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12,206.55..70,112.64 rows=7 width=325) (actual rows= loops=)

  • Join Filter: ("Extent34".location_id = "Extent41".id)
97. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12,206.55..70,031.32 rows=7 width=306) (actual rows= loops=)

  • Join Filter: ("Extent34".interest_id = "Extent40".id)
98. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12,206.55..69,884.13 rows=7 width=271) (actual rows= loops=)

99. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12,206.27..69,881.36 rows=7 width=234) (actual rows= loops=)

  • Join Filter: ("Extent37".category_id = "Extent38".id)
100. 0.000 0.000 ↓ 0.0

Seq Scan on categories "Extent38" (cost=0.00..68.60 rows=260 width=21) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

Materialize (cost=12,206.27..69,785.48 rows=7 width=213) (actual rows= loops=)

102. 0.000 0.000 ↓ 0.0

Nested Loop (cost=12,206.27..69,785.44 rows=7 width=213) (actual rows= loops=)

  • Join Filter: ("Extent34".channel_id = "Extent37".id)
103. 0.000 0.000 ↓ 0.0

Seq Scan on channels "Extent37" (cost=0.00..28.16 rows=1,116 width=37) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Materialize (cost=12,206.27..69,640.12 rows=7 width=176) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=12,206.27..69,640.09 rows=7 width=176) (actual rows= loops=)

106. 0.000 0.000 ↓ 0.0

Hash Join (cost=12,205.84..69,584.31 rows=7 width=163) (actual rows= loops=)

  • Hash Cond: ("Extent34".old_candidate_id = "Extent35".id)
107. 0.000 0.000 ↓ 0.0

Index Scan using ix_enquiries_organization_id on enquiries "Extent34" (cost=0.43..57,369.15 rows=2,580 width=88) (actual rows= loops=)

  • Index Cond: (organization_id = 35)
  • Filter: ((dropped_id IS NULL) AND ((channel_id = 748) OR (alternatives: SubPlan 2 or hashed SubPlan 3)))
108.          

SubPlan (forIndex Scan)

109. 0.000 0.000 ↓ 0.0

Index Scan using ix_enqury_cross_channel_events_channel_id_enquiry_id on cross_channel_events "Extent44" (cost=0.42..8.44 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((channel_id = 748) AND ("Extent34".id = enquiry_id))
  • Filter: ("Extent34".organization_id = organization_id)
110. 0.000 0.000 ↓ 0.0

Index Scan using ix_enqury_cross_channel_events_channel_id_enquiry_id on cross_channel_events "Extent44_1" (cost=0.42..100.89 rows=31 width=12) (actual rows= loops=)

  • Index Cond: (channel_id = 748)
111. 0.000 0.000 ↓ 0.0

Hash (cost=12,157.10..12,157.10 rows=3,865 width=75) (actual rows= loops=)

112. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on candidates "Extent35" (cost=118.32..12,157.10 rows=3,865 width=75) (actual rows= loops=)

  • Recheck Cond: (organization_id = 35)
  • Filter: ((NOT is_hidden) AND (anonymized_date IS NULL))
113. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ix_candidates_organization_id (cost=0.00..117.36 rows=4,093 width=0) (actual rows= loops=)

  • Index Cond: ((organization_id = 35) AND (is_hidden = false))
114. 0.000 0.000 ↓ 0.0

Index Scan using pk__applicat__3214ec0722b5168e on applications "Extent36" (cost=0.43..7.96 rows=1 width=21) (actual rows= loops=)

  • Index Cond: ("Extent34".application_id = id)
  • Filter: ((type_id = '2'::smallint) OR (type_id = '1'::smallint))
115. 0.000 0.000 ↓ 0.0

Index Scan using pk_education on educations "Extent39" (cost=0.28..0.39 rows=1 width=37) (actual rows= loops=)

  • Index Cond: ("Extent34".education_id = id)
116. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..31.88 rows=1,125 width=35) (actual rows= loops=)

117. 0.000 0.000 ↓ 0.0

Seq Scan on interests "Extent40" (cost=0.00..26.25 rows=1,125 width=35) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..15.62 rows=641 width=19) (actual rows= loops=)

119. 0.000 0.000 ↓ 0.0

Seq Scan on locations "Extent41" (cost=0.00..12.41 rows=641 width=19) (actual rows= loops=)

120. 0.000 0.000 ↓ 0.0

Index Scan using pk__dropped__3214ec072a563856 on dropped "Extent42" (cost=0.29..2.36 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ("Extent34".dropped_id = id)
121. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..11.60 rows=240 width=31) (actual rows= loops=)

122. 0.000 0.000 ↓ 0.0

Seq Scan on institute_drop_reasons "Extent43" (cost=0.00..10.40 rows=240 width=31) (actual rows= loops=)

123.          

SubPlan (forNested Loop Left Join)

124. 0.000 0.000 ↓ 0.0

Aggregate (cost=4.45..4.46 rows=1 width=4) (actual rows= loops=)

125. 0.000 0.000 ↓ 0.0

Index Only Scan using ix_enquiry_enquiries_organization_id_old_candidate_id on enquiries "Extent45" (cost=0.43..4.45 rows=1 width=0) (actual rows= loops=)

  • Index Cond: ((organization_id = "Extent34".organization_id) AND (old_candidate_id = "Extent34".old_candidate_id))
126. 0.000 0.000 ↓ 0.0

Index Scan using ix_enquiry_cross_channel_events_organization_id_enquiry_id on cross_channel_events "Extent46" (cost=0.42..8.44 rows=1 width=20) (actual rows= loops=)

  • Index Cond: ((organization_id = "Extent34".organization_id) AND (enquiry_id = "Extent34".id))
127. 0.000 0.000 ↓ 0.0

Index Scan using pk_channel on channels "Extent47" (cost=0.28..0.30 rows=1 width=29) (actual rows= loops=)

  • Index Cond: (id = "Extent46".channel_id)