# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 3.880 | 2,145.736 | ↓ 1.3 | 2,182 | 1 |
→
Nested Loop Left Join (cost=13,837.97..114,129.03 rows=1,643 width=0) (actual time=34.116..2,145.736 rows=2,182 loops=1)
|
2. |
CTE _prm |
|||||
3. | 0.016 | 0.016 | ↑ 1.0 | 1 | 1 |
→
Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.016..0.016 rows=1 loops=1)
|
4. |
CTE prm |
|||||
5. | 0.029 | 0.029 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on _prm (cost=0.00..0.03 rows=1 width=48) (actual time=0.028..0.029 rows=1 loops=1)
|
6. |
CTE sec_org |
|||||
7. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=0.43..10.65 rows=2 width=95) (never executed)
|
|
8. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=0.29..10.30 rows=2 width=36) (never executed)
|
|
9. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on _prm _prm_1 (cost=0.00..0.02 rows=1 width=36) (never executed)
|
|
10. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using sec_user_org_user_id_idx on public.sec_user_org suo (cost=0.29..10.26 rows=2 width=8) (never executed)
|
|
11. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using md_clinic_pk on public.md_clinic mc_1 (cost=0.14..0.16 rows=1 width=63) (never executed)
|
|
12. |
CTE all_deps |
|||||
13. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Recursive Union (cost=0.28..2,073.26 rows=731 width=4) (never executed) |
|
14. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
15. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on prm (cost=0.00..0.02 rows=1 width=8) (never executed)
|
|
16. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using pim_department_pk on public.pim_department pd (cost=0.28..8.30 rows=1 width=8) (never executed)
|
|
17. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
18. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
WorkTable Scan on all_deps (cost=0.00..0.20 rows=10 width=4) (never executed)
|
|
19. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using pim_department_parent_id_idx on public.pim_department pd_1 (cost=0.28..20.41 rows=7 width=8) (never executed)
|
|
20. |
CTE _pd |
|||||
21. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Recursive Union (cost=4.32..2,685.43 rows=505 width=66) (never executed) |
|
22. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=4.32..21.86 rows=5 width=66) (never executed)
|
|
23. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on prm prm_1 (cost=0.00..0.02 rows=1 width=4) (never executed)
|
|
24. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Bitmap Heap Scan on public.pim_department pd_2 (cost=4.32..21.79 rows=5 width=70) (never executed)
|
|
25. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Bitmap Index Scan on pim_department_org_id_idx (cost=0.00..4.32 rows=5 width=0) (never executed)
|
|
26. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Hash Join (cost=1.62..265.35 rows=50 width=66) (never executed)
|
|
27. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Seq Scan on public.pim_department d (cost=0.00..236.98 rows=6,998 width=66) (never executed)
|
|
28. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
29. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
WorkTable Scan on _pd (cost=0.00..1.00 rows=50 width=8) (never executed)
|
|
30. |
CTE pd |
|||||
31. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on _pd _pd_1 (cost=0.00..10.10 rows=3 width=520) (never executed)
|
|
32. |
CTE emps1 |
|||||
33. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=29.77..4,728.16 rows=94 width=590) (never executed)
|
|
34. |
Initplan (for Nested Loop) |
|||||
35. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
36. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
37. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
38. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
39. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
40. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
41. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
42. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
43. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
44. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
45. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
46. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on sec_org sec_org_1 (cost=0.00..0.04 rows=2 width=4) (never executed)
|
|
47. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
48. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
49. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=29.10..2,683.29 rows=94 width=541) (never executed)
|
|
50. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=28.81..2,649.41 rows=94 width=534) (never executed)
|
|
51. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Hash Left Join (cost=28.52..2,049.90 rows=43 width=526) (never executed)
|
|
52. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=28.42..2,049.63 rows=43 width=14) (never executed)
|
|
53. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Hash Join (cost=28.42..2,031.52 rows=161 width=16) (never executed)
|
|
54. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Bitmap Heap Scan on public.pim_position pp_1 (cost=14.75..2,015.63 rows=161 width=12) (never executed)
|
|
55. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Bitmap Index Scan on pim_position_organization_id_idx (cost=0.00..14.71 rows=323 width=0) (never executed)
|
|
56. |
SubPlan (for Bitmap Heap Scan) |
|||||
57. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on all_deps all_deps_1 (cost=0.00..16.45 rows=4 width=0) (never executed)
|
|
58. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on all_deps all_deps_2 (cost=0.00..14.62 rows=731 width=4) (never executed)
|
|
59. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
60. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Seq Scan on public.pim_position_role r (cost=0.00..9.41 rows=341 width=12) (never executed)
|
|
61. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
62. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Seq Scan on public.pim_position_category cat (cost=0.00..1.20 rows=4 width=6) (never executed)
|
|
63. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
64. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on pd pd_3 (cost=0.00..0.06 rows=3 width=520) (never executed)
|
|
65. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using pim_employee_position_position_id_idx on public.pim_employee_position pep_1 (cost=0.29..13.90 rows=4 width=16) (never executed)
|
|
66. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using pim_employee_pk on public.pim_employee pe (cost=0.29..0.35 rows=1 width=11) (never executed)
|
|
67. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using pim_individual_pk on public.pim_individual i (cost=0.43..5.04 rows=1 width=53) (never executed)
|
|
68. |
SubPlan (for Nested Loop) |
|||||
69. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Aggregate (cost=16.65..16.66 rows=1 width=11) (never executed)
|
|
70. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
71. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
72. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on prm t (cost=0.00..0.02 rows=1 width=0) (never executed)
|
|
73. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using idx_sec_user_party on public.sec_user_party sup (cost=0.28..8.30 rows=1 width=4) (never executed)
|
|
74. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using sec_user_pk on public.sec_user su (cost=0.28..8.30 rows=1 width=15) (never executed)
|
|
75. |
CTE _emps2 |
|||||
76. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=0.00..1,285.07 rows=70 width=156) (never executed)
|
|
77. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on prm prm_12 (cost=0.00..0.02 rows=1 width=52) (never executed)
|
|
78. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on emps1 (cost=0.00..1.88 rows=70 width=104) (never executed)
|
|
79. |
SubPlan (for Nested Loop) |
|||||
80. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using mc_step_lower_aud_who_create_admission_date_idx on public.mc_step steps (cost=0.56..25,745.85 rows=6,410 width=0) (never executed)
|
|
81. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using mc_step_lower_aud_who_create_admission_date_idx on public.mc_step steps_last (cost=0.56..25,745.85 rows=6,410 width=0) (never executed)
|
|
82. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using sr_srv_rendered_lower_aud_who_create_bdate_idx on public.sr_srv_rendered srvs (cost=0.56..59,257.56 rows=14,753 width=0) (never executed)
|
|
83. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using sr_srv_rendered_lower_aud_who_create_bdate_idx on public.sr_srv_rendered srvs_last (cost=0.56..59,257.56 rows=14,753 width=0) (never executed)
|
|
84. |
CTE emps2 |
|||||
85. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
GroupAggregate (cost=3.55..9.50 rows=70 width=112) (never executed)
|
|
86. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Sort (cost=3.55..3.72 rows=70 width=112) (never executed)
|
|
87. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on _emps2 (cost=0.00..1.40 rows=70 width=112) (never executed)
|
|
88. |
CTE emps3 |
|||||
89. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Aggregate (cost=3.54..3.57 rows=1 width=64) (never executed)
|
|
90. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=0.00..2.12 rows=70 width=64) (never executed)
|
|
91. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on prm prm_13 (cost=0.00..0.02 rows=1 width=0) (never executed)
|
|
92. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on emps2 (cost=0.00..1.40 rows=70 width=64) (never executed)
|
|
93. |
CTE emps4 |
|||||
94. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Aggregate (cost=7.03..7.06 rows=1 width=64) (never executed)
|
|
95. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=0.00..2.12 rows=70 width=64) (never executed)
|
|
96. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on prm prm_14 (cost=0.00..0.02 rows=1 width=0) (never executed)
|
|
97. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on emps2 emps2_1 (cost=0.00..1.40 rows=70 width=64) (never executed)
|
|
98. |
CTE close_cases0 |
|||||
99. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
GroupAggregate (cost=2,981.10..2,981.64 rows=2 width=72) (never executed)
|
|
100. |
Initplan (for GroupAggregate) |
|||||
101. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
102. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on prm prm_16 (cost=0.00..0.02 rows=1 width=32) (never executed)
|
|
103. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
104. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
105. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on sec_org sec_org_2 (cost=0.00..0.04 rows=2 width=4) (never executed)
|
|
106. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
107. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
108. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
109. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Sort (cost=2,980.92..2,981.01 rows=34 width=72) (never executed)
|
|
110. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop Left Join (cost=2.74..2,980.06 rows=34 width=72) (never executed)
|
|
111. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop Left Join (cost=1.42..650.67 rows=68 width=44) (never executed)
|
|
112. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop Left Join (cost=1.42..649.29 rows=34 width=12) (never executed)
|
|
113. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop Left Join (cost=0.86..404.00 rows=34 width=12) (never executed)
|
|
114. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using mc_case_close_date_care_regimen_24_idx on public.mc_case mc_2 (cost=0.42..116.10 rows=34 width=12) (never executed)
|
|
115. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using mc_step_pk on public.mc_step ms_1 (cost=0.44..8.46 rows=1 width=8) (never executed)
|
|
116. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using sr_res_group_pk on public.sr_res_group srg_1 (cost=0.56..7.20 rows=1 width=8) (never executed)
|
|
117. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on sec_org sec_org_3 (cost=0.00..0.04 rows=2 width=32) (never executed)
|
|
118. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Limit (cost=1.31..30.12 rows=1 width=572) (never executed)
|
|
119. |
Initplan (for Limit) |
|||||
120. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
121. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=1.29..30.10 rows=1 width=572) (never executed)
|
|
122. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=1.29..29.99 rows=1 width=56) (never executed)
|
|
123. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=1.01..21.68 rows=1 width=56) (never executed)
|
|
124. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=0.58..16.62 rows=1 width=11) (never executed)
|
|
125. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using pim_employee_position_pk on public.pim_employee_position pep_2 (cost=0.29..8.31 rows=1 width=8) (never executed)
|
|
126. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using pim_employee_pk on public.pim_employee pe_1 (cost=0.29..8.31 rows=1 width=11) (never executed)
|
|
127. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using pim_individual_pk on public.pim_individual i_1 (cost=0.43..5.04 rows=1 width=53) (never executed)
|
|
128. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using pim_position_pk on public.pim_position pp_2 (cost=0.29..8.30 rows=1 width=8) (never executed)
|
|
129. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on pd pd_4 (cost=0.00..0.06 rows=3 width=520) (never executed)
|
|
130. |
SubPlan (for Nested Loop Left Join) |
|||||
131. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on all_deps all_deps_3 (cost=0.00..16.45 rows=4 width=0) (never executed)
|
|
132. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on all_deps all_deps_4 (cost=0.00..14.62 rows=731 width=4) (never executed)
|
|
133. |
CTE close_cases1 |
|||||
134. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Aggregate (cost=0.06..0.07 rows=1 width=16) (never executed)
|
|
135. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on close_cases0 (cost=0.00..0.04 rows=2 width=16) (never executed)
|
|
136. |
CTE close_cases2 |
|||||
137. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Aggregate (cost=0.12..0.14 rows=1 width=40) (never executed)
|
|
138. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=0.00..0.08 rows=2 width=40) (never executed)
|
|
139. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on prm prm_23 (cost=0.00..0.02 rows=1 width=0) (never executed)
|
|
140. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on close_cases0 close_cases0_1 (cost=0.00..0.04 rows=2 width=40) (never executed)
|
|
141. |
CTE close_cases3 |
|||||
142. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Aggregate (cost=0.12..0.14 rows=1 width=40) (never executed)
|
|
143. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=0.00..0.08 rows=2 width=40) (never executed)
|
|
144. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on prm prm_24 (cost=0.00..0.02 rows=1 width=0) (never executed)
|
|
145. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on close_cases0 close_cases0_2 (cost=0.00..0.04 rows=2 width=40) (never executed)
|
|
146. |
Initplan (for Nested Loop Left Join) |
|||||
147. | 0.006 | 0.006 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on prm prm_25 (cost=0.00..0.02 rows=1 width=4) (actual time=0.005..0.006 rows=1 loops=1)
|
148. | 0.001 | 0.001 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on prm prm_26 (cost=0.00..0.02 rows=1 width=32) (actual time=0.001..0.001 rows=1 loops=1)
|
149. | 0.001 | 0.001 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on prm prm_27 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)
|
150. | 0.032 | 0.032 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on prm prm_28 (cost=0.00..0.02 rows=1 width=4) (actual time=0.031..0.032 rows=1 loops=1)
|
151. | 0.000 | 0.000 | ↓ 0.0 | 0 | ||
152. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on sec_org sec_org_4 (cost=0.00..0.04 rows=2 width=4) (never executed)
|
|
153. | 0.001 | 0.001 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on prm prm_29 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=1)
|
154. | 0.000 | 0.000 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on prm prm_30 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)
|
155. | 0.003 | 0.003 | ↑ 1.0 | 1 | 1 |
→
CTE Scan on prm prm_31 (cost=0.00..0.02 rows=1 width=4) (actual time=0.002..0.003 rows=1 loops=1)
|
156. | 1.343 | 2,139.630 | ↑ 1.5 | 2,182 | 1 |
→
Nested Loop (cost=42.40..32,135.17 rows=3,286 width=4) (actual time=34.102..2,139.630 rows=2,182 loops=1)
|
157. | 2.294 | 2,137.196 | ↑ 1.5 | 1,091 | 1 |
→
Nested Loop Left Join (cost=42.40..32,093.00 rows=1,643 width=4) (actual time=34.056..2,137.196 rows=1,091 loops=1)
|
158. | 3.391 | 2,133.811 | ↑ 1.5 | 1,091 | 1 |
→
Nested Loop Left Join (cost=41.84..20,239.34 rows=1,643 width=4) (actual time=34.049..2,133.811 rows=1,091 loops=1)
|
159. | 30.536 | 31.336 | ↑ 1.5 | 1,091 | 1 |
→
Bitmap Heap Scan on public.mc_case mc (cost=41.40..6,391.24 rows=1,643 width=4) (actual time=1.385..31.336 rows=1,091 loops=1)
|
160. | 0.800 | 0.800 | ↓ 1.3 | 2,141 | 1 |
→
Bitmap Index Scan on mc_case_clinic_close_date_idx (cost=0.00..40.99 rows=1,644 width=0) (actual time=0.800..0.800 rows=2,141 loops=1)
|
161. | 2,099.084 | 2,099.084 | ↑ 1.0 | 1 | 1,091 |
→
Index Scan using mc_step_pk on public.mc_step ms (cost=0.44..8.42 rows=1 width=8) (actual time=1.922..1.924 rows=1 loops=1,091)
|
162. | 1.091 | 1.091 | ↓ 0.0 | 0 | 1,091 |
→
Index Scan using sr_res_group_pk on public.sr_res_group srg (cost=0.56..7.20 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=1,091)
|
163. | 1.051 | 1.091 | ↑ 1.0 | 2 | 1,091 |
→
Materialize (cost=0.00..1.10 rows=2 width=0) (actual time=0.001..0.001 rows=2 loops=1,091)
|
164. | 0.040 | 0.040 | ↑ 1.0 | 2 | 1 |
→
Seq Scan on public.mc_care_regimen mcr (cost=0.00..1.09 rows=2 width=0) (actual time=0.035..0.040 rows=2 loops=1)
|
165. | 0.000 | 2.182 | ↓ 0.0 | 0 | 2,182 |
→
Limit (cost=0.58..16.62 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=2,182)
|
166. | 2.182 | 2.182 | ↓ 0.0 | 0 | 2,182 |
→
Nested Loop (cost=0.58..16.62 rows=1 width=4) (actual time=0.001..0.001 rows=0 loops=2,182)
|
167. | 0.000 | 0.000 | ↓ 0.0 | 0 | 2,182 |
→
Index Scan using pim_employee_position_pk on public.pim_employee_position pep (cost=0.29..8.31 rows=1 width=4) (actual time=0.000..0.000 rows=0 loops=2,182)
|
168. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using pim_position_pk on public.pim_position pp (cost=0.29..8.30 rows=1 width=8) (never executed)
|
|
169. |
SubPlan (for Nested Loop Left Join) |
|||||
170. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on all_deps all_deps_5 (cost=0.00..16.45 rows=4 width=0) (never executed)
|
|
171. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
CTE Scan on all_deps all_deps_6 (cost=0.00..14.62 rows=731 width=4) (never executed)
|
Planning time | : | 13.447 ms |
---|---|---|
Execution time | : | 2,148.014 ms |