explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QsvO

Settings
# exclusive inclusive rows x rows loops node
1. 8.413 439,493.212 ↓ 163.0 163 1

GroupAggregate (cost=9,566,823.19..9,566,823.29 rows=1 width=264) (actual time=439,483.816..439,493.212 rows=163 loops=1)

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

CTE chwlist

3. 1.822 168.677 ↓ 5,597.0 5,597 1

Nested Loop (cost=8.80..353.64 rows=1 width=213) (actual time=0.141..168.677 rows=5,597 loops=1)

4. 7.853 150.064 ↓ 5,597.0 5,597 1

Nested Loop Anti Join (cost=8.80..353.59 rows=1 width=201) (actual time=0.128..150.064 rows=5,597 loops=1)

5. 3.951 96.809 ↓ 7,567.0 7,567 1

Nested Loop (cost=8.52..353.27 rows=1 width=201) (actual time=0.113..96.809 rows=7,567 loops=1)

6. 6.305 9.115 ↓ 7,613.0 7,613 1

Hash Join (cost=7.97..350.87 rows=1 width=185) (actual time=0.084..9.115 rows=7,613 loops=1)

  • Hash Cond: (chp.branch_uuid = cmd.uuid)
7. 2.752 2.752 ↑ 1.0 7,616 1

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

8. 0.013 0.058 ↑ 3.8 25 1

Hash (cost=6.79..6.79 rows=94 width=52) (actual time=0.058..0.058 rows=25 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
9. 0.045 0.045 ↑ 3.8 25 1

Index Scan using contactview_metadata_type on contactview_metadata cmd (cost=0.43..6.79 rows=94 width=52) (actual time=0.030..0.045 rows=25 loops=1)

  • Index Cond: (type = 'district_hospital'::text)
10. 83.743 83.743 ↑ 1.0 1 7,613

Index Scan using contactview_metadata_uuid on contactview_metadata cmeta (cost=0.56..2.39 rows=1 width=52) (actual time=0.010..0.011 rows=1 loops=7,613)

  • Index Cond: (uuid = chp.supervisor_uuid)
11. 45.402 45.402 ↓ 0.0 0 7,567

Index Only Scan using chp_muting_chw on chp_muting (cost=0.28..0.30 rows=1 width=36) (actual time=0.006..0.006 rows=0 loops=7,567)

  • Index Cond: (chw = chp.uuid)
  • Heap Fetches: 195
12. 16.791 16.791 ↑ 1.0 1 5,597

Result (cost=0.00..0.03 rows=1 width=12) (actual time=0.003..0.003 rows=1 loops=5,597)

13.          

CTE chw_immunization_pool

14. 16.297 243.712 ↓ 6.0 1,707 1

GroupAggregate (cost=1,618.72..1,624.52 rows=286 width=47) (actual time=221.122..243.712 rows=1,707 loops=1)

  • Group Key: form.chw, 0
15. 64.055 227.415 ↓ 99.9 29,372 1

Sort (cost=1,618.72..1,619.46 rows=294 width=39) (actual time=221.079..227.415 rows=29,372 loops=1)

  • Sort Key: form.chw
  • Sort Method: quicksort Memory: 3063kB
16. 26.126 163.360 ↓ 99.9 29,372 1

Bitmap Heap Scan on form_metadata form (cost=1,300.91..1,606.67 rows=294 width=39) (actual time=139.377..163.360 rows=29,372 loops=1)

  • Recheck Cond: ((formname = ANY ('{immunization_ug,immunization_ug_follow_up}'::text[])) AND (reported >= ((((now())::timestamp without time zone - '1 mon'::interval) + '1 day'::interval))::timestamp without time zone) AND (reported < ((now() + '1 day'::interval))::timestamp without time zone))
  • Heap Blocks: exact=10087
17. 4.742 137.234 ↓ 0.0 0 1

BitmapAnd (cost=1,300.91..1,300.91 rows=294 width=0) (actual time=137.234..137.234 rows=0 loops=1)

18. 13.328 13.328 ↓ 1.8 65,814 1

Bitmap Index Scan on form_metadata_formname (cost=0.00..424.99 rows=36,016 width=0) (actual time=13.328..13.328 rows=65,814 loops=1)

  • Index Cond: (formname = ANY ('{immunization_ug,immunization_ug_follow_up}'::text[]))
19. 119.164 119.164 ↓ 6.9 468,371 1

Bitmap Index Scan on form_metadata_reported (cost=0.00..875.53 rows=68,007 width=0) (actual time=119.164..119.164 rows=468,371 loops=1)

  • Index Cond: ((reported >= ((((now())::timestamp without time zone - '1 mon'::interval) + '1 day'::interval))::timestamp without time zone) AND (reported < ((now() + '1 day'::interval))::timestamp without time zone))
20.          

CTE chw_pool

21. 67.287 364.539 ↑ 2.7 2,029 1

GroupAggregate (cost=35,984.51..36,399.10 rows=5,443 width=47) (actual time=279.221..364.539 rows=2,029 loops=1)

  • Group Key: form_1.chw, 0
22. 177.025 297.252 ↓ 1.8 65,814 1

Sort (cost=35,984.51..36,074.55 rows=36,016 width=39) (actual time=279.065..297.252 rows=65,814 loops=1)

  • Sort Key: form_1.chw
  • Sort Method: quicksort Memory: 8214kB
23. 120.227 120.227 ↓ 1.8 65,814 1

Index Scan using form_metadata_formname on form_metadata form_1 (cost=0.43..33,258.76 rows=36,016 width=39) (actual time=0.277..120.227 rows=65,814 loops=1)

  • Index Cond: (formname = ANY ('{immunization_ug,immunization_ug_follow_up}'::text[]))
24.          

CTE u2_child_numerator

25. 9.733 217.368 ↑ 3.2 1,082 1

GroupAggregate (cost=10,643.59..10,712.23 rows=3,432 width=47) (actual time=205.675..217.368 rows=1,082 loops=1)

  • Group Key: form_2.chw, 0
26. 12.887 207.635 ↓ 1.9 6,418 1

Sort (cost=10,643.59..10,652.17 rows=3,432 width=75) (actual time=205.624..207.635 rows=6,418 loops=1)

  • Sort Key: form_2.chw
  • Sort Method: quicksort Memory: 1095kB
27. 8.355 194.748 ↓ 1.9 6,418 1

Nested Loop (cost=0.87..10,442.04 rows=3,432 width=75) (actual time=0.120..194.748 rows=6,418 loops=1)

28. 38.779 38.779 ↓ 1.9 6,418 1

Index Scan using useview_immunization_ug_reported on useview_immunization_ug i (cost=0.31..1,669.32 rows=3,432 width=73) (actual time=0.081..38.779 rows=6,418 loops=1)

  • Index Cond: ((reported >= ((((now())::timestamp without time zone - '1 mon'::interval) + '1 day'::interval))::timestamp without time zone) AND (reported < ((now() + '1 day'::interval))::timestamp without time zone))
  • Filter: ((NOT (defaulter)::boolean) AND ((patient_age_in_months)::integer <= 23))
  • Rows Removed by Filter: 15513
29. 147.614 147.614 ↑ 1.0 1 6,418

Index Scan using form_metadata_uuid on form_metadata form_2 (cost=0.56..2.55 rows=1 width=72) (actual time=0.023..0.023 rows=1 loops=6,418)

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

CTE u2_children_registered

31. 17,200.311 174,516.821 ↑ 2.1 2,590 1

GroupAggregate (cost=2,319,134.12..2,420,941.77 rows=5,450 width=47) (actual time=54,905.203..174,516.821 rows=2,590 loops=1)

  • Group Key: form_3.chw, 0
32. 119,632.724 157,316.510 ↓ 2.3 23,480,439 1

Sort (cost=2,319,134.12..2,344,572.41 rows=10,175,315 width=75) (actual time=54,869.587..157,316.510 rows=23,480,439 loops=1)

  • Sort Key: form_3.chw
  • Sort Method: external merge Disk: 2056992kB
33. 10,034.504 37,683.786 ↓ 2.3 23,480,439 1

Hash Join (cost=586,553.28..876,442.21 rows=10,175,315 width=75) (actual time=27,598.229..37,683.786 rows=23,480,439 loops=1)

  • Hash Cond: (demo.chp_area_uuid = form_3.chw_area)
34. 56.895 20,063.375 ↓ 2.5 13,892 1

Bitmap Heap Scan on useview_population_demographics demo (cost=132,634.95..138,365.15 rows=5,630 width=71) (actual time=20,009.846..20,063.375 rows=13,892 loops=1)

  • Recheck Cond: ((age_in_months <= 23) AND (reported >= ((((now())::timestamp without time zone - '1 mon'::interval) + '1 day'::interval))::timestamp without time zone) AND (reported < ((now() + '1 day'::interval))::timestamp without time zone))
  • Heap Blocks: exact=12439
35. 28.733 20,006.480 ↓ 0.0 0 1

BitmapAnd (cost=132,634.95..132,634.95 rows=5,630 width=0) (actual time=20,006.480..20,006.480 rows=0 loops=1)

36. 161.297 161.297 ↓ 1.0 197,359 1

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

  • Index Cond: (age_in_months <= 23)
37. 19,816.450 19,816.450 ↓ 1.0 72,037 1

Bitmap Index Scan on useview_population_demographics_chp_area_reported (cost=0.00..104,656.65 rows=71,397 width=0) (actual time=19,816.449..19,816.450 rows=72,037 loops=1)

  • Index Cond: ((reported >= ((((now())::timestamp without time zone - '1 mon'::interval) + '1 day'::interval))::timestamp without time zone) AND (reported < ((now() + '1 day'::interval))::timestamp without time zone))
38. 4,309.667 7,585.907 ↑ 1.0 8,320,173 1

Hash (cost=252,361.26..252,361.26 rows=8,322,326 width=70) (actual time=7,585.907..7,585.907 rows=8,320,173 loops=1)

  • Buckets: 524288 Batches: 32 Memory Usage: 32591kB
39. 3,276.240 3,276.240 ↑ 1.0 8,320,192 1

Seq Scan on form_metadata form_3 (cost=0.00..252,361.26 rows=8,322,326 width=70) (actual time=0.021..3,276.240 rows=8,320,192 loops=1)

40.          

CTE u5_child_numerator

41. 35.520 827.137 ↑ 2.8 1,236 1

GroupAggregate (cost=10,643.59..10,712.23 rows=3,432 width=47) (actual time=788.024..827.137 rows=1,236 loops=1)

  • Group Key: form_4.chw, 0
42. 36.453 791.617 ↓ 4.0 13,723 1

Sort (cost=10,643.59..10,652.17 rows=3,432 width=75) (actual time=787.965..791.617 rows=13,723 loops=1)

  • Sort Key: form_4.chw
  • Sort Method: quicksort Memory: 2314kB
43. 13.600 755.164 ↓ 4.0 13,723 1

Nested Loop (cost=0.87..10,442.04 rows=3,432 width=75) (actual time=0.132..755.164 rows=13,723 loops=1)

44. 69.137 69.137 ↓ 4.0 13,723 1

Index Scan using useview_immunization_ug_reported on useview_immunization_ug i_1 (cost=0.31..1,669.32 rows=3,432 width=73) (actual time=0.103..69.137 rows=13,723 loops=1)

  • Index Cond: ((reported >= ((((now())::timestamp without time zone - '1 mon'::interval) + '1 day'::interval))::timestamp without time zone) AND (reported < ((now() + '1 day'::interval))::timestamp without time zone))
  • Filter: ((NOT (defaulter)::boolean) AND ((patient_age_in_months)::integer <= 59))
  • Rows Removed by Filter: 8208
45. 672.427 672.427 ↑ 1.0 1 13,723

Index Scan using form_metadata_uuid on form_metadata form_4 (cost=0.56..2.55 rows=1 width=72) (actual time=0.048..0.049 rows=1 loops=13,723)

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

CTE u5_children_registered

47. 27,382.165 259,706.150 ↑ 2.0 2,790 1

GroupAggregate (cost=6,713,891.61..7,068,780.85 rows=5,450 width=47) (actual time=54,113.685..259,706.150 rows=2,790 loops=1)

  • Group Key: form_5.chw, 0
48. 205,224.094 232,323.985 ↓ 1.2 41,864,663 1

Sort (cost=6,713,891.61..6,802,600.29 rows=35,483,474 width=75) (actual time=54,108.521..232,323.985 rows=41,864,663 loops=1)

  • Sort Key: form_5.chw
  • Sort Method: external merge Disk: 3666952kB
49. 16,152.814 27,099.891 ↓ 1.2 41,864,663 1

Hash Join (cost=453,918.91..1,363,201.73 rows=35,483,474 width=75) (actual time=8,867.278..27,099.891 rows=41,864,663 loops=1)

  • Hash Cond: (demo_1.chp_area_uuid = form_5.chw_area)
50. 2,115.599 2,115.599 ↓ 1.5 29,020 1

Index Scan using useview_population_demographics_chp_area_reported on useview_population_demographics demo_1 (cost=0.58..160,932.92 rows=19,633 width=71) (actual time=0.321..2,115.599 rows=29,020 loops=1)

  • Index Cond: ((reported >= ((((now())::timestamp without time zone - '1 mon'::interval) + '1 day'::interval))::timestamp without time zone) AND (reported < ((now() + '1 day'::interval))::timestamp without time zone))
  • Filter: (age_in_months <= 59)
  • Rows Removed by Filter: 43017
51. 5,532.795 8,831.478 ↑ 1.0 8,320,173 1

Hash (cost=252,361.26..252,361.26 rows=8,322,326 width=70) (actual time=8,831.478..8,831.478 rows=8,320,173 loops=1)

  • Buckets: 524288 Batches: 32 Memory Usage: 32591kB
52. 3,298.683 3,298.683 ↑ 1.0 8,320,192 1

Seq Scan on form_metadata form_5 (cost=0.00..252,361.26 rows=8,322,326 width=70) (actual time=0.012..3,298.683 rows=8,320,192 loops=1)

53.          

CTE u2_defaulters_treated

54. 4.867 213.568 ↑ 1.1 1,024 1

GroupAggregate (cost=5,736.97..5,760.29 rows=1,166 width=47) (actual time=207.928..213.568 rows=1,024 loops=1)

  • Group Key: form_6.chw, 0
55. 18.145 208.701 ↓ 3.2 3,722 1

Sort (cost=5,736.97..5,739.89 rows=1,166 width=75) (actual time=207.906..208.701 rows=3,722 loops=1)

  • Sort Key: form_6.chw
  • Sort Method: quicksort Memory: 620kB
56. 3.877 190.556 ↓ 3.2 3,722 1

Nested Loop (cost=930.41..5,677.58 rows=1,166 width=75) (actual time=38.819..190.556 rows=3,722 loops=1)

57. 3.556 89.907 ↓ 3.2 3,722 1

Hash Semi Join (cost=929.85..2,697.10 rows=1,166 width=73) (actual time=38.753..89.907 rows=3,722 loops=1)

  • Hash Cond: (i_2.id = useview_immunization_ug_follow_up.patient_id)
58. 48.086 48.086 ↓ 1.3 4,407 1

Index Scan using useview_immunization_ug_reported on useview_immunization_ug i_2 (cost=0.31..1,720.81 rows=3,432 width=73) (actual time=0.203..48.086 rows=4,407 loops=1)

  • Index Cond: ((reported >= ((((now())::timestamp without time zone - '1 mon'::interval) + '1 day'::interval))::timestamp without time zone) AND (reported < ((now() + '1 day'::interval))::timestamp without time zone))
  • Filter: ((patient_age_in_months <> ''::text) AND (defaulter)::boolean AND ((patient_age_in_months)::integer <= 23))
  • Rows Removed by Filter: 17524
59. 17.944 38.265 ↑ 1.0 15,535 1

Hash (cost=735.35..735.35 rows=15,535 width=36) (actual time=38.265..38.265 rows=15,535 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1175kB
60. 20.321 20.321 ↑ 1.0 15,535 1

Seq Scan on useview_immunization_ug_follow_up (cost=0.00..735.35 rows=15,535 width=36) (actual time=0.014..20.321 rows=15,535 loops=1)

61. 96.772 96.772 ↑ 1.0 1 3,722

Index Scan using form_metadata_uuid on form_metadata form_6 (cost=0.56..2.55 rows=1 width=72) (actual time=0.026..0.026 rows=1 loops=3,722)

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

CTE u2_defaulters

63. 6.376 201.429 ↑ 2.9 1,175 1

GroupAggregate (cost=10,695.07..10,763.71 rows=3,432 width=47) (actual time=194.304..201.429 rows=1,175 loops=1)

  • Group Key: form_7.chw, 0
64. 9.356 195.053 ↓ 1.3 4,407 1

Sort (cost=10,695.07..10,703.65 rows=3,432 width=75) (actual time=194.284..195.053 rows=4,407 loops=1)

  • Sort Key: form_7.chw
  • Sort Method: quicksort Memory: 812kB
65. 5.797 185.697 ↓ 1.3 4,407 1

Nested Loop (cost=0.87..10,493.53 rows=3,432 width=75) (actual time=0.146..185.697 rows=4,407 loops=1)

66. 38.876 38.876 ↓ 1.3 4,407 1

Index Scan using useview_immunization_ug_reported on useview_immunization_ug i_3 (cost=0.31..1,720.81 rows=3,432 width=73) (actual time=0.109..38.876 rows=4,407 loops=1)

  • Index Cond: ((reported >= ((((now())::timestamp without time zone - '1 mon'::interval) + '1 day'::interval))::timestamp without time zone) AND (reported < ((now() + '1 day'::interval))::timestamp without time zone))
  • Filter: ((patient_age_in_months <> ''::text) AND (defaulter)::boolean AND ((patient_age_in_months)::integer <= 23))
  • Rows Removed by Filter: 17524
67. 141.024 141.024 ↑ 1.0 1 4,407

Index Scan using form_metadata_uuid on form_metadata form_7 (cost=0.56..2.55 rows=1 width=72) (actual time=0.032..0.032 rows=1 loops=4,407)

  • Index Cond: (uuid = i_3.xmlform_uuid)
68. 15.494 439,484.799 ↓ 5,488.0 5,488 1

Sort (cost=774.86..774.86 rows=1 width=296) (actual time=439,483.755..439,484.799 rows=5,488 loops=1)

  • Sort Key: chwlist.branch_uuid, chwlist.branch_name, chwlist.supervisor_uuid, chwlist.supervisor_name, (date(chwlist.interval_start)), chwlist.interval_number
  • Sort Method: quicksort Memory: 1650kB
69. 4.550 439,469.305 ↓ 5,488.0 5,488 1

Hash Right Join (cost=680.46..774.85 rows=1 width=296) (actual time=439,456.908..439,469.305 rows=5,488 loops=1)

  • Hash Cond: ((u2_defaulters.chw_uuid = chwlist.chw_uuid) AND (u2_defaulters.interval_number = chwlist.interval_number))
70. 202.184 202.184 ↑ 2.9 1,175 1

CTE Scan on u2_defaulters (cost=0.00..68.64 rows=3,432 width=44) (actual time=194.312..202.184 rows=1,175 loops=1)

71. 8.503 439,262.571 ↓ 5,488.0 5,488 1

Hash (cost=680.44..680.44 rows=1 width=228) (actual time=439,262.571..439,262.571 rows=5,488 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1173kB
72. 1,622.379 439,254.068 ↓ 5,488.0 5,488 1

Nested Loop Left Join (cost=520.55..680.44 rows=1 width=228) (actual time=230,768.946..439,254.068 rows=5,488 loops=1)

  • Join Filter: ((chwlist.chw_uuid = chw_immunization_pool.chw_uuid) AND (chwlist.interval_number = chw_immunization_pool.interval_number))
  • Rows Removed by Join Filter: 9366316
73. 12.228 436,133.465 ↓ 5,488.0 5,488 1

Hash Right Join (cost=520.55..670.43 rows=1 width=220) (actual time=230,523.643..436,133.465 rows=5,488 loops=1)

  • Hash Cond: ((u5_children_registered.chw_uuid = chwlist.chw_uuid) AND (u5_children_registered.interval_number = chwlist.interval_number))
74. 259,711.305 259,711.305 ↑ 2.0 2,790 1

CTE Scan on u5_children_registered (cost=0.00..109.00 rows=5,450 width=44) (actual time=54,113.688..259,711.305 rows=2,790 loops=1)

75. 7.415 176,409.932 ↓ 5,488.0 5,488 1

Hash (cost=520.53..520.53 rows=1 width=212) (actual time=176,409.932..176,409.932 rows=5,488 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1137kB
76. 11.970 176,402.517 ↓ 5,488.0 5,488 1

Hash Right Join (cost=370.65..520.53 rows=1 width=212) (actual time=56,773.129..176,402.517 rows=5,488 loops=1)

  • Hash Cond: ((u2_children_registered.chw_uuid = chwlist.chw_uuid) AND (u2_children_registered.interval_number = chwlist.interval_number))
77. 174,522.646 174,522.646 ↑ 2.1 2,590 1

CTE Scan on u2_children_registered (cost=0.00..109.00 rows=5,450 width=44) (actual time=54,905.204..174,522.646 rows=2,590 loops=1)

78. 4.708 1,867.901 ↓ 5,488.0 5,488 1

Hash (cost=370.63..370.63 rows=1 width=204) (actual time=1,867.901..1,867.901 rows=5,488 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1110kB
79. 3.474 1,863.193 ↓ 5,488.0 5,488 1

Hash Right Join (cost=220.94..370.63 rows=1 width=204) (actual time=1,760.499..1,863.193 rows=5,488 loops=1)

  • Hash Cond: ((chw_pool.chw_uuid = chwlist.chw_uuid) AND (chw_pool.interval_number = chwlist.interval_number))
80. 378.462 378.462 ↑ 2.7 2,029 1

CTE Scan on chw_pool (cost=0.00..108.86 rows=5,443 width=44) (actual time=279.224..378.462 rows=2,029 loops=1)

81. 7.461 1,481.257 ↓ 5,488.0 5,488 1

Hash (cost=220.93..220.93 rows=1 width=196) (actual time=1,481.257..1,481.257 rows=5,488 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1092kB
82. 2.894 1,473.796 ↓ 5,488.0 5,488 1

Hash Right Join (cost=126.53..220.93 rows=1 width=196) (actual time=1,430.867..1,473.796 rows=5,488 loops=1)

  • Hash Cond: ((u5_child_numerator.chw_uuid = chwlist.chw_uuid) AND (u5_child_numerator.interval_number = chwlist.interval_number))
83. 828.086 828.086 ↑ 2.8 1,236 1

CTE Scan on u5_child_numerator (cost=0.00..68.64 rows=3,432 width=44) (actual time=788.028..828.086 rows=1,236 loops=1)

84. 11.043 642.816 ↓ 5,488.0 5,488 1

Hash (cost=126.52..126.52 rows=1 width=188) (actual time=642.816..642.816 rows=5,488 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1082kB
85. 2.833 631.773 ↓ 5,488.0 5,488 1

Hash Right Join (cost=32.13..126.52 rows=1 width=188) (actual time=612.479..631.773 rows=5,488 loops=1)

  • Hash Cond: ((u2_child_numerator.chw_uuid = chwlist.chw_uuid) AND (u2_child_numerator.interval_number = chwlist.interval_number))
86. 222.161 222.161 ↑ 3.2 1,082 1

CTE Scan on u2_child_numerator (cost=0.00..68.64 rows=3,432 width=44) (actual time=205.678..222.161 rows=1,082 loops=1)

87. 5.136 406.779 ↓ 5,488.0 5,488 1

Hash (cost=32.11..32.11 rows=1 width=180) (actual time=406.779..406.779 rows=5,488 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1032kB
88. 3.218 401.643 ↓ 5,488.0 5,488 1

Hash Right Join (cost=0.04..32.11 rows=1 width=180) (actual time=392.194..401.643 rows=5,488 loops=1)

  • Hash Cond: ((u2_defaulters_treated.chw_uuid = chwlist.chw_uuid) AND (u2_defaulters_treated.interval_number = chwlist.interval_number))
89. 214.185 214.185 ↑ 1.1 1,024 1

CTE Scan on u2_defaulters_treated (cost=0.00..23.32 rows=1,166 width=44) (actual time=207.931..214.185 rows=1,024 loops=1)

90. 4.709 184.240 ↓ 5,488.0 5,488 1

Hash (cost=0.03..0.03 rows=1 width=172) (actual time=184.240..184.240 rows=5,488 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1018kB
91. 179.531 179.531 ↓ 5,488.0 5,488 1

CTE Scan on chwlist (cost=0.00..0.03 rows=1 width=172) (actual time=0.148..179.531 rows=5,488 loops=1)

  • Filter: ((branch_name <> 'HQ'::text) AND (branch_name <> 'HQ OVC'::text))
  • Rows Removed by Filter: 109
92. 1,498.224 1,498.224 ↓ 6.0 1,707 5,488

CTE Scan on chw_immunization_pool (cost=0.00..5.72 rows=286 width=44) (actual time=0.041..0.273 rows=1,707 loops=5,488)

Planning time : 61.421 ms
Execution time : 440,431.307 ms