# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 0.289 | 14.894 | ↑ 1.0 | 1 | 1 |
→
Aggregate (cost=4,644.29..4,644.30 rows=1 width=16) (actual time=14.894..14.894 rows=1 loops=1)
|
2. | 1.773 | 14.605 | ↑ 1.0 | 1,000 | 1 |
→
Limit (cost=1,000.00..4,629.29 rows=1,000 width=8) (actual time=1.699..14.605 rows=1,000 loops=1)
|
3. | 0.000 | 12.832 | ↑ 902.2 | 1,000 | 1 |
→
Subquery Scan on bml_vbase_delivery_analytics (cost=1,000.00..3,275,195.77 rows=902,158 width=8) (actual time=1.697..12.832 rows=1,000 loops=1)
|
4. | 7.979 | 13.920 | ↑ 902.2 | 1,000 | 1 |
→
Gather (cost=1,000.00..3,266,174.19 rows=902,158 width=368) (actual time=1.697..13.920 rows=1,000 loops=1)
|
5. | 0.522 | 5.941 | ↑ 115,943.8 | 251 | 4 |
→
Result (cost=0.00..3,174,958.39 rows=29,101,900 width=368) (actual time=0.120..5.941 rows=251 loops=4)
|
6. | 4.913 | 5.419 | ↑ 115,943.8 | 251 | 4 |
→
ProjectSet (cost=0.00..337,523.14 rows=29,101,900 width=264) (actual time=0.111..5.419 rows=251 loops=4)
|
7. | 0.000 | 0.506 | ↑ 1,616.8 | 180 | 4 |
→
Parallel Append (cost=0.00..173,097.41 rows=291,019 width=1,252) (actual time=0.045..0.506 rows=180 loops=4)
|
8. | 0.485 | 0.485 | ↑ 1,751.3 | 96 | 2 |
→
Parallel Index Scan using route_delivery_1549231200_endtime_idx on delivery_1549231200 d_1 (cost=0.42..97,292.63 rows=168,128 width=1,249) (actual time=0.056..0.485 rows=96 loops=2)
|
9. | 0.351 | 0.351 | ↑ 462.0 | 266 | 2 |
→
Parallel Index Scan using route_delivery_1549317600_endtime_idx on delivery_1549317600 d_2 (cost=0.42..71,439.49 rows=122,890 width=1,255) (actual time=0.028..0.351 rows=266 loops=2)
|
10. | 0.001 | 0.001 | ↓ 0.0 | 0 | 1 |
→
Parallel Seq Scan on delivery d (cost=0.00..0.00 rows=1 width=40) (actual time=0.001..0.001 rows=0 loops=1)
|