explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mMRY : Optimization for: 1; plan #HGXJ

Settings

Optimization path:

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

GroupAggregate (cost=6,591,222.67..6,593,225.31 rows=1 width=264) (actual rows= loops=)

  • Group Key: chwlist.branch_uuid, chwlist.branch_name, 'multiple'::text, 'multiple'::text, 'multiple'::text, 'multiple'::text, 'multiple'::text, (date(chwlist.interval_start)), chwlist.interval_number
2.          

CTE chwlist

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.51..353.34 rows=1 width=213) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Anti Join (cost=8.51..353.29 rows=1 width=201) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=8.23..352.97 rows=1 width=201) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=7.68..350.58 rows=1 width=185) (actual rows= loops=)

  • Hash Cond: (chp.branch_uuid = cmd.uuid)
7. 0.000 0.000 ↓ 0.0

Seq Scan on contactview_chp chp (cost=0.00..313.74 rows=7,774 width=166) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=6.58..6.58 rows=88 width=52) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Index Scan using contactview_metadata_type on contactview_metadata cmd (cost=0.43..6.58 rows=88 width=52) (actual rows= loops=)

  • Index Cond: (type = 'district_hospital'::text)
10. 0.000 0.000 ↓ 0.0

Index Scan using contactview_metadata_uuid on contactview_metadata cmeta (cost=0.56..2.38 rows=1 width=52) (actual rows= loops=)

  • Index Cond: (uuid = chp.supervisor_uuid)
11. 0.000 0.000 ↓ 0.0

Index Only Scan using chp_muting_chw on chp_muting (cost=0.28..0.30 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (chw = chp.uuid)
12. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.02 rows=1 width=12) (actual rows= loops=)

13.          

CTE chw_immunization_pool

14. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=34,701.66..34,874.77 rows=1,282 width=76) (actual rows= loops=)

  • Group Key: x.chw, x.chw_area_uuid, 0
15. 0.000 0.000 ↓ 0.0

Sort (cost=34,701.66..34,733.72 rows=12,823 width=68) (actual rows= loops=)

  • Sort Key: x.chw, x.chw_area_uuid
16. 0.000 0.000 ↓ 0.0

Subquery Scan on x (cost=33,570.26..33,826.72 rows=12,823 width=68) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

HashAggregate (cost=33,570.26..33,698.49 rows=12,823 width=104) (actual rows= loops=)

  • Group Key: i.xmlform_uuid, i.reported, form.chw, form.chw_area
18. 0.000 0.000 ↓ 0.0

Append (cost=0.87..33,442.03 rows=12,823 width=104) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.87..23,754.19 rows=9,180 width=115) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Index Scan using useview_immunization_ug_reported on useview_immunization_ug i (cost=0.32..720.89 rows=9,180 width=45) (actual rows= loops=)

  • Index Cond: ((reported >= (((now())::timestamp without time zone - '15 days'::interval))::timestamp without time zone) AND (reported < ((((now())::timestamp without time zone)::timestamp with time zone + '1 day'::interval))::timestamp without time zone))
21. 0.000 0.000 ↓ 0.0

Index Scan using form_metadata_uuid on form_metadata form (cost=0.56..2.50 rows=1 width=107) (actual rows= loops=)

  • Index Cond: (uuid = i.xmlform_uuid)
22. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.87..9,559.62 rows=3,643 width=115) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Index Scan using useview_immunization_ug_follow_up_reported on useview_immunization_ug_follow_up f (cost=0.31..253.46 rows=3,643 width=45) (actual rows= loops=)

  • Index Cond: ((reported >= (((now())::timestamp without time zone - '15 days'::interval))::timestamp without time zone) AND (reported < ((((now())::timestamp without time zone)::timestamp with time zone + '1 day'::interval))::timestamp without time zone))
24. 0.000 0.000 ↓ 0.0

Index Scan using form_metadata_uuid on form_metadata form_1 (cost=0.56..2.54 rows=1 width=107) (actual rows= loops=)

  • Index Cond: (uuid = f.xmlform_uuid)
25.          

CTE chw_pool

26. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=161,694.02..162,582.50 rows=6,581 width=76) (actual rows= loops=)

  • Group Key: x_1.chw, x_1.chw_area_uuid, 0
27. 0.000 0.000 ↓ 0.0

Sort (cost=161,694.02..161,858.55 rows=65,814 width=68) (actual rows= loops=)

  • Sort Key: x_1.chw, x_1.chw_area_uuid
28. 0.000 0.000 ↓ 0.0

Subquery Scan on x_1 (cost=155,110.61..156,426.89 rows=65,814 width=68) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

HashAggregate (cost=155,110.61..155,768.75 rows=65,814 width=104) (actual rows= loops=)

  • Group Key: i_1.xmlform_uuid, i_1.reported, form_2.chw, form_2.chw_area
30. 0.000 0.000 ↓ 0.0

Append (cost=0.56..154,452.47 rows=65,814 width=104) (actual rows= loops=)

31. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..114,844.00 rows=50,279 width=115) (actual rows= loops=)

32. 0.000 0.000 ↓ 0.0

Seq Scan on useview_immunization_ug i_1 (cost=0.00..2,563.79 rows=50,279 width=45) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

Index Scan using form_metadata_uuid on form_metadata form_2 (cost=0.56..2.22 rows=1 width=107) (actual rows= loops=)

  • Index Cond: (uuid = i_1.xmlform_uuid)
34. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.56..38,950.32 rows=15,535 width=115) (actual rows= loops=)

35. 0.000 0.000 ↓ 0.0

Seq Scan on useview_immunization_ug_follow_up f_1 (cost=0.00..735.35 rows=15,535 width=45) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Index Scan using form_metadata_uuid on form_metadata form_3 (cost=0.56..2.45 rows=1 width=107) (actual rows= loops=)

  • Index Cond: (uuid = f_1.xmlform_uuid)
37.          

CTE u2_child_numerator

38. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=5,078.51..5,078.54 rows=1 width=82) (actual rows= loops=)

  • Group Key: form_4.chw, form_4.chw_area, 0
39. 0.000 0.000 ↓ 0.0

Sort (cost=5,078.51..5,078.52 rows=1 width=110) (actual rows= loops=)

  • Sort Key: form_4.chw, form_4.chw_area
40. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3,674.33..5,078.50 rows=1 width=110) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,673.77..5,075.93 rows=1 width=73) (actual rows= loops=)

  • Hash Cond: ((useview_immunization_ug.id = i_2.id) AND ((max(useview_immunization_ug.reported)) = i_2.reported))
42. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,815.19..3,246.62 rows=43,143 width=44) (actual rows= loops=)

  • Group Key: useview_immunization_ug.id
43. 0.000 0.000 ↓ 0.0

Seq Scan on useview_immunization_ug (cost=0.00..2,563.79 rows=50,279 width=44) (actual rows= loops=)

44. 0.000 0.000 ↓ 0.0

Hash (cost=835.64..835.64 rows=1,530 width=81) (actual rows= loops=)

45. 0.000 0.000 ↓ 0.0

Index Scan using useview_immunization_ug_reported on useview_immunization_ug i_2 (cost=0.32..835.64 rows=1,530 width=81) (actual rows= loops=)

  • Index Cond: ((reported >= (((now())::timestamp without time zone - '15 days'::interval))::timestamp without time zone) AND (reported < ((((now())::timestamp without time zone)::timestamp with time zone + '1 day'::interval))::timestamp without time zone))
  • Filter: ((NOT (defaulter)::boolean) AND ((patient_age_in_months)::integer <= 23))
46. 0.000 0.000 ↓ 0.0

Index Scan using form_metadata_uuid on form_metadata form_4 (cost=0.56..2.56 rows=1 width=107) (actual rows= loops=)

  • Index Cond: (uuid = i_2.xmlform_uuid)
47.          

CTE u2_children_registered

48. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1,416,624.46..1,518,246.59 rows=4,516,539 width=82) (actual rows= loops=)

  • Group Key: form_5.chw, demo.chp_area_uuid, 0
49. 0.000 0.000 ↓ 0.0

Sort (cost=1,416,624.46..1,427,915.81 rows=4,516,539 width=110) (actual rows= loops=)

  • Sort Key: form_5.chw, demo.chp_area_uuid
50. 0.000 0.000 ↓ 0.0

Hash Join (cost=453,918.92..767,429.65 rows=4,516,539 width=110) (actual rows= loops=)

  • Hash Cond: (demo.chp_area_uuid = form_5.chw_area)
51. 0.000 0.000 ↓ 0.0

Index Scan using useview_population_demographics_chp_area_reported on useview_population_demographics demo (cost=0.58..133,141.73 rows=2,499 width=71) (actual rows= loops=)

  • Index Cond: ((reported >= (((now())::timestamp without time zone - '15 days'::interval))::timestamp without time zone) AND (reported < ((((now())::timestamp without time zone)::timestamp with time zone + '1 day'::interval))::timestamp without time zone))
  • Filter: (age_in_months <= 23)
52. 0.000 0.000 ↓ 0.0

Hash (cost=252,361.26..252,361.26 rows=8,322,326 width=70) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Seq Scan on form_metadata form_5 (cost=0.00..252,361.26 rows=8,322,326 width=70) (actual rows= loops=)

54.          

CTE u5_child_numerator

55. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=5,078.51..5,078.54 rows=1 width=82) (actual rows= loops=)

  • Group Key: form_6.chw, form_6.chw_area, 0
56. 0.000 0.000 ↓ 0.0

Sort (cost=5,078.51..5,078.52 rows=1 width=110) (actual rows= loops=)

  • Sort Key: form_6.chw, form_6.chw_area
57. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3,674.33..5,078.50 rows=1 width=110) (actual rows= loops=)

58. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,673.77..5,075.93 rows=1 width=73) (actual rows= loops=)

  • Hash Cond: ((useview_immunization_ug_1.id = i_3.id) AND ((max(useview_immunization_ug_1.reported)) = i_3.reported))
59. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,815.19..3,246.62 rows=43,143 width=44) (actual rows= loops=)

  • Group Key: useview_immunization_ug_1.id
60. 0.000 0.000 ↓ 0.0

Seq Scan on useview_immunization_ug useview_immunization_ug_1 (cost=0.00..2,563.79 rows=50,279 width=44) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Hash (cost=835.64..835.64 rows=1,530 width=81) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Index Scan using useview_immunization_ug_reported on useview_immunization_ug i_3 (cost=0.32..835.64 rows=1,530 width=81) (actual rows= loops=)

  • Index Cond: ((reported >= (((now())::timestamp without time zone - '15 days'::interval))::timestamp without time zone) AND (reported < ((((now())::timestamp without time zone)::timestamp with time zone + '1 day'::interval))::timestamp without time zone))
  • Filter: ((NOT (defaulter)::boolean) AND ((patient_age_in_months)::integer <= 59))
63. 0.000 0.000 ↓ 0.0

Index Scan using form_metadata_uuid on form_metadata form_6 (cost=0.56..2.56 rows=1 width=107) (actual rows= loops=)

  • Index Cond: (uuid = i_3.xmlform_uuid)
64.          

CTE u5_children_registered

65. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=3,379,733.06..3,734,170.18 rows=15,752,761 width=82) (actual rows= loops=)

  • Group Key: form_7.chw, demo_1.chp_area_uuid, 0
66. 0.000 0.000 ↓ 0.0

Sort (cost=3,379,733.06..3,419,114.96 rows=15,752,761 width=110) (actual rows= loops=)

  • Sort Key: form_7.chw, demo_1.chp_area_uuid
67. 0.000 0.000 ↓ 0.0

Hash Join (cost=453,918.92..973,519.26 rows=15,752,761 width=110) (actual rows= loops=)

  • Hash Cond: (demo_1.chp_area_uuid = form_7.chw_area)
68. 0.000 0.000 ↓ 0.0

Index Scan using useview_population_demographics_chp_area_reported on useview_population_demographics demo_1 (cost=0.58..133,141.73 rows=8,716 width=71) (actual rows= loops=)

  • Index Cond: ((reported >= (((now())::timestamp without time zone - '15 days'::interval))::timestamp without time zone) AND (reported < ((((now())::timestamp without time zone)::timestamp with time zone + '1 day'::interval))::timestamp without time zone))
  • Filter: (age_in_months <= 59)
69. 0.000 0.000 ↓ 0.0

Hash (cost=252,361.26..252,361.26 rows=8,322,326 width=70) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Seq Scan on form_metadata form_7 (cost=0.00..252,361.26 rows=8,322,326 width=70) (actual rows= loops=)

71.          

CTE u2_defaulters_treated

72. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=5,172.52..5,172.55 rows=1 width=82) (actual rows= loops=)

  • Group Key: form_8.chw, form_8.chw_area, 0
73. 0.000 0.000 ↓ 0.0

Sort (cost=5,172.52..5,172.53 rows=1 width=110) (actual rows= loops=)

  • Sort Key: form_8.chw, form_8.chw_area
74. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3,984.05..5,172.51 rows=1 width=110) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,983.50..5,169.94 rows=1 width=73) (actual rows= loops=)

  • Hash Cond: ((useview_immunization_ug_2.id = i_4.id) AND ((max(useview_immunization_ug_2.reported)) = i_4.reported))
76. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,815.19..3,246.62 rows=43,143 width=44) (actual rows= loops=)

  • Group Key: useview_immunization_ug_2.id
77. 0.000 0.000 ↓ 0.0

Seq Scan on useview_immunization_ug useview_immunization_ug_2 (cost=0.00..2,563.79 rows=50,279 width=44) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Hash (cost=1,166.24..1,166.24 rows=138 width=117) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=299.31..1,166.24 rows=138 width=117) (actual rows= loops=)

  • Hash Cond: (i_4.id = useview_immunization_ug_follow_up.patient_id)
80. 0.000 0.000 ↓ 0.0

Index Scan using useview_immunization_ug_reported on useview_immunization_ug i_4 (cost=0.32..858.59 rows=1,530 width=81) (actual rows= loops=)

  • Index Cond: ((reported >= (((now())::timestamp without time zone - '15 days'::interval))::timestamp without time zone) AND (reported < ((((now())::timestamp without time zone)::timestamp with time zone + '1 day'::interval))::timestamp without time zone))
  • Filter: ((patient_age_in_months <> ''::text) AND (defaulter)::boolean AND ((patient_age_in_months)::integer <= 23))
81. 0.000 0.000 ↓ 0.0

Hash (cost=253.46..253.46 rows=3,643 width=36) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Index Scan using useview_immunization_ug_follow_up_reported on useview_immunization_ug_follow_up (cost=0.31..253.46 rows=3,643 width=36) (actual rows= loops=)

  • Index Cond: ((reported >= (((now())::timestamp without time zone - '15 days'::interval))::timestamp without time zone) AND (reported < ((((now())::timestamp without time zone)::timestamp with time zone + '1 day'::interval))::timestamp without time zone))
83. 0.000 0.000 ↓ 0.0

Index Scan using form_metadata_uuid on form_metadata form_8 (cost=0.56..2.56 rows=1 width=107) (actual rows= loops=)

  • Index Cond: (uuid = i_4.xmlform_uuid)
84.          

CTE u2_defaulters

85. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=5,101.46..5,101.49 rows=1 width=82) (actual rows= loops=)

  • Group Key: form_9.chw, form_9.chw_area, 0
86. 0.000 0.000 ↓ 0.0

Sort (cost=5,101.46..5,101.47 rows=1 width=110) (actual rows= loops=)

  • Sort Key: form_9.chw, form_9.chw_area
87. 0.000 0.000 ↓ 0.0

Nested Loop (cost=3,697.28..5,101.45 rows=1 width=110) (actual rows= loops=)

88. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,696.72..5,098.88 rows=1 width=73) (actual rows= loops=)

  • Hash Cond: ((useview_immunization_ug_3.id = i_5.id) AND ((max(useview_immunization_ug_3.reported)) = i_5.reported))
89. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,815.19..3,246.62 rows=43,143 width=44) (actual rows= loops=)

  • Group Key: useview_immunization_ug_3.id
90. 0.000 0.000 ↓ 0.0

Seq Scan on useview_immunization_ug useview_immunization_ug_3 (cost=0.00..2,563.79 rows=50,279 width=44) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Hash (cost=858.59..858.59 rows=1,530 width=81) (actual rows= loops=)

92. 0.000 0.000 ↓ 0.0

Index Scan using useview_immunization_ug_reported on useview_immunization_ug i_5 (cost=0.32..858.59 rows=1,530 width=81) (actual rows= loops=)

  • Index Cond: ((reported >= (((now())::timestamp without time zone - '15 days'::interval))::timestamp without time zone) AND (reported < ((((now())::timestamp without time zone)::timestamp with time zone + '1 day'::interval))::timestamp without time zone))
  • Filter: ((patient_age_in_months <> ''::text) AND (defaulter)::boolean AND ((patient_age_in_months)::integer <= 23))
93. 0.000 0.000 ↓ 0.0

Index Scan using form_metadata_uuid on form_metadata form_9 (cost=0.56..2.56 rows=1 width=107) (actual rows= loops=)

  • Index Cond: (uuid = i_5.xmlform_uuid)
94. 0.000 0.000 ↓ 0.0

Sort (cost=1,120,564.18..1,120,675.44 rows=44,502 width=296) (actual rows= loops=)

  • Sort Key: chwlist.branch_uuid, chwlist.branch_name, (date(chwlist.interval_start)), chwlist.interval_number
95. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=197,992.33..1,117,128.28 rows=44,502 width=296) (actual rows= loops=)

  • Hash Cond: ((chwlist.chw_uuid = u2_defaulters.chw_uuid) AND (chwlist.interval_number = u2_defaulters.interval_number))
96. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=197,992.29..1,116,238.20 rows=44,502 width=164) (actual rows= loops=)

  • Hash Cond: ((chwlist.chw_uuid = u2_children_registered.chw_uuid) AND (chwlist.interval_number = u2_children_registered.interval_number))
97. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=216.43..433,421.30 rows=394 width=156) (actual rows= loops=)

  • Hash Cond: ((u5_children_registered.chw_uuid = chwlist.chw_uuid) AND (u5_children_registered.interval_number = chwlist.interval_number))
98. 0.000 0.000 ↓ 0.0

CTE Scan on u5_children_registered (cost=0.00..315,055.22 rows=15,752,761 width=44) (actual rows= loops=)

99. 0.000 0.000 ↓ 0.0

Hash (cost=216.41..216.41 rows=1 width=148) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=35.32..216.41 rows=1 width=148) (actual rows= loops=)

  • Join Filter: ((chwlist.chw_uuid = u2_defaulters_treated.chw_uuid) AND (chwlist.interval_number = u2_defaulters_treated.interval_number))
101. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=35.32..216.38 rows=1 width=140) (actual rows= loops=)

  • Join Filter: ((chwlist.chw_uuid = u5_child_numerator.chw_uuid) AND (chwlist.interval_number = u5_child_numerator.interval_number))
102. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=35.32..216.34 rows=1 width=132) (actual rows= loops=)

  • Join Filter: ((chwlist.chw_uuid = u2_child_numerator.chw_uuid) AND (chwlist.interval_number = u2_child_numerator.interval_number))
103. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=35.32..216.31 rows=1 width=124) (actual rows= loops=)

  • Hash Cond: ((chw_pool.chw_area_uuid = chwlist.chw_area_uuid) AND (chw_pool.interval_number = chwlist.interval_number))
104. 0.000 0.000 ↓ 0.0

CTE Scan on chw_pool (cost=0.00..131.62 rows=6,581 width=44) (actual rows= loops=)

105. 0.000 0.000 ↓ 0.0

Hash (cost=35.30..35.30 rows=1 width=148) (actual rows= loops=)

106. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=0.04..35.30 rows=1 width=148) (actual rows= loops=)

  • Hash Cond: ((chw_immunization_pool.chw_area_uuid = chwlist.chw_area_uuid) AND (chw_immunization_pool.interval_number = chwlist.interval_number))
107. 0.000 0.000 ↓ 0.0

CTE Scan on chw_immunization_pool (cost=0.00..25.64 rows=1,282 width=44) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

Hash (cost=0.03..0.03 rows=1 width=140) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

CTE Scan on chwlist (cost=0.00..0.03 rows=1 width=140) (actual rows= loops=)

  • Filter: ((branch_name <> 'HQ'::text) AND (branch_name <> 'HQ OVC'::text))
110. 0.000 0.000 ↓ 0.0

CTE Scan on u2_child_numerator (cost=0.00..0.02 rows=1 width=44) (actual rows= loops=)

111. 0.000 0.000 ↓ 0.0

CTE Scan on u5_child_numerator (cost=0.00..0.02 rows=1 width=44) (actual rows= loops=)

112. 0.000 0.000 ↓ 0.0

CTE Scan on u2_defaulters_treated (cost=0.00..0.02 rows=1 width=44) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

Hash (cost=90,330.78..90,330.78 rows=4,516,539 width=44) (actual rows= loops=)

114. 0.000 0.000 ↓ 0.0

CTE Scan on u2_children_registered (cost=0.00..90,330.78 rows=4,516,539 width=44) (actual rows= loops=)

115. 0.000 0.000 ↓ 0.0

Hash (cost=0.02..0.02 rows=1 width=44) (actual rows= loops=)

116. 0.000 0.000 ↓ 0.0

CTE Scan on u2_defaulters (cost=0.00..0.02 rows=1 width=44) (actual rows= loops=)