explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GWYr

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

HashAggregate (cost=13,438,907.31..13,438,907.37 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=74,702.46..75,086.32 rows=2,843 width=76) (actual rows= loops=)

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

Sort (cost=74,702.46..74,773.55 rows=28,434 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=72,030.33..72,599.01 rows=28,434 width=68) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

HashAggregate (cost=72,030.33..72,314.67 rows=28,434 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..71,745.99 rows=28,434 width=104) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.87..52,480.75 rows=21,098 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..1,441.42 rows=21,098 width=45) (actual rows= loops=)

  • Index Cond: ((reported >= (((now())::timestamp without time zone - '30 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.41 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..18,980.89 rows=7,336 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..465.33 rows=7,336 width=45) (actual rows= loops=)

  • Index Cond: ((reported >= (((now())::timestamp without time zone - '30 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.51 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,977.80..5,977.82 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,977.80..5,977.80 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=4,573.63..5,977.79 rows=1 width=110) (actual rows= loops=)

41. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,573.07..5,975.23 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=1,705.15..1,705.15 rows=3,516 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..1,705.15 rows=3,516 width=81) (actual rows= loops=)

  • Index Cond: ((reported >= (((now())::timestamp without time zone - '30 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.55 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=2,448,209.66..2,683,498.01 rows=10,457,260 width=82) (actual rows= loops=)

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

Sort (cost=2,448,209.66..2,474,352.81 rows=10,457,260 width=110) (actual rows= loops=)

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

Hash Join (cost=586,553.36..881,783.63 rows=10,457,260 width=110) (actual rows= loops=)

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

Bitmap Heap Scan on useview_population_demographics demo (cost=132,635.03..138,534.93 rows=5,786 width=71) (actual rows= loops=)

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

BitmapAnd (cost=132,635.03..132,635.03 rows=5,786 width=0) (actual rows= loops=)

53. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on useview_population_demographics_patient_age (cost=0.00..27,975.23 rows=194,337 width=0) (actual rows= loops=)

  • Index Cond: (age_in_months <= 23)
54. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on useview_population_demographics_chp_area_reported (cost=0.00..104,656.65 rows=73,377 width=0) (actual rows= loops=)

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

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

56. 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=)

57.          

CTE u5_child_numerator

58. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=5,977.80..5,977.82 rows=1 width=82) (actual rows= loops=)

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

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

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

Nested Loop (cost=4,573.63..5,977.79 rows=1 width=110) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,573.07..5,975.23 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))
62. 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
63. 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=)

64. 0.000 0.000 ↓ 0.0

Hash (cost=1,705.15..1,705.15 rows=3,516 width=81) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((reported >= (((now())::timestamp without time zone - '30 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))
66. 0.000 0.000 ↓ 0.0

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

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

CTE u5_children_registered

68. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=7,173,811.13..7,931,542.56 rows=30,187,550 width=82) (actual rows= loops=)

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

Sort (cost=7,173,811.13..7,264,982.32 rows=36,468,474 width=110) (actual rows= loops=)

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

Hash Join (cost=453,918.92..1,382,476.09 rows=36,468,474 width=110) (actual rows= loops=)

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

Index Scan using useview_population_demographics_chp_area_reported on useview_population_demographics demo_1 (cost=0.58..162,141.67 rows=20,178 width=71) (actual rows= loops=)

  • Index Cond: ((reported >= (((now())::timestamp without time zone - '30 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)
72. 0.000 0.000 ↓ 0.0

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

73. 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=)

74.          

CTE u2_defaulters_treated

75. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=6,357.53..6,357.56 rows=1 width=82) (actual rows= loops=)

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

Sort (cost=6,357.53..6,357.54 rows=1 width=110) (actual rows= loops=)

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

Nested Loop (cost=5,169.08..6,357.52 rows=1 width=110) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Hash Join (cost=5,168.53..6,354.97 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))
79. 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
80. 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=)

81. 0.000 0.000 ↓ 0.0

Hash (cost=2,344.10..2,344.10 rows=616 width=117) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=557.35..2,344.10 rows=616 width=117) (actual rows= loops=)

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

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

  • Index Cond: ((reported >= (((now())::timestamp without time zone - '30 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))
84. 0.000 0.000 ↓ 0.0

Hash (cost=465.33..465.33 rows=7,336 width=36) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

Index Scan using useview_immunization_ug_follow_up_reported on useview_immunization_ug_follow_up (cost=0.31..465.33 rows=7,336 width=36) (actual rows= loops=)

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

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

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

CTE u2_defaulters

88. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=6,030.54..6,030.57 rows=1 width=82) (actual rows= loops=)

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

Sort (cost=6,030.54..6,030.55 rows=1 width=110) (actual rows= loops=)

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

Nested Loop (cost=4,626.38..6,030.53 rows=1 width=110) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,625.82..6,027.98 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))
92. 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
93. 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=)

94. 0.000 0.000 ↓ 0.0

Hash (cost=1,757.89..1,757.89 rows=3,516 width=81) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

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

  • Index Cond: ((reported >= (((now())::timestamp without time zone - '30 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))
96. 0.000 0.000 ↓ 0.0

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

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

Hash Left Join (cost=2,442,637.88..2,553,129.43 rows=196,974 width=296) (actual rows= loops=)

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

Merge Left Join (cost=2,442,637.84..2,549,189.92 rows=196,974 width=164) (actual rows= loops=)

  • Merge Cond: ((chwlist.chw_uuid = u2_children_registered.chw_uuid) AND (chwlist.interval_number = u2_children_registered.interval_number))
99. 0.000 0.000 ↓ 0.0

Sort (cost=830,460.62..830,462.51 rows=755 width=156) (actual rows= loops=)

  • Sort Key: chwlist.chw_uuid, chwlist.interval_number
100. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=259.36..830,424.53 rows=755 width=156) (actual rows= loops=)

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

CTE Scan on u5_children_registered (cost=0.00..603,751.00 rows=30,187,550 width=44) (actual rows= loops=)

102. 0.000 0.000 ↓ 0.0

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

103. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=78.25..259.34 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))
104. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=78.25..259.31 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))
105. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=78.25..259.27 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))
106. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=78.25..259.24 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))
107. 0.000 0.000 ↓ 0.0

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

108. 0.000 0.000 ↓ 0.0

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

109. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=0.04..78.23 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))
110. 0.000 0.000 ↓ 0.0

CTE Scan on chw_immunization_pool (cost=0.00..56.86 rows=2,843 width=44) (actual rows= loops=)

111. 0.000 0.000 ↓ 0.0

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

112. 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))
113. 0.000 0.000 ↓ 0.0

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

114. 0.000 0.000 ↓ 0.0

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

115. 0.000 0.000 ↓ 0.0

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

116. 0.000 0.000 ↓ 0.0

Materialize (cost=1,612,177.22..1,664,463.52 rows=10,457,260 width=44) (actual rows= loops=)

117. 0.000 0.000 ↓ 0.0

Sort (cost=1,612,177.22..1,638,320.37 rows=10,457,260 width=44) (actual rows= loops=)

  • Sort Key: u2_children_registered.chw_uuid, u2_children_registered.interval_number
118. 0.000 0.000 ↓ 0.0

CTE Scan on u2_children_registered (cost=0.00..209,145.20 rows=10,457,260 width=44) (actual rows= loops=)

119. 0.000 0.000 ↓ 0.0

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

120. 0.000 0.000 ↓ 0.0

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