# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.002 | 0.053 | ↑ 1.0 | 1 | 1 |
→
Limit (cost=0.42..9.16 rows=1 width=189) (actual time=0.051..0.053 rows=1 loops=1) |
2. | 0.002 | 0.051 | ↑ 19.0 | 1 | 1 |
→
Nested Loop Left Join (cost=0.42..166.55 rows=19 width=189) (actual time=0.051..0.051 rows=1 loops=1)
|
3. | 0.001 | 0.042 | ↑ 19.0 | 1 | 1 |
→
Nested Loop Left Join (cost=0.42..97.05 rows=19 width=35) (actual time=0.042..0.042 rows=1 loops=1) |
4. | 0.003 | 0.038 | ↑ 19.0 | 1 | 1 |
→
Nested Loop (cost=0.27..45.39 rows=19 width=37) (actual time=0.038..0.038 rows=1 loops=1)
|
5. | 0.026 | 0.026 | ↑ 19.0 | 1 | 1 |
→
Index Only Scan using watph_wat_mac_index on wifiaeroscouttagspositionhistory (cost=0.27..42.74 rows=19 width=22) (actual time=0.026..0.026 rows=1 loops=1)
|
6. | 0.003 | 0.009 | ↑ 1.2 | 5 | 1 |
→
Materialize (cost=0.00..1.09 rows=6 width=15) (actual time=0.007..0.009 rows=5 loops=1) |
7. | 0.006 | 0.006 | ↑ 1.2 | 5 | 1 |
→
Seq Scan on wifiaccesspoints (cost=0.00..1.06 rows=6 width=15) (actual time=0.004..0.006 rows=5 loops=1) |
8. | 0.003 | 0.003 | ↓ 0.0 | 0 | 1 |
→
Index Scan using wapah_unique_active_mac on wifiaccesspointsassignmenthistory (cost=0.14..2.69 rows=1 width=10) (actual time=0.003..0.003 rows=0 loops=1)
|
9. | 0.002 | 0.007 | ↑ 50.0 | 4 | 1 |
→
Materialize (cost=0.00..13.00 rows=200 width=158) (actual time=0.005..0.007 rows=4 loops=1) |
10. | 0.005 | 0.005 | ↑ 50.0 | 4 | 1 |
→
Seq Scan on nodeslogical (cost=0.00..12.00 rows=200 width=158) (actual time=0.004..0.005 rows=4 loops=1) |