# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.000 | 1.059 | ↓ 0.0 | 0 | 1 |
→
Unique (cost=24.30..24.30 rows=1 width=8) (actual time=1.059..1.059 rows=0 loops=1) |
2. | 0.026 | 1.059 | ↓ 0.0 | 0 | 1 |
→
Sort (cost=24.30..24.30 rows=1 width=8) (actual time=1.059..1.059 rows=0 loops=1)
|
3. | 0.001 | 1.033 | ↓ 0.0 | 0 | 1 |
→
Nested Loop Left Join (cost=5.89..24.29 rows=1 width=8) (actual time=1.033..1.033 rows=0 loops=1) |
4. | 0.001 | 1.032 | ↓ 0.0 | 0 | 1 |
→
Hash Join (cost=5.33..21.69 rows=1 width=8) (actual time=1.032..1.032 rows=0 loops=1)
|
5. | 1.031 | 1.031 | ↓ 0.0 | 0 | 1 |
→
Index Scan using user_loc_user_id on user_location ul (cost=0.42..16.63 rows=37 width=8) (actual time=1.031..1.031 rows=0 loops=1)
|
6. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Hash (cost=4.90..4.90 rows=1 width=16) (never executed) |
|
7. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Nested Loop (cost=0.85..4.90 rows=1 width=16) (never executed) |
|
8. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using i_loc_corp_id on location loc (cost=0.29..2.31 rows=1 width=8) (never executed)
|
|
9. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using idx_loc_flag_del on location_flag lf (cost=0.56..2.58 rows=1 width=8) (never executed)
|
|
10. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Index Scan using idx_loc_flag_del on location_flag lfg (cost=0.56..2.58 rows=1 width=8) (never executed)
|