# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.324 | 30.040 | ↑ 1.0 | 1,000 | 1 |
→
Limit (cost=1,000.43..6,649.97 rows=1,000 width=368) (actual time=1.688..30.040 rows=1,000 loops=1)
|
2. | 9.400 | 29.716 | ↑ 77.5 | 1,000 | 1 |
→
Gather (cost=1,000.43..438,273.33 rows=77,537 width=368) (actual time=1.686..29.716 rows=1,000 loops=1)
|
3. | 1.502 | 20.316 | ↑ 5,708.0 | 566 | 3 |
→
Result (cost=0.43..429,519.63 rows=3,230,700 width=368) (actual time=0.139..20.316 rows=566 loops=3)
|
4. | 10.713 | 18.814 | ↑ 5,708.0 | 566 | 3 |
→
ProjectSet (cost=0.43..98,372.88 rows=3,230,700 width=304) (actual time=0.127..18.814 rows=566 loops=3)
|
5. | 0.000 | 8.101 | ↑ 79.4 | 407 | 3 |
→
Parallel Append (cost=0.43..80,119.43 rows=32,307 width=80) (actual time=0.051..8.101 rows=407 loops=3)
|
6. | 1.125 | 1.125 | ↑ 59.2 | 481 | 1 |
→
Parallel Index Scan using route_delivery_1549144800_endtime_idx on delivery_1549144800 d_1 (cost=0.43..49,739.39 rows=28,487 width=80) (actual time=0.075..1.125 rows=481 loops=1)
|
7. | 11.305 | 11.305 | ↑ 46.3 | 370 | 2 |
→
Parallel Index Scan using route_delivery_1549231200_endtime_idx on delivery_1549231200 d_2 (cost=0.43..29,895.44 rows=17,122 width=80) (actual time=0.032..11.305 rows=370 loops=2)
|
8. | 0.001 | 0.001 | ↓ 0.0 | 0 | 1 |
→
Parallel Seq Scan on delivery d (cost=0.00..0.00 rows=1 width=80) (actual time=0.001..0.001 rows=0 loops=1)
|