explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wnCr

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

HashAggregate (cost=13,427,902.49..13,427,902.54 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=72,035.21..72,672.03 rows=28,303 width=82) (actual rows= loops=)

  • Group Key: form.chw, form.chw_area, 0
15. 0.000 0.000 ↓ 0.0

Sort (cost=72,035.21..72,105.97 rows=28,303 width=74) (actual rows= loops=)

  • Sort Key: form.chw, form.chw_area
16. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2,324.63..69,942.39 rows=28,303 width=74) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

HashAggregate (cost=2,324.07..2,607.10 rows=28,303 width=40) (actual rows= loops=)

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

Append (cost=0.32..2,182.56 rows=28,303 width=40) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

Index Scan using useview_immunization_ug_reported on useview_immunization_ug i (cost=0.32..1,435.74 rows=20,998 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))
20. 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..463.79 rows=7,305 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.36 rows=1 width=107) (actual rows= loops=)

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

CTE chw_pool

23. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=152,346.95..153,827.76 rows=65,814 width=82) (actual rows= loops=)

  • Group Key: form_1.chw, form_1.chw_area, 0
24. 0.000 0.000 ↓ 0.0

Sort (cost=152,346.95..152,511.48 rows=65,814 width=74) (actual rows= loops=)

  • Sort Key: form_1.chw, form_1.chw_area
25. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4,286.91..147,079.82 rows=65,814 width=74) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

HashAggregate (cost=4,286.35..4,944.49 rows=65,814 width=40) (actual rows= loops=)

  • Group Key: i_1.xmlform_uuid, i_1.reported
27. 0.000 0.000 ↓ 0.0

Append (cost=0.00..3,957.28 rows=65,814 width=40) (actual rows= loops=)

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

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

30. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (uuid = i_1.xmlform_uuid)
31.          

CTE u2_child_numerator

32. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=5,970.62..5,970.65 rows=1 width=82) (actual rows= loops=)

  • Group Key: form_2.chw, form_2.chw_area, 0
33. 0.000 0.000 ↓ 0.0

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

  • Sort Key: form_2.chw, form_2.chw_area
34. 0.000 0.000 ↓ 0.0

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

35. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,565.90..5,968.06 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))
36. 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
37. 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=)

38. 0.000 0.000 ↓ 0.0

Hash (cost=1,698.22..1,698.22 rows=3,500 width=81) (actual rows= loops=)

39. 0.000 0.000 ↓ 0.0

Index Scan using useview_immunization_ug_reported on useview_immunization_ug i_2 (cost=0.32..1,698.22 rows=3,500 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))
40. 0.000 0.000 ↓ 0.0

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

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

CTE u2_children_registered

42. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=2,444,713.59..2,679,554.62 rows=10,437,379 width=82) (actual rows= loops=)

  • Group Key: form_3.chw, demo.chp_area_uuid, 0
43. 0.000 0.000 ↓ 0.0

Sort (cost=2,444,713.59..2,470,807.04 rows=10,437,379 width=110) (actual rows= loops=)

  • Sort Key: form_3.chw, demo.chp_area_uuid
44. 0.000 0.000 ↓ 0.0

Hash Join (cost=586,553.35..881,408.77 rows=10,437,379 width=110) (actual rows= loops=)

  • Hash Cond: (demo.chp_area_uuid = form_3.chw_area)
45. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on useview_population_demographics demo (cost=132,635.02..138,524.46 rows=5,775 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))
46. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=132,635.02..132,635.02 rows=5,775 width=0) (actual rows= loops=)

47. 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)
48. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on useview_population_demographics_chp_area_reported (cost=0.00..104,656.65 rows=73,231 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))
49. 0.000 0.000 ↓ 0.0

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

50. 0.000 0.000 ↓ 0.0

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

51.          

CTE u5_child_numerator

52. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=5,970.62..5,970.65 rows=1 width=82) (actual rows= loops=)

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

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

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

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

55. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,565.90..5,968.06 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))
56. 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
57. 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=)

58. 0.000 0.000 ↓ 0.0

Hash (cost=1,698.22..1,698.22 rows=3,500 width=81) (actual rows= loops=)

59. 0.000 0.000 ↓ 0.0

Index Scan using useview_immunization_ug_reported on useview_immunization_ug i_3 (cost=0.32..1,698.22 rows=3,500 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))
60. 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_3.xmlform_uuid)
61.          

CTE u5_children_registered

62. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=7,160,394.12..7,917,167.37 rows=30,182,100 width=82) (actual rows= loops=)

  • Group Key: form_5.chw, demo_1.chp_area_uuid, 0
63. 0.000 0.000 ↓ 0.0

Sort (cost=7,160,394.12..7,251,384.57 rows=36,396,180 width=110) (actual rows= loops=)

  • Sort Key: form_5.chw, demo_1.chp_area_uuid
64. 0.000 0.000 ↓ 0.0

Hash Join (cost=453,918.92..1,381,060.22 rows=36,396,180 width=110) (actual rows= loops=)

  • Hash Cond: (demo_1.chp_area_uuid = form_5.chw_area)
65. 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,052.84 rows=20,138 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)
66. 0.000 0.000 ↓ 0.0

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

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

68.          

CTE u2_defaulters_treated

69. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=6,348.09..6,348.12 rows=1 width=82) (actual rows= loops=)

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

Sort (cost=6,348.09..6,348.10 rows=1 width=110) (actual rows= loops=)

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

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

72. 0.000 0.000 ↓ 0.0

Hash Join (cost=5,159.08..6,345.53 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))
73. 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
74. 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=)

75. 0.000 0.000 ↓ 0.0

Hash (cost=2,334.75..2,334.75 rows=610 width=117) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=555.41..2,334.75 rows=610 width=117) (actual rows= loops=)

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

Index Scan using useview_immunization_ug_reported on useview_immunization_ug i_4 (cost=0.32..1,750.71 rows=3,500 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))
78. 0.000 0.000 ↓ 0.0

Hash (cost=463.79..463.79 rows=7,305 width=36) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Index Scan using useview_immunization_ug_follow_up_reported on useview_immunization_ug_follow_up (cost=0.31..463.79 rows=7,305 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))
80. 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_4.xmlform_uuid)
81.          

CTE u2_defaulters

82. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=6,023.12..6,023.14 rows=1 width=82) (actual rows= loops=)

  • Group Key: form_7.chw, form_7.chw_area, 0
83. 0.000 0.000 ↓ 0.0

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

  • Sort Key: form_7.chw, form_7.chw_area
84. 0.000 0.000 ↓ 0.0

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

85. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,618.40..6,020.55 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))
86. 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
87. 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=)

88. 0.000 0.000 ↓ 0.0

Hash (cost=1,750.71..1,750.71 rows=3,500 width=81) (actual rows= loops=)

89. 0.000 0.000 ↓ 0.0

Index Scan using useview_immunization_ug_reported on useview_immunization_ug i_5 (cost=0.32..1,750.71 rows=3,500 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))
90. 0.000 0.000 ↓ 0.0

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

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

Hash Left Join (cost=2,446,973.08..2,563,275.08 rows=393,876 width=296) (actual rows= loops=)

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

Merge Left Join (cost=2,446,973.05..2,555,397.53 rows=393,876 width=164) (actual rows= loops=)

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

Merge Left Join (cost=838,004.65..838,110.29 rows=1,509 width=156) (actual rows= loops=)

  • Merge Cond: ((chwlist.chw_uuid = u2_defaulters_treated.chw_uuid) AND (chwlist.interval_number = u2_defaulters_treated.interval_number))
94. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=838,004.62..838,076.30 rows=1,509 width=148) (actual rows= loops=)

  • Merge Cond: ((chwlist.chw_uuid = u5_child_numerator.chw_uuid) AND (chwlist.interval_number = u5_child_numerator.interval_number))
95. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=838,004.59..838,042.32 rows=1,509 width=140) (actual rows= loops=)

  • Merge Cond: ((chwlist.chw_uuid = u2_child_numerator.chw_uuid) AND (chwlist.interval_number = u2_child_numerator.interval_number))
96. 0.000 0.000 ↓ 0.0

Sort (cost=838,004.56..838,008.33 rows=1,509 width=132) (actual rows= loops=)

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

Merge Left Join (cost=837,413.20..837,924.88 rows=1,509 width=132) (actual rows= loops=)

  • Merge Cond: ((chwlist.interval_number = chw_pool.interval_number) AND (chwlist.chw_area_uuid = chw_pool.chw_area_uuid))
98. 0.000 0.000 ↓ 0.0

Sort (cost=830,829.79..830,831.68 rows=755 width=156) (actual rows= loops=)

  • Sort Key: chwlist.interval_number, chwlist.chw_area_uuid
99. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=778.40..830,793.70 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))
100. 0.000 0.000 ↓ 0.0

CTE Scan on u5_children_registered (cost=0.00..603,642.00 rows=30,182,100 width=44) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

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

102. 0.000 0.000 ↓ 0.0

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

CTE Scan on chw_immunization_pool (cost=0.00..566.06 rows=28,303 width=44) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

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

105. 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))
106. 0.000 0.000 ↓ 0.0

Sort (cost=6,583.41..6,747.94 rows=65,814 width=44) (actual rows= loops=)

  • Sort Key: chw_pool.interval_number, chw_pool.chw_area_uuid
107. 0.000 0.000 ↓ 0.0

CTE Scan on chw_pool (cost=0.00..1,316.28 rows=65,814 width=44) (actual rows= loops=)

108. 0.000 0.000 ↓ 0.0

Materialize (cost=0.03..0.04 rows=1 width=44) (actual rows= loops=)

109. 0.000 0.000 ↓ 0.0

Sort (cost=0.03..0.04 rows=1 width=44) (actual rows= loops=)

  • Sort Key: u2_child_numerator.chw_uuid, u2_child_numerator.interval_number
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

Materialize (cost=0.03..0.04 rows=1 width=44) (actual rows= loops=)

112. 0.000 0.000 ↓ 0.0

Sort (cost=0.03..0.04 rows=1 width=44) (actual rows= loops=)

  • Sort Key: u5_child_numerator.chw_uuid, u5_child_numerator.interval_number
113. 0.000 0.000 ↓ 0.0

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

114. 0.000 0.000 ↓ 0.0

Materialize (cost=0.03..0.04 rows=1 width=44) (actual rows= loops=)

115. 0.000 0.000 ↓ 0.0

Sort (cost=0.03..0.04 rows=1 width=44) (actual rows= loops=)

  • Sort Key: u2_defaulters_treated.chw_uuid, u2_defaulters_treated.interval_number
116. 0.000 0.000 ↓ 0.0

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

117. 0.000 0.000 ↓ 0.0

Materialize (cost=1,608,968.40..1,661,155.30 rows=10,437,379 width=44) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

Sort (cost=1,608,968.40..1,635,061.85 rows=10,437,379 width=44) (actual rows= loops=)

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

CTE Scan on u2_children_registered (cost=0.00..208,747.58 rows=10,437,379 width=44) (actual rows= loops=)

120. 0.000 0.000 ↓ 0.0

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

121. 0.000 0.000 ↓ 0.0

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