# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 2,214.746 | 3,572.732 | ↓ 2.5 | 2,225,121 | 1 |
→
Hash Right Join (cost=21,527.94..120,379.48 rows=907,458 width=178) (actual time=1,507.448..3,572.732 rows=2,225,121 loops=1)
|
2. | 788.827 | 788.827 | ↑ 1.0 | 2,267,962 | 1 |
→
Seq Scan on vehicle_attribute vehicleatt1_ (cost=0.00..44,465.10 rows=2,275,710 width=38) (actual time=0.008..788.827 rows=2,267,962 loops=1) |
3. | 155.279 | 569.159 | ↓ 3.7 | 219,107 | 1 |
→
Hash (cost=19,564.44..19,564.44 rows=59,480 width=140) (actual time=569.159..569.159 rows=219,107 loops=1)
|
4. | 145.572 | 413.880 | ↓ 3.7 | 219,107 | 1 |
→
Hash Left Join (cost=541.49..19,564.44 rows=59,480 width=140) (actual time=19.943..413.880 rows=219,107 loops=1)
|
5. | 107.473 | 260.954 | ↓ 3.7 | 219,107 | 1 |
→
Nested Loop Left Join (cost=191.14..18,396.24 rows=59,480 width=105) (actual time=12.523..260.954 rows=219,107 loops=1) |
6. | 19.067 | 69.481 | ↓ 1.8 | 2,000 | 1 |
→
Hash Semi Join (cost=190.71..4,762.96 rows=1,094 width=89) (actual time=12.493..69.481 rows=2,000 loops=1)
|
7. | 37.952 | 37.952 | ↓ 1.1 | 64,407 | 1 |
→
Seq Scan on vehicle vehicle0_ (cost=0.00..4,401.49 rows=60,414 width=89) (actual time=0.011..37.952 rows=64,407 loops=1)
|
8. | 0.569 | 12.462 | ↑ 1.0 | 2,000 | 1 |
→
Hash (cost=165.71..165.71 rows=2,000 width=32) (actual time=12.462..12.462 rows=2,000 loops=1)
|
9. | 0.804 | 11.893 | ↑ 1.0 | 2,000 | 1 |
→
Limit (cost=0.00..145.71 rows=2,000 width=32) (actual time=0.008..11.893 rows=2,000 loops=1) |
10. | 11.089 | 11.089 | ↑ 30.2 | 2,000 | 1 |
→
Seq Scan on vehicle (cost=0.00..4,401.49 rows=60,414 width=32) (actual time=0.006..11.089 rows=2,000 loops=1)
|
11. | 84.000 | 84.000 | ↑ 1.8 | 110 | 2,000 |
→
Index Scan using vehicle_capability_vehicles_id_idx on vehicle_capability capabiliti2_ (cost=0.43..10.51 rows=195 width=16) (actual time=0.005..0.042 rows=110 loops=2,000)
|
12. | 4.069 | 7.354 | ↓ 1.0 | 11,201 | 1 |
→
Hash (cost=214.60..214.60 rows=10,860 width=35) (actual time=7.354..7.354 rows=11,201 loops=1)
|
13. | 3.285 | 3.285 | ↓ 1.0 | 11,201 | 1 |
→
Seq Scan on capability capability3_ (cost=0.00..214.60 rows=10,860 width=35) (actual time=0.005..3.285 rows=11,201 loops=1) |