explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vHfB

Settings
# exclusive inclusive rows x rows loops node
1. 162.772 41,756.428 ↑ 3.6 114,358 1

Merge Join (cost=850,011.53..878,870.55 rows=409,835 width=1,451) (actual time=38,459.163..41,756.428 rows=114,358 loops=1)

2. 119.352 40,878.358 ↑ 3.6 114,358 1

Merge Join (cost=807,106.43..829,817.91 rows=409,835 width=1,281) (actual time=37,745.412..40,878.358 rows=114,358 loops=1)

3. 69.445 40,038.152 ↑ 3.6 114,358 1

Merge Join (cost=807,106.01..821,216.76 rows=409,835 width=1,275) (actual time=37,743.291..40,038.152 rows=114,358 loops=1)

4. 89.358 39,967.488 ↑ 3.6 114,358 1

Merge Join (cost=806,397.76..819,478.68 rows=409,835 width=1,269) (actual time=37,742.197..39,967.488 rows=114,358 loops=1)

5. 82.408 39,773.782 ↑ 3.6 114,358 1

Merge Join (cost=802,281.57..813,917.88 rows=409,835 width=1,263) (actual time=37,642.771..39,773.782 rows=114,358 loops=1)

6. 69.954 39,633.312 ↑ 3.6 114,358 1

Merge Join (cost=799,616.49..809,986.73 rows=409,835 width=1,257) (actual time=37,587.509..39,633.312 rows=114,358 loops=1)

7. 140.415 39,547.332 ↑ 3.6 114,358 1

Merge Join (cost=798,273.32..807,548.81 rows=409,835 width=1,251) (actual time=37,572.693..39,547.332 rows=114,358 loops=1)

8. 65.404 32,042.207 ↑ 3.6 114,358 1

Merge Join (cost=649,130.2..656,851.17 rows=409,835 width=227) (actual time=31,701.215..32,042.207 rows=114,358 loops=1)

9. 82.414 31,894.442 ↑ 3.6 114,358 1

Merge Join (cost=593,311.82..596,385.63 rows=409,835 width=195) (actual time=31,623.83..31,894.442 rows=114,358 loops=1)

10. 624.529 4,885.656 ↑ 3.6 114,358 1

Sort (cost=399,876.73..400,901.31 rows=409,835 width=131) (actual time=4,700.745..4,885.656 rows=114,358 loops=1)

  • Sort Key: se.per_id, se.stu_enr_fiscal_year
  • Sort Method: external merge Disk: 13536kB
11. 660.095 4,261.127 ↑ 3.6 114,358 1

Hash Join (cost=63,433.49..305,635.51 rows=409,835 width=131) (actual time=841.017..4,261.127 rows=114,358 loops=1)

12. 218.076 3,321.385 ↓ 1.0 615,337 1

Hash Join (cost=35,598.78..237,413.95 rows=614,752 width=131) (actual time=559.965..3,321.385 rows=615,337 loops=1)

13. 480.689 3,103.252 ↓ 1.0 615,337 1

Hash Join (cost=35,592.71..212,753.17 rows=614,752 width=129) (actual time=559.891..3,103.252 rows=615,337 loops=1)

14. 194.498 2,063.394 ↓ 1.0 615,337 1

Hash Join (cost=46.06..160,811.96 rows=614,752 width=47) (actual time=0.418..2,063.394 rows=615,337 loops=1)

15. 374.824 1,868.868 ↓ 1.0 615,337 1

Hash Join (cost=41.71..152,354.77 rows=614,752 width=45) (actual time=0.379..1,868.868 rows=615,337 loops=1)

16. 444.602 1,493.725 ↓ 1.0 615,337 1

Merge Join (cost=12.58..100,242.57 rows=614,752 width=49) (actual time=0.047..1,493.725 rows=615,337 loops=1)

17. 129.164 724.332 ↓ 1.0 615,336 1

Merge Join (cost=0.71..50,988.34 rows=614,752 width=42) (actual time=0.037..724.332 rows=615,336 loops=1)

18. 152.553 594.587 ↓ 1.0 615,336 1

Merge Join (cost=0.57..49,394.26 rows=614,752 width=40) (actual time=0.024..594.587 rows=615,336 loops=1)

19. 441.805 441.805 ↓ 1.0 615,336 1

Index Scan using i_ibm_se_per_date on student_enrollment se (cost=0.42..47,827.86 rows=614,752 width=38) (actual time=0.011..441.805 rows=615,336 loops=1)

  • Filter: ((stu_enr_status)::text = ANY ('{E,N,W}'::text[]))
20. 0.039 0.229 ↓ 5.1 365 1

Materialize (cost=0.14..19.77 rows=71 width=13) (actual time=0.011..0.229 rows=365 loops=1)

21. 0.070 0.190 ↑ 1.0 71 1

Nested Loop (cost=0.14..19.59 rows=71 width=13) (actual time=0.01..0.19 rows=71 loops=1)

22. 0.049 0.049 ↑ 1.0 71 1

Index Scan using pk_student_milt_cnctd on student_milt_cnctd smc (cost=0.14..13.21 rows=71 width=13) (actual time=0.003..0.049 rows=71 loops=1)

23. 0.067 0.071 ↑ 1.0 5 71

Materialize (cost=0..1.07 rows=5 width=4) (actual time=0..0.001 rows=5 loops=71)

24. 0.004 0.004 ↑ 1.0 5 1

Seq Scan on rfd_milt_cnctd_student mcs (cost=0..1.05 rows=5 width=4) (actual time=0.002..0.004 rows=5 loops=1)

25. 0.138 0.581 ↓ 5.9 1,220 1

Materialize (cost=0.14..28.71 rows=208 width=13) (actual time=0.012..0.581 rows=1,220 loops=1)

26. 0.339 0.443 ↑ 1.0 208 1

Nested Loop (cost=0.14..28.19 rows=208 width=13) (actual time=0.011..0.443 rows=208 loops=1)

27. 0.104 0.104 ↑ 1.0 208 1

Index Scan using ifk_ri_c_5788 on student_in_foster_care sfc (cost=0.14..17.79 rows=208 width=13) (actual time=0.004..0.104 rows=208 loops=1)

28. 0.000 0.000 ↑ 1.0 3 208

Materialize (cost=0..1.04 rows=3 width=4) (actual time=0..0 rows=3 loops=208)

29. 0.003 0.003 ↑ 1.0 3 1

Seq Scan on rfd_foster_care_indicator fci (cost=0..1.03 rows=3 width=4) (actual time=0.001..0.003 rows=3 loops=1)

30. 324.791 324.791 ↓ 1.0 598,951 1

Index Scan using idbi_140401_001_student_exit_004 on student_exit sx (cost=0.42..41,509.29 rows=598,917 width=30) (actual time=0.004..324.791 rows=598,951 loops=1)

31. 0.208 0.319 ↑ 1.0 885 1

Hash (cost=15.85..15.85 rows=885 width=11) (actual time=0.319..0.319 rows=885 loops=1)

32. 0.111 0.111 ↑ 1.0 885 1

Seq Scan on rfds_exit rx (cost=0..15.85 rows=885 width=11) (actual time=0.004..0.111 rows=885 loops=1)

33. 0.009 0.028 ↑ 1.0 60 1

Hash (cost=3.6..3.6 rows=60 width=6) (actual time=0.028..0.028 rows=60 loops=1)

34. 0.019 0.019 ↑ 1.0 60 1

Seq Scan on campus c (cost=0..3.6 rows=60 width=6) (actual time=0.004..0.019 rows=60 loops=1)

35. 55.459 559.169 ↑ 1.0 116,002 1

Hash (cost=32,396.63..32,396.63 rows=116,002 width=89) (actual time=559.169..559.169 rows=116,002 loops=1)

36. 33.089 503.710 ↑ 1.0 116,002 1

Hash Join (cost=231.36..32,396.63 rows=116,002 width=89) (actual time=2.905..503.71 rows=116,002 loops=1)

37. 26.058 470.615 ↑ 1.0 116,002 1

Hash Join (cost=230.22..31,742.63 rows=116,002 width=94) (actual time=2.892..470.615 rows=116,002 loops=1)

38. 25.841 444.546 ↑ 1.0 116,002 1

Hash Join (cost=228.59..30,985.56 rows=116,002 width=94) (actual time=2.876..444.546 rows=116,002 loops=1)

39. 33.295 418.663 ↑ 1.0 116,002 1

Hash Join (cost=224.4..30,139.26 rows=116,002 width=94) (actual time=2.829..418.663 rows=116,002 loops=1)

40. 192.378 385.322 ↑ 1.0 116,002 1

Merge Join (cost=220.2..28,540.58 rows=116,002 width=94) (actual time=2.773..385.322 rows=116,002 loops=1)

41. 163.112 163.112 ↑ 1.0 446,124 1

Index Scan using xpkperson on person p (cost=0.42..20,328.48 rows=450,991 width=57) (actual time=0.006..163.112 rows=446,124 loops=1)

42. 29.832 29.832 ↑ 1.0 116,002 1

Index Scan using xpkstudent on student s (cost=0.42..5,970.62 rows=116,002 width=37) (actual time=0.004..29.832 rows=116,002 loops=1)

43. 0.024 0.046 ↑ 1.0 142 1

Hash (cost=2.42..2.42 rows=142 width=6) (actual time=0.046..0.046 rows=142 loops=1)

44. 0.022 0.022 ↑ 1.0 142 1

Seq Scan on rfd_language lng (cost=0..2.42 rows=142 width=6) (actual time=0.007..0.022 rows=142 loops=1)

45. 0.026 0.042 ↑ 1.0 142 1

Hash (cost=2.42..2.42 rows=142 width=6) (actual time=0.042..0.042 rows=142 loops=1)

46. 0.016 0.016 ↑ 1.0 142 1

Seq Scan on rfd_language slng (cost=0..2.42 rows=142 width=6) (actual time=0.003..0.016 rows=142 loops=1)

47. 0.007 0.011 ↑ 1.0 28 1

Hash (cost=1.28..1.28 rows=28 width=6) (actual time=0.011..0.011 rows=28 loops=1)

48. 0.004 0.004 ↑ 1.0 28 1

Seq Scan on rfd_graduation_plan gp (cost=0..1.28 rows=28 width=6) (actual time=0.002..0.004 rows=28 loops=1)

49. 0.003 0.006 ↑ 1.0 6 1

Hash (cost=1.06..1.06 rows=6 width=9) (actual time=0.006..0.006 rows=6 loops=1)

50. 0.003 0.003 ↑ 1.0 6 1

Seq Scan on rfd_ethnicity eth (cost=0..1.06 rows=6 width=9) (actual time=0.002..0.003 rows=6 loops=1)

51. 0.036 0.057 ↑ 1.0 163 1

Hash (cost=3.63..3.63 rows=163 width=8) (actual time=0.057..0.057 rows=163 loops=1)

52. 0.021 0.021 ↑ 1.0 163 1

Seq Scan on rfd_ada ada (cost=0..3.63 rows=163 width=8) (actual time=0.007..0.021 rows=163 loops=1)

53. 111.467 279.647 ↓ 1.0 615,336 1

Hash (cost=17,148.31..17,148.31 rows=614,752 width=15) (actual time=279.647..279.647 rows=615,336 loops=1)

54. 168.180 168.180 ↓ 1.0 615,336 1

Seq Scan on student_enrollment sechk (cost=0..17,148.31 rows=614,752 width=15) (actual time=0.09..168.18 rows=615,336 loops=1)

  • Filter: ((stu_enr_status)::text = ANY ('{E,N,W}'::text[]))
55. 0.504 26,926.372 ↓ 1,701.0 1,701 1

Materialize (cost=193,435.09..193,435.13 rows=1 width=75) (actual time=26,923.079..26,926.372 rows=1,701 loops=1)

56. 2.141 26,925.868 ↓ 1,701.0 1,701 1

Aggregate (cost=193,435.09..193,435.12 rows=1 width=79) (actual time=26,923.077..26,925.868 rows=1,701 loops=1)

57. 7.549 26,923.727 ↓ 3,402.0 3,402 1

Sort (cost=193,435.09..193,435.1 rows=1 width=15) (actual time=26,923.067..26,923.727 rows=3,402 loops=1)

  • Sort Key: sdtv.per_id, sdtv.stu_enr_fiscal_year
  • Sort Method: quicksort Memory: 256kB
58. 0.427 26,916.178 ↓ 3,402.0 3,402 1

Hash Join (cost=193,433.99..193,435.08 rows=1 width=15) (actual time=26,915.767..26,916.178 rows=3,402 loops=1)

59. 0.003 0.003 ↑ 1.0 6 1

Seq Scan on rfd_homeless_status hs (cost=0..1.06 rows=6 width=39) (actual time=0.003..0.003 rows=6 loops=1)

60. 0.705 26,915.748 ↓ 3,402.0 3,402 1

Hash (cost=193,433.97..193,433.97 rows=1 width=47) (actual time=26,915.748..26,915.748 rows=3,402 loops=1)

61. 0.604 26,915.043 ↓ 3,402.0 3,402 1

Merge Join (cost=193,433.93..193,433.97 rows=1 width=47) (actual time=26,914.141..26,915.043 rows=3,402 loops=1)

62. 1.117 26,914.379 ↓ 3,402.0 3,402 1

Sort (cost=193,432.82..193,432.83 rows=1 width=45) (actual time=26,914.107..26,914.379 rows=3,402 loops=1)

  • Sort Key: sdtv.stu_dt_trk_value
  • Sort Method: quicksort Memory: 429kB
63. 3.795 26,913.262 ↓ 3,402.0 3,402 1

Subquery Scan on sdtv (cost=193,432.77..193,432.81 rows=1 width=45) (actual time=26,879.328..26,913.262 rows=3,402 loops=1)

  • Filter: (sdtv.row_num = 1)
64. 22.020 26,909.467 ↓ 55,518.0 55,518 1

WindowAgg (cost=193,432.77..193,432.8 rows=1 width=69) (actual time=26,879.314..26,909.467 rows=55,518 loops=1)

65. 258.289 26,887.447 ↓ 55,518.0 55,518 1

Sort (cost=193,432.77..193,432.78 rows=1 width=53) (actual time=26,879.307..26,887.447 rows=55,518 loops=1)

  • Sort Key: student_date_tracked_value.per_id, student_date_tracked_value.rfds_dt_track_field_nm, minenryr.stu_enr_fiscal_year DESC, student_date_tracked_value.stu_dt_trk_eff_date DESC
  • Sort Method: external sort Disk: 4248kB
66. 1,675.838 26,629.158 ↓ 55,518.0 55,518 1

Nested Loop (cost=96,821.87..193,432.76 rows=1 width=53) (actual time=4,119.125..26,629.158 rows=55,518 loops=1)

67. 1,271.872 7,352.492 ↓ 2,514,404.0 2,514,404 1

Hash Join (cost=96,821.45..193,423.66 rows=1 width=42) (actual time=2,593.045..7,352.492 rows=2,514,404 loops=1)

68. 1,018.274 6,032.890 ↓ 29,719.6 4,190,470 1

Merge Join (cost=92,289.8..188,519.76 rows=141 width=44) (actual time=2,544.196..6,032.89 rows=4,190,470 loops=1)

69. 74.941 3,886.303 ↓ 178.3 558,930 1

Subquery Scan on maxenryr (cost=92,289.37..114,226.88 rows=3,134 width=25) (actual time=2,544.154..3,886.303 rows=558,930 loops=1)

  • Filter: (maxenryr.rnumb = 1)
70. 382.931 3,811.362 ↑ 1.0 626,786 1

WindowAgg (cost=92,289.37..106,392.06 rows=626,786 width=41) (actual time=2,544.148..3,811.362 rows=626,786 loops=1)

71. 3,318.391 3,428.431 ↑ 1.0 626,786 1

Sort (cost=92,289.37..93,856.34 rows=626,786 width=33) (actual time=2,544.141..3,428.431 rows=626,786 loops=1)

  • Sort Key: student_enrollment.per_id, student_enrollment.stu_enr_fiscal_year, student_enrollment.stu_enr_entry_date DESC
  • Sort Method: external merge Disk: 30360kB
72. 110.040 110.040 ↑ 1.0 626,786 1

Seq Scan on student_enrollment student_enrollment (cost=0..14,797.86 rows=626,786 width=33) (actual time=0.08..110.04 rows=626,786 loops=1)

73. 289.509 1,128.313 ↓ 1,337.1 4,190,470 1

Materialize (cost=0.42..74,275.8 rows=3,134 width=19) (actual time=0.037..1,128.313 rows=4,190,470 loops=1)

74. 70.188 838.804 ↓ 178.3 558,930 1

Subquery Scan on minenryr (cost=0.42..74,267.96 rows=3,134 width=19) (actual time=0.036..838.804 rows=558,930 loops=1)

  • Filter: (minenryr.rnumb = 1)
75. 387.808 768.616 ↑ 1.0 626,786 1

WindowAgg (cost=0.42..66,433.14 rows=626,786 width=27) (actual time=0.03..768.616 rows=626,786 loops=1)

76. 380.808 380.808 ↑ 1.0 626,786 1

Index Only Scan using idbi_121015_008_student_enrollment_005 on student_enrollment student_enrollment_1 (cost=0.42..53,897.42 rows=626,786 width=19) (actual time=0.022..380.808 rows=626,786 loops=1)

77. 0.097 47.730 ↑ 13.7 511 1

Hash (cost=4,408.78..4,408.78 rows=7,021 width=18) (actual time=47.73..47.73 rows=511 loops=1)

78. 23.928 47.633 ↑ 13.7 511 1

Aggregate (cost=4,268.36..4,338.57 rows=7,021 width=18) (actual time=47.545..47.633 rows=511 loops=1)

79. 23.705 23.705 ↓ 1.0 89,326 1

Seq Scan on student_calendar_date student_calendar_date (cost=0..3,378.21 rows=89,015 width=18) (actual time=0.131..23.705 rows=89,326 loops=1)

  • Filter: ((student_cal_date_type)::text = 'Instructional'::text)
80. 17,600.828 17,600.828 ↓ 0.0 0 2,514,404

Index Scan using xpkstudent_date_tr on student_date_tracked_value student_date_tracked_value (cost=0.42..9.09 rows=1 width=49) (actual time=0.007..0.007 rows=0 loops=2,514,404)

  • Index Cond: (((per_id)::text = (minenryr.per_id)::text) AND (stu_dt_trk_eff_date >= minenryr.stu_enr_entry_date) AND (stu_dt_trk_eff_date <= COALESCE(maxenryr.stu_enrlast_enrolled_date, (max(student_calendar_date.student_cal_date)))))
  • Filter: ((rfds_dt_track_field_nm)::text = ANY ('{"Homeless Status","Unaccompanied Youth Status"}'::text[]))
81. 0.051 0.060 ↓ 108.4 542 1

Sort (cost=1.11..1.12 rows=5 width=42) (actual time=0.026..0.06 rows=542 loops=1)

  • Sort Key: uys.rfd_unacmp_yth_sts_nm
  • Sort Method: quicksort Memory: 25kB
82. 0.009 0.009 ↑ 1.0 5 1

Seq Scan on rfd_unacmp_yth_status uys (cost=0..1.05 rows=5 width=42) (actual time=0.008..0.009 rows=5 loops=1)

83. 0.724 82.361 ↑ 8.2 4,032 1

Materialize (cost=55,818.38..56,871.29 rows=33,217 width=39) (actual time=77.382..82.361 rows=4,032 loops=1)

84. 3.262 81.637 ↑ 8.2 4,032 1

Aggregate (cost=55,818.38..56,456.08 rows=33,217 width=39) (actual time=77.38..81.637 rows=4,032 loops=1)

85. 13.625 78.375 ↑ 8.4 4,877 1

Sort (cost=55,818.38..55,920.22 rows=40,737 width=9) (actual time=77.374..78.375 rows=4,877 loops=1)

  • Sort Key: sc.per_id
  • Sort Method: quicksort Memory: 421kB
86. 1.558 64.750 ↑ 8.4 4,877 1

Merge Join (cost=1.4..52,699.14 rows=40,737 width=9) (actual time=1.408..64.75 rows=4,877 loops=1)

87. 0.623 62.892 ↑ 11.1 4,878 1

Nested Loop (cost=1.27..405,050.58 rows=54,316 width=9) (actual time=1.393..62.892 rows=4,878 loops=1)

88. 3.799 37.879 ↑ 17.5 4,878 1

Nested Loop (cost=0.85..355,991.58 rows=85,143 width=31) (actual time=1.375..37.879 rows=4,878 loops=1)

89. 1.338 1.338 ↑ 7.2 5,457 1

Index Scan using ifk_f_course_may_be_ct on district_course_catalog dcc (cost=0.29..5,054.91 rows=39,150 width=11) (actual time=0.011..1.338 rows=5,457 loops=1)

90. 32.742 32.742 ↑ 13.0 1 5,457

Index Scan using idbi_121025_003_student_class_022 on student_class sc (cost=0.56..8.83 rows=13 width=20) (actual time=0.006..0.006 rows=1 loops=5,457)

  • Index Cond: (((dist_course_id)::text = (dcc.dist_course_id)::text) AND (dist_course_fiscal_year = dcc.dist_course_fiscal_year) AND (stu_class_exit_date >= now()) AND (stu_class_enter_date <= now()))
91. 24.390 24.390 ↑ 1.0 1 4,878

Index Only Scan using xpklocation_course on location_course_catalog lcc (cost=0.42..0.57 rows=1 width=13) (actual time=0.005..0.005 rows=1 loops=4,878)

  • Index Cond: ((dist_course_id = (sc.dist_course_id)::text) AND (loc_id = (sc.loc_id)::text) AND (dist_course_fiscal_year = sc.dist_course_fiscal_year))
92. 0.289 0.300 ↓ 1,626.0 4,878 1

Materialize (cost=0.13..12.21 rows=3 width=4) (actual time=0.012..0.3 rows=4,878 loops=1)

93. 0.011 0.011 ↑ 1.0 3 1

Index Scan using xpkrfd_career_tech on rfd_career_tech_indicator ctec (cost=0.13..12.2 rows=3 width=4) (actual time=0.009..0.011 rows=3 loops=1)

  • Filter: ((rfs_p_career_tech_ind_code)::text <> '0'::text)
94. 30.558 7,364.710 ↓ 42.2 83,535 1

Materialize (cost=149,143.12..149,519.96 rows=1,979 width=1,031) (actual time=5,871.475..7,364.71 rows=83,535 loops=1)

95. 1,098.627 7,334.152 ↓ 42.2 83,532 1

Aggregate (cost=149,143.12..149,495.22 rows=1,979 width=1,031) (actual time=5,871.473..7,334.152 rows=83,532 loops=1)

96. 1,259.186 6,235.525 ↓ 115.9 233,400 1

Sort (cost=149,143.12..149,148.16 rows=2,014 width=76) (actual time=5,871.416..6,235.525 rows=233,400 loops=1)

  • Sort Key: sdtv_1.per_id
  • Sort Method: external merge Disk: 14024kB
97. 63.093 4,976.339 ↓ 115.9 233,400 1

Merge Join (cost=148,932.56..149,032.59 rows=2,014 width=76) (actual time=4,120..4,976.339 rows=233,400 loops=1)

98. 45.074 4,901.316 ↓ 115.9 233,400 1

Merge Join (cost=148,931.3..149,025 rows=2,014 width=74) (actual time=4,119.986..4,901.316 rows=233,400 loops=1)

99. 45.535 4,856.164 ↓ 115.9 233,400 1

Merge Join (cost=148,930.22..149,018.36 rows=2,014 width=71) (actual time=4,119.976..4,856.164 rows=233,400 loops=1)

100. 44.801 4,810.593 ↓ 115.9 233,400 1

Merge Join (cost=148,928.81..149,010.11 rows=2,014 width=68) (actual time=4,119.945..4,810.593 rows=233,400 loops=1)

101. 61.300 4,765.335 ↓ 115.9 233,400 1

Merge Join (cost=148,926.26..148,997.07 rows=2,014 width=65) (actual time=4,119.919..4,765.335 rows=233,400 loops=1)

102. 49.285 4,693.162 ↓ 115.9 233,400 1

Merge Join (cost=148,924.85..148,988.82 rows=2,014 width=63) (actual time=4,119.902..4,693.162 rows=233,400 loops=1)

103. 44.085 4,642.062 ↓ 115.9 233,400 1

Merge Join (cost=148,923.59..148,981.23 rows=2,014 width=61) (actual time=4,119.885..4,642.062 rows=233,400 loops=1)

104. 48.520 4,597.924 ↓ 115.9 233,400 1

Merge Join (cost=148,922.45..148,974.27 rows=2,014 width=59) (actual time=4,119.871..4,597.924 rows=233,400 loops=1)

105. 41.058 4,549.367 ↓ 115.9 233,400 1

Merge Join (cost=148,921.39..148,967.79 rows=2,014 width=57) (actual time=4,119.863..4,549.367 rows=233,400 loops=1)

106. 57.956 4,507.644 ↓ 115.9 233,400 1

Merge Join (cost=148,920.31..148,961.15 rows=2,014 width=55) (actual time=4,119.848..4,507.644 rows=233,400 loops=1)

107. 43.730 4,437.836 ↓ 115.9 233,400 1

Merge Join (cost=148,919.21..148,954.37 rows=2,014 width=52) (actual time=4,119.834..4,437.836 rows=233,400 loops=1)

108. 42.282 4,393.482 ↓ 115.9 233,400 1

Merge Join (cost=148,917.8..148,946.11 rows=2,014 width=49) (actual time=4,119.806..4,393.482 rows=233,400 loops=1)

109. 53.235 4,351.026 ↓ 115.9 233,400 1

Merge Join (cost=148,916.75..148,939.63 rows=2,014 width=47) (actual time=4,119.791..4,351.026 rows=233,400 loops=1)

110. 39.465 4,285.709 ↓ 115.9 233,400 1

Merge Join (cost=148,915.58..148,932.51 rows=2,014 width=45) (actual time=4,119.772..4,285.709 rows=233,400 loops=1)

111. 48.289 4,243.476 ↓ 115.9 233,400 1

Merge Join (cost=148,914.41..148,925.4 rows=2,014 width=43) (actual time=4,119.754..4,243.476 rows=233,400 loops=1)

112. 289.721 4,192.485 ↓ 115.9 233,400 1

Sort (cost=148,913.24..148,918.28 rows=2,014 width=41) (actual time=4,119.716..4,192.485 rows=233,400 loops=1)

  • Sort Key: sdtv_1.stu_dt_trk_value
  • Sort Method: external merge Disk: 11112kB
113. 73.530 3,902.764 ↓ 115.9 233,400 1

Subquery Scan on sdtv_1 (cost=127,695.54..148,802.72 rows=2,014 width=41) (actual time=2,553.938..3,902.764 rows=233,400 loops=1)

  • Filter: ((sdtv_1.stu_dt_trk_end_prog_flg = 'N'::bpchar) AND (sdtv_1.row_num = 1))
114. 299.015 3,829.234 ↓ 1.0 577,185 1

WindowAgg (cost=127,695.54..140,359.85 rows=562,858 width=59) (actual time=2,553.928..3,829.234 rows=577,185 loops=1)

115. 3,303.014 3,530.219 ↓ 1.0 577,185 1

Sort (cost=127,695.54..129,102.69 rows=562,858 width=51) (actual time=2,553.916..3,530.219 rows=577,185 loops=1)

  • Sort Key: student_date_tracked_value_1.per_id, student_date_tracked_value_1.rfds_dt_track_field_nm, student_date_tracked_value_1.stu_dt_trk_eff_date DESC
  • Sort Method: external merge Disk: 35944kB
116. 184.223 227.205 ↓ 1.0 577,185 1

Bitmap Heap Scan on student_date_tracked_value student_date_tracked_value_1 (cost=13,530.87..54,696.31 rows=562,858 width=51) (actual time=44.321..227.205 rows=577,185 loops=1)

  • Filter: (stu_dt_trk_eff_date <= now())
117. 42.982 42.982 ↓ 1.0 577,185 1

Bitmap Index Scan on ifk_r_687 (cost=0..13,390.16 rows=563,808 width=0) (actual time=42.982..42.982 rows=577,185 loops=1)

  • Index Cond: ((rfds_dt_track_field_nm)::text = ANY ('{"At-Risk Indicator","Special Ed Indicator","Speech Therapy Indicator","Gifted and Talented Indicator","LEP Indicator","Secondary Disability","Tertiary Disability","Bilingual Indicator","ESL Indicator","Primary Disability","Instructional Setting","Economic Disadvantage 1 Indicator","Economic Disadvantage 2 Indicator","Migrant Indicator","Immigrant Indicator","Career and Technology Indicator","Single Parent Pregnant Teen","Day Care Support Services","Campus ID of Residence","Title I Indicator","Parental Permission","PK Foster Care Indicator","SSI Promotion Retention Indicator","PK Military Indicator","Attribution Code","Student Crisis","Displaced Homemaker","504 Indicator","Dyslexia Indicator Code","Preschool Program for Children with Disabilities","PPCD Service Location","PRS Indicator"}'::text[]))
118. 2.690 2.702 ↓ 4,451.0 31,157 1

Sort (cost=1.17..1.19 rows=7 width=19) (actual time=0.035..2.702 rows=31,157 loops=1)

  • Sort Key: lep.rfd_lep_indicator_nm
  • Sort Method: quicksort Memory: 25kB
119. 0.012 0.012 ↑ 1.0 7 1

Seq Scan on rfd_lep_indicator lep (cost=0..1.07 rows=7 width=19) (actual time=0.012..0.012 rows=7 loops=1)

120. 2.765 2.768 ↓ 4,533.9 31,737 1

Sort (cost=1.17..1.19 rows=7 width=4) (actual time=0.015..2.768 rows=31,737 loops=1)

  • Sort Key: bil.rfd_bil_program_type_cd
  • Sort Method: quicksort Memory: 25kB
121. 0.003 0.003 ↑ 1.0 7 1

Seq Scan on rfd_bil_program_type bil (cost=0..1.07 rows=7 width=4) (actual time=0.003..0.003 rows=7 loops=1)

122. 12.079 12.082 ↓ 18,238.4 127,669 1

Sort (cost=1.17..1.19 rows=7 width=5) (actual time=0.016..12.082 rows=127,669 loops=1)

  • Sort Key: esl.rfd_esl_program_type_cd
  • Sort Method: quicksort Memory: 25kB
123. 0.003 0.003 ↑ 1.0 7 1

Seq Scan on rfd_esl_program_type esl (cost=0..1.07 rows=7 width=5) (actual time=0.002..0.003 rows=7 loops=1)

124. 0.172 0.174 ↓ 548.3 1,645 1

Sort (cost=1.05..1.06 rows=3 width=43) (actual time=0.013..0.174 rows=1,645 loops=1)

  • Sort Key: speech.rfd_speech_therapy_nm
  • Sort Method: quicksort Memory: 25kB
125. 0.002 0.002 ↑ 1.0 3 1

Seq Scan on rfd_speech_therapy speech (cost=0..1.03 rows=3 width=43) (actual time=0.002..0.002 rows=3 loops=1)

126. 0.617 0.624 ↓ 449.9 6,299 1

Sort (cost=1.41..1.44 rows=14 width=22) (actual time=0.026..0.624 rows=6,299 loops=1)

  • Sort Key: dis.rfd_disability_nm
  • Sort Method: quicksort Memory: 26kB
127. 0.007 0.007 ↑ 1.0 14 1

Seq Scan on rfd_disability dis (cost=0..1.14 rows=14 width=22) (actual time=0.005..0.007 rows=14 loops=1)

128. 11.850 11.852 ↓ 22,319.0 111,595 1

Sort (cost=1.11..1.12 rows=5 width=5) (actual time=0.012..11.852 rows=111,595 loops=1)

  • Sort Key: ed.rfd_econ_dis_advntg_nm
  • Sort Method: quicksort Memory: 25kB
129. 0.002 0.002 ↑ 1.0 5 1

Seq Scan on rfd_economic_disadvantage ed (cost=0..1.05 rows=5 width=5) (actual time=0.002..0.002 rows=5 loops=1)

130. 0.662 0.665 ↓ 2,022.0 8,088 1

Sort (cost=1.08..1.09 rows=4 width=32) (actual time=0.012..0.665 rows=8,088 loops=1)

  • Sort Key: ctc.rfd_career_technology_nm
  • Sort Method: quicksort Memory: 25kB
131. 0.003 0.003 ↑ 1.0 4 1

Seq Scan on rfd_career_technology ctc (cost=0..1.04 rows=4 width=32) (actual time=0.003..0.003 rows=4 loops=1)

132. 0.035 0.037 ↓ 71.7 215 1

Sort (cost=1.05..1.06 rows=3 width=21) (actual time=0.006..0.037 rows=215 loops=1)

  • Sort Key: sp.rfd_sgle_par_preg_tn_nm
  • Sort Method: quicksort Memory: 25kB
133. 0.002 0.002 ↑ 1.0 3 1

Seq Scan on rfd_single_parent_preg_teen sp (cost=0..1.03 rows=3 width=21) (actual time=0.002..0.002 rows=3 loops=1)

134. 0.048 0.053 ↓ 75.3 452 1

Sort (cost=1.14..1.15 rows=6 width=27) (actual time=0.012..0.053 rows=452 loops=1)

  • Sort Key: ttl.rfd_title1_indicator_nm
  • Sort Method: quicksort Memory: 25kB
135. 0.005 0.005 ↑ 1.0 6 1

Seq Scan on rfd_title1_indicator ttl (cost=0..1.06 rows=6 width=27) (actual time=0.005..0.005 rows=6 loops=1)

136. 1.811 1.815 ↓ 2,087.3 20,873 1

Sort (cost=1.27..1.29 rows=10 width=44) (actual time=0.013..1.815 rows=20,873 loops=1)

  • Sort Key: parp.rfd_par_permission_nm
  • Sort Method: quicksort Memory: 26kB
137. 0.004 0.004 ↑ 1.0 10 1

Seq Scan on rfd_parental_permission parp (cost=0..1.1 rows=10 width=44) (actual time=0.003..0.004 rows=10 loops=1)

138. 10.867 10.873 ↓ 9,601.4 134,419 1

Sort (cost=1.41..1.44 rows=14 width=4) (actual time=0.014..10.873 rows=134,419 loops=1)

  • Sort Key: prt.rfd_participate_cd_code
  • Sort Method: quicksort Memory: 25kB
139. 0.006 0.006 ↑ 1.0 14 1

Seq Scan on rfd_participate_code prt (cost=0..1.14 rows=14 width=4) (actual time=0.003..0.006 rows=14 loops=1)

140. 0.450 0.457 ↓ 129.7 5,447 1

Sort (cost=2.55..2.66 rows=42 width=6) (actual time=0.025..0.457 rows=5,447 loops=1)

  • Sort Key: iset.rfd_instr_setting_code
  • Sort Method: quicksort Memory: 26kB
141. 0.007 0.007 ↑ 1.0 42 1

Seq Scan on rfd_instructional_setting iset (cost=0..1.42 rows=42 width=6) (actual time=0.004..0.007 rows=42 loops=1)

142. 0.031 0.036 ↑ 1.0 14 1

Sort (cost=1.41..1.44 rows=14 width=29) (actual time=0.029..0.036 rows=14 loops=1)

  • Sort Key: ssi.rfd_ssi_promo_reten_nm
  • Sort Method: quicksort Memory: 26kB
143. 0.005 0.005 ↑ 1.0 14 1

Seq Scan on rfd_ssi_promotion_retension ssi (cost=0..1.14 rows=14 width=29) (actual time=0.003..0.005 rows=14 loops=1)

144. 0.075 0.078 ↓ 199.2 797 1

Sort (cost=1.08..1.09 rows=4 width=6) (actual time=0.006..0.078 rows=797 loops=1)

  • Sort Key: crisis.rfd_crisis_cd
  • Sort Method: quicksort Memory: 25kB
145. 0.003 0.003 ↑ 1.0 4 1

Seq Scan on rfd_crisis crisis (cost=0..1.04 rows=4 width=6) (actual time=0.002..0.003 rows=4 loops=1)

146. 11.927 11.930 ↓ 13,251.9 132,519 1

Sort (cost=1.27..1.29 rows=10 width=4) (actual time=0.012..11.93 rows=132,519 loops=1)

  • Sort Key: ppcdsl.rfd_ppcd_svc_loc_cd_cd
  • Sort Method: quicksort Memory: 25kB
147. 0.003 0.003 ↑ 1.0 10 1

Seq Scan on rfd_ppcd_svc_loc_cd ppcdsl (cost=0..1.1 rows=10 width=4) (actual time=0.003..0.003 rows=10 loops=1)

148. 14.114 16.026 ↓ 1.0 5,178 1

Sort (cost=1,343.17..1,355.63 rows=4,981 width=6) (actual time=14.801..16.026 rows=5,178 loops=1)

  • Sort Key: pr.per_id
  • Sort Method: quicksort Memory: 437kB
149. 1.477 1.912 ↓ 1.0 5,221 1

Bitmap Heap Scan on person_race pr (cost=115.02..1,037.29 rows=4,981 width=6) (actual time=0.491..1.912 rows=5,221 loops=1)

150. 0.435 0.435 ↓ 1.0 5,221 1

Bitmap Index Scan on ifk_r_9096 (cost=0..113.78 rows=4,981 width=0) (actual time=0.435..0.435 rows=5,221 loops=1)

  • Index Cond: ((rfs_race_name)::text = 'American Indian or Alaska Native'::text)
151. 53.751 58.062 ↓ 1.0 17,216 1

Sort (cost=2,665.08..2,707.93 rows=17,142 width=6) (actual time=55.21..58.062 rows=17,216 loops=1)

  • Sort Key: pr_1.per_id
  • Sort Method: quicksort Memory: 1583kB
152. 3.114 4.311 ↓ 1.0 17,380 1

Bitmap Heap Scan on person_race pr_1 (cost=385.27..1,459.55 rows=17,142 width=6) (actual time=1.262..4.311 rows=17,380 loops=1)

153. 1.197 1.197 ↓ 1.0 17,380 1

Bitmap Index Scan on ifk_r_9096 (cost=0..380.99 rows=17,142 width=0) (actual time=1.197..1.197 rows=17,380 loops=1)

  • Index Cond: ((rfs_race_name)::text = 'Asian'::text)
154. 97.694 104.348 ↑ 1.0 28,910 1

Sort (cost=4,116.19..4,190.73 rows=29,817 width=6) (actual time=99.341..104.348 rows=28,910 loops=1)

  • Sort Key: pr_2.per_id
  • Sort Method: quicksort Memory: 2140kB
155. 4.530 6.654 ↑ 1.0 29,254 1

Bitmap Heap Scan on person_race pr_2 (cost=667.5..1,900.21 rows=29,817 width=6) (actual time=2.2..6.654 rows=29,254 loops=1)

156. 2.124 2.124 ↑ 1.0 29,254 1

Bitmap Index Scan on ifk_r_9096 (cost=0..660.05 rows=29,817 width=0) (actual time=2.124..2.124 rows=29,254 loops=1)

  • Index Cond: ((rfs_race_name)::text = 'Black or African American'::text)
157. 0.902 1.219 ↓ 1.3 466 1

Sort (cost=708.25..709.18 rows=372 width=6) (actual time=1.091..1.219 rows=466 loops=1)

  • Sort Key: pr_3.per_id
  • Sort Method: quicksort Memory: 46kB
158. 0.251 0.317 ↓ 1.3 468 1

Bitmap Heap Scan on person_race pr_3 (cost=11.3..692.36 rows=372 width=6) (actual time=0.096..0.317 rows=468 loops=1)

159. 0.066 0.066 ↓ 1.3 468 1

Bitmap Index Scan on ifk_r_9096 (cost=0..11.21 rows=372 width=0) (actual time=0.066..0.066 rows=468 loops=1)

  • Index Cond: ((rfs_race_name)::text = 'Native Hawaiian or Other Pacific Islander'::text)
160. 720.854 720.854 ↑ 1.0 83,256 1

Index Scan using i_r_9095 on person_race pr_4 (cost=0.42..6,569.46 rows=86,994 width=6) (actual time=0.014..720.854 rows=83,256 loops=1)

  • Filter: ((rfs_race_name)::text = 'White'::text)
161. 34.610 715.298 ↓ 11,150.0 11,150 1

Sort (cost=42,905.1..42,905.11 rows=1 width=13) (actual time=713.733..715.298 rows=11,150 loops=1)

  • Sort Key: eri.per_id, eri.stu_enr_fiscal_year
  • Sort Method: quicksort Memory: 907kB
162. 1.286 680.688 ↓ 11,150.0 11,150 1

Subquery Scan on eri (cost=42,894.74..42,905.09 rows=1 width=13) (actual time=672.748..680.688 rows=11,150 loops=1)

  • Filter: (eri.rnumb = 1)
163. 5.870 679.402 ↓ 40.4 11,154 1

WindowAgg (cost=42,894.74..42,901.64 rows=276 width=197) (actual time=672.743..679.402 rows=11,154 loops=1)

164. 5.915 673.532 ↓ 40.4 11,154 1

Sort (cost=42,894.74..42,895.43 rows=276 width=43) (actual time=672.737..673.532 rows=11,154 loops=1)

  • Sort Key: student_enrollment_2.stu_enr_fiscal_year, student_date_tracked_value_2.per_id, student_date_tracked_value_2.stu_dt_trk_eff_date DESC
  • Sort Method: quicksort Memory: 1953kB
165. 1.035 667.617 ↓ 40.4 11,154 1

Nested Loop (cost=39,821.83..42,883.55 rows=276 width=43) (actual time=648.368..667.617 rows=11,154 loops=1)

166. 0.036 0.036 ↑ 1.0 1 1

Seq Scan on rfds_date_track_field rfds_date_track_field (cost=0..6.38 rows=1 width=22) (actual time=0.016..0.036 rows=1 loops=1)

  • Filter: ((rfds_dt_track_field_nm)::text = 'Early Reading Indicator'::text)
167. 15.528 666.546 ↓ 40.4 11,154 1

Hash Join (cost=39,821.83..42,874.42 rows=276 width=43) (actual time=648.349..666.546 rows=11,154 loops=1)

168. 36.791 623.549 ↓ 1.9 125,363 1

Aggregate (cost=27,398.04..29,372.53 rows=65,707 width=19) (actual time=568.916..623.549 rows=125,363 loops=1)

169. 528.133 586.758 ↓ 1.0 132,511 1

Sort (cost=27,398.04..27,727.39 rows=131,742 width=19) (actual time=568.909..586.758 rows=132,511 loops=1)

  • Sort Key: student_enrollment_2.stu_enr_fiscal_year, student_enrollment_2.per_id
  • Sort Method: external sort Disk: 4920kB
170. 48.147 58.625 ↓ 1.0 132,511 1

Bitmap Heap Scan on student_enrollment student_enrollment_2 (cost=2,584.19..13,493.12 rows=131,742 width=19) (actual time=11.255..58.625 rows=132,511 loops=1)

  • Filter: ((stu_enr_status)::text = ANY ('{E,W}'::text[]))
171. 10.478 10.478 ↓ 1.0 147,419 1

Bitmap Index Scan on ifk_f_stu_enrollment2 (cost=0..2,551.25 rows=146,396 width=0) (actual time=10.478..10.478 rows=147,419 loops=1)

  • Index Cond: (rfs_grade_code = ANY ('{KG,01,02}'::bpchar[]))
172. 1.309 27.469 ↓ 9.5 6,200 1

Hash (cost=12,415.64..12,415.64 rows=652 width=39) (actual time=27.469..27.469 rows=6,200 loops=1)

173. 0.702 26.160 ↓ 9.5 6,200 1

Nested Loop (cost=5,101.56..12,415.64 rows=652 width=39) (actual time=9.051..26.16 rows=6,200 loops=1)

174. 0.006 0.006 ↓ 1.5 3 1

Seq Scan on rfd_early_rdr_ind rfd_early_rdr_ind (cost=0..1.04 rows=2 width=13) (actual time=0.005..0.006 rows=3 loops=1)

  • Filter: ((rfs_p_early_rdr_ind_cd IS NOT NULL) AND ((rfs_p_early_rdr_ind_cd)::text <> '0'::text))
175. 0.885 25.452 ↓ 6.3 2,067 3

Bitmap Heap Scan on student_date_tracked_value student_date_tracked_value_2 (cost=5,101.56..6,204.04 rows=326 width=49) (actual time=8.201..8.484 rows=2,067 loops=3)

176. 24.567 24.567 ↓ 6.3 2,067 3

Bitmap Index Scan on idbi_121018_006_student_date_tracked_value_003 (cost=0..5,101.48 rows=326 width=0) (actual time=8.189..8.189 rows=2,067 loops=3)

  • Index Cond: (((rfds_dt_track_field_nm)::text = 'Early Reading Indicator'::text) AND (stu_dt_trk_end_prog_flg = 'N'::bpchar) AND ((stu_dt_trk_value)::text = (rfd_early_rdr_ind.rfd_early_rdr_ind_nm)::text))