API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 22nd, 2022
245
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 42.85 KB | None | 0 0
raw download clone embed print report
  1. Sort (cost=297846.88..297848.90 rows=809 width=68)
  2. Sort Key: p_1.date_time
  3. -> Hash Right Join (cost=245374.57..297807.81 rows=809 width=68)
  4. Hash Cond: (m_1.id = p_1.id)
  5. -> Hash Join (cost=112212.48..160549.56 rows=142216 width=12)
  6. Hash Cond: (t_1.device_info_serial = m_1.device_info_serial)
  7. Join Filter: ((m_1.date_time >= s_2.s) AND (m_1.date_time <= ((SubPlan 6))))
  8. -> Hash Join (cost=106082.48..120649.05 rows=1657 width=24)
  9. Hash Cond: (s_2.tracker_id = s_3.device)
  10. -> HashAggregate (cost=105743.09..120249.09 rows=200 width=16)
  11. CTE starts
  12. -> Hash Anti Join (cost=204.16..310.88 rows=1449 width=16)
  13. Hash Cond: (o_5.device = o_6.device)
  14. Join Filter: ((o_6.start_date < o_5.start_date) AND (o_6.end_date >= o_5.start_date))
  15. -> Hash Join (cost=52.67..131.89 rows=1568 width=16)
  16. Hash Cond: (o_5.project = p_10.id)
  17. -> Seq Scan on ee_tracker_ownership o_5 (cost=0.00..54.39 rows=2439 width=24)
  18. -> Hash (cost=51.89..51.89 rows=63 width=8)
  19. -> HashAggregate (cost=50.63..51.26 rows=63 width=8)
  20. -> Nested Loop (cost=36.62..50.47 rows=63 width=8)
  21. -> Hash Join (cost=36.48..45.12 rows=3 width=16)
  22. Hash Cond: (direct_p_8.id = m_10.project)
  23. -> Seq Scan on ee_project direct_p_8 (cost=0.00..7.90 rows=190 width=24)
  24. -> Hash (cost=36.44..36.44 rows=3 width=8)
  25. -> HashAggregate (cost=36.38..36.41 rows=3 width=8)
  26. -> Hash Join (cost=14.48..36.37 rows=3 width=8)
  27. Hash Cond: (m_10.member_user = u_8.id)
  28. -> Seq Scan on ee_membership m_10 (cost=0.00..19.76 rows=560 width=16)
  29. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  30. -> Hash (cost=14.46..14.46 rows=2 width=8)
  31. -> Seq Scan on ee_user u_8 (cost=0.00..14.46 rows=2 width=8)
  32. Filter: ((login_name)::name = "current_user"())
  33. -> Index Scan using ee_project_rgt_key on ee_project p_10 (cost=0.14..1.57 rows=21 width=24)
  34. Index Cond: (rgt <= direct_p_8.rgt)
  35. Filter: (lft >= direct_p_8.lft)
  36. -> Hash (cost=131.89..131.89 rows=1568 width=24)
  37. -> Hash Join (cost=52.67..131.89 rows=1568 width=24)
  38. Hash Cond: (o_6.project = p_11.id)
  39. -> Seq Scan on ee_tracker_ownership o_6 (cost=0.00..54.39 rows=2439 width=32)
  40. -> Hash (cost=51.89..51.89 rows=63 width=8)
  41. -> HashAggregate (cost=50.63..51.26 rows=63 width=8)
  42. -> Nested Loop (cost=36.62..50.47 rows=63 width=8)
  43. -> Hash Join (cost=36.48..45.12 rows=3 width=16)
  44. Hash Cond: (direct_p_9.id = m_11.project)
  45. -> Seq Scan on ee_project direct_p_9 (cost=0.00..7.90 rows=190 width=24)
  46. -> Hash (cost=36.44..36.44 rows=3 width=8)
  47. -> HashAggregate (cost=36.38..36.41 rows=3 width=8)
  48. -> Hash Join (cost=14.48..36.37 rows=3 width=8)
  49. Hash Cond: (m_11.member_user = u_9.id)
  50. -> Seq Scan on ee_membership m_11 (cost=0.00..19.76 rows=560 width=16)
  51. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  52. -> Hash (cost=14.46..14.46 rows=2 width=8)
  53. -> Seq Scan on ee_user u_9 (cost=0.00..14.46 rows=2 width=8)
  54. Filter: ((login_name)::name = "current_user"())
  55. -> Index Scan using ee_project_rgt_key on ee_project p_11 (cost=0.14..1.57 rows=21 width=24)
  56. Index Cond: (rgt <= direct_p_9.rgt)
  57. Filter: (lft >= direct_p_9.lft)
  58. CTE ends
  59. -> Hash Anti Join (cost=204.16..310.88 rows=1449 width=16)
  60. Hash Cond: (o_7.device = o_8.device)
  61. Join Filter: ((o_8.start_date <= o_7.end_date) AND (o_8.end_date > o_7.end_date))
  62. -> Hash Join (cost=52.67..131.89 rows=1568 width=16)
  63. Hash Cond: (o_7.project = p_12.id)
  64. -> Seq Scan on ee_tracker_ownership o_7 (cost=0.00..54.39 rows=2439 width=24)
  65. -> Hash (cost=51.89..51.89 rows=63 width=8)
  66. -> HashAggregate (cost=50.63..51.26 rows=63 width=8)
  67. -> Nested Loop (cost=36.62..50.47 rows=63 width=8)
  68. -> Hash Join (cost=36.48..45.12 rows=3 width=16)
  69. Hash Cond: (direct_p_10.id = m_12.project)
  70. -> Seq Scan on ee_project direct_p_10 (cost=0.00..7.90 rows=190 width=24)
  71. -> Hash (cost=36.44..36.44 rows=3 width=8)
  72. -> HashAggregate (cost=36.38..36.41 rows=3 width=8)
  73. -> Hash Join (cost=14.48..36.37 rows=3 width=8)
  74. Hash Cond: (m_12.member_user = u_10.id)
  75. -> Seq Scan on ee_membership m_12 (cost=0.00..19.76 rows=560 width=16)
  76. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  77. -> Hash (cost=14.46..14.46 rows=2 width=8)
  78. -> Seq Scan on ee_user u_10 (cost=0.00..14.46 rows=2 width=8)
  79. Filter: ((login_name)::name = "current_user"())
  80. -> Index Scan using ee_project_rgt_key on ee_project p_12 (cost=0.14..1.57 rows=21 width=24)
  81. Index Cond: (rgt <= direct_p_10.rgt)
  82. Filter: (lft >= direct_p_10.lft)
  83. -> Hash (cost=131.89..131.89 rows=1568 width=24)
  84. -> Hash Join (cost=52.67..131.89 rows=1568 width=24)
  85. Hash Cond: (o_8.project = p_13.id)
  86. -> Seq Scan on ee_tracker_ownership o_8 (cost=0.00..54.39 rows=2439 width=32)
  87. -> Hash (cost=51.89..51.89 rows=63 width=8)
  88. -> HashAggregate (cost=50.63..51.26 rows=63 width=8)
  89. -> Nested Loop (cost=36.62..50.47 rows=63 width=8)
  90. -> Hash Join (cost=36.48..45.12 rows=3 width=16)
  91. Hash Cond: (direct_p_11.id = m_13.project)
  92. -> Seq Scan on ee_project direct_p_11 (cost=0.00..7.90 rows=190 width=24)
  93. -> Hash (cost=36.44..36.44 rows=3 width=8)
  94. -> HashAggregate (cost=36.38..36.41 rows=3 width=8)
  95. -> Hash Join (cost=14.48..36.37 rows=3 width=8)
  96. Hash Cond: (m_13.member_user = u_11.id)
  97. -> Seq Scan on ee_membership m_13 (cost=0.00..19.76 rows=560 width=16)
  98. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  99. -> Hash (cost=14.46..14.46 rows=2 width=8)
  100. -> Seq Scan on ee_user u_11 (cost=0.00..14.46 rows=2 width=8)
  101. Filter: ((login_name)::name = "current_user"())
  102. -> Index Scan using ee_project_rgt_key on ee_project p_13 (cost=0.14..1.57 rows=21 width=24)
  103. Index Cond: (rgt <= direct_p_11.rgt)
  104. Filter: (lft >= direct_p_11.lft)
  105. -> CTE Scan on starts s_2 (cost=0.00..105110.46 rows=1449 width=16)
  106. SubPlan 6
  107. -> Limit (cost=0.00..72.52 rows=1 width=8)
  108. -> Nested Loop Anti Join (cost=0.00..72.52 rows=1 width=8)
  109. Join Filter: ((e2_1.e < e_1.e) AND (e_1.tracker_id = e2_1.tracker_id))
  110. -> CTE Scan on ends e_1 (cost=0.00..36.23 rows=2 width=16)
  111. Filter: ((s_2.s < e) AND (s_2.tracker_id = tracker_id))
  112. -> CTE Scan on ends e2_1 (cost=0.00..36.23 rows=2 width=16)
  113. Filter: ((s_2.s < e) AND (tracker_id = s_2.tracker_id))
  114. -> Hash (cost=318.67..318.67 rows=1657 width=16)
  115. -> HashAggregate (cost=285.53..302.10 rows=1657 width=16)
  116. -> Hash Join (cost=150.48..277.25 rows=1657 width=16)
  117. Hash Cond: (s_3.device = t_1.id)
  118. -> Hash Join (cost=52.67..152.52 rows=1657 width=8)
  119. Hash Cond: (s_3.project = p_2.id)
  120. -> Seq Scan on ee_track_session s_3 (cost=0.00..74.20 rows=2420 width=16)
  121. -> Hash (cost=51.89..51.89 rows=63 width=8)
  122. -> HashAggregate (cost=50.63..51.26 rows=63 width=8)
  123. -> Nested Loop (cost=36.62..50.47 rows=63 width=8)
  124. -> Hash Join (cost=36.48..45.12 rows=3 width=16)
  125. Hash Cond: (direct_p.id = m_2.project)
  126. -> Seq Scan on ee_project direct_p (cost=0.00..7.90 rows=190 width=24)
  127. -> Hash (cost=36.44..36.44 rows=3 width=8)
  128. -> HashAggregate (cost=36.38..36.41 rows=3 width=8)
  129. -> Hash Join (cost=14.48..36.37 rows=3 width=8)
  130. Hash Cond: (m_2.member_user = u.id)
  131. -> Seq Scan on ee_membership m_2 (cost=0.00..19.76 rows=560 width=16)
  132. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  133. -> Hash (cost=14.46..14.46 rows=2 width=8)
  134. -> Seq Scan on ee_user u (cost=0.00..14.46 rows=2 width=8)
  135. Filter: ((login_name)::name = "current_user"())
  136. -> Index Scan using ee_project_rgt_key on ee_project p_2 (cost=0.14..1.57 rows=21 width=24)
  137. Index Cond: (rgt <= direct_p.rgt)
  138. Filter: (lft >= direct_p.lft)
  139. -> Hash (cost=64.58..64.58 rows=2658 width=16)
  140. -> Seq Scan on ee_tracker t_1 (cost=0.00..64.58 rows=2658 width=16)
  141. -> Hash (cost=3292.89..3292.89 rows=154489 width=24)
  142. -> Seq Scan on message m_1 (cost=0.00..3292.89 rows=154489 width=24)
  143. -> Hash (cost=133151.97..133151.97 rows=809 width=64)
  144. -> Hash Join (cost=118395.38..133151.97 rows=809 width=64)
  145. Hash Cond: (t_2.device_info_serial = m.device_info_serial)
  146. Join Filter: ((m.date_time >= s_4.s) AND (m.date_time <= ((SubPlan 3))))
  147. -> Hash Join (cost=106082.48..120649.05 rows=1657 width=24)
  148. Hash Cond: (s_4.tracker_id = s_5.device)
  149. -> HashAggregate (cost=105743.09..120249.09 rows=200 width=16)
  150. CTE starts
  151. -> Hash Anti Join (cost=204.16..310.88 rows=1449 width=16)
  152. Hash Cond: (o_1.device = o_2.device)
  153. Join Filter: ((o_2.start_date < o_1.start_date) AND (o_2.end_date >= o_1.start_date))
  154. -> Hash Join (cost=52.67..131.89 rows=1568 width=16)
  155. Hash Cond: (o_1.project = p_6.id)
  156. -> Seq Scan on ee_tracker_ownership o_1 (cost=0.00..54.39 rows=2439 width=24)
  157. -> Hash (cost=51.89..51.89 rows=63 width=8)
  158. -> HashAggregate (cost=50.63..51.26 rows=63 width=8)
  159. -> Nested Loop (cost=36.62..50.47 rows=63 width=8)
  160. -> Hash Join (cost=36.48..45.12 rows=3 width=16)
  161. Hash Cond: (direct_p_4.id = m_6.project)
  162. -> Seq Scan on ee_project direct_p_4 (cost=0.00..7.90 rows=190 width=24)
  163. -> Hash (cost=36.44..36.44 rows=3 width=8)
  164. -> HashAggregate (cost=36.38..36.41 rows=3 width=8)
  165. -> Hash Join (cost=14.48..36.37 rows=3 width=8)
  166. Hash Cond: (m_6.member_user = u_4.id)
  167. -> Seq Scan on ee_membership m_6 (cost=0.00..19.76 rows=560 width=16)
  168. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  169. -> Hash (cost=14.46..14.46 rows=2 width=8)
  170. -> Seq Scan on ee_user u_4 (cost=0.00..14.46 rows=2 width=8)
  171. Filter: ((login_name)::name = "current_user"())
  172. -> Index Scan using ee_project_rgt_key on ee_project p_6 (cost=0.14..1.57 rows=21 width=24)
  173. Index Cond: (rgt <= direct_p_4.rgt)
  174. Filter: (lft >= direct_p_4.lft)
  175. -> Hash (cost=131.89..131.89 rows=1568 width=24)
  176. -> Hash Join (cost=52.67..131.89 rows=1568 width=24)
  177. Hash Cond: (o_2.project = p_7.id)
  178. -> Seq Scan on ee_tracker_ownership o_2 (cost=0.00..54.39 rows=2439 width=32)
  179. -> Hash (cost=51.89..51.89 rows=63 width=8)
  180. -> HashAggregate (cost=50.63..51.26 rows=63 width=8)
  181. -> Nested Loop (cost=36.62..50.47 rows=63 width=8)
  182. -> Hash Join (cost=36.48..45.12 rows=3 width=16)
  183. Hash Cond: (direct_p_5.id = m_7.project)
  184. -> Seq Scan on ee_project direct_p_5 (cost=0.00..7.90 rows=190 width=24)
  185. -> Hash (cost=36.44..36.44 rows=3 width=8)
  186. -> HashAggregate (cost=36.38..36.41 rows=3 width=8)
  187. -> Hash Join (cost=14.48..36.37 rows=3 width=8)
  188. Hash Cond: (m_7.member_user = u_5.id)
  189. -> Seq Scan on ee_membership m_7 (cost=0.00..19.76 rows=560 width=16)
  190. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  191. -> Hash (cost=14.46..14.46 rows=2 width=8)
  192. -> Seq Scan on ee_user u_5 (cost=0.00..14.46 rows=2 width=8)
  193. Filter: ((login_name)::name = "current_user"())
  194. -> Index Scan using ee_project_rgt_key on ee_project p_7 (cost=0.14..1.57 rows=21 width=24)
  195. Index Cond: (rgt <= direct_p_5.rgt)
  196. Filter: (lft >= direct_p_5.lft)
  197. CTE ends
  198. -> Hash Anti Join (cost=204.16..310.88 rows=1449 width=16)
  199. Hash Cond: (o_3.device = o_4.device)
  200. Join Filter: ((o_4.start_date <= o_3.end_date) AND (o_4.end_date > o_3.end_date))
  201. -> Hash Join (cost=52.67..131.89 rows=1568 width=16)
  202. Hash Cond: (o_3.project = p_8.id)
  203. -> Seq Scan on ee_tracker_ownership o_3 (cost=0.00..54.39 rows=2439 width=24)
  204. -> Hash (cost=51.89..51.89 rows=63 width=8)
  205. -> HashAggregate (cost=50.63..51.26 rows=63 width=8)
  206. -> Nested Loop (cost=36.62..50.47 rows=63 width=8)
  207. -> Hash Join (cost=36.48..45.12 rows=3 width=16)
  208. Hash Cond: (direct_p_6.id = m_8.project)
  209. -> Seq Scan on ee_project direct_p_6 (cost=0.00..7.90 rows=190 width=24)
  210. -> Hash (cost=36.44..36.44 rows=3 width=8)
  211. -> HashAggregate (cost=36.38..36.41 rows=3 width=8)
  212. -> Hash Join (cost=14.48..36.37 rows=3 width=8)
  213. Hash Cond: (m_8.member_user = u_6.id)
  214. -> Seq Scan on ee_membership m_8 (cost=0.00..19.76 rows=560 width=16)
  215. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  216. -> Hash (cost=14.46..14.46 rows=2 width=8)
  217. -> Seq Scan on ee_user u_6 (cost=0.00..14.46 rows=2 width=8)
  218. Filter: ((login_name)::name = "current_user"())
  219. -> Index Scan using ee_project_rgt_key on ee_project p_8 (cost=0.14..1.57 rows=21 width=24)
  220. Index Cond: (rgt <= direct_p_6.rgt)
  221. Filter: (lft >= direct_p_6.lft)
  222. -> Hash (cost=131.89..131.89 rows=1568 width=24)
  223. -> Hash Join (cost=52.67..131.89 rows=1568 width=24)
  224. Hash Cond: (o_4.project = p_9.id)
  225. -> Seq Scan on ee_tracker_ownership o_4 (cost=0.00..54.39 rows=2439 width=32)
  226. -> Hash (cost=51.89..51.89 rows=63 width=8)
  227. -> HashAggregate (cost=50.63..51.26 rows=63 width=8)
  228. -> Nested Loop (cost=36.62..50.47 rows=63 width=8)
  229. -> Hash Join (cost=36.48..45.12 rows=3 width=16)
  230. Hash Cond: (direct_p_7.id = m_9.project)
  231. -> Seq Scan on ee_project direct_p_7 (cost=0.00..7.90 rows=190 width=24)
  232. -> Hash (cost=36.44..36.44 rows=3 width=8)
  233. -> HashAggregate (cost=36.38..36.41 rows=3 width=8)
  234. -> Hash Join (cost=14.48..36.37 rows=3 width=8)
  235. Hash Cond: (m_9.member_user = u_7.id)
  236. -> Seq Scan on ee_membership m_9 (cost=0.00..19.76 rows=560 width=16)
  237. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  238. -> Hash (cost=14.46..14.46 rows=2 width=8)
  239. -> Seq Scan on ee_user u_7 (cost=0.00..14.46 rows=2 width=8)
  240. Filter: ((login_name)::name = "current_user"())
  241. -> Index Scan using ee_project_rgt_key on ee_project p_9 (cost=0.14..1.57 rows=21 width=24)
  242. Index Cond: (rgt <= direct_p_7.rgt)
  243. Filter: (lft >= direct_p_7.lft)
  244. -> CTE Scan on starts s_4 (cost=0.00..105110.46 rows=1449 width=16)
  245. SubPlan 3
  246. -> Limit (cost=0.00..72.52 rows=1 width=8)
  247. -> Nested Loop Anti Join (cost=0.00..72.52 rows=1 width=8)
  248. Join Filter: ((e2.e < e.e) AND (e.tracker_id = e2.tracker_id))
  249. -> CTE Scan on ends e (cost=0.00..36.23 rows=2 width=16)
  250. Filter: ((s_4.s < e) AND (s_4.tracker_id = tracker_id))
  251. -> CTE Scan on ends e2 (cost=0.00..36.23 rows=2 width=16)
  252. Filter: ((s_4.s < e) AND (tracker_id = s_4.tracker_id))
  253. -> Hash (cost=318.67..318.67 rows=1657 width=16)
  254. -> HashAggregate (cost=285.53..302.10 rows=1657 width=16)
  255. -> Hash Join (cost=150.48..277.25 rows=1657 width=16)
  256. Hash Cond: (s_5.device = t_2.id)
  257. -> Hash Join (cost=52.67..152.52 rows=1657 width=8)
  258. Hash Cond: (s_5.project = p_3.id)
  259. -> Seq Scan on ee_track_session s_5 (cost=0.00..74.20 rows=2420 width=16)
  260. -> Hash (cost=51.89..51.89 rows=63 width=8)
  261. -> HashAggregate (cost=50.63..51.26 rows=63 width=8)
  262. -> Nested Loop (cost=36.62..50.47 rows=63 width=8)
  263. -> Hash Join (cost=36.48..45.12 rows=3 width=16)
  264. Hash Cond: (direct_p_1.id = m_3.project)
  265. -> Seq Scan on ee_project direct_p_1 (cost=0.00..7.90 rows=190 width=24)
  266. -> Hash (cost=36.44..36.44 rows=3 width=8)
  267. -> HashAggregate (cost=36.38..36.41 rows=3 width=8)
  268. -> Hash Join (cost=14.48..36.37 rows=3 width=8)
  269. Hash Cond: (m_3.member_user = u_1.id)
  270. -> Seq Scan on ee_membership m_3 (cost=0.00..19.76 rows=560 width=16)
  271. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  272. -> Hash (cost=14.46..14.46 rows=2 width=8)
  273. -> Seq Scan on ee_user u_1 (cost=0.00..14.46 rows=2 width=8)
  274. Filter: ((login_name)::name = "current_user"())
  275. -> Index Scan using ee_project_rgt_key on ee_project p_3 (cost=0.14..1.57 rows=21 width=24)
  276. Index Cond: (rgt <= direct_p_1.rgt)
  277. Filter: (lft >= direct_p_1.lft)
  278. -> Hash (cost=64.58..64.58 rows=2658 width=16)
  279. -> Seq Scan on ee_tracker t_2 (cost=0.00..64.58 rows=2658 width=16)
  280. -> Hash (cost=12301.91..12301.91 rows=879 width=76)
  281. -> Nested Loop (cost=768.53..12301.91 rows=879 width=76)
  282. -> Hash Join (cost=768.11..8325.53 rows=879 width=64)
  283. Hash Cond: (p_1.device_info_serial = t.device_info_serial)
  284. -> Seq Scan on "position" p_1 (cost=0.00..7541.57 rows=1410 width=32)
  285. Filter: ((date_time >= '2022-10-01 00:00:00'::timestamp without time zone) AND (date_time < '2022-11-01 14:01:00'::timestamp without time zone))
  286. -> Hash (cost=747.40..747.40 rows=1657 width=40)
  287. -> Hash Join (cost=576.40..747.40 rows=1657 width=40)
  288. Hash Cond: (s.individual = i.id)
  289. -> Hash Join (cost=481.20..627.34 rows=1657 width=40)
  290. Hash Cond: (s.device = t.id)
  291. -> Hash Left Join (cost=383.39..502.61 rows=1657 width=32)
  292. Hash Cond: (s.individual = o.individual)
  293. -> Hash Join (cost=62.70..162.55 rows=1657 width=32)
  294. Hash Cond: (s.project = p_4.id)
  295. -> Seq Scan on ee_track_session s (cost=0.00..74.20 rows=2420 width=32)
  296. -> Hash (cost=61.92..61.92 rows=63 width=16)
  297. -> Hash Join (cost=52.67..61.92 rows=63 width=16)
  298. Hash Cond: (p.id = p_4.id)
  299. -> Seq Scan on ee_project p (cost=0.00..7.90 rows=190 width=8)
  300. -> Hash (cost=51.89..51.89 rows=63 width=8)
  301. -> HashAggregate (cost=50.63..51.26 rows=63 width=8)
  302. -> Nested Loop (cost=36.62..50.47 rows=63 width=8)
  303. -> Hash Join (cost=36.48..45.12 rows=3 width=16)
  304. Hash Cond: (direct_p_2.id = m_4.project)
  305. -> Seq Scan on ee_project direct_p_2 (cost=0.00..7.90 rows=190 width=24)
  306. -> Hash (cost=36.44..36.44 rows=3 width=8)
  307. -> HashAggregate (cost=36.38..36.41 rows=3 width=8)
  308. -> Hash Join (cost=14.48..36.37 rows=3 width=8)
  309. Hash Cond: (m_4.member_user = u_2.id)
  310. -> Seq Scan on ee_membership m_4 (cost=0.00..19.76 rows=560 width=16)
  311. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  312. -> Hash (cost=14.46..14.46 rows=2 width=8)
  313. -> Seq Scan on ee_user u_2 (cost=0.00..14.46 rows=2 width=8)
  314. Filter: ((login_name)::name = "current_user"())
  315. -> Index Scan using ee_project_rgt_key on ee_project p_4 (cost=0.14..1.57 rows=21 width=24)
  316. Index Cond: (rgt <= direct_p_2.rgt)
  317. Filter: (lft >= direct_p_2.lft)
  318. -> Hash (cost=300.91..300.91 rows=1582 width=8)
  319. -> Hash Join (cost=186.21..300.91 rows=1582 width=8)
  320. Hash Cond: (i_1.species = s_1.id)
  321. -> Hash Join (cost=183.97..276.92 rows=1582 width=16)
  322. Hash Cond: (i_1.id = o.individual)
  323. -> Seq Scan on ee_individual i_1 (cost=0.00..65.09 rows=2409 width=16)
  324. -> Hash (cost=164.19..164.19 rows=1582 width=8)
  325. -> HashAggregate (cost=132.55..148.37 rows=1582 width=8)
  326. -> Hash Join (cost=52.67..128.60 rows=1582 width=8)
  327. Hash Cond: (o.project = p_5.id)
  328. -> Seq Scan on ee_individual_ownership o (cost=0.00..51.35 rows=2335 width=16)
  329. -> Hash (cost=51.89..51.89 rows=63 width=8)
  330. -> HashAggregate (cost=50.63..51.26 rows=63 width=8)
  331. -> Nested Loop (cost=36.62..50.47 rows=63 width=8)
  332. -> Hash Join (cost=36.48..45.12 rows=3 width=16)
  333. Hash Cond: (direct_p_3.id = m_5.project)
  334. -> Seq Scan on ee_project direct_p_3 (cost=0.00..7.90 rows=190 width=24)
  335. -> Hash (cost=36.44..36.44 rows=3 width=8)
  336. -> HashAggregate (cost=36.38..36.41 rows=3 width=8)
  337. -> Hash Join (cost=14.48..36.37 rows=3 width=8)
  338. Hash Cond: (m_5.member_user = u_3.id)
  339. -> Seq Scan on ee_membership m_5 (cost=0.00..19.76 rows=560 width=16)
  340. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  341. -> Hash (cost=14.46..14.46 rows=2 width=8)
  342. -> Seq Scan on ee_user u_3 (cost=0.00..14.46 rows=2 width=8)
  343. Filter: ((login_name)::name = "current_user"())
  344. -> Index Scan using ee_project_rgt_key on ee_project p_5 (cost=0.14..1.57 rows=21 width=24)
  345. Index Cond: (rgt <= direct_p_3.rgt)
  346. Filter: (lft >= direct_p_3.lft)
  347. -> Hash (cost=1.55..1.55 rows=55 width=25)
  348. -> Seq Scan on ee_species s_1 (cost=0.00..1.55 rows=55 width=25)
  349. -> Hash (cost=64.58..64.58 rows=2658 width=16)
  350. -> Seq Scan on ee_tracker t (cost=0.00..64.58 rows=2658 width=16)
  351. -> Hash (cost=65.09..65.09 rows=2409 width=8)
  352. -> Seq Scan on ee_individual i (cost=0.00..65.09 rows=2409 width=8)
  353. -> Index Scan using message_pkey on message m (cost=0.42..4.51 rows=1 width=16)
  354. Index Cond: (id = p_1.id)
  355. (354 rows)
  356.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!