explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tcvj

Settings
# exclusive inclusive rows x rows loops node
1. 23.616 251,554.734 ↑ 1.0 1 1

Aggregate (cost=48,770,310.83..48,770,311.03 rows=1 width=32) (actual time=251,554.733..251,554.734 rows=1 loops=1)

  • Functions: 274
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 34.904 ms, Inlining 52.504 ms, Optimization 935.833 ms, Emission 582.616 ms, Total 1605.857 ms"Execution Time: 251667.933 ms
2. 3.836 251,531.118 ↑ 2.5 3,432 1

Subquery Scan on q (cost=48,754,701.35..48,770,286.89 rows=8,578 width=44) (actual time=238,120.059..251,531.118 rows=3,432 loops=1)

3. 13,064.347 251,527.282 ↑ 2.5 3,432 1

GroupAggregate (cost=48,754,701.35..48,768,571.29 rows=8,578 width=255) (actual time=238,120.028..251,527.282 rows=3,432 loops=1)

  • Group Key: v_transit_roads.link_id, v_transit_roads.street_name, v_transit_roads.road_speed, v_transit_roads.road_rank, v_transit_roads.truck, v_transit_roads.surface, v_transit_roads.road_km, v_transit_roads.geometry
4. 6,224.285 238,462.935 ↓ 16.5 3,493,140 1

Sort (cost=48,754,701.35..48,755,231.40 rows=212,020 width=211) (actual time=238,119.931..238,462.935 rows=3,493,140 loops=1)

  • Sort Key: v_transit_roads.link_id, v_transit_roads.street_name, v_transit_roads.road_speed, v_transit_roads.road_rank, v_transit_roads.truck, v_transit_roads.surface, v_transit_roads.road_km, v_transit_roads.geometry
  • Sort Method: quicksort Memory: 1141224kB
5. 2,453.918 232,238.650 ↓ 16.5 3,493,140 1

Nested Loop (cost=1.43..48,735,944.11 rows=212,020 width=211) (actual time=1,591.646..232,238.650 rows=3,493,140 loops=1)

6. 505.038 219,305.312 ↓ 16.5 3,493,140 1

Nested Loop (cost=1.00..48,236,715.85 rows=212,020 width=195) (actual time=1,591.624..219,305.312 rows=3,493,140 loops=1)

7. 1,579.903 2,330.306 ↓ 11.0 3,432 1

Nested Loop (cost=0.57..55.17 rows=311 width=187) (actual time=1,590.485..2,330.306 rows=3,432 loops=1)

8. 0.742 0.742 ↑ 1.0 1 1

Index Scan using idx_v_transit_boundaries_code on v_transit_boundaries (cost=0.28..2.48 rows=1 width=78,632) (actual time=0.740..0.742 rows=1 loops=1)

  • Index Cond: (code = ANY ('{LGA_34580}'::text[]))
9. 749.661 749.661 ↓ 3,432.0 3,432 1

Index Scan using v_transit_roads_geometry_geom_idx on v_transit_roads (cost=0.29..52.49 rows=1 width=187) (actual time=12.375..749.661 rows=3,432 loops=1)

  • Index Cond: ((geometry && v_transit_boundaries.geometry) AND (geometry && '0103000020110F000001000000050000003D0A977A991F7041CDCCCC56F6E247C13D0A977A991F7041EC51F818D67B48C1E17ADC72B5327041EC51F818D67B48C1E17ADC72B5327041CDCCCC56F6E247C13D0A977A991F7041CDCCCC56F6E247C1'::geometry))
  • Filter: (st_intersects(geometry, '0103000020110F000001000000050000003D0A977A991F7041CDCCCC56F6E247C13D0A977A991F7041EC51F818D67B48C1E17ADC72B5327041EC51F818D67B48C1E17ADC72B5327041CDCCCC56F6E247C13D0A977A991F7041CDCCCC56F6E247C1'::geometry) AND st_intersects(geometry, v_transit_boundaries.geometry))
  • Rows Removed by Filter: 1564
10. 385.022 216,469.968 ↑ 111.2 1,018 3,432

Append (cost=0.43..132,454.20 rows=113,238 width=16) (actual time=0.641..63.074 rows=1,018 loops=3,432)

11. 2,180.920 2,180.920 ↑ 1.4 1,578 56

Index Scan using road_segments_partitioned_0_link_id_idx on road_segments_partitioned_0 (cost=0.43..2,438.24 rows=2,279 width=16) (actual time=0.634..38.945 rows=1,578 loops=56)

  • Index Cond: (link_id = v_transit_roads.link_id)
12. 4,807.560 4,807.560 ↑ 2.2 976 60

Index Scan using road_segments_partitioned_1_link_id_idx on road_segments_partitioned_1 (cost=0.43..2,313.20 rows=2,163 width=16) (actual time=0.652..80.126 rows=976 loops=60)

  • Index Cond: (link_id = v_transit_roads.link_id)
13. 4,630.693 4,630.693 ↑ 4.3 516 61

Index Scan using road_segments_partitioned_2_link_id_idx on road_segments_partitioned_2 (cost=0.43..2,361.29 rows=2,206 width=16) (actual time=0.672..75.913 rows=516 loops=61)

  • Index Cond: (link_id = v_transit_roads.link_id)
14. 4,851.004 4,851.004 ↑ 1.9 1,206 62

Index Scan using road_segments_partitioned_3_link_id_idx on road_segments_partitioned_3 (cost=0.43..2,407.39 rows=2,250 width=16) (actual time=0.571..78.242 rows=1,206 loops=62)

  • Index Cond: (link_id = v_transit_roads.link_id)
15. 1,670.240 1,670.240 ↑ 1.5 1,529 80

Index Scan using road_segments_partitioned_4_link_id_idx on road_segments_partitioned_4 (cost=0.43..2,470.23 rows=2,309 width=16) (actual time=0.564..20.878 rows=1,529 loops=80)

  • Index Cond: (link_id = v_transit_roads.link_id)
16. 4,906.291 4,906.291 ↑ 2.5 895 61

Index Scan using road_segments_partitioned_5_link_id_idx on road_segments_partitioned_5 (cost=0.43..2,360.60 rows=2,208 width=16) (actual time=0.635..80.431 rows=895 loops=61)

  • Index Cond: (link_id = v_transit_roads.link_id)
17. 4,791.240 4,791.240 ↑ 3.4 652 72

Index Scan using road_segments_partitioned_6_link_id_idx on road_segments_partitioned_6 (cost=0.43..2,368.71 rows=2,214 width=16) (actual time=0.609..66.545 rows=652 loops=72)

  • Index Cond: (link_id = v_transit_roads.link_id)
18. 5,841.588 5,841.588 ↑ 3.2 696 76

Index Scan using road_segments_partitioned_7_link_id_idx on road_segments_partitioned_7 (cost=0.43..2,361.05 rows=2,209 width=16) (actual time=0.562..76.863 rows=696 loops=76)

  • Index Cond: (link_id = v_transit_roads.link_id)
19. 3,848.747 3,848.747 ↑ 1.5 1,468 59

Index Scan using road_segments_partitioned_8_link_id_idx on road_segments_partitioned_8 (cost=0.43..2,280.42 rows=2,132 width=16) (actual time=0.663..65.233 rows=1,468 loops=59)

  • Index Cond: (link_id = v_transit_roads.link_id)
20. 2,669.012 2,669.012 ↑ 2.2 1,088 67

Index Scan using road_segments_partitioned_9_link_id_idx on road_segments_partitioned_9 (cost=0.43..2,516.85 rows=2,352 width=16) (actual time=0.601..39.836 rows=1,088 loops=67)

  • Index Cond: (link_id = v_transit_roads.link_id)
21. 4,465.076 4,465.076 ↑ 3.7 589 77

Index Scan using road_segments_partitioned_10_link_id_idx on road_segments_partitioned_10 (cost=0.43..2,344.21 rows=2,191 width=16) (actual time=0.701..57.988 rows=589 loops=77)

  • Index Cond: (link_id = v_transit_roads.link_id)
22. 4,881.336 4,881.336 ↑ 1.8 1,294 69

Index Scan using road_segments_partitioned_11_link_id_idx on road_segments_partitioned_11 (cost=0.43..2,529.57 rows=2,365 width=16) (actual time=0.581..70.744 rows=1,294 loops=69)

  • Index Cond: (link_id = v_transit_roads.link_id)
23. 5,309.616 5,309.616 ↑ 2.5 946 78

Index Scan using road_segments_partitioned_12_link_id_idx on road_segments_partitioned_12 (cost=0.43..2,486.21 rows=2,325 width=16) (actual time=0.629..68.072 rows=946 loops=78)

  • Index Cond: (link_id = v_transit_roads.link_id)
24. 5,074.410 5,074.410 ↑ 2.2 1,058 66

Index Scan using road_segments_partitioned_13_link_id_idx on road_segments_partitioned_13 (cost=0.43..2,469.06 rows=2,311 width=16) (actual time=0.588..76.885 rows=1,058 loops=66)

  • Index Cond: (link_id = v_transit_roads.link_id)
25. 5,025.822 5,025.822 ↑ 2.2 1,030 69

Index Scan using road_segments_partitioned_14_link_id_idx on road_segments_partitioned_14 (cost=0.43..2,473.47 rows=2,311 width=16) (actual time=0.602..72.838 rows=1,030 loops=69)

  • Index Cond: (link_id = v_transit_roads.link_id)
26. 4,569.124 4,569.124 ↑ 1.4 1,583 58

Index Scan using road_segments_partitioned_15_link_id_idx on road_segments_partitioned_15 (cost=0.43..2,394.70 rows=2,237 width=16) (actual time=0.639..78.778 rows=1,583 loops=58)

  • Index Cond: (link_id = v_transit_roads.link_id)
27. 4,575.932 4,575.932 ↑ 3.3 693 73

Index Scan using road_segments_partitioned_16_link_id_idx on road_segments_partitioned_16 (cost=0.43..2,456.96 rows=2,296 width=16) (actual time=0.684..62.684 rows=693 loops=73)

  • Index Cond: (link_id = v_transit_roads.link_id)
28. 5,112.502 5,112.502 ↑ 1.6 1,390 67

Index Scan using road_segments_partitioned_17_link_id_idx on road_segments_partitioned_17 (cost=0.43..2,453.58 rows=2,292 width=16) (actual time=0.758..76.306 rows=1,390 loops=67)

  • Index Cond: (link_id = v_transit_roads.link_id)
29. 4,666.816 4,666.816 ↑ 1.9 1,183 56

Index Scan using road_segments_partitioned_18_link_id_idx on road_segments_partitioned_18 (cost=0.43..2,451.05 rows=2,294 width=16) (actual time=0.540..83.336 rows=1,183 loops=56)

  • Index Cond: (link_id = v_transit_roads.link_id)
30. 5,058.640 5,058.640 ↑ 5.7 392 74

Index Scan using road_segments_partitioned_19_link_id_idx on road_segments_partitioned_19 (cost=0.43..2,406.43 rows=2,249 width=16) (actual time=0.634..68.360 rows=392 loops=74)

  • Index Cond: (link_id = v_transit_roads.link_id)
31. 4,933.610 4,933.610 ↑ 3.0 752 55

Index Scan using road_segments_partitioned_20_link_id_idx on road_segments_partitioned_20 (cost=0.43..2,430.00 rows=2,271 width=16) (actual time=0.751..89.702 rows=752 loops=55)

  • Index Cond: (link_id = v_transit_roads.link_id)
32. 4,974.650 4,974.650 ↑ 4.9 462 74

Index Scan using road_segments_partitioned_21_link_id_idx on road_segments_partitioned_21 (cost=0.43..2,436.22 rows=2,277 width=16) (actual time=0.617..67.225 rows=462 loops=74)

  • Index Cond: (link_id = v_transit_roads.link_id)
33. 1,717.200 1,717.200 ↑ 1.3 1,823 80

Index Scan using road_segments_partitioned_22_link_id_idx on road_segments_partitioned_22 (cost=0.43..2,447.24 rows=2,289 width=16) (actual time=0.563..21.465 rows=1,823 loops=80)

  • Index Cond: (link_id = v_transit_roads.link_id)
34. 4,975.803 4,975.803 ↑ 2.4 975 63

Index Scan using road_segments_partitioned_23_link_id_idx on road_segments_partitioned_23 (cost=0.43..2,459.63 rows=2,299 width=16) (actual time=0.612..78.981 rows=975 loops=63)

  • Index Cond: (link_id = v_transit_roads.link_id)
35. 5,288.512 5,288.512 ↑ 2.6 895 64

Index Scan using road_segments_partitioned_24_link_id_idx on road_segments_partitioned_24 (cost=0.43..2,490.48 rows=2,328 width=16) (actual time=0.679..82.633 rows=895 loops=64)

  • Index Cond: (link_id = v_transit_roads.link_id)
36. 4,844.112 4,844.112 ↑ 2.3 979 78

Index Scan using road_segments_partitioned_25_link_id_idx on road_segments_partitioned_25 (cost=0.43..2,371.40 rows=2,217 width=16) (actual time=0.629..62.104 rows=979 loops=78)

  • Index Cond: (link_id = v_transit_roads.link_id)
37. 5,250.187 5,250.187 ↑ 2.2 1,015 67

Index Scan using road_segments_partitioned_26_link_id_idx on road_segments_partitioned_26 (cost=0.43..2,425.98 rows=2,267 width=16) (actual time=0.680..78.361 rows=1,015 loops=67)

  • Index Cond: (link_id = v_transit_roads.link_id)
38. 1,950.169 1,950.169 ↑ 1.7 1,378 67

Index Scan using road_segments_partitioned_27_link_id_idx on road_segments_partitioned_27 (cost=0.43..2,461.93 rows=2,305 width=16) (actual time=0.698..29.107 rows=1,378 loops=67)

  • Index Cond: (link_id = v_transit_roads.link_id)
39. 4,879.974 4,879.974 ↑ 2.3 956 66

Index Scan using road_segments_partitioned_28_link_id_idx on road_segments_partitioned_28 (cost=0.43..2,352.86 rows=2,198 width=16) (actual time=0.618..73.939 rows=956 loops=66)

  • Index Cond: (link_id = v_transit_roads.link_id)
40. 2,215.697 2,215.697 ↑ 1.3 1,708 71

Index Scan using road_segments_partitioned_29_link_id_idx on road_segments_partitioned_29 (cost=0.43..2,433.49 rows=2,274 width=16) (actual time=0.611..31.207 rows=1,708 loops=71)

  • Index Cond: (link_id = v_transit_roads.link_id)
41. 2,203.791 2,203.791 ↑ 7.0 325 69

Index Scan using road_segments_partitioned_30_link_id_idx on road_segments_partitioned_30 (cost=0.43..2,428.46 rows=2,270 width=16) (actual time=0.735..31.939 rows=325 loops=69)

  • Index Cond: (link_id = v_transit_roads.link_id)
42. 4,432.644 4,432.644 ↑ 2.3 974 81

Index Scan using road_segments_partitioned_31_link_id_idx on road_segments_partitioned_31 (cost=0.43..2,358.28 rows=2,206 width=16) (actual time=0.669..54.724 rows=974 loops=81)

  • Index Cond: (link_id = v_transit_roads.link_id)
43. 4,863.634 4,863.634 ↑ 2.3 983 83

Index Scan using road_segments_partitioned_32_link_id_idx on road_segments_partitioned_32 (cost=0.43..2,438.69 rows=2,281 width=16) (actual time=0.602..58.598 rows=983 loops=83)

  • Index Cond: (link_id = v_transit_roads.link_id)
44. 4,435.920 4,435.920 ↑ 3.4 652 60

Index Scan using road_segments_partitioned_33_link_id_idx on road_segments_partitioned_33 (cost=0.43..2,363.46 rows=2,208 width=16) (actual time=0.684..73.932 rows=652 loops=60)

  • Index Cond: (link_id = v_transit_roads.link_id)
45. 4,632.432 4,632.432 ↑ 1.8 1,333 84

Index Scan using road_segments_partitioned_34_link_id_idx on road_segments_partitioned_34 (cost=0.43..2,497.86 rows=2,335 width=16) (actual time=0.574..55.148 rows=1,333 loops=84)

  • Index Cond: (link_id = v_transit_roads.link_id)
46. 5,429.529 5,429.529 ↑ 4.0 549 63

Index Scan using road_segments_partitioned_35_link_id_idx on road_segments_partitioned_35 (cost=0.43..2,357.62 rows=2,204 width=16) (actual time=0.772..86.183 rows=549 loops=63)

  • Index Cond: (link_id = v_transit_roads.link_id)
47. 4,772.716 4,772.716 ↑ 3.3 679 68

Index Scan using road_segments_partitioned_36_link_id_idx on road_segments_partitioned_36 (cost=0.43..2,393.10 rows=2,238 width=16) (actual time=0.547..70.187 rows=679 loops=68)

  • Index Cond: (link_id = v_transit_roads.link_id)
48. 1,368.000 1,368.000 ↑ 4.0 565 60

Index Scan using road_segments_partitioned_37_link_id_idx on road_segments_partitioned_37 (cost=0.43..2,391.96 rows=2,236 width=16) (actual time=0.755..22.800 rows=565 loops=60)

  • Index Cond: (link_id = v_transit_roads.link_id)
49. 4,877.274 4,877.274 ↑ 2.5 899 71

Index Scan using road_segments_partitioned_38_link_id_idx on road_segments_partitioned_38 (cost=0.43..2,416.10 rows=2,260 width=16) (actual time=0.618..68.694 rows=899 loops=71)

  • Index Cond: (link_id = v_transit_roads.link_id)
50. 4,945.460 4,945.460 ↑ 3.5 646 65

Index Scan using road_segments_partitioned_39_link_id_idx on road_segments_partitioned_39 (cost=0.43..2,437.39 rows=2,278 width=16) (actual time=0.784..76.084 rows=646 loops=65)

  • Index Cond: (link_id = v_transit_roads.link_id)
51. 4,526.970 4,526.970 ↑ 1.8 1,310 70

Index Scan using road_segments_partitioned_40_link_id_idx on road_segments_partitioned_40 (cost=0.43..2,464.24 rows=2,303 width=16) (actual time=0.502..64.671 rows=1,310 loops=70)

  • Index Cond: (link_id = v_transit_roads.link_id)
52. 4,762.044 4,762.044 ↑ 1.6 1,495 63

Index Scan using road_segments_partitioned_41_link_id_idx on road_segments_partitioned_41 (cost=0.43..2,509.43 rows=2,345 width=16) (actual time=0.749..75.588 rows=1,495 loops=63)

  • Index Cond: (link_id = v_transit_roads.link_id)
53. 4,776.150 4,776.150 ↑ 2.7 851 85

Index Scan using road_segments_partitioned_42_link_id_idx on road_segments_partitioned_42 (cost=0.43..2,439.29 rows=2,279 width=16) (actual time=0.640..56.190 rows=851 loops=85)

  • Index Cond: (link_id = v_transit_roads.link_id)
54. 4,616.160 4,616.160 ↑ 2.2 1,075 60

Index Scan using road_segments_partitioned_43_link_id_idx on road_segments_partitioned_43 (cost=0.43..2,520.24 rows=2,358 width=16) (actual time=0.677..76.936 rows=1,075 loops=60)

  • Index Cond: (link_id = v_transit_roads.link_id)
55. 5,479.859 5,479.859 ↑ 1.8 1,213 77

Index Scan using road_segments_partitioned_44_link_id_idx on road_segments_partitioned_44 (cost=0.43..2,382.04 rows=2,226 width=16) (actual time=0.577..71.167 rows=1,213 loops=77)

  • Index Cond: (link_id = v_transit_roads.link_id)
56. 4,439.952 4,439.952 ↑ 2.0 1,145 72

Index Scan using road_segments_partitioned_45_link_id_idx on road_segments_partitioned_45 (cost=0.43..2,451.59 rows=2,291 width=16) (actual time=0.625..61.666 rows=1,145 loops=72)

  • Index Cond: (link_id = v_transit_roads.link_id)
57. 4,731.440 4,731.440 ↑ 2.3 979 68

Index Scan using road_segments_partitioned_46_link_id_idx on road_segments_partitioned_46 (cost=0.43..2,397.14 rows=2,242 width=16) (actual time=0.616..69.580 rows=979 loops=68)

  • Index Cond: (link_id = v_transit_roads.link_id)
58. 1,333.566 1,333.566 ↑ 2.0 1,116 78

Index Scan using road_segments_partitioned_47_link_id_idx on road_segments_partitioned_47 (cost=0.43..2,387.68 rows=2,232 width=16) (actual time=0.544..17.097 rows=1,116 loops=78)

  • Index Cond: (link_id = v_transit_roads.link_id)
59. 4,397.746 4,397.746 ↑ 2.7 822 67

Index Scan using road_segments_partitioned_48_link_id_idx on road_segments_partitioned_48 (cost=0.43..2,354.34 rows=2,200 width=16) (actual time=0.643..65.638 rows=822 loops=67)

  • Index Cond: (link_id = v_transit_roads.link_id)
60. 5,093.176 5,093.176 ↑ 1.4 1,619 62

Index Scan using road_segments_partitioned_49_link_id_idx on road_segments_partitioned_49 (cost=0.43..2,489.03 rows=2,328 width=16) (actual time=0.705..82.148 rows=1,619 loops=62)

  • Index Cond: (link_id = v_transit_roads.link_id)
61. 10,479.420 10,479.420 ↑ 1.0 1 3,493,140

Index Scan using road_movements_pkey on road_movements (cost=0.42..2.35 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=3,493,140)

  • Index Cond: (trip_id = road_segments_partitioned_0.trip_id)