# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 1.659 | 59.725 | ↓ 1,111.0 | 6,666 | 1 |
→
Nested Loop (cost=1,651.79..3,360.76 rows=6 width=10) (actual time=22.823..59.725 rows=6,666 loops=1) |
2. | 1.576 | 31.402 | ↓ 12.1 | 6,666 | 1 |
→
Nested Loop (cost=1,651.35..2,430.13 rows=552 width=14) (actual time=22.802..31.402 rows=6,666 loops=1) |
3. | 1.533 | 23.160 | ↓ 12.1 | 1,111 | 1 |
→
HashAggregate (cost=1,650.93..1,651.85 rows=92 width=8) (actual time=22.780..23.160 rows=1,111 loops=1)
|
4. | 0.721 | 21.627 | ↓ 11.6 | 1,111 | 1 |
→
Nested Loop (cost=13.87..1,650.69 rows=96 width=8) (actual time=6.379..21.627 rows=1,111 loops=1) |
5. | 0.979 | 15.351 | ↓ 11.6 | 1,111 | 1 |
→
Nested Loop (cost=13.43..1,111.33 rows=96 width=12) (actual time=6.338..15.351 rows=1,111 loops=1) |
6. | 2.748 | 8.817 | ↓ 12.1 | 1,111 | 1 |
→
Bitmap Heap Scan on fs_node u0 (cost=13.01..342.39 rows=92 width=4) (actual time=6.304..8.817 rows=1,111 loops=1)
|
7. | 6.069 | 6.069 | ↓ 11.8 | 1,112 | 1 |
→
Bitmap Index Scan on path_gist_idx (cost=0.00..12.98 rows=94 width=0) (actual time=6.069..6.069 rows=1,112 loops=1)
|
8. | 5.555 | 5.555 | ↑ 1.0 | 1 | 1,111 |
→
Index Scan using fs_permission_node_id_access_right_81ac3a0e_uniq on fs_permission u1 (cost=0.42..8.36 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=1,111)
|
9. | 5.555 | 5.555 | ↑ 1.0 | 1 | 1,111 |
→
Index Only Scan using fs_userpermission_user_id_permission_id_baa0e460_uniq on fs_userpermission u2 (cost=0.43..5.62 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=1,111)
|
10. | 6.666 | 6.666 | ↑ 1.0 | 6 | 1,111 |
→
Index Scan using fs_permission_node_id_638e8a2b on fs_permission (cost=0.42..8.40 rows=6 width=14) (actual time=0.004..0.006 rows=6 loops=1,111)
|
11. | 26.664 | 26.664 | ↑ 1.0 | 1 | 6,666 |
→
Index Only Scan using fs_userpermission_user_id_permission_id_baa0e460_uniq on fs_userpermission (cost=0.43..1.69 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=6,666)
|
Planning time | : | 2.259 ms |
---|---|---|
Execution time | : | 60.395 ms |