# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.024 | 9.849 | ↓ 6.0 | 6 | 1 |
→
Unique (cost=107.22..107.22 rows=1 width=8) (actual time=9.806..9.849 rows=6 loops=1) |
2. | 0.181 | 9.825 | ↓ 344.0 | 344 | 1 |
→
Sort (cost=107.22..107.22 rows=1 width=8) (actual time=9.805..9.825 rows=344 loops=1)
|
3. | 0.199 | 9.644 | ↓ 344.0 | 344 | 1 |
→
Nested Loop Left Join (cost=1.83..107.21 rows=1 width=8) (actual time=0.173..9.644 rows=344 loops=1) |
4. | 0.230 | 6.693 | ↓ 344.0 | 344 | 1 |
→
Nested Loop (cost=1.27..104.61 rows=1 width=8) (actual time=0.146..6.693 rows=344 loops=1) |
5. | 0.152 | 2.251 | ↓ 351.0 | 351 | 1 |
→
Nested Loop (cost=0.71..102.02 rows=1 width=16) (actual time=0.084..2.251 rows=351 loops=1) |
6. | 0.691 | 0.691 | ↓ 9.5 | 352 | 1 |
→
Index Scan using user_loc_user_id on user_location ul (cost=0.42..16.63 rows=37 width=8) (actual time=0.051..0.691 rows=352 loops=1)
|
7. | 1.408 | 1.408 | ↑ 1.0 | 1 | 352 |
→
Index Scan using idx_location_id_del on location loc (cost=0.29..2.31 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=352)
|
8. | 4.212 | 4.212 | ↑ 1.0 | 1 | 351 |
→
Index Scan using idx_loc_flag_del on location_flag lf (cost=0.56..2.58 rows=1 width=8) (actual time=0.012..0.012 rows=1 loops=351)
|
9. | 2.752 | 2.752 | ↓ 0.0 | 0 | 344 |
→
Index Scan using idx_loc_flag_del on location_flag lfg (cost=0.56..2.58 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=344)
|