explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LXbO : Optimization for: plan #CCsO

Settings

Optimization path:

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

Nested Loop Left Join (cost=236,736.21..272,473.65 rows=1 width=1,123) (actual rows= loops=)

2.          

CTE tmp_staff_exam_dmn_asgnt

3. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=36,570.37..47,456.52 rows=687 width=42) (actual rows= loops=)

  • Group Key: t.exam_dmn_id, t.aplcn_user_id
4. 0.000 0.000 ↓ 0.0

Subquery Scan on t (cost=36,570.37..47,428.90 rows=701 width=28) (actual rows= loops=)

  • Filter: (t.rnk = 1)
5. 0.000 0.000 ↓ 0.0

WindowAgg (cost=36,570.37..42,875.32 rows=140,110 width=38) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Sort (cost=36,570.37..36,920.65 rows=140,110 width=30) (actual rows= loops=)

  • Sort Key: seda.exam_dmn_id, seda.aplcn_user_id, r_4.tm_trckg_hrchy DESC, ar.aplcn_role_id DESC
7. 0.000 0.000 ↓ 0.0

Hash Join (cost=3.65..24,593.63 rows=140,110 width=30) (actual rows= loops=)

  • Hash Cond: (seda.role_id = ar.aplcn_role_id)
8. 0.000 0.000 ↓ 0.0

Seq Scan on staff_exam_dmn_asgnt seda (cost=0.00..18,735.38 rows=440,346 width=10) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=3.42..3.42 rows=7 width=22) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.47..3.42 rows=7 width=22) (actual rows= loops=)

  • Hash Cond: (ar.star_role_id = r_4.role_id)
11. 0.000 0.000 ↓ 0.0

Seq Scan on aplcn_role_lk ar (cost=0.00..1.66 rows=22 width=22) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Hash (cost=1.21..1.21 rows=8 width=4) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1.21 rows=8 width=4) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on role_lk r_4 (cost=0.00..0.00 rows=1 width=4) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Seq Scan on role_lk_20200727030011 r_5 (cost=0.00..1.21 rows=7 width=4) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=189,279.41..224,981.55 rows=1 width=951) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=189,279.41..224,979.64 rows=1 width=948) (actual rows= loops=)

  • Join Filter: ((ed.xtrnl_id)::text = (ed_4.xtrnl_id)::text)
18. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=172,983.08..203,790.89 rows=1 width=788) (actual rows= loops=)

  • Join Filter: ((d_2.dstrt_cd)::text = (map_1.dstrt_cd)::text)
19. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=172,983.08..203,788.45 rows=1 width=791) (actual rows= loops=)

  • Join Filter: ((d_2.rgn_cd)::text = (r_2.rgn_cd)::text)
20. 0.000 0.000 ↓ 0.0

Nested Loop (cost=172,983.08..203,786.17 rows=1 width=793) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Nested Loop (cost=172,983.08..203,784.27 rows=1 width=769) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Nested Loop (cost=172,982.94..203,784.08 rows=1 width=768) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Nested Loop (cost=172,982.94..203,783.84 rows=1 width=711) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

Nested Loop (cost=172,982.65..203,770.89 rows=5 width=694) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=172,982.52..203,769.75 rows=5 width=675) (actual rows= loops=)

  • Hash Cond: ((d.dstrt_cd)::text = (map.dstrt_cd)::text)
26. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=172,980.08..203,767.26 rows=5 width=678) (actual rows= loops=)

  • Hash Cond: ((d.rgn_cd)::text = (r.rgn_cd)::text)
27. 0.000 0.000 ↓ 0.0

Nested Loop (cost=172,977.80..203,764.93 rows=5 width=680) (actual rows= loops=)

28. 0.000 0.000 ↓ 0.0

Nested Loop (cost=172,977.80..203,755.41 rows=5 width=656) (actual rows= loops=)

29. 0.000 0.000 ↓ 0.0

Nested Loop (cost=172,977.65..203,754.49 rows=5 width=653) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

Hash Join (cost=172,977.37..203,730.99 rows=23 width=559) (actual rows= loops=)

  • Hash Cond: (ed.exam_dmn_id = eda.exam_dmn_id)
31. 0.000 0.000 ↓ 0.0

Subquery Scan on ed (cost=172,913.82..202,480.69 rows=13,364 width=517) (actual rows= loops=)

  • Filter: ((ed.exam_year_nb >= 2,020) AND ((ed.dsply_fl)::text = 'Y'::text))
32. 0.000 0.000 ↓ 0.0

WindowAgg (cost=172,913.82..188,682.82 rows=394,225 width=1,963) (actual rows= loops=)

33.          

CTE tmp_mttr_list

34. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=0.29..5,960.12 rows=52,628 width=36) (actual rows= loops=)

  • Group Key: ed_1_1.exam_dmn_exam_id
35. 0.000 0.000 ↓ 0.0

Index Scan using exam_dmn_r3 on exam_dmn ed_1_1 (cost=0.29..3,978.62 rows=54,219 width=18) (actual rows= loops=)

36. 0.000 0.000 ↓ 0.0

Sort (cost=166,953.70..167,939.26 rows=394,225 width=491) (actual rows= loops=)

  • Sort Key: ed_1.exam_dmn_exam_id, ed_1.prmry_fl DESC
37. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=46,559.20..130,313.12 rows=394,225 width=491) (actual rows= loops=)

  • Hash Cond: ((msre_sg.sbgrp_cd)::text = (msl.sbgrp_cd)::text)
38. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=46,555.61..117,004.44 rows=394,225 width=444) (actual rows= loops=)

  • Hash Cond: ((msre_g.grp_cd)::text = (mgl.grp_cd)::text)
39. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=46,553.79..115,023.92 rows=394,225 width=226) (actual rows= loops=)

  • Hash Cond: ((e.exam_clsfn_cd)::text = (ecl.exam_clsfn_cd)::text)
40. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=46,552.54..113,248.33 rows=394,225 width=224) (actual rows= loops=)

  • Hash Cond: (e.exam_id = e_1.exam_id)
41. 0.000 0.000 ↓ 0.0

Hash Join (cost=34,672.98..88,063.67 rows=394,225 width=164) (actual rows= loops=)

  • Hash Cond: ((etl.exam_type_cd)::text = (et.exam_type_cd)::text)
42. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=34,661.54..86,914.27 rows=394,225 width=164) (actual rows= loops=)

  • Hash Cond: ((e.sbgrp_cd)::text = (msre_sg.sbgrp_cd)::text)
43. 0.000 0.000 ↓ 0.0

Hash Join (cost=34,657.95..84,454.27 rows=394,225 width=161) (actual rows= loops=)

  • Hash Cond: (ed_2.exam_id = ed_1.exam_dmn_exam_id)
44. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=19,743.35..52,486.85 rows=413,402 width=137) (actual rows= loops=)

  • Hash Cond: ((m.mttr_id)::text = (e.model_id)::text)
  • Join Filter: ((e.exam_model_type_cd)::text = 'MATTER'::text)
45. 0.000 0.000 ↓ 0.0

Append (cost=0.00..17,743.49 rows=417,184 width=12) (actual rows= loops=)

46. 0.000 0.000 ↓ 0.0

Seq Scan on mttr m (cost=0.00..0.00 rows=1 width=84) (actual rows= loops=)

47. 0.000 0.000 ↓ 0.0

Seq Scan on mttr_20200727030011 m_1 (cost=0.00..17,743.49 rows=417,183 width=12) (actual rows= loops=)

48. 0.000 0.000 ↓ 0.0

Hash (cost=17,981.24..17,981.24 rows=54,219 width=156) (actual rows= loops=)

49. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=8,431.16..17,981.24 rows=54,219 width=156) (actual rows= loops=)

  • Hash Cond: ((e.grp_cd)::text = (msre_g.grp_cd)::text)
50. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=8,429.35..17,826.08 rows=54,219 width=105) (actual rows= loops=)

  • Hash Cond: (e.exam_id = eo.exam_id)
51. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=4,508.72..12,088.43 rows=54,219 width=105) (actual rows= loops=)

  • Hash Cond: (e.case_wt_id = cwl.case_wt_id)
52. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=4,507.44..11,787.92 rows=54,219 width=107) (actual rows= loops=)

  • Hash Cond: (e.rglty_sgnfc_id = rsl.rglty_sgnfc_id)
53. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,505.97..10,147.69 rows=54,219 width=109) (actual rows= loops=)

  • Hash Cond: (dd_1.dmn_id = dl.dmn_id)
54. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,504.66..9,666.53 rows=54,219 width=111) (actual rows= loops=)

  • Hash Cond: (ed_2.dstrt_dmn_id = dd_1.dstrt_dmn_id)
55. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,493.09..9,502.65 rows=54,219 width=111) (actual rows= loops=)

  • Hash Cond: (e.dstrt_id = d_4.dstrt_id)
56. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,479.38..7,659.04 rows=54,219 width=113) (actual rows= loops=)

  • Hash Cond: ((e.exam_ctgry_cd)::text = (ecl_1.exam_ctgry_cd)::text)
57. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,478.12..7,093.57 rows=54,219 width=113) (actual rows= loops=)

  • Hash Cond: ((e.exam_type_cd)::text = (etl.exam_type_cd)::text)
58. 0.000 0.000 ↓ 0.0

Hash Join (cost=4,466.69..6,925.61 rows=54,219 width=107) (actual rows= loops=)

  • Hash Cond: (ed_2.exam_id = e.exam_id)
59. 0.000 0.000 ↓ 0.0

Seq Scan on exam_dmn ed_2 (cost=0.00..2,316.57 rows=54,219 width=6) (actual rows= loops=)

60. 0.000 0.000 ↓ 0.0

Hash (cost=2,688.45..2,688.45 rows=54,715 width=104) (actual rows= loops=)

61. 0.000 0.000 ↓ 0.0

Seq Scan on exam e (cost=0.00..2,688.45 rows=54,715 width=104) (actual rows= loops=)

62. 0.000 0.000 ↓ 0.0

Hash (cost=7.57..7.57 rows=119 width=6) (actual rows= loops=)

63. 0.000 0.000 ↓ 0.0

Seq Scan on exam_type_lk etl (cost=0.00..7.57 rows=119 width=6) (actual rows= loops=)

64. 0.000 0.000 ↓ 0.0

Hash (cost=1.12..1.12 rows=4 width=6) (actual rows= loops=)

65. 0.000 0.000 ↓ 0.0

Seq Scan on exam_ctgry_lk ecl_1 (cost=0.00..1.12 rows=4 width=6) (actual rows= loops=)

66. 0.000 0.000 ↓ 0.0

Hash (cost=7.61..7.61 rows=188 width=2) (actual rows= loops=)

67. 0.000 0.000 ↓ 0.0

Append (cost=0.00..7.61 rows=188 width=2) (actual rows= loops=)

68. 0.000 0.000 ↓ 0.0

Seq Scan on dstrt d_4 (cost=0.00..0.00 rows=1 width=2) (actual rows= loops=)

69. 0.000 0.000 ↓ 0.0

Seq Scan on dstrt_20200727030011 d_5 (cost=0.00..7.61 rows=187 width=2) (actual rows= loops=)

70. 0.000 0.000 ↓ 0.0

Hash (cost=6.07..6.07 rows=169 width=4) (actual rows= loops=)

71. 0.000 0.000 ↓ 0.0

Seq Scan on dstrt_dmn dd_1 (cost=0.00..6.07 rows=169 width=4) (actual rows= loops=)

72. 0.000 0.000 ↓ 0.0

Hash (cost=1.15..1.15 rows=5 width=2) (actual rows= loops=)

73. 0.000 0.000 ↓ 0.0

Seq Scan on dmn_lk dl (cost=0.00..1.15 rows=5 width=2) (actual rows= loops=)

74. 0.000 0.000 ↓ 0.0

Hash (cost=1.21..1.21 rows=8 width=2) (actual rows= loops=)

75. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1.21 rows=8 width=2) (actual rows= loops=)

76. 0.000 0.000 ↓ 0.0

Seq Scan on rglty_sgnfc_lk rsl (cost=0.00..0.00 rows=1 width=2) (actual rows= loops=)

77. 0.000 0.000 ↓ 0.0

Seq Scan on rglty_sgnfc_lk_20200727030011 rsl_1 (cost=0.00..1.21 rows=7 width=2) (actual rows= loops=)

78. 0.000 0.000 ↓ 0.0

Hash (cost=1.12..1.12 rows=5 width=2) (actual rows= loops=)

79. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1.12 rows=5 width=2) (actual rows= loops=)

80. 0.000 0.000 ↓ 0.0

Seq Scan on case_wt_lk cwl (cost=0.00..0.00 rows=1 width=2) (actual rows= loops=)

81. 0.000 0.000 ↓ 0.0

Seq Scan on case_wt_lk_20200727030011 cwl_1 (cost=0.00..1.12 rows=4 width=2) (actual rows= loops=)

82. 0.000 0.000 ↓ 0.0

Hash (cost=2,156.46..2,156.46 rows=54,282 width=4) (actual rows= loops=)

83. 0.000 0.000 ↓ 0.0

Seq Scan on exam_orgnr eo (cost=0.00..2,156.46 rows=54,282 width=4) (actual rows= loops=)

84. 0.000 0.000 ↓ 0.0

Hash (cost=1.39..1.39 rows=13 width=58) (actual rows= loops=)

85. 0.000 0.000 ↓ 0.0

Seq Scan on msre_grp_lk msre_g (cost=0.00..1.39 rows=13 width=58) (actual rows= loops=)

86. 0.000 0.000 ↓ 0.0

Hash (cost=13,152.47..13,152.47 rows=54,219 width=36) (actual rows= loops=)

87. 0.000 0.000 ↓ 0.0

Hash Join (cost=8,902.21..13,152.47 rows=54,219 width=36) (actual rows= loops=)

  • Hash Cond: (ed_1.dstrt_dmn_id = dd.dstrt_dmn_id)
88. 0.000 0.000 ↓ 0.0

Hash Join (cost=8,890.64..12,988.60 rows=54,219 width=36) (actual rows= loops=)

  • Hash Cond: (ed_1.exam_dmn_exam_id = edsply.exam_id)
89. 0.000 0.000 ↓ 0.0

Seq Scan on exam_dmn ed_1 (cost=0.00..2,316.57 rows=54,219 width=26) (actual rows= loops=)

90. 0.000 0.000 ↓ 0.0

Hash (cost=7,180.23..7,180.23 rows=52,628 width=10) (actual rows= loops=)

91. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,884.38..7,180.23 rows=52,628 width=10) (actual rows= loops=)

  • Hash Cond: (ml.exam_dmn_exam_id = edsply.exam_id)
92. 0.000 0.000 ↓ 0.0

CTE Scan on tmp_mttr_list ml (cost=0.00..3,157.68 rows=52,628 width=4) (actual rows= loops=)

93. 0.000 0.000 ↓ 0.0

Hash (cost=2,121.38..2,121.38 rows=54,246 width=6) (actual rows= loops=)

94. 0.000 0.000 ↓ 0.0

Seq Scan on exam_dsply edsply (cost=0.00..2,121.38 rows=54,246 width=6) (actual rows= loops=)

95. 0.000 0.000 ↓ 0.0

Hash (cost=6.07..6.07 rows=169 width=2) (actual rows= loops=)

96. 0.000 0.000 ↓ 0.0

Seq Scan on dstrt_dmn dd (cost=0.00..6.07 rows=169 width=2) (actual rows= loops=)

97. 0.000 0.000 ↓ 0.0

Hash (cost=2.75..2.75 rows=26 width=11) (actual rows= loops=)

98. 0.000 0.000 ↓ 0.0

Append (cost=0.00..2.75 rows=26 width=11) (actual rows= loops=)

99. 0.000 0.000 ↓ 0.0

Seq Scan on msre_sbgrp_lk msre_sg (cost=0.00..0.00 rows=1 width=58) (actual rows= loops=)

100. 0.000 0.000 ↓ 0.0

Seq Scan on msre_sbgrp_lk_20200727030011 msre_sg_1 (cost=0.00..2.75 rows=25 width=9) (actual rows= loops=)

101. 0.000 0.000 ↓ 0.0

Hash (cost=7.57..7.57 rows=119 width=20) (actual rows= loops=)

102. 0.000 0.000 ↓ 0.0

Seq Scan on exam_type_lk et (cost=0.00..7.57 rows=119 width=20) (actual rows= loops=)

103. 0.000 0.000 ↓ 0.0

Hash (cost=10,101.33..10,101.33 rows=54,715 width=68) (actual rows= loops=)

104. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=3,457.02..10,101.33 rows=54,715 width=68) (actual rows= loops=)

  • Merge Cond: (e_1.exam_id = ec.exam_id)
105. 0.000 0.000 ↓ 0.0

Merge Left Join (cost=1,136.87..6,156.00 rows=54,715 width=36) (actual rows= loops=)

  • Merge Cond: (e_1.exam_id = ed_3.exam_id)
106. 0.000 0.000 ↓ 0.0

Index Only Scan using exam_pk on exam e_1 (cost=0.29..3,915.55 rows=54,715 width=4) (actual rows= loops=)

107. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=1,136.58..1,515.67 rows=9,408 width=36) (actual rows= loops=)

  • Group Key: ed_3.exam_id
108. 0.000 0.000 ↓ 0.0

Sort (cost=1,136.58..1,161.02 rows=9,777 width=14) (actual rows= loops=)

  • Sort Key: ed_3.exam_id
109. 0.000 0.000 ↓ 0.0

Hash Join (cost=1.19..488.60 rows=9,777 width=14) (actual rows= loops=)

  • Hash Cond: ((ed_3.exam_drvr_cd)::text = (edl.exam_drvr_cd)::text)
110. 0.000 0.000 ↓ 0.0

Seq Scan on exam_drvr ed_3 (cost=0.00..360.31 rows=9,777 width=9) (actual rows= loops=)

111. 0.000 0.000 ↓ 0.0

Hash (cost=1.09..1.09 rows=3 width=16) (actual rows= loops=)

112. 0.000 0.000 ↓ 0.0

Seq Scan on exam_drvr_lk edl (cost=0.00..1.09 rows=3 width=16) (actual rows= loops=)

113. 0.000 0.000 ↓ 0.0

Materialize (cost=2,320.15..3,364.10 rows=13,675 width=36) (actual rows= loops=)

114. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=2,320.15..2,919.66 rows=13,675 width=40) (actual rows= loops=)

  • Group Key: ec.exam_id
115. 0.000 0.000 ↓ 0.0

Sort (cost=2,320.15..2,371.84 rows=20,676 width=25) (actual rows= loops=)

  • Sort Key: ec.exam_id
116. 0.000 0.000 ↓ 0.0

Hash Join (cost=23.67..838.13 rows=20,676 width=25) (actual rows= loops=)

  • Hash Cond: ((ec.exam_cmpnt_cd)::text = (ecl_2.exam_cmpnt_cd)::text)
117. 0.000 0.000 ↓ 0.0

Seq Scan on exam_cmpnt ec (cost=0.00..757.10 rows=21,070 width=11) (actual rows= loops=)

118. 0.000 0.000 ↓ 0.0

Hash (cost=13.43..13.43 rows=315 width=28) (actual rows= loops=)

119. 0.000 0.000 ↓ 0.0

Seq Scan on exam_cmpnt_lk ecl_2 (cost=0.00..13.43 rows=315 width=28) (actual rows= loops=)

  • Filter: (dsply_outsd_plng_fl = 'Y'::bpchar)
120. 0.000 0.000 ↓ 0.0

Hash (cost=1.12..1.12 rows=4 width=16) (actual rows= loops=)

121. 0.000 0.000 ↓ 0.0

Seq Scan on exam_clsfn_lk ecl (cost=0.00..1.12 rows=4 width=16) (actual rows= loops=)

122. 0.000 0.000 ↓ 0.0

Hash (cost=1.39..1.39 rows=13 width=276) (actual rows= loops=)

123. 0.000 0.000 ↓ 0.0

Seq Scan on msre_grp_lk mgl (cost=0.00..1.39 rows=13 width=276) (actual rows= loops=)

124. 0.000 0.000 ↓ 0.0

Hash (cost=2.75..2.75 rows=26 width=58) (actual rows= loops=)

125. 0.000 0.000 ↓ 0.0

Append (cost=0.00..2.75 rows=26 width=58) (actual rows= loops=)

126. 0.000 0.000 ↓ 0.0

Seq Scan on msre_sbgrp_lk msl (cost=0.00..0.00 rows=1 width=476) (actual rows= loops=)

127. 0.000 0.000 ↓ 0.0

Seq Scan on msre_sbgrp_lk_20200727030011 msl_1 (cost=0.00..2.75 rows=25 width=41) (actual rows= loops=)

128. 0.000 0.000 ↓ 0.0

Hash (cost=41.22..41.22 rows=687 width=42) (actual rows= loops=)

129. 0.000 0.000 ↓ 0.0

CTE Scan on tmp_staff_exam_dmn_asgnt eda (cost=0.00..41.22 rows=687 width=42) (actual rows= loops=)

130. 0.000 0.000 ↓ 0.0

Index Scan using mlstn_dmn_dates_pk on mlstn_dmn_dates smv (cost=0.29..1.02 rows=1 width=98) (actual rows= loops=)

  • Index Cond: (exam_dmn_id = ed.exam_dmn_id)
  • Filter: (((ews_dt IS NOT NULL) OR (risk_exec_cmplt_dt IS NOT NULL)) AND (GREATEST(COALESCE(ews_dt, risk_exec_cmplt_dt), (to_date('06/29/2020'::text, 'MM/DD/YYYY'::text))::timestamp without time zone) <= LEAST(COALESCE(risk_exec_cmplt_dt, ews_dt), (to_date('10/04/2020'::text, 'MM/DD/YYYY'::text))::timestamp without time zone)))
131. 0.000 0.000 ↓ 0.0

Index Scan using dstrt_dmn_pk on dstrt_dmn edd (cost=0.14..0.18 rows=1 width=7) (actual rows= loops=)

  • Index Cond: (dstrt_dmn_id = ed.dstrt_dmn_id)
132. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1.84 rows=2 width=28) (actual rows= loops=)

133. 0.000 0.000 ↓ 0.0

Seq Scan on dstrt d (cost=0.00..0.00 rows=1 width=322) (actual rows= loops=)

  • Filter: ((edd.dstrt_cd)::text = (dstrt_cd)::text)
134. 0.000 0.000 ↓ 0.0

Index Scan using dstrt_cv1_20200727030011 on dstrt_20200727030011 d_1 (cost=0.27..1.84 rows=1 width=26) (actual rows= loops=)

  • Index Cond: ((dstrt_cd)::text = (edd.dstrt_cd)::text)
135. 0.000 0.000 ↓ 0.0

Hash (cost=1.60..1.60 rows=21 width=3) (actual rows= loops=)

136. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1.60 rows=21 width=3) (actual rows= loops=)

137. 0.000 0.000 ↓ 0.0

Seq Scan on rgn_lk r (cost=0.00..0.00 rows=1 width=28) (actual rows= loops=)

138. 0.000 0.000 ↓ 0.0

Seq Scan on rgn_lk_20200727030011 r_1 (cost=0.00..1.60 rows=20 width=2) (actual rows= loops=)

139. 0.000 0.000 ↓ 0.0

Hash (cost=2.21..2.21 rows=7 width=3) (actual rows= loops=)

140. 0.000 0.000 ↓ 0.0

Seq Scan on staff_dstrt_grp_map map (cost=0.00..2.21 rows=7 width=3) (actual rows= loops=)

141. 0.000 0.000 ↓ 0.0

Index Scan using dmn_pk on dmn_lk edm (cost=0.13..0.24 rows=1 width=21) (actual rows= loops=)

  • Index Cond: (dmn_id = edd.dmn_id)
142. 0.000 0.000 ↓ 0.0

Index Scan using aplcn_user_pk on aplcn_user au (cost=0.29..2.59 rows=1 width=21) (actual rows= loops=)

  • Index Cond: (aplcn_user_id = eda.aplcn_user_id)
  • Filter: (actv_fl = 'Y'::bpchar)
143. 0.000 0.000 ↓ 0.0

Append (cost=0.00..0.18 rows=2 width=59) (actual rows= loops=)

144. 0.000 0.000 ↓ 0.0

Seq Scan on role_lk ur (cost=0.00..0.00 rows=1 width=380) (actual rows= loops=)

  • Filter: (au.star_role_id = role_id)
145. 0.000 0.000 ↓ 0.0

Index Scan using role_lk_pk_20200727030011 on role_lk_20200727030011 ur_1 (cost=0.13..0.18 rows=1 width=13) (actual rows= loops=)

  • Index Cond: (role_id = au.star_role_id)
146. 0.000 0.000 ↓ 0.0

Index Scan using dstrt_dmn_pk on dstrt_dmn ddu (cost=0.14..0.19 rows=1 width=5) (actual rows= loops=)

  • Index Cond: (dstrt_dmn_id = au.dstrt_dmn_id)
147. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1.84 rows=2 width=28) (actual rows= loops=)

148. 0.000 0.000 ↓ 0.0

Seq Scan on dstrt d_2 (cost=0.00..0.00 rows=1 width=322) (actual rows= loops=)

  • Filter: ((ddu.dstrt_cd)::text = (dstrt_cd)::text)
149. 0.000 0.000 ↓ 0.0

Index Scan using dstrt_cv1_20200727030011 on dstrt_20200727030011 d_3 (cost=0.27..1.84 rows=1 width=26) (actual rows= loops=)

  • Index Cond: ((dstrt_cd)::text = (ddu.dstrt_cd)::text)
150. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1.60 rows=21 width=3) (actual rows= loops=)

151. 0.000 0.000 ↓ 0.0

Seq Scan on rgn_lk r_2 (cost=0.00..0.00 rows=1 width=28) (actual rows= loops=)

152. 0.000 0.000 ↓ 0.0

Seq Scan on rgn_lk_20200727030011 r_3 (cost=0.00..1.60 rows=20 width=2) (actual rows= loops=)

153. 0.000 0.000 ↓ 0.0

Seq Scan on staff_dstrt_grp_map map_1 (cost=0.00..2.21 rows=7 width=3) (actual rows= loops=)

154. 0.000 0.000 ↓ 0.0

Hash Join (cost=16,296.32..18,744.99 rows=39,100 width=208) (actual rows= loops=)

  • Hash Cond: (eeh.exam_dmn_id = ed_4.exam_dmn_id)
155.          

CTE ew_exam_hours

156. 0.000 0.000 ↓ 0.0

HashAggregate (cost=10,555.89..12,217.64 rows=39,100 width=164) (actual rows= loops=)

  • Group Key: eh.exam_dmn_id
157. 0.000 0.000 ↓ 0.0

Seq Scan on mlstn_exam_hours eh (cost=0.00..6,098.55 rows=162,085 width=11) (actual rows= loops=)

158. 0.000 0.000 ↓ 0.0

CTE Scan on ew_exam_hours eeh (cost=0.00..2,346.00 rows=39,100 width=164) (actual rows= loops=)

159. 0.000 0.000 ↓ 0.0

Hash (cost=2,316.57..2,316.57 rows=54,219 width=16) (actual rows= loops=)

160. 0.000 0.000 ↓ 0.0

Seq Scan on exam_dmn ed_4 (cost=0.00..2,316.57 rows=54,219 width=16) (actual rows= loops=)

161. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1.85 rows=2 width=15) (actual rows= loops=)

162. 0.000 0.000 ↓ 0.0

Seq Scan on tm_entry_smmry tes (cost=0.00..0.00 rows=1 width=98) (actual rows= loops=)

  • Filter: ((ed.xtrnl_id)::text = (mttr_id)::text)
163. 0.000 0.000 ↓ 0.0

Index Scan using tm_entry_smmry_n1_20200727030011 on tm_entry_smmry_20200727030011 tes_1 (cost=0.42..1.85 rows=1 width=15) (actual rows= loops=)

  • Index Cond: ((ed.xtrnl_id)::text = (mttr_id)::text)
164. 0.000 0.000 ↓ 0.0

Index Scan using staff_exam_dmn_in_town_unq on staff_exam_dmn_in_town edi (cost=0.29..0.50 rows=1 width=6) (actual rows= loops=)

  • Index Cond: (exam_dmn_id = ed.exam_dmn_id)
165.          

SubPlan (for Nested Loop Left Join)

166. 0.000 0.000 ↓ 0.0

Aggregate (cost=35.02..35.05 rows=1 width=32) (actual rows= loops=)

167. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..25.50 rows=3,807 width=5) (actual rows= loops=)

168. 0.000 0.000 ↓ 0.0

Append (cost=0.00..8.46 rows=2 width=48) (actual rows= loops=)

169. 0.000 0.000 ↓ 0.0

Seq Scan on mttr m_2 (cost=0.00..0.00 rows=1 width=84) (actual rows= loops=)

  • Filter: (((asctd_mttr_id)::text = (ed.xtrnl_id)::text) AND (mttr_type_id = 25))
170. 0.000 0.000 ↓ 0.0

Index Scan using mttr_n4_20200727030011 on mttr_20200727030011 m_3 (cost=0.42..8.46 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((mttr_type_id = 25) AND ((asctd_mttr_id)::text = (ed.xtrnl_id)::text))
171. 0.000 0.000 ↓ 0.0

Append (cost=0.00..8.46 rows=2 width=17) (actual rows= loops=)

172. 0.000 0.000 ↓ 0.0

Seq Scan on tm_entry_smmry ts (cost=0.00..0.00 rows=1 width=98) (actual rows= loops=)

  • Filter: ((m_2.mttr_id)::text = (mttr_id)::text)
173. 0.000 0.000 ↓ 0.0

Index Scan using tm_entry_smmry_n1_20200727030011 on tm_entry_smmry_20200727030011 ts_1 (cost=0.42..8.46 rows=1 width=17) (actual rows= loops=)

  • Index Cond: ((mttr_id)::text = (m_2.mttr_id)::text)