# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.019 | 14.674 | ↑ 501.6 | 44 | 1 |
→
Unique (cost=27,602.73..32,237.85 rows=22,072 width=2,133) (actual time=14.628..14.674 rows=44 loops=1) |
2. |
Initplan (for Unique) |
|||||
3. | 0.024 | 0.024 | ↑ 1.0 | 1 | 1 |
→
Seq Scan on task_mgt_tag taskmanage13_ (cost=0.00..1.79 rows=1 width=8) (actual time=0.010..0.024 rows=1 loops=1)
|
4. | 0.306 | 14.631 | ↑ 501.6 | 44 | 1 |
→
Sort (cost=27,600.95..27,656.13 rows=22,072 width=2,133) (actual time=14.627..14.631 rows=44 loops=1)
|
5. | 0.071 | 14.325 | ↑ 501.6 | 44 | 1 |
→
Hash Left Join (cost=4,375.72..5,638.46 rows=22,072 width=2,133) (actual time=14.203..14.325 rows=44 loops=1)
|
6. | 0.044 | 11.880 | ↑ 567.9 | 26 | 1 |
→
Hash Left Join (cost=4,307.09..5,146.09 rows=14,765 width=1,884) (actual time=11.810..11.880 rows=26 loops=1)
|
7. | 0.048 | 11.814 | ↑ 567.9 | 26 | 1 |
→
Hash Join (cost=4,305.66..5,086.42 rows=14,765 width=828) (actual time=11.764..11.814 rows=26 loops=1)
|
8. | 3.060 | 11.594 | ↑ 527.3 | 28 | 1 |
→
Hash Right Join (cost=4,299.94..5,025.33 rows=14,765 width=828) (actual time=11.566..11.594 rows=28 loops=1)
|
9. | 2.696 | 2.696 | ↑ 1.0 | 16,490 | 1 |
→
Seq Scan on task_mgt_action_comment comments8_ (cost=0.00..515.90 rows=16,490 width=136) (actual time=0.006..2.696 rows=16,490 loops=1) |
10. | 0.048 | 5.838 | ↑ 17.4 | 28 | 1 |
→
Hash (cost=4,293.84..4,293.84 rows=488 width=692) (actual time=5.838..5.838 rows=28 loops=1)
|
11. | 0.049 | 5.790 | ↑ 17.4 | 28 | 1 |
→
Hash Left Join (cost=4,262.81..4,293.84 rows=488 width=692) (actual time=5.166..5.790 rows=28 loops=1)
|
12. | 0.161 | 5.493 | ↑ 17.4 | 28 | 1 |
→
Hash Right Join (cost=4,255.07..4,279.38 rows=488 width=539) (actual time=4.901..5.493 rows=28 loops=1)
|
13. | 0.446 | 0.579 | ↓ 1.0 | 546 | 1 |
→
Hash Left Join (cost=1.14..20.69 rows=545 width=165) (actual time=0.039..0.579 rows=546 loops=1)
|
14. | 0.122 | 0.122 | ↑ 1.0 | 545 | 1 |
→
Seq Scan on task_mgt_action actions1_ (cost=0.00..17.45 rows=545 width=149) (actual time=0.007..0.122 rows=545 loops=1) |
15. | 0.006 | 0.011 | ↑ 1.0 | 6 | 1 |
→
Hash (cost=1.06..1.06 rows=6 width=16) (actual time=0.011..0.011 rows=6 loops=1)
|
16. | 0.005 | 0.005 | ↑ 1.0 | 6 | 1 |
→
Seq Scan on task_mgt_tag_to_action tags9_ (cost=0.00..1.06 rows=6 width=16) (actual time=0.004..0.005 rows=6 loops=1) |
17. | 0.033 | 4.753 | ↑ 27.1 | 18 | 1 |
→
Hash (cost=4,247.83..4,247.83 rows=488 width=374) (actual time=4.753..4.753 rows=18 loops=1)
|
18. | 0.057 | 4.720 | ↑ 27.1 | 18 | 1 |
→
Hash Left Join (cost=10.13..4,247.83 rows=488 width=374) (actual time=0.810..4.720 rows=18 loops=1)
|
19. | 1.378 | 4.306 | ↑ 27.1 | 18 | 1 |
→
Seq Scan on task_mgt_task taskentity0_ (cost=0.00..4,226.80 rows=488 width=249) (actual time=0.424..4.306 rows=18 loops=1)
|
20. |
SubPlan (for Seq Scan) |
|||||
21. | 2.928 | 2.928 | ↑ 1.0 | 1 | 976 |
→
Index Only Scan using task_mgt_tag_to_task_idx on task_mgt_tag_to_task tags14_ (cost=0.28..8.29 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=976)
|
22. | 0.212 | 0.357 | ↑ 1.0 | 228 | 1 |
→
Hash (cost=7.28..7.28 rows=228 width=125) (actual time=0.357..0.357 rows=228 loops=1)
|
23. | 0.145 | 0.145 | ↑ 1.0 | 228 | 1 |
→
Seq Scan on task_mgt_task_comment comments2_ (cost=0.00..7.28 rows=228 width=125) (actual time=0.009..0.145 rows=228 loops=1) |
24. | 0.046 | 0.248 | ↑ 1.0 | 63 | 1 |
→
Hash (cost=6.96..6.96 rows=63 width=153) (actual time=0.248..0.248 rows=63 loops=1)
|
25. | 0.059 | 0.202 | ↑ 1.0 | 63 | 1 |
→
Hash Left Join (cost=4.83..6.96 rows=63 width=153) (actual time=0.126..0.202 rows=63 loops=1)
|
26. | 0.068 | 0.123 | ↑ 1.0 | 63 | 1 |
→
Hash Right Join (cost=2.42..4.29 rows=63 width=102) (actual time=0.090..0.123 rows=63 loops=1)
|
27. | 0.012 | 0.012 | ↑ 1.0 | 63 | 1 |
→
Seq Scan on task_mgt_tag taskmanage11_ (cost=0.00..1.63 rows=63 width=51) (actual time=0.004..0.012 rows=63 loops=1) |
28. | 0.028 | 0.043 | ↑ 1.0 | 63 | 1 |
→
Hash (cost=1.63..1.63 rows=63 width=51) (actual time=0.043..0.043 rows=63 loops=1)
|
29. | 0.015 | 0.015 | ↑ 1.0 | 63 | 1 |
→
Seq Scan on task_mgt_tag taskmanage10_ (cost=0.00..1.63 rows=63 width=51) (actual time=0.005..0.015 rows=63 loops=1) |
30. | 0.008 | 0.020 | ↓ 0.0 | 0 | 1 |
→
Hash (cost=1.63..1.63 rows=63 width=51) (actual time=0.020..0.020 rows=0 loops=1)
|
31. | 0.012 | 0.012 | ↑ 1.0 | 63 | 1 |
→
Seq Scan on task_mgt_tag children12_ (cost=0.00..1.63 rows=63 width=51) (actual time=0.004..0.012 rows=63 loops=1) |
32. | 0.009 | 0.172 | ↑ 1.0 | 8 | 1 |
→
Hash (cost=5.63..5.63 rows=8 width=8) (actual time=0.172..0.172 rows=8 loops=1)
|
33. | 0.015 | 0.163 | ↑ 1.0 | 8 | 1 |
→
HashAggregate (cost=5.55..5.63 rows=8 width=8) (actual time=0.159..0.163 rows=8 loops=1)
|
34. | 0.030 | 0.148 | ↑ 1.0 | 8 | 1 |
→
Hash Join (cost=2.12..5.53 rows=8 width=8) (actual time=0.113..0.148 rows=8 loops=1)
|
35. | 0.055 | 0.055 | ↑ 1.0 | 8 | 1 |
→
Seq Scan on task_mgt_project_member projectmem15_ (cost=0.00..3.30 rows=8 width=8) (actual time=0.026..0.055 rows=8 loops=1)
|
36. | 0.036 | 0.063 | ↑ 1.0 | 50 | 1 |
→
Hash (cost=1.50..1.50 rows=50 width=16) (actual time=0.063..0.063 rows=50 loops=1)
|
37. | 0.027 | 0.027 | ↑ 1.0 | 50 | 1 |
→
Seq Scan on task_mgt_project project16_ (cost=0.00..1.50 rows=50 width=16) (actual time=0.007..0.027 rows=50 loops=1) |
38. | 0.012 | 0.022 | ↑ 1.0 | 19 | 1 |
→
Hash (cost=1.19..1.19 rows=19 width=1,056) (actual time=0.022..0.022 rows=19 loops=1)
|
39. | 0.010 | 0.010 | ↑ 1.0 | 19 | 1 |
→
Seq Scan on task_mgt_checklist_item checklisti3_ (cost=0.00..1.19 rows=19 width=1,056) (actual time=0.004..0.010 rows=19 loops=1) |
40. | 0.785 | 2.374 | ↑ 1.0 | 1,459 | 1 |
→
Hash (cost=50.40..50.40 rows=1,459 width=169) (actual time=2.374..2.374 rows=1,459 loops=1)
|
41. | 1.164 | 1.589 | ↑ 1.0 | 1,459 | 1 |
→
Hash Left Join (cost=7.74..50.40 rows=1,459 width=169) (actual time=0.226..1.589 rows=1,459 loops=1)
|
42. | 0.223 | 0.223 | ↑ 1.0 | 1,459 | 1 |
→
Seq Scan on task_mgt_tag_to_task tags4_ (cost=0.00..22.59 rows=1,459 width=16) (actual time=0.007..0.223 rows=1,459 loops=1) |
43. | 0.033 | 0.202 | ↑ 1.0 | 63 | 1 |
→
Hash (cost=6.96..6.96 rows=63 width=153) (actual time=0.202..0.202 rows=63 loops=1)
|
44. | 0.049 | 0.169 | ↑ 1.0 | 63 | 1 |
→
Hash Left Join (cost=4.83..6.96 rows=63 width=153) (actual time=0.110..0.169 rows=63 loops=1)
|
45. | 0.052 | 0.105 | ↑ 1.0 | 63 | 1 |
→
Hash Right Join (cost=2.42..4.29 rows=63 width=102) (actual time=0.080..0.105 rows=63 loops=1)
|
46. | 0.010 | 0.010 | ↑ 1.0 | 63 | 1 |
→
Seq Scan on task_mgt_tag taskmanage6_ (cost=0.00..1.63 rows=63 width=51) (actual time=0.003..0.010 rows=63 loops=1) |
47. | 0.030 | 0.043 | ↑ 1.0 | 63 | 1 |
→
Hash (cost=1.63..1.63 rows=63 width=51) (actual time=0.043..0.043 rows=63 loops=1)
|
48. | 0.013 | 0.013 | ↑ 1.0 | 63 | 1 |
→
Seq Scan on task_mgt_tag taskmanage5_ (cost=0.00..1.63 rows=63 width=51) (actual time=0.004..0.013 rows=63 loops=1) |
49. | 0.006 | 0.015 | ↓ 0.0 | 0 | 1 |
→
Hash (cost=1.63..1.63 rows=63 width=51) (actual time=0.015..0.015 rows=0 loops=1)
|
50. | 0.009 | 0.009 | ↑ 1.0 | 63 | 1 |
→
Seq Scan on task_mgt_tag children7_ (cost=0.00..1.63 rows=63 width=51) (actual time=0.003..0.009 rows=63 loops=1) |