# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.031 | 57,825.182 | ↓ 3.7 | 74 | 1 |
→
Limit (cost=1,400,187.01..1,400,187.06 rows=20 width=1,105) (actual time=57,825.140..57,825.182 rows=74 loops=1)
|
2. | 0.263 | 57,825.151 | ↓ 3.7 | 74 | 1 |
→
Sort (cost=1,400,187.01..1,400,187.06 rows=20 width=1,105) (actual time=57,825.138..57,825.151 rows=74 loops=1)
|
3. | 0.519 | 57,824.888 | ↓ 3.7 | 74 | 1 |
→
Nested Loop Left Join (cost=0.00..1,400,186.58 rows=20 width=1,105) (actual time=981.863..57,824.888 rows=74 loops=1)
|
4. | 0.167 | 11,072.279 | ↓ 3.7 | 74 | 1 |
→
Nested Loop (cost=0.00..382,662.08 rows=20 width=73) (actual time=311.673..11,072.279 rows=74 loops=1)
|
5. | 0.007 | 0.007 | ↑ 1.0 | 1 | 1 |
→
Seq Scan on projectstatuslabel projectstatuslabel7 (cost=0.00..1.07 rows=1 width=16) (actual time=0.005..0.007 rows=1 loops=1)
|
6. | 0.334 | 11,072.105 | ↓ 1.9 | 77 | 1 |
→
Seq Scan on project project0 (cost=0.00..382,660.49 rows=41 width=89) (actual time=191.022..11,072.105 rows=77 loops=1)
|
7. |
SubPlan (forSeq Scan) |
|||||
8. | 12.495 | 11,071.771 | ↑ 29.0 | 1 | 79 |
→
Nested Loop Semi Join (cost=73.39..50,876.07 rows=29 width=0) (actual time=140.149..140.149 rows=1 loops=79)
|
9. | 9.796 | 9.796 | ↑ 2.1 | 120 | 79 |
→
Index Scan using ixtkprojectid on task task8 (cost=0.29..90.59 rows=254 width=4) (actual time=0.010..0.124 rows=120 loops=79)
|
10. | 919.272 | 11,049.480 | ↓ 0.0 | 0 | 9,444 |
→
Hash Join (cost=73.10..260.30 rows=3,712 width=4) (actual time=1.170..1.170 rows=0 loops=9,444)
|
11. | 10,082.977 | 10,082.988 | ↑ 9.8 | 379 | 9,441 |
→
Seq Scan on projectteammember projectteammember9 (cost=4.53..170.75 rows=3,712 width=16) (actual time=0.002..1.068 rows=379 loops=9,441)
|
12. |
SubPlan (forSeq Scan) |
|||||
13. | 0.002 | 0.011 | ↑ 1.5 | 2 | 1 |
→
Nested Loop (cost=0.42..4.52 rows=3 width=4) (actual time=0.008..0.011 rows=2 loops=1)
|
14. | 0.006 | 0.006 | ↑ 1.0 | 1 | 1 |
→
Index Scan using ixduuserid on departmentusers departmentusers12 (cost=0.28..2.29 rows=1 width=4) (actual time=0.005..0.006 rows=1 loops=1)
|
15. | 0.003 | 0.003 | ↑ 1.5 | 2 | 1 |
→
Index Scan using ixdfhchildid on departmentflathierarchy departmentflathierarchy11 (cost=0.14..2.19 rows=3 width=8) (actual time=0.002..0.003 rows=2 loops=1)
|
16. | 18.888 | 47.220 | ↑ 241.5 | 2 | 9,444 |
→
Hash (cost=62.54..62.54 rows=483 width=20) (actual time=0.005..0.005 rows=2 loops=9,444)
|
17. | 28.332 | 28.332 | ↑ 241.5 | 2 | 9,444 |
→
Index Only Scan using uix2projectteammembertaskassignment on taskteammemberassignment taskteammemberassignment10 (cost=0.43..62.54 rows=483 width=20) (actual time=0.003..0.003 rows=2 loops=9,444)
|
18. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Hash Join (cost=86,104.89..87,819.59 rows=6,096 width=4) (never executed)
|
|
19. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Seq Scan on task task8_1 (cost=0.00..1,456.55 rows=52,583 width=8) (never executed)
|
|
20. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Hash (cost=86,026.58..86,026.58 rows=6,265 width=4) (never executed) |
|
21. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
HashAggregate (cost=85,963.93..86,026.58 rows=6,265 width=4) (never executed)
|
|
22. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Hash Join (cost=217.15..82,177.41 rows=1,514,607 width=4) (never executed)
|
|
23. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Seq Scan on taskteammemberassignment taskteammemberassignment10_1 (cost=0.00..55,468.41 rows=3,025,541 width=20) (never executed) |
|
24. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Hash (cost=170.75..170.75 rows=3,712 width=16) (never executed) |
|
25. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Seq Scan on projectteammember projectteammember9_1 (cost=4.53..170.75 rows=3,712 width=16) (never executed)
|
|
26. |
SubPlan (forSeq Scan) |
|||||
27. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=0.42..4.52 rows=3 width=4) (never executed) |
|
28. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using ixduuserid on departmentusers departmentusers12_1 (cost=0.28..2.29 rows=1 width=4) (never executed)
|
|
29. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using ixdfhchildid on departmentflathierarchy departmentflathierarchy11_1 (cost=0.14..2.19 rows=3 width=8) (never executed)
|
|
30. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using uix3ptm_projectrole on projectteammember projectteammember13 (cost=4.81..20.26 rows=18 width=0) (never executed)
|
|
31. |
SubPlan (forIndex Scan) |
|||||
32. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=0.42..4.52 rows=3 width=4) (never executed) |
|
33. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using ixduuserid on departmentusers departmentusers15 (cost=0.28..2.29 rows=1 width=4) (never executed)
|
|
34. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using ixdfhchildid on departmentflathierarchy departmentflathierarchy14 (cost=0.14..2.19 rows=3 width=8) (never executed)
|
|
35. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Seq Scan on projectteammember projectteammember13_1 (cost=4.53..170.75 rows=3,712 width=4) (never executed)
|
|
36. |
SubPlan (forSeq Scan) |
|||||
37. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=0.42..4.52 rows=3 width=4) (never executed) |
|
38. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using ixduuserid on departmentusers departmentusers15_1 (cost=0.28..2.29 rows=1 width=4) (never executed)
|
|
39. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using ixdfhchildid on departmentflathierarchy departmentflathierarchy14_1 (cost=0.14..2.19 rows=3 width=8) (never executed)
|
|
40. | 0.067 | 0.074 | ↑ 1.0 | 1 | 74 |
→
Materialize (cost=0.00..1.14 rows=1 width=1,048) (actual time=0.001..0.001 rows=1 loops=74)
|
41. | 0.007 | 0.007 | ↑ 1.0 | 1 | 1 |
→
Seq Scan on program program6 (cost=0.00..1.14 rows=1 width=1,048) (actual time=0.005..0.007 rows=1 loops=1)
|
42. |
SubPlan (forNested Loop Left Join) |
|||||
43. | 0.666 | 46,752.016 | ↑ 1.0 | 1 | 74 |
→
Aggregate (cost=50,876.14..50,876.15 rows=1 width=0) (actual time=631.783..631.784 rows=1 loops=74)
|
44. | 79.364 | 46,751.350 | ↑ 1.9 | 15 | 74 |
→
Nested Loop Semi Join (cost=73.39..50,876.07 rows=29 width=0) (actual time=143.949..631.775 rows=15 loops=74)
|
45. | 39.146 | 39.146 | ↓ 2.2 | 553 | 74 |
→
Index Scan using ixtkprojectid on task task1 (cost=0.29..90.59 rows=254 width=4) (actual time=0.008..0.529 rows=553 loops=74)
|
46. | 3,911.030 | 46,632.840 | ↓ 0.0 | 0 | 40,906 |
→
Hash Join (cost=73.10..260.30 rows=3,712 width=4) (actual time=1.140..1.140 rows=0 loops=40,906)
|
47. | 42,517.268 | 42,517.280 | ↑ 9.9 | 376 | 40,882 |
→
Seq Scan on projectteammember projectteammember2 (cost=4.53..170.75 rows=3,712 width=16) (actual time=0.002..1.040 rows=376 loops=40,882)
|
48. |
SubPlan (forSeq Scan) |
|||||
49. | 0.003 | 0.012 | ↑ 1.5 | 2 | 1 |
→
Nested Loop (cost=0.42..4.52 rows=3 width=4) (actual time=0.010..0.012 rows=2 loops=1)
|
50. | 0.005 | 0.005 | ↑ 1.0 | 1 | 1 |
→
Index Scan using ixduuserid on departmentusers departmentusers5 (cost=0.28..2.29 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=1)
|
51. | 0.004 | 0.004 | ↑ 1.5 | 2 | 1 |
→
Index Scan using ixdfhchildid on departmentflathierarchy departmentflathierarchy4 (cost=0.14..2.19 rows=3 width=8) (actual time=0.003..0.004 rows=2 loops=1)
|
52. | 81.812 | 204.530 | ↑ 483.0 | 1 | 40,906 |
→
Hash (cost=62.54..62.54 rows=483 width=20) (actual time=0.005..0.005 rows=1 loops=40,906)
|
53. | 122.718 | 122.718 | ↑ 483.0 | 1 | 40,906 |
→
Index Only Scan using uix2projectteammembertaskassignment on taskteammemberassignment taskteammemberassignment3 (cost=0.43..62.54 rows=483 width=20) (actual time=0.003..0.003 rows=1 loops=40,906)
|