# | exclusive | inclusive | rows x | rows | loops | node |
---|---|---|---|---|---|---|
1. | 13.659 | 50,399.486 | ↑ 1.0 | 1 | 1 |
→
Aggregate (cost=6,670.14..6,670.15 rows=1 width=32) (actual time=50,399.486..50,399.486 rows=1 loops=1) |
2. | 1.685 | 50,385.827 | ↓ 417.0 | 417 | 1 |
→
Subquery Scan on q (cost=6,632.54..6,670.13 rows=1 width=44) (actual time=29,399.653..50,385.827 rows=417 loops=1) |
3. | 18,929.864 | 50,384.142 | ↓ 417.0 | 417 | 1 |
→
GroupAggregate (cost=6,632.54..6,670.12 rows=1 width=253) (actual time=29,399.634..50,384.142 rows=417 loops=1)
|
4. |
CTE boundaries |
|||||
5. | 0.000 | 0.000 | ↓ 0.0 | 0 |
→
Seq Scan on v_transit_boundaries (cost=0.00..910.46 rows=3,346 width=75,373) (never executed) |
|
6. | 11,930.518 | 31,454.278 | ↓ 5,599.9 | 3,819,120 | 1 |
→
Sort (cost=5,722.08..5,723.79 rows=682 width=209) (actual time=29,392.342..31,454.278 rows=3,819,120 loops=1)
|
7. | 1,747.763 | 19,523.760 | ↓ 5,599.9 | 3,819,120 | 1 |
→
Nested Loop Left Join (cost=5.73..5,689.98 rows=682 width=209) (actual time=0.343..19,523.760 rows=3,819,120 loops=1)
|
8. | 3,277.325 | 17,775.997 | ↓ 5,599.9 | 3,819,120 | 1 |
→
Nested Loop Left Join (cost=5.73..5,683.16 rows=682 width=209) (actual time=0.340..17,775.997 rows=3,819,120 loops=1) |
9. | 708.522 | 3,041.312 | ↓ 5,599.9 | 3,819,120 | 1 |
→
Nested Loop (cost=5.31..463.10 rows=682 width=193) (actual time=0.320..3,041.312 rows=3,819,120 loops=1) |
10. | 30.410 | 30.533 | ↓ 417.0 | 417 | 1 |
→
Bitmap Heap Scan on v_transit_roads (cost=4.73..174.86 rows=1 width=185) (actual time=0.244..30.533 rows=417 loops=1)
|
11. | 0.123 | 0.123 | ↓ 11.0 | 449 | 1 |
→
Bitmap Index Scan on idx_v_transit_roads_street_name (cost=0.00..4.73 rows=41 width=0) (actual time=0.122..0.123 rows=449 loops=1)
|
12. | 2,302.257 | 2,302.257 | ↓ 1.8 | 9,159 | 417 |
→
Index Only Scan using idx_road_segments_key on road_segments (cost=0.57..236.00 rows=5,224 width=16) (actual time=0.023..5.521 rows=9,159 loops=417)
|
13. | 11,457.360 | 11,457.360 | ↑ 1.0 | 1 | 3,819,120 |
→
Index Scan using trip on road_movements (cost=0.42..7.65 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=3,819,120)
|
14. | 0.000 | 0.000 | ↓ 0.0 | 0 | 3,819,120 |
→
Result (cost=0.00..0.00 rows=0 width=0) (actual time=0.000..0.000 rows=0 loops=3,819,120)
|
Planning time | : | 2.188 ms |
---|