# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.002 | 0.077 | ↑ 1.0 | 1 | 1 |
→
Limit (cost=40.37..40.37 rows=1 width=189) (actual time=0.075..0.077 rows=1 loops=1) |
2. | 0.009 | 0.075 | ↑ 19.0 | 1 | 1 |
→
Sort (cost=40.37..40.41 rows=19 width=189) (actual time=0.075..0.075 rows=1 loops=1)
|
3. | 0.006 | 0.066 | ↑ 1.1 | 18 | 1 |
→
Hash Join (cost=27.45..40.27 rows=19 width=189) (actual time=0.060..0.066 rows=18 loops=1)
|
4. | 0.006 | 0.051 | ↑ 1.1 | 18 | 1 |
→
Hash Right Join (cost=26.32..39.06 rows=19 width=180) (actual time=0.047..0.051 rows=18 loops=1)
|
5. | 0.007 | 0.015 | ↑ 8.0 | 1 | 1 |
→
Hash Right Join (cost=14.42..26.95 rows=8 width=164) (actual time=0.011..0.015 rows=1 loops=1)
|
6. | 0.004 | 0.004 | ↑ 50.0 | 4 | 1 |
→
Seq Scan on nodeslogical (cost=0.00..12.00 rows=200 width=158) (actual time=0.003..0.004 rows=4 loops=1) |
7. | 0.001 | 0.004 | ↑ 8.0 | 1 | 1 |
→
Hash (cost=14.32..14.32 rows=8 width=10) (actual time=0.004..0.004 rows=1 loops=1)
|
8. | 0.001 | 0.003 | ↑ 8.0 | 1 | 1 |
→
Bitmap Heap Scan on wifiaccesspointsassignmenthistory (cost=4.19..14.32 rows=8 width=10) (actual time=0.003..0.003 rows=1 loops=1)
|
9. | 0.002 | 0.002 | ↑ 8.0 | 1 | 1 |
→
Bitmap Index Scan on wapah_unique_active_logical (cost=0.00..4.18 rows=8 width=0) (actual time=0.002..0.002 rows=1 loops=1) |
10. | 0.003 | 0.030 | ↑ 1.1 | 18 | 1 |
→
Hash (cost=11.66..11.66 rows=19 width=22) (actual time=0.030..0.030 rows=18 loops=1)
|
11. | 0.014 | 0.027 | ↑ 1.1 | 18 | 1 |
→
Bitmap Heap Scan on wifiaeroscouttagspositionhistory (cost=4.42..11.66 rows=19 width=22) (actual time=0.017..0.027 rows=18 loops=1)
|
12. | 0.013 | 0.013 | ↑ 1.1 | 18 | 1 |
→
Bitmap Index Scan on watph_wat_mac_index (cost=0.00..4.42 rows=19 width=0) (actual time=0.012..0.013 rows=18 loops=1)
|
13. | 0.002 | 0.009 | ↑ 1.0 | 6 | 1 |
→
Hash (cost=1.06..1.06 rows=6 width=15) (actual time=0.009..0.009 rows=6 loops=1)
|
14. | 0.007 | 0.007 | ↑ 1.0 | 6 | 1 |
→
Seq Scan on wifiaccesspoints (cost=0.00..1.06 rows=6 width=15) (actual time=0.005..0.007 rows=6 loops=1) |