API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 22nd, 2022
165
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 86.85 KB | None | 0 0
raw download clone embed print report
  1.  
  2. -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
  3. Sort (cost=297846.88..297848.90 rows=809 width=68) (actual time=2280.284..2280.811 rows=2004 loops=1)
  4. Sort Key: p_1.date_time
  5. Sort Method: quicksort Memory: 330kB
  6. Buffers: shared hit=9825 read=5234 dirtied=1, temp read=1206 written=1194
  7. -> Hash Right Join (cost=245374.57..297807.81 rows=809 width=68) (actual time=2166.171..2279.322 rows=2004 loops=1)
  8. Hash Cond: (m_1.id = p_1.id)
  9. Buffers: shared hit=9822 read=5234 dirtied=1, temp read=1206 written=1194
  10. -> Hash Join (cost=112212.48..160549.56 rows=142216 width=12) (actual time=1110.865..1186.116 rows=141205 loops=1)
  11. Hash Cond: (t_1.device_info_serial = m_1.device_info_serial)
  12. Join Filter: ((m_1.date_time >= s_2.s) AND (m_1.date_time <= ((SubPlan 6))))
  13. Rows Removed by Join Filter: 16403
  14. Buffers: shared hit=730 read=1736, temp read=1206 written=1194
  15. -> Hash Join (cost=106082.48..120649.05 rows=1657 width=24) (actual time=997.904..1000.061 rows=2229 loops=1)
  16. Hash Cond: (s_2.tracker_id = s_3.device)
  17. Buffers: shared hit=718
  18. -> HashAggregate (cost=105743.09..120249.09 rows=200 width=16) (actual time=989.394..990.073 rows=2414 loops=1)
  19. Buffers: shared hit=528
  20. CTE starts
  21. -> Hash Anti Join (cost=204.16..310.88 rows=1449 width=16) (actual time=4.949..9.000 rows=2438 loops=1)
  22. Hash Cond: (o_5.device = o_6.device)
  23. Join Filter: ((o_6.start_date < o_5.start_date) AND (o_6.end_date >= o_5.start_date))
  24. Rows Removed by Join Filter: 2670
  25. Buffers: shared hit=264
  26. -> Hash Join (cost=52.67..131.89 rows=1568 width=16) (actual time=0.900..3.127 rows=2483 loops=1)
  27. Hash Cond: (o_5.project = p_10.id)
  28. Buffers: shared hit=132
  29. -> Seq Scan on ee_tracker_ownership o_5 (cost=0.00..54.39 rows=2439 width=24) (actual time=0.004..0.661 rows=2483 loops=1)
  30. Buffers: shared hit=30
  31. -> Hash (cost=51.89..51.89 rows=63 width=8) (actual time=0.884..0.884 rows=112 loops=1)
  32. Buckets: 1024 Batches: 1 Memory Usage: 5kB
  33. Buffers: shared hit=102
  34. -> HashAggregate (cost=50.63..51.26 rows=63 width=8) (actual time=0.816..0.844 rows=112 loops=1)
  35. Buffers: shared hit=102
  36. -> Nested Loop (cost=36.62..50.47 rows=63 width=8) (actual time=0.579..0.776 rows=114 loops=1)
  37. Buffers: shared hit=102
  38. -> Hash Join (cost=36.48..45.12 rows=3 width=16) (actual time=0.569..0.609 rows=3 loops=1)
  39. Hash Cond: (direct_p_8.id = m_10.project)
  40. Buffers: shared hit=23
  41. -> Seq Scan on ee_project direct_p_8 (cost=0.00..7.90 rows=190 width=24) (actual time=0.002..0.029 rows=113 loops=1)
  42. Buffers: shared hit=6
  43. -> Hash (cost=36.44..36.44 rows=3 width=8) (actual time=0.538..0.538 rows=3 loops=1)
  44. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  45. Buffers: shared hit=17
  46. -> HashAggregate (cost=36.38..36.41 rows=3 width=8) (actual time=0.536..0.537 rows=3 loops=1)
  47. Buffers: shared hit=17
  48. -> Hash Join (cost=14.48..36.37 rows=3 width=8) (actual time=0.518..0.530 rows=3 loops=1)
  49. Hash Cond: (m_10.member_user = u_8.id)
  50. Buffers: shared hit=17
  51. -> Seq Scan on ee_membership m_10 (cost=0.00..19.76 rows=560 width=16) (actual time=0.006..0.238 rows=578 loops=1)
  52. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  53. Rows Removed by Filter: 90
  54. Buffers: shared hit=9
  55. -> Hash (cost=14.46..14.46 rows=2 width=8) (actual time=0.114..0.114 rows=1 loops=1)
  56. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  57. Buffers: shared hit=8
  58. -> Seq Scan on ee_user u_8 (cost=0.00..14.46 rows=2 width=8) (actual time=0.027..0.113 rows=1 loops=1)
  59. Filter: ((login_name)::name = "current_user"())
  60. Rows Removed by Filter: 372
  61. Buffers: shared hit=8
  62. -> Index Scan using ee_project_rgt_key on ee_project p_10 (cost=0.14..1.57 rows=21 width=24) (actual time=0.016..0.036 rows=38 loops=3)
  63. Index Cond: (rgt <= direct_p_8.rgt)
  64. Filter: (lft >= direct_p_8.lft)
  65. Rows Removed by Filter: 72
  66. Buffers: shared hit=79
  67. -> Hash (cost=131.89..131.89 rows=1568 width=24) (actual time=4.034..4.034 rows=2483 loops=1)
  68. Buckets: 1024 Batches: 1 Memory Usage: 136kB
  69. Buffers: shared hit=132
  70. -> Hash Join (cost=52.67..131.89 rows=1568 width=24) (actual time=0.898..3.064 rows=2483 loops=1)
  71. Hash Cond: (o_6.project = p_11.id)
  72. Buffers: shared hit=132
  73. -> Seq Scan on ee_tracker_ownership o_6 (cost=0.00..54.39 rows=2439 width=32) (actual time=0.003..0.662 rows=2483 loops=1)
  74. Buffers: shared hit=30
  75. -> Hash (cost=51.89..51.89 rows=63 width=8) (actual time=0.882..0.882 rows=112 loops=1)
  76. Buckets: 1024 Batches: 1 Memory Usage: 5kB
  77. Buffers: shared hit=102
  78. -> HashAggregate (cost=50.63..51.26 rows=63 width=8) (actual time=0.814..0.842 rows=112 loops=1)
  79. Buffers: shared hit=102
  80. -> Nested Loop (cost=36.62..50.47 rows=63 width=8) (actual time=0.569..0.761 rows=114 loops=1)
  81. Buffers: shared hit=102
  82. -> Hash Join (cost=36.48..45.12 rows=3 width=16) (actual time=0.560..0.600 rows=3 loops=1)
  83. Hash Cond: (direct_p_9.id = m_11.project)
  84. Buffers: shared hit=23
  85. -> Seq Scan on ee_project direct_p_9 (cost=0.00..7.90 rows=190 width=24) (actual time=0.001..0.032 rows=113 loops=1)
  86. Buffers: shared hit=6
  87. -> Hash (cost=36.44..36.44 rows=3 width=8) (actual time=0.530..0.530 rows=3 loops=1)
  88. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  89. Buffers: shared hit=17
  90. -> HashAggregate (cost=36.38..36.41 rows=3 width=8) (actual time=0.527..0.528 rows=3 loops=1)
  91. Buffers: shared hit=17
  92. -> Hash Join (cost=14.48..36.37 rows=3 width=8) (actual time=0.511..0.523 rows=3 loops=1)
  93. Hash Cond: (m_11.member_user = u_9.id)
  94. Buffers: shared hit=17
  95. -> Seq Scan on ee_membership m_11 (cost=0.00..19.76 rows=560 width=16) (actual time=0.005..0.241 rows=578 loops=1)
  96. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  97. Rows Removed by Filter: 90
  98. Buffers: shared hit=9
  99. -> Hash (cost=14.46..14.46 rows=2 width=8) (actual time=0.115..0.115 rows=1 loops=1)
  100. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  101. Buffers: shared hit=8
  102. -> Seq Scan on ee_user u_9 (cost=0.00..14.46 rows=2 width=8) (actual time=0.028..0.112 rows=1 loops=1)
  103. Filter: ((login_name)::name = "current_user"())
  104. Rows Removed by Filter: 372
  105. Buffers: shared hit=8
  106. -> Index Scan using ee_project_rgt_key on ee_project p_11 (cost=0.14..1.57 rows=21 width=24) (actual time=0.017..0.034 rows=38 loops=3)
  107. Index Cond: (rgt <= direct_p_9.rgt)
  108. Filter: (lft >= direct_p_9.lft)
  109. Rows Removed by Filter: 72
  110. Buffers: shared hit=79
  111. CTE ends
  112. -> Hash Anti Join (cost=204.16..310.88 rows=1449 width=16) (actual time=4.809..8.628 rows=2420 loops=1)
  113. Hash Cond: (o_7.device = o_8.device)
  114. Join Filter: ((o_8.start_date <= o_7.end_date) AND (o_8.end_date > o_7.end_date))
  115. Rows Removed by Join Filter: 2651
  116. Buffers: shared hit=264
  117. -> Hash Join (cost=52.67..131.89 rows=1568 width=16) (actual time=0.898..3.006 rows=2483 loops=1)
  118. Hash Cond: (o_7.project = p_12.id)
  119. Buffers: shared hit=132
  120. -> Seq Scan on ee_tracker_ownership o_7 (cost=0.00..54.39 rows=2439 width=24) (actual time=0.003..0.590 rows=2483 loops=1)
  121. Buffers: shared hit=30
  122. -> Hash (cost=51.89..51.89 rows=63 width=8) (actual time=0.884..0.884 rows=112 loops=1)
  123. Buckets: 1024 Batches: 1 Memory Usage: 5kB
  124. Buffers: shared hit=102
  125. -> HashAggregate (cost=50.63..51.26 rows=63 width=8) (actual time=0.816..0.846 rows=112 loops=1)
  126. Buffers: shared hit=102
  127. -> Nested Loop (cost=36.62..50.47 rows=63 width=8) (actual time=0.575..0.759 rows=114 loops=1)
  128. Buffers: shared hit=102
  129. -> Hash Join (cost=36.48..45.12 rows=3 width=16) (actual time=0.566..0.606 rows=3 loops=1)
  130. Hash Cond: (direct_p_10.id = m_12.project)
  131. Buffers: shared hit=23
  132. -> Seq Scan on ee_project direct_p_10 (cost=0.00..7.90 rows=190 width=24) (actual time=0.002..0.026 rows=113 loops=1)
  133. Buffers: shared hit=6
  134. -> Hash (cost=36.44..36.44 rows=3 width=8) (actual time=0.529..0.529 rows=3 loops=1)
  135. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  136. Buffers: shared hit=17
  137. -> HashAggregate (cost=36.38..36.41 rows=3 width=8) (actual time=0.527..0.528 rows=3 loops=1)
  138. Buffers: shared hit=17
  139. -> Hash Join (cost=14.48..36.37 rows=3 width=8) (actual time=0.509..0.522 rows=3 loops=1)
  140. Hash Cond: (m_12.member_user = u_10.id)
  141. Buffers: shared hit=17
  142. -> Seq Scan on ee_membership m_12 (cost=0.00..19.76 rows=560 width=16) (actual time=0.006..0.247 rows=578 loops=1)
  143. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  144. Rows Removed by Filter: 90
  145. Buffers: shared hit=9
  146. -> Hash (cost=14.46..14.46 rows=2 width=8) (actual time=0.113..0.113 rows=1 loops=1)
  147. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  148. Buffers: shared hit=8
  149. -> Seq Scan on ee_user u_10 (cost=0.00..14.46 rows=2 width=8) (actual time=0.027..0.112 rows=1 loops=1)
  150. Filter: ((login_name)::name = "current_user"())
  151. Rows Removed by Filter: 372
  152. Buffers: shared hit=8
  153. -> Index Scan using ee_project_rgt_key on ee_project p_12 (cost=0.14..1.57 rows=21 width=24) (actual time=0.017..0.033 rows=38 loops=3)
  154. Index Cond: (rgt <= direct_p_10.rgt)
  155. Filter: (lft >= direct_p_10.lft)
  156. Rows Removed by Filter: 72
  157. Buffers: shared hit=79
  158. -> Hash (cost=131.89..131.89 rows=1568 width=24) (actual time=3.891..3.891 rows=2483 loops=1)
  159. Buckets: 1024 Batches: 1 Memory Usage: 136kB
  160. Buffers: shared hit=132
  161. -> Hash Join (cost=52.67..131.89 rows=1568 width=24) (actual time=0.885..3.009 rows=2483 loops=1)
  162. Hash Cond: (o_8.project = p_13.id)
  163. Buffers: shared hit=132
  164. -> Seq Scan on ee_tracker_ownership o_8 (cost=0.00..54.39 rows=2439 width=32) (actual time=0.002..0.625 rows=2483 loops=1)
  165. Buffers: shared hit=30
  166. -> Hash (cost=51.89..51.89 rows=63 width=8) (actual time=0.873..0.873 rows=112 loops=1)
  167. Buckets: 1024 Batches: 1 Memory Usage: 5kB
  168. Buffers: shared hit=102
  169. -> HashAggregate (cost=50.63..51.26 rows=63 width=8) (actual time=0.806..0.835 rows=112 loops=1)
  170. Buffers: shared hit=102
  171. -> Nested Loop (cost=36.62..50.47 rows=63 width=8) (actual time=0.562..0.766 rows=114 loops=1)
  172. Buffers: shared hit=102
  173. -> Hash Join (cost=36.48..45.12 rows=3 width=16) (actual time=0.554..0.594 rows=3 loops=1)
  174. Hash Cond: (direct_p_11.id = m_13.project)
  175. Buffers: shared hit=23
  176. -> Seq Scan on ee_project direct_p_11 (cost=0.00..7.90 rows=190 width=24) (actual time=0.001..0.020 rows=113 loops=1)
  177. Buffers: shared hit=6
  178. -> Hash (cost=36.44..36.44 rows=3 width=8) (actual time=0.523..0.523 rows=3 loops=1)
  179. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  180. Buffers: shared hit=17
  181. -> HashAggregate (cost=36.38..36.41 rows=3 width=8) (actual time=0.521..0.522 rows=3 loops=1)
  182. Buffers: shared hit=17
  183. -> Hash Join (cost=14.48..36.37 rows=3 width=8) (actual time=0.505..0.517 rows=3 loops=1)
  184. Hash Cond: (m_13.member_user = u_11.id)
  185. Buffers: shared hit=17
  186. -> Seq Scan on ee_membership m_13 (cost=0.00..19.76 rows=560 width=16) (actual time=0.006..0.238 rows=578 loops=1)
  187. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  188. Rows Removed by Filter: 90
  189. Buffers: shared hit=9
  190. -> Hash (cost=14.46..14.46 rows=2 width=8) (actual time=0.113..0.113 rows=1 loops=1)
  191. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  192. Buffers: shared hit=8
  193. -> Seq Scan on ee_user u_11 (cost=0.00..14.46 rows=2 width=8) (actual time=0.027..0.112 rows=1 loops=1)
  194. Filter: ((login_name)::name = "current_user"())
  195. Rows Removed by Filter: 372
  196. Buffers: shared hit=8
  197. -> Index Scan using ee_project_rgt_key on ee_project p_13 (cost=0.14..1.57 rows=21 width=24) (actual time=0.020..0.037 rows=38 loops=3)
  198. Index Cond: (rgt <= direct_p_11.rgt)
  199. Filter: (lft >= direct_p_11.lft)
  200. Rows Removed by Filter: 72
  201. Buffers: shared hit=79
  202. -> CTE Scan on starts s_2 (cost=0.00..105110.46 rows=1449 width=16) (actual time=14.763..988.132 rows=2438 loops=1)
  203. Buffers: shared hit=528
  204. SubPlan 6
  205. -> Limit (cost=0.00..72.52 rows=1 width=8) (actual time=0.400..0.400 rows=1 loops=2438)
  206. Buffers: shared hit=264
  207. -> Nested Loop Anti Join (cost=0.00..72.52 rows=1 width=8) (actual time=0.399..0.399 rows=1 loops=2438)
  208. Join Filter: ((e2_1.e < e_1.e) AND (e_1.tracker_id = e2_1.tracker_id))
  209. Rows Removed by Join Filter: 1
  210. Buffers: shared hit=264
  211. -> CTE Scan on ends e_1 (cost=0.00..36.23 rows=2 width=16) (actual time=0.133..0.133 rows=1 loops=2438)
  212. Filter: ((s_2.s < e) AND (s_2.tracker_id = tracker_id))
  213. Rows Removed by Filter: 1206
  214. Buffers: shared hit=235
  215. -> CTE Scan on ends e2_1 (cost=0.00..36.23 rows=2 width=16) (actual time=0.131..0.265 rows=1 loops=2444)
  216. Filter: ((s_2.s < e) AND (tracker_id = s_2.tracker_id))
  217. Rows Removed by Filter: 2417
  218. Buffers: shared hit=29
  219. -> Hash (cost=318.67..318.67 rows=1657 width=16) (actual time=8.485..8.485 rows=2193 loops=1)
  220. Buckets: 1024 Batches: 1 Memory Usage: 103kB
  221. Buffers: shared hit=190
  222. -> HashAggregate (cost=285.53..302.10 rows=1657 width=16) (actual time=7.133..7.720 rows=2193 loops=1)
  223. Buffers: shared hit=190
  224. -> Hash Join (cost=150.48..277.25 rows=1657 width=16) (actual time=2.653..6.196 rows=2336 loops=1)
  225. Hash Cond: (s_3.device = t_1.id)
  226. Buffers: shared hit=190
  227. -> Hash Join (cost=52.67..152.52 rows=1657 width=8) (actual time=0.993..3.126 rows=2336 loops=1)
  228. Hash Cond: (s_3.project = p_2.id)
  229. Buffers: shared hit=152
  230. -> Seq Scan on ee_track_session s_3 (cost=0.00..74.20 rows=2420 width=16) (actual time=0.003..0.655 rows=2336 loops=1)
  231. Buffers: shared hit=50
  232. -> Hash (cost=51.89..51.89 rows=63 width=8) (actual time=0.977..0.977 rows=112 loops=1)
  233. Buckets: 1024 Batches: 1 Memory Usage: 5kB
  234. Buffers: shared hit=102
  235. -> HashAggregate (cost=50.63..51.26 rows=63 width=8) (actual time=0.908..0.936 rows=112 loops=1)
  236. Buffers: shared hit=102
  237. -> Nested Loop (cost=36.62..50.47 rows=63 width=8) (actual time=0.665..0.865 rows=114 loops=1)
  238. Buffers: shared hit=102
  239. -> Hash Join (cost=36.48..45.12 rows=3 width=16) (actual time=0.645..0.686 rows=3 loops=1)
  240. Hash Cond: (direct_p.id = m_2.project)
  241. Buffers: shared hit=23
  242. -> Seq Scan on ee_project direct_p (cost=0.00..7.90 rows=190 width=24) (actual time=0.004..0.037 rows=113 loops=1)
  243. Buffers: shared hit=6
  244. -> Hash (cost=36.44..36.44 rows=3 width=8) (actual time=0.606..0.606 rows=3 loops=1)
  245. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  246. Buffers: shared hit=17
  247. -> HashAggregate (cost=36.38..36.41 rows=3 width=8) (actual time=0.602..0.603 rows=3 loops=1)
  248. Buffers: shared hit=17
  249. -> Hash Join (cost=14.48..36.37 rows=3 width=8) (actual time=0.586..0.597 rows=3 loops=1)
  250. Hash Cond: (m_2.member_user = u.id)
  251. Buffers: shared hit=17
  252. -> Seq Scan on ee_membership m_2 (cost=0.00..19.76 rows=560 width=16) (actual time=0.013..0.281 rows=578 loops=1)
  253. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  254. Rows Removed by Filter: 90
  255. Buffers: shared hit=9
  256. -> Hash (cost=14.46..14.46 rows=2 width=8) (actual time=0.152..0.152 rows=1 loops=1)
  257. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  258. Buffers: shared hit=8
  259. -> Seq Scan on ee_user u (cost=0.00..14.46 rows=2 width=8) (actual time=0.048..0.151 rows=1 loops=1)
  260. Filter: ((login_name)::name = "current_user"())
  261. Rows Removed by Filter: 372
  262. Buffers: shared hit=8
  263. -> Index Scan using ee_project_rgt_key on ee_project p_2 (cost=0.14..1.57 rows=21 width=24) (actual time=0.019..0.039 rows=38 loops=3)
  264. Index Cond: (rgt <= direct_p.rgt)
  265. Filter: (lft >= direct_p.lft)
  266. Rows Removed by Filter: 72
  267. Buffers: shared hit=79
  268. -> Hash (cost=64.58..64.58 rows=2658 width=16) (actual time=1.646..1.646 rows=2613 loops=1)
  269. Buckets: 1024 Batches: 1 Memory Usage: 123kB
  270. Buffers: shared hit=38
  271. -> Seq Scan on ee_tracker t_1 (cost=0.00..64.58 rows=2658 width=16) (actual time=0.004..0.760 rows=2613 loops=1)
  272. Buffers: shared hit=38
  273. -> Hash (cost=3292.89..3292.89 rows=154489 width=24) (actual time=112.748..112.748 rows=156121 loops=1)
  274. Buckets: 8192 Batches: 8 (originally 4) Memory Usage: 3073kB
  275. Buffers: shared hit=12 read=1736, temp written=755
  276. -> Seq Scan on message m_1 (cost=0.00..3292.89 rows=154489 width=24) (actual time=0.004..52.267 rows=156121 loops=1)
  277. Buffers: shared hit=12 read=1736
  278. -> Hash (cost=133151.97..133151.97 rows=809 width=64) (actual time=1054.481..1054.481 rows=2004 loops=1)
  279. Buckets: 1024 Batches: 1 Memory Usage: 196kB
  280. Buffers: shared hit=9089 read=3498 dirtied=1
  281. -> Hash Join (cost=118395.38..133151.97 rows=809 width=64) (actual time=1049.768..1053.577 rows=2004 loops=1)
  282. Hash Cond: (t_2.device_info_serial = m.device_info_serial)
  283. Join Filter: ((m.date_time >= s_4.s) AND (m.date_time <= ((SubPlan 3))))
  284. Rows Removed by Join Filter: 270
  285. Buffers: shared hit=9089 read=3498 dirtied=1
  286. -> Hash Join (cost=106082.48..120649.05 rows=1657 width=24) (actual time=984.999..987.245 rows=2229 loops=1)
  287. Hash Cond: (s_4.tracker_id = s_5.device)
  288. Buffers: shared hit=718
  289. -> HashAggregate (cost=105743.09..120249.09 rows=200 width=16) (actual time=976.657..977.370 rows=2414 loops=1)
  290. Buffers: shared hit=528
  291. CTE starts
  292. -> Hash Anti Join (cost=204.16..310.88 rows=1449 width=16) (actual time=4.950..9.380 rows=2438 loops=1)
  293. Hash Cond: (o_1.device = o_2.device)
  294. Join Filter: ((o_2.start_date < o_1.start_date) AND (o_2.end_date >= o_1.start_date))
  295. Rows Removed by Join Filter: 2670
  296. Buffers: shared hit=264
  297. -> Hash Join (cost=52.67..131.89 rows=1568 width=16) (actual time=0.909..3.286 rows=2483 loops=1)
  298. Hash Cond: (o_1.project = p_6.id)
  299. Buffers: shared hit=132
  300. -> Seq Scan on ee_tracker_ownership o_1 (cost=0.00..54.39 rows=2439 width=24) (actual time=0.006..0.765 rows=2483 loops=1)
  301. Buffers: shared hit=30
  302. -> Hash (cost=51.89..51.89 rows=63 width=8) (actual time=0.886..0.886 rows=112 loops=1)
  303. Buckets: 1024 Batches: 1 Memory Usage: 5kB
  304. Buffers: shared hit=102
  305. -> HashAggregate (cost=50.63..51.26 rows=63 width=8) (actual time=0.819..0.849 rows=112 loops=1)
  306. Buffers: shared hit=102
  307. -> Nested Loop (cost=36.62..50.47 rows=63 width=8) (actual time=0.587..0.776 rows=114 loops=1)
  308. Buffers: shared hit=102
  309. -> Hash Join (cost=36.48..45.12 rows=3 width=16) (actual time=0.577..0.618 rows=3 loops=1)
  310. Hash Cond: (direct_p_4.id = m_6.project)
  311. Buffers: shared hit=23
  312. -> Seq Scan on ee_project direct_p_4 (cost=0.00..7.90 rows=190 width=24) (actual time=0.002..0.025 rows=113 loops=1)
  313. Buffers: shared hit=6
  314. -> Hash (cost=36.44..36.44 rows=3 width=8) (actual time=0.546..0.546 rows=3 loops=1)
  315. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  316. Buffers: shared hit=17
  317. -> HashAggregate (cost=36.38..36.41 rows=3 width=8) (actual time=0.543..0.543 rows=3 loops=1)
  318. Buffers: shared hit=17
  319. -> Hash Join (cost=14.48..36.37 rows=3 width=8) (actual time=0.527..0.540 rows=3 loops=1)
  320. Hash Cond: (m_6.member_user = u_4.id)
  321. Buffers: shared hit=17
  322. -> Seq Scan on ee_membership m_6 (cost=0.00..19.76 rows=560 width=16) (actual time=0.005..0.239 rows=578 loops=1)
  323. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  324. Rows Removed by Filter: 90
  325. Buffers: shared hit=9
  326. -> Hash (cost=14.46..14.46 rows=2 width=8) (actual time=0.115..0.115 rows=1 loops=1)
  327. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  328. Buffers: shared hit=8
  329. -> Seq Scan on ee_user u_4 (cost=0.00..14.46 rows=2 width=8) (actual time=0.028..0.114 rows=1 loops=1)
  330. Filter: ((login_name)::name = "current_user"())
  331. Rows Removed by Filter: 372
  332. Buffers: shared hit=8
  333. -> Index Scan using ee_project_rgt_key on ee_project p_6 (cost=0.14..1.57 rows=21 width=24) (actual time=0.017..0.034 rows=38 loops=3)
  334. Index Cond: (rgt <= direct_p_4.rgt)
  335. Filter: (lft >= direct_p_4.lft)
  336. Rows Removed by Filter: 72
  337. Buffers: shared hit=79
  338. -> Hash (cost=131.89..131.89 rows=1568 width=24) (actual time=4.028..4.028 rows=2483 loops=1)
  339. Buckets: 1024 Batches: 1 Memory Usage: 136kB
  340. Buffers: shared hit=132
  341. -> Hash Join (cost=52.67..131.89 rows=1568 width=24) (actual time=0.899..3.138 rows=2483 loops=1)
  342. Hash Cond: (o_2.project = p_7.id)
  343. Buffers: shared hit=132
  344. -> Seq Scan on ee_tracker_ownership o_2 (cost=0.00..54.39 rows=2439 width=32) (actual time=0.002..0.726 rows=2483 loops=1)
  345. Buffers: shared hit=30
  346. -> Hash (cost=51.89..51.89 rows=63 width=8) (actual time=0.888..0.888 rows=112 loops=1)
  347. Buckets: 1024 Batches: 1 Memory Usage: 5kB
  348. Buffers: shared hit=102
  349. -> HashAggregate (cost=50.63..51.26 rows=63 width=8) (actual time=0.819..0.847 rows=112 loops=1)
  350. Buffers: shared hit=102
  351. -> Nested Loop (cost=36.62..50.47 rows=63 width=8) (actual time=0.587..0.775 rows=114 loops=1)
  352. Buffers: shared hit=102
  353. -> Hash Join (cost=36.48..45.12 rows=3 width=16) (actual time=0.578..0.619 rows=3 loops=1)
  354. Hash Cond: (direct_p_5.id = m_7.project)
  355. Buffers: shared hit=23
  356. -> Seq Scan on ee_project direct_p_5 (cost=0.00..7.90 rows=190 width=24) (actual time=0.001..0.027 rows=113 loops=1)
  357. Buffers: shared hit=6
  358. -> Hash (cost=36.44..36.44 rows=3 width=8) (actual time=0.546..0.546 rows=3 loops=1)
  359. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  360. Buffers: shared hit=17
  361. -> HashAggregate (cost=36.38..36.41 rows=3 width=8) (actual time=0.544..0.545 rows=3 loops=1)
  362. Buffers: shared hit=17
  363. -> Hash Join (cost=14.48..36.37 rows=3 width=8) (actual time=0.528..0.539 rows=3 loops=1)
  364. Hash Cond: (m_7.member_user = u_5.id)
  365. Buffers: shared hit=17
  366. -> Seq Scan on ee_membership m_7 (cost=0.00..19.76 rows=560 width=16) (actual time=0.010..0.258 rows=578 loops=1)
  367. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  368. Rows Removed by Filter: 90
  369. Buffers: shared hit=9
  370. -> Hash (cost=14.46..14.46 rows=2 width=8) (actual time=0.111..0.111 rows=1 loops=1)
  371. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  372. Buffers: shared hit=8
  373. -> Seq Scan on ee_user u_5 (cost=0.00..14.46 rows=2 width=8) (actual time=0.027..0.110 rows=1 loops=1)
  374. Filter: ((login_name)::name = "current_user"())
  375. Rows Removed by Filter: 372
  376. Buffers: shared hit=8
  377. -> Index Scan using ee_project_rgt_key on ee_project p_7 (cost=0.14..1.57 rows=21 width=24) (actual time=0.016..0.033 rows=38 loops=3)
  378. Index Cond: (rgt <= direct_p_5.rgt)
  379. Filter: (lft >= direct_p_5.lft)
  380. Rows Removed by Filter: 72
  381. Buffers: shared hit=79
  382. CTE ends
  383. -> Hash Anti Join (cost=204.16..310.88 rows=1449 width=16) (actual time=4.848..8.798 rows=2420 loops=1)
  384. Hash Cond: (o_3.device = o_4.device)
  385. Join Filter: ((o_4.start_date <= o_3.end_date) AND (o_4.end_date > o_3.end_date))
  386. Rows Removed by Join Filter: 2651
  387. Buffers: shared hit=264
  388. -> Hash Join (cost=52.67..131.89 rows=1568 width=16) (actual time=0.898..3.055 rows=2483 loops=1)
  389. Hash Cond: (o_3.project = p_8.id)
  390. Buffers: shared hit=132
  391. -> Seq Scan on ee_tracker_ownership o_3 (cost=0.00..54.39 rows=2439 width=24) (actual time=0.002..0.621 rows=2483 loops=1)
  392. Buffers: shared hit=30
  393. -> Hash (cost=51.89..51.89 rows=63 width=8) (actual time=0.885..0.885 rows=112 loops=1)
  394. Buckets: 1024 Batches: 1 Memory Usage: 5kB
  395. Buffers: shared hit=102
  396. -> HashAggregate (cost=50.63..51.26 rows=63 width=8) (actual time=0.815..0.846 rows=112 loops=1)
  397. Buffers: shared hit=102
  398. -> Nested Loop (cost=36.62..50.47 rows=63 width=8) (actual time=0.583..0.769 rows=114 loops=1)
  399. Buffers: shared hit=102
  400. -> Hash Join (cost=36.48..45.12 rows=3 width=16) (actual time=0.572..0.612 rows=3 loops=1)
  401. Hash Cond: (direct_p_6.id = m_8.project)
  402. Buffers: shared hit=23
  403. -> Seq Scan on ee_project direct_p_6 (cost=0.00..7.90 rows=190 width=24) (actual time=0.002..0.018 rows=113 loops=1)
  404. Buffers: shared hit=6
  405. -> Hash (cost=36.44..36.44 rows=3 width=8) (actual time=0.541..0.541 rows=3 loops=1)
  406. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  407. Buffers: shared hit=17
  408. -> HashAggregate (cost=36.38..36.41 rows=3 width=8) (actual time=0.539..0.540 rows=3 loops=1)
  409. Buffers: shared hit=17
  410. -> Hash Join (cost=14.48..36.37 rows=3 width=8) (actual time=0.523..0.534 rows=3 loops=1)
  411. Hash Cond: (m_8.member_user = u_6.id)
  412. Buffers: shared hit=17
  413. -> Seq Scan on ee_membership m_8 (cost=0.00..19.76 rows=560 width=16) (actual time=0.004..0.233 rows=578 loops=1)
  414. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  415. Rows Removed by Filter: 90
  416. Buffers: shared hit=9
  417. -> Hash (cost=14.46..14.46 rows=2 width=8) (actual time=0.114..0.114 rows=1 loops=1)
  418. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  419. Buffers: shared hit=8
  420. -> Seq Scan on ee_user u_6 (cost=0.00..14.46 rows=2 width=8) (actual time=0.027..0.113 rows=1 loops=1)
  421. Filter: ((login_name)::name = "current_user"())
  422. Rows Removed by Filter: 372
  423. Buffers: shared hit=8
  424. -> Index Scan using ee_project_rgt_key on ee_project p_8 (cost=0.14..1.57 rows=21 width=24) (actual time=0.017..0.033 rows=38 loops=3)
  425. Index Cond: (rgt <= direct_p_6.rgt)
  426. Filter: (lft >= direct_p_6.lft)
  427. Rows Removed by Filter: 72
  428. Buffers: shared hit=79
  429. -> Hash (cost=131.89..131.89 rows=1568 width=24) (actual time=3.935..3.935 rows=2483 loops=1)
  430. Buckets: 1024 Batches: 1 Memory Usage: 136kB
  431. Buffers: shared hit=132
  432. -> Hash Join (cost=52.67..131.89 rows=1568 width=24) (actual time=0.897..3.023 rows=2483 loops=1)
  433. Hash Cond: (o_4.project = p_9.id)
  434. Buffers: shared hit=132
  435. -> Seq Scan on ee_tracker_ownership o_4 (cost=0.00..54.39 rows=2439 width=32) (actual time=0.001..0.654 rows=2483 loops=1)
  436. Buffers: shared hit=30
  437. -> Hash (cost=51.89..51.89 rows=63 width=8) (actual time=0.878..0.878 rows=112 loops=1)
  438. Buckets: 1024 Batches: 1 Memory Usage: 5kB
  439. Buffers: shared hit=102
  440. -> HashAggregate (cost=50.63..51.26 rows=63 width=8) (actual time=0.811..0.838 rows=112 loops=1)
  441. Buffers: shared hit=102
  442. -> Nested Loop (cost=36.62..50.47 rows=63 width=8) (actual time=0.578..0.767 rows=114 loops=1)
  443. Buffers: shared hit=102
  444. -> Hash Join (cost=36.48..45.12 rows=3 width=16) (actual time=0.570..0.610 rows=3 loops=1)
  445. Hash Cond: (direct_p_7.id = m_9.project)
  446. Buffers: shared hit=23
  447. -> Seq Scan on ee_project direct_p_7 (cost=0.00..7.90 rows=190 width=24) (actual time=0.002..0.030 rows=113 loops=1)
  448. Buffers: shared hit=6
  449. -> Hash (cost=36.44..36.44 rows=3 width=8) (actual time=0.538..0.538 rows=3 loops=1)
  450. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  451. Buffers: shared hit=17
  452. -> HashAggregate (cost=36.38..36.41 rows=3 width=8) (actual time=0.536..0.537 rows=3 loops=1)
  453. Buffers: shared hit=17
  454. -> Hash Join (cost=14.48..36.37 rows=3 width=8) (actual time=0.520..0.533 rows=3 loops=1)
  455. Hash Cond: (m_9.member_user = u_7.id)
  456. Buffers: shared hit=17
  457. -> Seq Scan on ee_membership m_9 (cost=0.00..19.76 rows=560 width=16) (actual time=0.005..0.249 rows=578 loops=1)
  458. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  459. Rows Removed by Filter: 90
  460. Buffers: shared hit=9
  461. -> Hash (cost=14.46..14.46 rows=2 width=8) (actual time=0.114..0.114 rows=1 loops=1)
  462. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  463. Buffers: shared hit=8
  464. -> Seq Scan on ee_user u_7 (cost=0.00..14.46 rows=2 width=8) (actual time=0.027..0.111 rows=1 loops=1)
  465. Filter: ((login_name)::name = "current_user"())
  466. Rows Removed by Filter: 372
  467. Buffers: shared hit=8
  468. -> Index Scan using ee_project_rgt_key on ee_project p_9 (cost=0.14..1.57 rows=21 width=24) (actual time=0.017..0.033 rows=38 loops=3)
  469. Index Cond: (rgt <= direct_p_7.rgt)
  470. Filter: (lft >= direct_p_7.lft)
  471. Rows Removed by Filter: 72
  472. Buffers: shared hit=79
  473. -> CTE Scan on starts s_4 (cost=0.00..105110.46 rows=1449 width=16) (actual time=14.911..975.300 rows=2438 loops=1)
  474. Buffers: shared hit=528
  475. SubPlan 3
  476. -> Limit (cost=0.00..72.52 rows=1 width=8) (actual time=0.395..0.395 rows=1 loops=2438)
  477. Buffers: shared hit=264
  478. -> Nested Loop Anti Join (cost=0.00..72.52 rows=1 width=8) (actual time=0.394..0.394 rows=1 loops=2438)
  479. Join Filter: ((e2.e < e.e) AND (e.tracker_id = e2.tracker_id))
  480. Rows Removed by Join Filter: 1
  481. Buffers: shared hit=264
  482. -> CTE Scan on ends e (cost=0.00..36.23 rows=2 width=16) (actual time=0.131..0.131 rows=1 loops=2438)
  483. Filter: ((s_4.s < e) AND (s_4.tracker_id = tracker_id))
  484. Rows Removed by Filter: 1206
  485. Buffers: shared hit=235
  486. -> CTE Scan on ends e2 (cost=0.00..36.23 rows=2 width=16) (actual time=0.128..0.261 rows=1 loops=2444)
  487. Filter: ((s_4.s < e) AND (tracker_id = s_4.tracker_id))
  488. Rows Removed by Filter: 2417
  489. Buffers: shared hit=29
  490. -> Hash (cost=318.67..318.67 rows=1657 width=16) (actual time=8.326..8.326 rows=2193 loops=1)
  491. Buckets: 1024 Batches: 1 Memory Usage: 103kB
  492. Buffers: shared hit=190
  493. -> HashAggregate (cost=285.53..302.10 rows=1657 width=16) (actual time=6.987..7.578 rows=2193 loops=1)
  494. Buffers: shared hit=190
  495. -> Hash Join (cost=150.48..277.25 rows=1657 width=16) (actual time=2.554..6.067 rows=2336 loops=1)
  496. Hash Cond: (s_5.device = t_2.id)
  497. Buffers: shared hit=190
  498. -> Hash Join (cost=52.67..152.52 rows=1657 width=8) (actual time=0.914..2.975 rows=2336 loops=1)
  499. Hash Cond: (s_5.project = p_3.id)
  500. Buffers: shared hit=152
  501. -> Seq Scan on ee_track_session s_5 (cost=0.00..74.20 rows=2420 width=16) (actual time=0.002..0.595 rows=2336 loops=1)
  502. Buffers: shared hit=50
  503. -> Hash (cost=51.89..51.89 rows=63 width=8) (actual time=0.902..0.902 rows=112 loops=1)
  504. Buckets: 1024 Batches: 1 Memory Usage: 5kB
  505. Buffers: shared hit=102
  506. -> HashAggregate (cost=50.63..51.26 rows=63 width=8) (actual time=0.834..0.861 rows=112 loops=1)
  507. Buffers: shared hit=102
  508. -> Nested Loop (cost=36.62..50.47 rows=63 width=8) (actual time=0.590..0.788 rows=114 loops=1)
  509. Buffers: shared hit=102
  510. -> Hash Join (cost=36.48..45.12 rows=3 width=16) (actual time=0.580..0.621 rows=3 loops=1)
  511. Hash Cond: (direct_p_1.id = m_3.project)
  512. Buffers: shared hit=23
  513. -> Seq Scan on ee_project direct_p_1 (cost=0.00..7.90 rows=190 width=24) (actual time=0.002..0.037 rows=113 loops=1)
  514. Buffers: shared hit=6
  515. -> Hash (cost=36.44..36.44 rows=3 width=8) (actual time=0.544..0.544 rows=3 loops=1)
  516. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  517. Buffers: shared hit=17
  518. -> HashAggregate (cost=36.38..36.41 rows=3 width=8) (actual time=0.541..0.542 rows=3 loops=1)
  519. Buffers: shared hit=17
  520. -> Hash Join (cost=14.48..36.37 rows=3 width=8) (actual time=0.526..0.538 rows=3 loops=1)
  521. Hash Cond: (m_3.member_user = u_1.id)
  522. Buffers: shared hit=17
  523. -> Seq Scan on ee_membership m_3 (cost=0.00..19.76 rows=560 width=16) (actual time=0.006..0.238 rows=578 loops=1)
  524. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  525. Rows Removed by Filter: 90
  526. Buffers: shared hit=9
  527. -> Hash (cost=14.46..14.46 rows=2 width=8) (actual time=0.116..0.116 rows=1 loops=1)
  528. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  529. Buffers: shared hit=8
  530. -> Seq Scan on ee_user u_1 (cost=0.00..14.46 rows=2 width=8) (actual time=0.029..0.115 rows=1 loops=1)
  531. Filter: ((login_name)::name = "current_user"())
  532. Rows Removed by Filter: 372
  533. Buffers: shared hit=8
  534. -> Index Scan using ee_project_rgt_key on ee_project p_3 (cost=0.14..1.57 rows=21 width=24) (actual time=0.017..0.038 rows=38 loops=3)
  535. Index Cond: (rgt <= direct_p_1.rgt)
  536. Filter: (lft >= direct_p_1.lft)
  537. Rows Removed by Filter: 72
  538. Buffers: shared hit=79
  539. -> Hash (cost=64.58..64.58 rows=2658 width=16) (actual time=1.627..1.627 rows=2613 loops=1)
  540. Buckets: 1024 Batches: 1 Memory Usage: 123kB
  541. Buffers: shared hit=38
  542. -> Seq Scan on ee_tracker t_2 (cost=0.00..64.58 rows=2658 width=16) (actual time=0.003..0.738 rows=2613 loops=1)
  543. Buffers: shared hit=38
  544. -> Hash (cost=12301.91..12301.91 rows=879 width=76) (actual time=64.657..64.657 rows=2008 loops=1)
  545. Buckets: 1024 Batches: 1 Memory Usage: 220kB
  546. Buffers: shared hit=8371 read=3498 dirtied=1
  547. -> Nested Loop (cost=768.53..12301.91 rows=879 width=76) (actual time=56.053..63.627 rows=2008 loops=1)
  548. Buffers: shared hit=8371 read=3498 dirtied=1
  549. -> Hash Join (cost=768.11..8325.53 rows=879 width=64) (actual time=56.031..58.376 rows=2008 loops=1)
  550. Hash Cond: (p_1.device_info_serial = t.device_info_serial)
  551. Buffers: shared hit=342 read=3485 dirtied=1
  552. -> Seq Scan on "position" p_1 (cost=0.00..7541.57 rows=1410 width=32) (actual time=34.271..35.349 rows=1875 loops=1)
  553. 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))
  554. Rows Removed by Filter: 272408
  555. Buffers: shared hit=5 read=3413 dirtied=1
  556. -> Hash (cost=747.40..747.40 rows=1657 width=40) (actual time=21.737..21.737 rows=2336 loops=1)
  557. Buckets: 1024 Batches: 1 Memory Usage: 165kB
  558. Buffers: shared hit=337 read=72
  559. -> Hash Join (cost=576.40..747.40 rows=1657 width=40) (actual time=14.130..20.769 rows=2336 loops=1)
  560. Hash Cond: (s.individual = i.id)
  561. Buffers: shared hit=337 read=72
  562. -> Hash Join (cost=481.20..627.34 rows=1657 width=40) (actual time=12.508..17.681 rows=2336 loops=1)
  563. Hash Cond: (s.device = t.id)
  564. Buffers: shared hit=335 read=33
  565. -> Hash Left Join (cost=383.39..502.61 rows=1657 width=32) (actual time=10.778..14.526 rows=2336 loops=1)
  566. Hash Cond: (s.individual = o.individual)
  567. Buffers: shared hit=297 read=33
  568. -> Hash Join (cost=62.70..162.55 rows=1657 width=32) (actual time=1.225..3.489 rows=2336 loops=1)
  569. Hash Cond: (s.project = p_4.id)
  570. Buffers: shared hit=153 read=5
  571. -> Seq Scan on ee_track_session s (cost=0.00..74.20 rows=2420 width=32) (actual time=0.006..0.765 rows=2336 loops=1)
  572. Buffers: shared hit=50
  573. -> Hash (cost=61.92..61.92 rows=63 width=16) (actual time=1.205..1.205 rows=112 loops=1)
  574. Buckets: 1024 Batches: 1 Memory Usage: 6kB
  575. Buffers: shared hit=103 read=5
  576. -> Hash Join (cost=52.67..61.92 rows=63 width=16) (actual time=1.066..1.161 rows=112 loops=1)
  577. Hash Cond: (p.id = p_4.id)
  578. Buffers: shared hit=103 read=5
  579. -> Seq Scan on ee_project p (cost=0.00..7.90 rows=190 width=8) (actual time=0.007..0.038 rows=113 loops=1)
  580. Buffers: shared hit=6
  581. -> Hash (cost=51.89..51.89 rows=63 width=8) (actual time=1.048..1.048 rows=112 loops=1)
  582. Buckets: 1024 Batches: 1 Memory Usage: 5kB
  583. Buffers: shared hit=97 read=5
  584. -> HashAggregate (cost=50.63..51.26 rows=63 width=8) (actual time=0.980..1.008 rows=112 loops=1)
  585. Buffers: shared hit=97 read=5
  586. -> Nested Loop (cost=36.62..50.47 rows=63 width=8) (actual time=0.722..0.928 rows=114 loops=1)
  587. Buffers: shared hit=97 read=5
  588. -> Hash Join (cost=36.48..45.12 rows=3 width=16) (actual time=0.688..0.731 rows=3 loops=1)
  589. Hash Cond: (direct_p_2.id = m_4.project)
  590. Buffers: shared hit=19 read=4
  591. -> Seq Scan on ee_project direct_p_2 (cost=0.00..7.90 rows=190 width=24) (actual time=0.001..0.044 rows=113 loops=1)
  592. Buffers: shared hit=6
  593. -> Hash (cost=36.44..36.44 rows=3 width=8) (actual time=0.643..0.643 rows=3 loops=1)
  594. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  595. Buffers: shared hit=13 read=4
  596. -> HashAggregate (cost=36.38..36.41 rows=3 width=8) (actual time=0.641..0.642 rows=3 loops=1)
  597. Buffers: shared hit=13 read=4
  598. -> Hash Join (cost=14.48..36.37 rows=3 width=8) (actual time=0.623..0.636 rows=3 loops=1)
  599. Hash Cond: (m_4.member_user = u_2.id)
  600. Buffers: shared hit=13 read=4
  601. -> Seq Scan on ee_membership m_4 (cost=0.00..19.76 rows=560 width=16) (actual time=0.017..0.302 rows=578 loops=1)
  602. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  603. Rows Removed by Filter: 90
  604. Buffers: shared hit=9
  605. -> Hash (cost=14.46..14.46 rows=2 width=8) (actual time=0.146..0.146 rows=1 loops=1)
  606. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  607. Buffers: shared hit=4 read=4
  608. -> Seq Scan on ee_user u_2 (cost=0.00..14.46 rows=2 width=8) (actual time=0.038..0.144 rows=1 loops=1)
  609. Filter: ((login_name)::name = "current_user"())
  610. Rows Removed by Filter: 372
  611. Buffers: shared hit=4 read=4
  612. -> Index Scan using ee_project_rgt_key on ee_project p_4 (cost=0.14..1.57 rows=21 width=24) (actual time=0.024..0.049 rows=38 loops=3)
  613. Index Cond: (rgt <= direct_p_2.rgt)
  614. Filter: (lft >= direct_p_2.lft)
  615. Rows Removed by Filter: 72
  616. Buffers: shared hit=78 read=1
  617. -> Hash (cost=300.91..300.91 rows=1582 width=8) (actual time=9.542..9.542 rows=2303 loops=1)
  618. Buckets: 1024 Batches: 1 Memory Usage: 90kB
  619. Buffers: shared hit=144 read=28
  620. -> Hash Join (cost=186.21..300.91 rows=1582 width=8) (actual time=5.296..8.727 rows=2303 loops=1)
  621. Hash Cond: (i_1.species = s_1.id)
  622. Buffers: shared hit=144 read=28
  623. -> Hash Join (cost=183.97..276.92 rows=1582 width=16) (actual time=5.246..7.345 rows=2303 loops=1)
  624. Hash Cond: (i_1.id = o.individual)
  625. Buffers: shared hit=143 read=28
  626. -> Seq Scan on ee_individual i_1 (cost=0.00..65.09 rows=2409 width=16) (actual time=0.001..0.617 rows=2310 loops=1)
  627. Buffers: shared hit=41
  628. -> Hash (cost=164.19..164.19 rows=1582 width=8) (actual time=5.229..5.229 rows=2303 loops=1)
  629. Buckets: 1024 Batches: 1 Memory Usage: 90kB
  630. Buffers: shared hit=102 read=28
  631. -> HashAggregate (cost=132.55..148.37 rows=1582 width=8) (actual time=3.855..4.454 rows=2303 loops=1)
  632. Buffers: shared hit=102 read=28
  633. -> Hash Join (cost=52.67..128.60 rows=1582 width=8) (actual time=0.915..2.984 rows=2327 loops=1)
  634. Hash Cond: (o.project = p_5.id)
  635. Buffers: shared hit=102 read=28
  636. -> Seq Scan on ee_individual_ownership o (cost=0.00..51.35 rows=2335 width=16) (actual time=0.008..0.678 rows=2327 loops=1)
  637. Buffers: shared read=28
  638. -> Hash (cost=51.89..51.89 rows=63 width=8) (actual time=0.897..0.897 rows=112 loops=1)
  639. Buckets: 1024 Batches: 1 Memory Usage: 5kB
  640. Buffers: shared hit=102
  641. -> HashAggregate (cost=50.63..51.26 rows=63 width=8) (actual time=0.830..0.860 rows=112 loops=1)
  642. Buffers: shared hit=102
  643. -> Nested Loop (cost=36.62..50.47 rows=63 width=8) (actual time=0.593..0.781 rows=114 loops=1)
  644. Buffers: shared hit=102
  645. -> Hash Join (cost=36.48..45.12 rows=3 width=16) (actual time=0.585..0.625 rows=3 loops=1)
  646. Hash Cond: (direct_p_3.id = m_5.project)
  647. Buffers: shared hit=23
  648. -> Seq Scan on ee_project direct_p_3 (cost=0.00..7.90 rows=190 width=24) (actual time=0.001..0.032 rows=113 loops=1)
  649. Buffers: shared hit=6
  650. -> Hash (cost=36.44..36.44 rows=3 width=8) (actual time=0.551..0.551 rows=3 loops=1)
  651. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  652. Buffers: shared hit=17
  653. -> HashAggregate (cost=36.38..36.41 rows=3 width=8) (actual time=0.548..0.549 rows=3 loops=1)
  654. Buffers: shared hit=17
  655. -> Hash Join (cost=14.48..36.37 rows=3 width=8) (actual time=0.527..0.539 rows=3 loops=1)
  656. Hash Cond: (m_5.member_user = u_3.id)
  657. Buffers: shared hit=17
  658. -> Seq Scan on ee_membership m_5 (cost=0.00..19.76 rows=560 width=16) (actual time=0.004..0.261 rows=578 loops=1)
  659. Filter: (((status)::text = 'APPROVED'::text) AND ((role)::text = ANY ('{BASE,ADMIN,LEADER}'::text[])))
  660. Rows Removed by Filter: 90
  661. Buffers: shared hit=9
  662. -> Hash (cost=14.46..14.46 rows=2 width=8) (actual time=0.113..0.113 rows=1 loops=1)
  663. Buckets: 1024 Batches: 1 Memory Usage: 1kB
  664. Buffers: shared hit=8
  665. -> Seq Scan on ee_user u_3 (cost=0.00..14.46 rows=2 width=8) (actual time=0.028..0.113 rows=1 loops=1)
  666. Filter: ((login_name)::name = "current_user"())
  667. Rows Removed by Filter: 372
  668. Buffers: shared hit=8
  669. -> Index Scan using ee_project_rgt_key on ee_project p_5 (cost=0.14..1.57 rows=21 width=24) (actual time=0.016..0.032 rows=38 loops=3)
  670. Index Cond: (rgt <= direct_p_3.rgt)
  671. Filter: (lft >= direct_p_3.lft)
  672. Rows Removed by Filter: 72
  673. Buffers: shared hit=79
  674. -> Hash (cost=1.55..1.55 rows=55 width=25) (actual time=0.039..0.039 rows=55 loops=1)
  675. Buckets: 1024 Batches: 1 Memory Usage: 4kB
  676. Buffers: shared hit=1
  677. -> Seq Scan on ee_species s_1 (cost=0.00..1.55 rows=55 width=25) (actual time=0.002..0.015 rows=55 loops=1)
  678. Buffers: shared hit=1
  679. -> Hash (cost=64.58..64.58 rows=2658 width=16) (actual time=1.719..1.719 rows=2613 loops=1)
  680. Buckets: 1024 Batches: 1 Memory Usage: 123kB
  681. Buffers: shared hit=38
  682. -> Seq Scan on ee_tracker t (cost=0.00..64.58 rows=2658 width=16) (actual time=0.006..0.810 rows=2613 loops=1)
  683. Buffers: shared hit=38
  684. -> Hash (cost=65.09..65.09 rows=2409 width=8) (actual time=1.607..1.607 rows=2310 loops=1)
  685. Buckets: 1024 Batches: 1 Memory Usage: 91kB
  686. Buffers: shared hit=2 read=39
  687. -> Seq Scan on ee_individual i (cost=0.00..65.09 rows=2409 width=8) (actual time=0.004..0.787 rows=2310 loops=1)
  688. Buffers: shared hit=2 read=39
  689. -> Index Scan using message_pkey on message m (cost=0.42..4.51 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=2008)
  690. Index Cond: (id = p_1.id)
  691. Buffers: shared hit=8029 read=13
  692. Total runtime: 2282.807 ms
  693. (690 rows)
  694.  
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!