# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.057 | 164.450 | ↓ 1.4 | 321 | 1 |
→
Limit (cost=871.56..872.12 rows=226 width=883) (actual time=164.351..164.450 rows=321 loops=1) |
2. | 0.804 | 164.393 | ↓ 1.4 | 321 | 1 |
→
Sort (cost=871.56..872.12 rows=226 width=883) (actual time=164.350..164.393 rows=321 loops=1)
|
3. | 5.014 | 163.589 | ↓ 1.4 | 321 | 1 |
→
Hash Left Join (cost=61.02..862.72 rows=226 width=883) (actual time=4.802..163.589 rows=321 loops=1)
|
4. | 0.798 | 158.301 | ↓ 1.4 | 321 | 1 |
→
Hash Join (cost=43.52..838.72 rows=226 width=608) (actual time=4.305..158.301 rows=321 loops=1)
|
5. | 154.294 | 157.484 | ↓ 1.4 | 321 | 1 |
→
Bitmap Heap Scan on position_log_data pl (cost=14.17..806.26 rows=226 width=578) (actual time=4.184..157.484 rows=321 loops=1)
|
6. | 3.190 | 3.190 | ↓ 1.4 | 321 | 1 |
→
Bitmap Index Scan on position_log_vehicle_position_idx (cost=0.00..14.12 rows=226 width=0) (actual time=3.190..3.190 rows=321 loops=1)
|
7. | 0.006 | 0.019 | ↑ 172.0 | 5 | 1 |
→
Hash (cost=18.60..18.60 rows=860 width=34) (actual time=0.019..0.019 rows=5 loops=1)
|
8. | 0.013 | 0.013 | ↑ 172.0 | 5 | 1 |
→
Seq Scan on position_source ps (cost=0.00..18.60 rows=860 width=34) (actual time=0.013..0.013 rows=5 loops=1) |
9. | 0.036 | 0.274 | ↑ 1.0 | 111 | 1 |
→
Hash (cost=16.11..16.11 rows=111 width=155) (actual time=0.274..0.274 rows=111 loops=1)
|
10. | 0.238 | 0.238 | ↑ 1.0 | 111 | 1 |
→
Seq Scan on administrator a (cost=0.00..16.11 rows=111 width=155) (actual time=0.009..0.238 rows=111 loops=1) |