explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9GfA

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

Sort (cost=174,313,468.08..174,313,468.35 rows=109 width=730) (actual rows= loops=)

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

Subquery Scan on UnionAll2 (cost=58,102,819.98..174,313,464.39 rows=109 width=730) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Append (cost=58,102,819.98..174,313,463.30 rows=109 width=730) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Append (cost=58,102,819.98..116,207,488.65 rows=104 width=730) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 1 (cost=58,102,819.98..58,103,674.17 rows=50 width=595) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=58,102,819.98..58,103,673.67 rows=50 width=584) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Limit (cost=58,102,819.29..58,103,243.54 rows=50 width=410) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Result (cost=58,102,819.29..58,103,854.46 rows=122 width=410) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Sort (cost=58,102,819.29..58,102,819.59 rows=122 width=406) (actual rows= loops=)

  • Sort Key: "Extent1".creation_date DESC
10. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..58,102,815.24 rows=122 width=406) (actual rows= loops=)

  • Join Filter: ("Extent8".old_drop_reason_id = "Extent9".id)
11. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..58,102,365.66 rows=122 width=335) (actual rows= loops=)

  • Join Filter: ("Extent1".dropped_id = "Extent8".id)
12. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..57,865,399.03 rows=122 width=303) (actual rows= loops=)

  • Join Filter: ("Extent1".location_id = "Extent7".id)
13. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..57,864,372.29 rows=122 width=285) (actual rows= loops=)

  • Join Filter: ("Extent1".interest_id = "Extent6".id)
14. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..57,862,304.74 rows=122 width=250) (actual rows= loops=)

  • Join Filter: ("Extent1".education_id = "Extent5".id)
15. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..57,855,251.03 rows=122 width=213) (actual rows= loops=)

  • Join Filter: ("Extent3".category_id = "Extent4".id)
16. 0.000 0.000 ↓ 0.0

Seq Scan on categories "Extent4" (cost=0.00..68.30 rows=230 width=20) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Materialize (cost=0.43..57,854,762.14 rows=122 width=193) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..57,854,761.53 rows=122 width=193) (actual rows= loops=)

  • Join Filter: ("Extent1".channel_id = "Extent3".id)
19. 0.000 0.000 ↓ 0.0

Seq Scan on channels "Extent3" (cost=0.00..24.47 rows=947 width=37) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Materialize (cost=0.43..57,853,004.35 rows=122 width=156) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..57,853,003.74 rows=122 width=156) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Seq Scan on candidates "Extent2" (cost=0.00..51,799.78 rows=16,547 width=76) (actual rows= loops=)

  • Filter: ((NOT is_hidden) AND (anonymized_date IS NULL) AND (organization_id = 14))
23. 0.000 0.000 ↓ 0.0

Index Scan using ix_enquiry_enquiries_organization_id_old_candidate_id on enquiries "Extent1" (cost=0.43..3,493.14 rows=1 width=80) (actual rows= loops=)

  • Index Cond: ((organization_id = 14) AND (old_candidate_id = "Extent2".id))
  • Filter: ((dropped_id IS NULL) AND (SubPlan 18))
24.          

SubPlan (forIndex Scan)

25. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..3,487.64 rows=1 width=0) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_dbo_candidate on candidates "Extent10" (cost=0.43..8.45 rows=1 width=4) (actual rows= loops=)

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

Seq Scan on recruitment_units "Extent11" (cost=0.00..3,479.18 rows=1 width=4) (actual rows= loops=)

  • Filter: ((organization_id = "Extent1".organization_id) AND (SubPlan 17))
28.          

SubPlan (forSeq Scan)

29. 0.000 0.000 ↓ 0.0

Index Scan using pk_institute_user on institute_users "Extent12" (cost=0.28..34.08 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (user_id = 'f70e6474-aaad-4587-b6fa-e4f4a9735f3d'::uuid)
  • Filter: (("Extent11".id = recruitment_unit_id) AND ((alternatives: SubPlan 14 or hashed SubPlan 15) OR (SubPlan 16)))
30.          

SubPlan (forIndex Scan)

31. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..12.89 rows=1 width=0) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Index Scan using pk_dbo_candidate on candidates "Extent14" (cost=0.43..8.45 rows=1 width=23) (actual rows= loops=)

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

Index Only Scan using pk_user_selection on user_selection "Extent13" (cost=0.41..4.43 rows=1 width=23) (actual rows= loops=)

  • Index Cond: ((user_id = "Extent12".user_id) AND (email = "Extent14".email))
34. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.46..1,375.54 rows=1 width=16) (actual rows= loops=)

  • Hash Cond: ("Extent13_1".email = "Extent14_1".email)
35. 0.000 0.000 ↓ 0.0

Seq Scan on user_selection "Extent13_1" (cost=0.00..1,143.96 rows=59,496 width=39) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Hash (cost=8.45..8.45 rows=1 width=23) (actual rows= loops=)

37. 0.000 0.000 ↓ 0.0

Index Scan using pk_dbo_candidate on candidates "Extent14_1" (cost=0.43..8.45 rows=1 width=23) (actual rows= loops=)

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

Nested Loop (cost=0.84..12.89 rows=1 width=0) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Index Scan using ix_candidate_emails_organization_id_candidate_id on emails "Extent16" (cost=0.42..8.45 rows=1 width=23) (actual rows= loops=)

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

Index Only Scan using pk_user_selection on user_selection "Extent15" (cost=0.41..4.43 rows=1 width=23) (actual rows= loops=)

  • Index Cond: ((user_id = "Extent12".user_id) AND (email = "Extent16".email))
41. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..100.08 rows=3,805 width=37) (actual rows= loops=)

42. 0.000 0.000 ↓ 0.0

Seq Scan on educations "Extent5" (cost=0.00..81.05 rows=3,805 width=37) (actual rows= loops=)

43. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..31.71 rows=1,114 width=35) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Seq Scan on interests "Extent6" (cost=0.00..26.14 rows=1,114 width=35) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..14.31 rows=554 width=18) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Seq Scan on locations "Extent7" (cost=0.00..11.54 rows=554 width=18) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..2,605.75 rows=88,250 width=32) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Seq Scan on dropped "Extent8" (cost=0.00..1,560.50 rows=88,250 width=32) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..11.59 rows=239 width=31) (actual rows= loops=)

50. 0.000 0.000 ↓ 0.0

Seq Scan on institute_drop_reasons "Extent9" (cost=0.00..10.39 rows=239 width=31) (actual rows= loops=)

51.          

SubPlan (forResult)

52. 0.000 0.000 ↓ 0.0

Aggregate (cost=8.45..8.46 rows=1 width=4) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

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

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

Nested Loop (cost=0.69..8.58 rows=1 width=37) (actual rows= loops=)

55. 0.000 0.000 ↓ 0.0

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

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

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

  • Index Cond: (id = "Extent18".tag_id)
57. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2_1 (cost=58,103,781.32..58,103,814.47 rows=54 width=595) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Nested Loop (cost=58,103,781.32..58,103,813.93 rows=54 width=607) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=58,103,780.90..58,103,789.16 rows=54 width=442) (actual rows= loops=)

  • Merge Cond: ("Extent37".draft_id = "Extent39".draft_id)
60. 0.000 0.000 ↓ 0.0

Sort (cost=58,103,668.72..58,103,668.85 rows=54 width=426) (actual rows= loops=)

  • Sort Key: "Extent37".draft_id
61. 0.000 0.000 ↓ 0.0

Nested Loop (cost=58,102,819.72..58,103,667.16 rows=54 width=426) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Limit (cost=58,102,819.29..58,103,243.54 rows=50 width=410) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Result (cost=58,102,819.29..58,103,854.46 rows=122 width=410) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Sort (cost=58,102,819.29..58,102,819.59 rows=122 width=406) (actual rows= loops=)

  • Sort Key: "Extent20".creation_date DESC
65. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..58,102,815.24 rows=122 width=406) (actual rows= loops=)

  • Join Filter: ("Extent27".old_drop_reason_id = "Extent28".id)
66. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..58,102,365.66 rows=122 width=335) (actual rows= loops=)

  • Join Filter: ("Extent20".dropped_id = "Extent27".id)
67. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..57,865,399.03 rows=122 width=303) (actual rows= loops=)

  • Join Filter: ("Extent20".location_id = "Extent26".id)
68. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..57,864,372.29 rows=122 width=285) (actual rows= loops=)

  • Join Filter: ("Extent20".interest_id = "Extent25".id)
69. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..57,862,304.74 rows=122 width=250) (actual rows= loops=)

  • Join Filter: ("Extent20".education_id = "Extent24".id)
70. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..57,855,251.03 rows=122 width=213) (actual rows= loops=)

  • Join Filter: ("Extent22".category_id = "Extent23".id)
71. 0.000 0.000 ↓ 0.0

Seq Scan on categories "Extent23" (cost=0.00..68.30 rows=230 width=20) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Materialize (cost=0.43..57,854,762.14 rows=122 width=193) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..57,854,761.53 rows=122 width=193) (actual rows= loops=)

  • Join Filter: ("Extent20".channel_id = "Extent22".id)
74. 0.000 0.000 ↓ 0.0

Seq Scan on channels "Extent22" (cost=0.00..24.47 rows=947 width=37) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Materialize (cost=0.43..57,853,004.35 rows=122 width=156) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..57,853,003.74 rows=122 width=156) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Seq Scan on candidates "Extent21" (cost=0.00..51,799.78 rows=16,547 width=76) (actual rows= loops=)

  • Filter: ((NOT is_hidden) AND (anonymized_date IS NULL) AND (organization_id = 14))
78. 0.000 0.000 ↓ 0.0

Index Scan using ix_enquiry_enquiries_organization_id_old_candidate_id on enquiries "Extent20" (cost=0.43..3,493.14 rows=1 width=80) (actual rows= loops=)

  • Index Cond: ((organization_id = 14) AND (old_candidate_id = "Extent21".id))
  • Filter: ((dropped_id IS NULL) AND (SubPlan 12))
79.          

SubPlan (forIndex Scan)

80. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..3,487.64 rows=1 width=0) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_dbo_candidate on candidates "Extent29" (cost=0.43..8.45 rows=1 width=4) (actual rows= loops=)

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

Seq Scan on recruitment_units "Extent30" (cost=0.00..3,479.18 rows=1 width=4) (actual rows= loops=)

  • Filter: ((organization_id = "Extent20".organization_id) AND (SubPlan 11))
83.          

SubPlan (forSeq Scan)

84. 0.000 0.000 ↓ 0.0

Index Scan using pk_institute_user on institute_users "Extent31" (cost=0.28..34.08 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (user_id = 'f70e6474-aaad-4587-b6fa-e4f4a9735f3d'::uuid)
  • Filter: (("Extent30".id = recruitment_unit_id) AND ((alternatives: SubPlan 8 or hashed SubPlan 9) OR (SubPlan 10)))
85.          

SubPlan (forIndex Scan)

86. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..12.89 rows=1 width=0) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Index Scan using pk_dbo_candidate on candidates "Extent33" (cost=0.43..8.45 rows=1 width=23) (actual rows= loops=)

  • Index Cond: (("Extent20".organization_id = organization_id) AND ("Extent20".old_candidate_id = id))
88. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_user_selection on user_selection "Extent32" (cost=0.41..4.43 rows=1 width=23) (actual rows= loops=)

  • Index Cond: ((user_id = "Extent31".user_id) AND (email = "Extent33".email))
89. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.46..1,375.54 rows=1 width=16) (actual rows= loops=)

  • Hash Cond: ("Extent32_1".email = "Extent33_1".email)
90. 0.000 0.000 ↓ 0.0

Seq Scan on user_selection "Extent32_1" (cost=0.00..1,143.96 rows=59,496 width=39) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Hash (cost=8.45..8.45 rows=1 width=23) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Index Scan using pk_dbo_candidate on candidates "Extent33_1" (cost=0.43..8.45 rows=1 width=23) (actual rows= loops=)

  • Index Cond: (("Extent20".organization_id = organization_id) AND ("Extent20".old_candidate_id = id))
93. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..12.89 rows=1 width=0) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Index Scan using ix_candidate_emails_organization_id_candidate_id on emails "Extent35" (cost=0.42..8.45 rows=1 width=23) (actual rows= loops=)

  • Index Cond: (("Extent20".organization_id = organization_id) AND ("Extent20".old_candidate_id = candidate_id))
95. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_user_selection on user_selection "Extent34" (cost=0.41..4.43 rows=1 width=23) (actual rows= loops=)

  • Index Cond: ((user_id = "Extent31".user_id) AND (email = "Extent35".email))
96. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..100.08 rows=3,805 width=37) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Seq Scan on educations "Extent24" (cost=0.00..81.05 rows=3,805 width=37) (actual rows= loops=)

98. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..31.71 rows=1,114 width=35) (actual rows= loops=)

99. 0.000 0.000 ↓ 0.0

Seq Scan on interests "Extent25" (cost=0.00..26.14 rows=1,114 width=35) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..14.31 rows=554 width=18) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

Seq Scan on locations "Extent26" (cost=0.00..11.54 rows=554 width=18) (actual rows= loops=)

102. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..2,605.75 rows=88,250 width=32) (actual rows= loops=)

103. 0.000 0.000 ↓ 0.0

Seq Scan on dropped "Extent27" (cost=0.00..1,560.50 rows=88,250 width=32) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..11.59 rows=239 width=31) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

Seq Scan on institute_drop_reasons "Extent28" (cost=0.00..10.39 rows=239 width=31) (actual rows= loops=)

106.          

SubPlan (forResult)

107. 0.000 0.000 ↓ 0.0

Aggregate (cost=8.45..8.46 rows=1 width=4) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((organization_id = "Extent20".organization_id) AND (old_candidate_id = "Extent20".old_candidate_id))
109. 0.000 0.000 ↓ 0.0

Index Scan using ix_message_draft_receivers_organization_id_enquiry_id on draft_receivers "Extent37" (cost=0.43..8.45 rows=1 width=28) (actual rows= loops=)

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

Sort (cost=112.14..116.00 rows=1,543 width=16) (actual rows= loops=)

  • Sort Key: "Extent39".draft_id
111. 0.000 0.000 ↓ 0.0

Seq Scan on auto_sendouts "Extent39" (cost=0.00..30.43 rows=1,543 width=16) (actual rows= loops=)

112. 0.000 0.000 ↓ 0.0

Index Scan using drafts_pkey on drafts "Extent38" (cost=0.42..0.45 rows=1 width=60) (actual rows= loops=)

  • Index Cond: (id = "Extent37".draft_id)
113. 0.000 0.000 ↓ 0.0

Subquery Scan on *SELECT* 2 (cost=58,103,281.10..58,105,972.57 rows=5 width=595) (actual rows= loops=)

114. 0.000 0.000 ↓ 0.0

Hash Join (cost=58,103,281.10..58,105,972.52 rows=5 width=584) (actual rows= loops=)

  • Hash Cond: (("Extent57".enquiry_id = "Alias15".id) AND ("Extent57".organization_id = "Alias15".organization_id))
115. 0.000 0.000 ↓ 0.0

Hash Join (cost=36.31..2,205.35 rows=69,644 width=41) (actual rows= loops=)

  • Hash Cond: ("Extent57".channel_id = "Extent58".id)
116. 0.000 0.000 ↓ 0.0

Seq Scan on cross_channel_events "Extent57" (cost=0.00..1,211.44 rows=69,644 width=20) (actual rows= loops=)

117. 0.000 0.000 ↓ 0.0

Hash (cost=24.47..24.47 rows=947 width=29) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

Seq Scan on channels "Extent58" (cost=0.00..24.47 rows=947 width=29) (actual rows= loops=)

119. 0.000 0.000 ↓ 0.0

Hash (cost=58,103,244.04..58,103,244.04 rows=50 width=410) (actual rows= loops=)

120. 0.000 0.000 ↓ 0.0

Subquery Scan on Alias15 (cost=58,102,819.29..58,103,244.04 rows=50 width=410) (actual rows= loops=)

121. 0.000 0.000 ↓ 0.0

Limit (cost=58,102,819.29..58,103,243.54 rows=50 width=410) (actual rows= loops=)

122. 0.000 0.000 ↓ 0.0

Result (cost=58,102,819.29..58,103,854.46 rows=122 width=410) (actual rows= loops=)

123. 0.000 0.000 ↓ 0.0

Sort (cost=58,102,819.29..58,102,819.59 rows=122 width=406) (actual rows= loops=)

  • Sort Key: "Extent40".creation_date DESC
124. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..58,102,815.24 rows=122 width=406) (actual rows= loops=)

  • Join Filter: ("Extent47".old_drop_reason_id = "Extent48".id)
125. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..58,102,365.66 rows=122 width=335) (actual rows= loops=)

  • Join Filter: ("Extent40".dropped_id = "Extent47".id)
126. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..57,865,399.03 rows=122 width=303) (actual rows= loops=)

  • Join Filter: ("Extent40".location_id = "Extent46".id)
127. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..57,864,372.29 rows=122 width=285) (actual rows= loops=)

  • Join Filter: ("Extent40".interest_id = "Extent45".id)
128. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.43..57,862,304.74 rows=122 width=250) (actual rows= loops=)

  • Join Filter: ("Extent40".education_id = "Extent44".id)
129. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..57,855,251.03 rows=122 width=213) (actual rows= loops=)

  • Join Filter: ("Extent42".category_id = "Extent43".id)
130. 0.000 0.000 ↓ 0.0

Seq Scan on categories "Extent43" (cost=0.00..68.30 rows=230 width=20) (actual rows= loops=)

131. 0.000 0.000 ↓ 0.0

Materialize (cost=0.43..57,854,762.14 rows=122 width=193) (actual rows= loops=)

132. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..57,854,761.53 rows=122 width=193) (actual rows= loops=)

  • Join Filter: ("Extent40".channel_id = "Extent42".id)
133. 0.000 0.000 ↓ 0.0

Seq Scan on channels "Extent42" (cost=0.00..24.47 rows=947 width=37) (actual rows= loops=)

134. 0.000 0.000 ↓ 0.0

Materialize (cost=0.43..57,853,004.35 rows=122 width=156) (actual rows= loops=)

135. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..57,853,003.74 rows=122 width=156) (actual rows= loops=)

136. 0.000 0.000 ↓ 0.0

Seq Scan on candidates "Extent41" (cost=0.00..51,799.78 rows=16,547 width=76) (actual rows= loops=)

  • Filter: ((NOT is_hidden) AND (anonymized_date IS NULL) AND (organization_id = 14))
137. 0.000 0.000 ↓ 0.0

Index Scan using ix_enquiry_enquiries_organization_id_old_candidate_id on enquiries "Extent40" (cost=0.43..3,493.14 rows=1 width=80) (actual rows= loops=)

  • Index Cond: ((organization_id = 14) AND (old_candidate_id = "Extent41".id))
  • Filter: ((dropped_id IS NULL) AND (SubPlan 6))
138.          

SubPlan (forIndex Scan)

139. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.43..3,487.64 rows=1 width=0) (actual rows= loops=)

140. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_dbo_candidate on candidates "Extent49" (cost=0.43..8.45 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((organization_id = "Extent40".organization_id) AND (id = "Extent40".old_candidate_id))
141. 0.000 0.000 ↓ 0.0

Seq Scan on recruitment_units "Extent50" (cost=0.00..3,479.18 rows=1 width=4) (actual rows= loops=)

  • Filter: ((organization_id = "Extent40".organization_id) AND (SubPlan 5))
142.          

SubPlan (forSeq Scan)

143. 0.000 0.000 ↓ 0.0

Index Scan using pk_institute_user on institute_users "Extent51" (cost=0.28..34.08 rows=1 width=0) (actual rows= loops=)

  • Index Cond: (user_id = 'f70e6474-aaad-4587-b6fa-e4f4a9735f3d'::uuid)
  • Filter: (("Extent50".id = recruitment_unit_id) AND ((alternatives: SubPlan 2 or hashed SubPlan 3) OR (SubPlan 4)))
144.          

SubPlan (forIndex Scan)

145. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..12.89 rows=1 width=0) (actual rows= loops=)

146. 0.000 0.000 ↓ 0.0

Index Scan using pk_dbo_candidate on candidates "Extent53" (cost=0.43..8.45 rows=1 width=23) (actual rows= loops=)

  • Index Cond: (("Extent40".organization_id = organization_id) AND ("Extent40".old_candidate_id = id))
147. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_user_selection on user_selection "Extent52" (cost=0.41..4.43 rows=1 width=23) (actual rows= loops=)

  • Index Cond: ((user_id = "Extent51".user_id) AND (email = "Extent53".email))
148. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.46..1,375.54 rows=1 width=16) (actual rows= loops=)

  • Hash Cond: ("Extent52_1".email = "Extent53_1".email)
149. 0.000 0.000 ↓ 0.0

Seq Scan on user_selection "Extent52_1" (cost=0.00..1,143.96 rows=59,496 width=39) (actual rows= loops=)

150. 0.000 0.000 ↓ 0.0

Hash (cost=8.45..8.45 rows=1 width=23) (actual rows= loops=)

151. 0.000 0.000 ↓ 0.0

Index Scan using pk_dbo_candidate on candidates "Extent53_1" (cost=0.43..8.45 rows=1 width=23) (actual rows= loops=)

  • Index Cond: (("Extent40".organization_id = organization_id) AND ("Extent40".old_candidate_id = id))
152. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.84..12.89 rows=1 width=0) (actual rows= loops=)

153. 0.000 0.000 ↓ 0.0

Index Scan using ix_candidate_emails_organization_id_candidate_id on emails "Extent55" (cost=0.42..8.45 rows=1 width=23) (actual rows= loops=)

  • Index Cond: (("Extent40".organization_id = organization_id) AND ("Extent40".old_candidate_id = candidate_id))
154. 0.000 0.000 ↓ 0.0

Index Only Scan using pk_user_selection on user_selection "Extent54" (cost=0.41..4.43 rows=1 width=23) (actual rows= loops=)

  • Index Cond: ((user_id = "Extent51".user_id) AND (email = "Extent55".email))
155. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..100.08 rows=3,805 width=37) (actual rows= loops=)

156. 0.000 0.000 ↓ 0.0

Seq Scan on educations "Extent44" (cost=0.00..81.05 rows=3,805 width=37) (actual rows= loops=)

157. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..31.71 rows=1,114 width=35) (actual rows= loops=)

158. 0.000 0.000 ↓ 0.0

Seq Scan on interests "Extent45" (cost=0.00..26.14 rows=1,114 width=35) (actual rows= loops=)

159. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..14.31 rows=554 width=18) (actual rows= loops=)

160. 0.000 0.000 ↓ 0.0

Seq Scan on locations "Extent46" (cost=0.00..11.54 rows=554 width=18) (actual rows= loops=)

161. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..2,605.75 rows=88,250 width=32) (actual rows= loops=)

162. 0.000 0.000 ↓ 0.0

Seq Scan on dropped "Extent47" (cost=0.00..1,560.50 rows=88,250 width=32) (actual rows= loops=)

163. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..11.59 rows=239 width=31) (actual rows= loops=)

164. 0.000 0.000 ↓ 0.0

Seq Scan on institute_drop_reasons "Extent48" (cost=0.00..10.39 rows=239 width=31) (actual rows= loops=)

165.          

SubPlan (forResult)

166. 0.000 0.000 ↓ 0.0

Aggregate (cost=8.45..8.46 rows=1 width=4) (actual rows= loops=)

167. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((organization_id = "Extent40".organization_id) AND (old_candidate_id = "Extent40".old_candidate_id))