explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CaN0 : test11111

Settings
# exclusive inclusive rows x rows loops node
1. 0.150 0.231 ↑ 1.0 10 1

Limit (cost=0.00..178.10 rows=10 width=752) (actual time=0.043..0.231 rows=10 loops=1)

  • Buffers: shared hit=1
2. 0.019 0.081 ↑ 1,752,129.7 10 1

Subquery Scan on mv (cost=0.00..312,056,977.46 rows=17,521,297 width=752) (actual time=0.042..0.081 rows=10 loops=1)

  • Filter: (((SubPlan 1))::integer = 3)
  • Buffers: shared hit=1
3. 0.006 0.052 ↑ 350,425,937.4 10 1

Append (cost=0.00..198,168,547.80 rows=3,504,259,374 width=752) (actual time=0.031..0.052 rows=10 loops=1)

  • Buffers: shared hit=1
4. 0.009 0.046 ↑ 4,850,533.0 10 1

Result (cost=0.00..6,669,482.88 rows=48,505,330 width=752) (actual time=0.029..0.046 rows=10 loops=1)

  • Buffers: shared hit=1
5. 0.006 0.037 ↑ 4,850,533.0 10 1

Append (cost=0.00..6,063,166.25 rows=48,505,330 width=748) (actual time=0.025..0.037 rows=10 loops=1)

  • Buffers: shared hit=1
6. 0.031 0.031 ↑ 42,818.0 10 1

Seq Scan on bml_mv_routing_esme_1521237600 t (cost=0.00..47,099.80 rows=428,180 width=748) (actual time=0.023..0.031 rows=10 loops=1)

  • Buffers: shared hit=1
7. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1521324000 t_1 (cost=0.00..44,290.40 rows=402,640 width=748) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1521410400 t_2 (cost=0.00..50,472.40 rows=458,840 width=748) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1521496800 t_3 (cost=0.00..51,524.00 rows=468,400 width=748) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1521583200 t_4 (cost=0.00..49,748.60 rows=452,260 width=748) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1521669600 t_5 (cost=0.00..49,632.00 rows=451,200 width=748) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1521756000 t_6 (cost=0.00..50,778.20 rows=461,620 width=748) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1521842400 t_7 (cost=0.00..46,901.80 rows=426,380 width=748) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1521928800 t_8 (cost=0.00..43,956.00 rows=399,600 width=748) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1522011600 t_9 (cost=0.00..48,711.30 rows=442,830 width=748) (never executed)

16. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1522022400 t_10 (cost=0.00..50,505.40 rows=459,140 width=748) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1522108800 t_11 (cost=0.00..51,559.20 rows=468,720 width=748) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1522195200 t_12 (cost=0.00..52,819.80 rows=480,180 width=748) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1522281600 t_13 (cost=0.00..50,883.80 rows=462,580 width=748) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1522368000 t_14 (cost=0.00..50,464.70 rows=458,770 width=748) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1522454400 t_15 (cost=0.00..48,078.80 rows=437,080 width=748) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1522540800 t_16 (cost=0.00..45,841.40 rows=416,740 width=748) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1522627200 t_17 (cost=0.00..46,938.10 rows=426,710 width=748) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1522713600 t_18 (cost=0.00..49,921.30 rows=453,830 width=748) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1522800000 t_19 (cost=0.00..49,011.60 rows=445,560 width=748) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1522886400 t_20 (cost=0.00..48,720.10 rows=442,910 width=748) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1522972800 t_21 (cost=0.00..47,749.90 rows=434,090 width=748) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1523059200 t_22 (cost=0.00..45,465.20 rows=413,320 width=748) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1523145600 t_23 (cost=0.00..43,854.80 rows=398,680 width=748) (never executed)

30. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1523232000 t_24 (cost=0.00..48,070.00 rows=437,000 width=748) (never executed)

31. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1523318400 t_25 (cost=0.00..48,727.80 rows=442,980 width=748) (never executed)

32. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1523404800 t_26 (cost=0.00..46,868.80 rows=426,080 width=748) (never executed)

33. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1523491200 t_27 (cost=0.00..43,102.40 rows=391,840 width=748) (never executed)

34. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1523577600 t_28 (cost=0.00..38,395.50 rows=349,050 width=748) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1523664000 t_29 (cost=0.00..29,395.30 rows=267,230 width=748) (never executed)

36. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1523750400 t_30 (cost=0.00..28,528.50 rows=259,350 width=748) (never executed)

37. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1523836800 t_31 (cost=0.00..33,833.80 rows=307,580 width=748) (never executed)

38. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1523923200 t_32 (cost=0.00..34,435.50 rows=313,050 width=748) (never executed)

39. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1524009600 t_33 (cost=0.00..34,164.90 rows=310,590 width=748) (never executed)

40. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1524096000 t_34 (cost=0.00..36,501.30 rows=331,830 width=748) (never executed)

41. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1524182400 t_35 (cost=0.00..45,354.10 rows=412,310 width=748) (never executed)

42. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1524268800 t_36 (cost=0.00..41,534.90 rows=377,590 width=748) (never executed)

43. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1524355200 t_37 (cost=0.00..39,435.00 rows=358,500 width=748) (never executed)

44. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1524441600 t_38 (cost=0.00..44,874.50 rows=407,950 width=748) (never executed)

45. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1524528000 t_39 (cost=0.00..47,940.20 rows=435,820 width=748) (never executed)

46. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1524614400 t_40 (cost=0.00..45,527.90 rows=413,890 width=748) (never executed)

47. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1524700800 t_41 (cost=0.00..46,383.70 rows=421,670 width=748) (never executed)

48. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1524787200 t_42 (cost=0.00..46,058.10 rows=418,710 width=748) (never executed)

49. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1524873600 t_43 (cost=0.00..42,314.80 rows=384,680 width=748) (never executed)

50. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1524960000 t_44 (cost=0.00..40,393.10 rows=367,210 width=748) (never executed)

51. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1525046400 t_45 (cost=0.00..47,129.50 rows=428,450 width=748) (never executed)

52. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1525132800 t_46 (cost=0.00..45,020.80 rows=409,280 width=748) (never executed)

53. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1525219200 t_47 (cost=0.00..49,588.00 rows=450,800 width=748) (never executed)

54. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1525305600 t_48 (cost=0.00..47,355.00 rows=430,500 width=748) (never executed)

55. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1525392000 t_49 (cost=0.00..36,470.50 rows=331,550 width=748) (never executed)

56. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1525478400 t_50 (cost=0.00..32,879.00 rows=298,900 width=748) (never executed)

57. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1525564800 t_51 (cost=0.00..32,021.00 rows=291,100 width=748) (never executed)

58. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1525651200 t_52 (cost=0.00..37,563.90 rows=341,490 width=748) (never executed)

59. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1525737600 t_53 (cost=0.00..35,525.60 rows=322,960 width=748) (never executed)

60. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1525824000 t_54 (cost=0.00..35,264.90 rows=320,590 width=748) (never executed)

61. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1525910400 t_55 (cost=0.00..35,010.80 rows=318,280 width=748) (never executed)

62. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1525996800 t_56 (cost=0.00..35,938.10 rows=326,710 width=748) (never executed)

63. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1526083200 t_57 (cost=0.00..31,395.10 rows=285,410 width=748) (never executed)

64. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1526169600 t_58 (cost=0.00..29,964.00 rows=272,400 width=748) (never executed)

65. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1526256000 t_59 (cost=0.00..34,248.50 rows=311,350 width=748) (never executed)

66. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1526342400 t_60 (cost=0.00..43,672.20 rows=397,020 width=748) (never executed)

67. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1526428800 t_61 (cost=0.00..50,298.60 rows=457,260 width=748) (never executed)

68. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1526515200 t_62 (cost=0.00..45,336.50 rows=412,150 width=748) (never executed)

69. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1526601600 t_63 (cost=0.00..36,015.10 rows=327,410 width=748) (never executed)

70. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1526688000 t_64 (cost=0.00..32,083.70 rows=291,670 width=748) (never executed)

71. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1526774400 t_65 (cost=0.00..30,934.20 rows=281,220 width=748) (never executed)

72. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1526860800 t_66 (cost=0.00..36,638.80 rows=333,080 width=748) (never executed)

73. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1526947200 t_67 (cost=0.00..39,475.70 rows=358,870 width=748) (never executed)

74. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1527033600 t_68 (cost=0.00..40,496.50 rows=368,150 width=748) (never executed)

75. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1527120000 t_69 (cost=0.00..39,823.30 rows=362,030 width=748) (never executed)

76. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1527206400 t_70 (cost=0.00..40,926.60 rows=372,060 width=748) (never executed)

77. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1527292800 t_71 (cost=0.00..36,381.40 rows=330,740 width=748) (never executed)

78. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1527379200 t_72 (cost=0.00..33,564.30 rows=305,130 width=748) (never executed)

79. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1527465600 t_73 (cost=0.00..38,732.10 rows=352,110 width=748) (never executed)

80. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1527552000 t_74 (cost=0.00..39,542.80 rows=359,480 width=748) (never executed)

81. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1527638400 t_75 (cost=0.00..38,941.10 rows=354,010 width=748) (never executed)

82. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1527724800 t_76 (cost=0.00..39,589.00 rows=359,900 width=748) (never executed)

83. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1527811200 t_77 (cost=0.00..21,157.40 rows=192,340 width=748) (never executed)

84. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1527897600 t_78 (cost=0.00..37,490.20 rows=340,820 width=748) (never executed)

85. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1527984000 t_79 (cost=0.00..30,022.30 rows=272,930 width=748) (never executed)

86. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1528070400 t_80 (cost=0.00..39,787.00 rows=361,700 width=748) (never executed)

87. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1528156800 t_81 (cost=0.00..39,673.70 rows=360,670 width=748) (never executed)

88. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1528243200 t_82 (cost=0.00..38,287.70 rows=348,070 width=748) (never executed)

89. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1528329600 t_83 (cost=0.00..40,279.80 rows=366,180 width=748) (never executed)

90. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1528416000 t_84 (cost=0.00..40,244.60 rows=365,860 width=748) (never executed)

91. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1528502400 t_85 (cost=0.00..38,018.20 rows=345,620 width=748) (never executed)

92. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1528588800 t_86 (cost=0.00..35,812.70 rows=325,570 width=748) (never executed)

93. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1528675200 t_87 (cost=0.00..40,659.30 rows=369,630 width=748) (never executed)

94. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1528761600 t_88 (cost=0.00..42,633.80 rows=387,580 width=748) (never executed)

95. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1528848000 t_89 (cost=0.00..42,270.80 rows=384,280 width=748) (never executed)

96. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1528934400 t_90 (cost=0.00..42,035.40 rows=382,140 width=748) (never executed)

97. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1529020800 t_91 (cost=0.00..47,663.00 rows=433,300 width=748) (never executed)

98. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1529107200 t_92 (cost=0.00..53,787.80 rows=488,980 width=748) (never executed)

99. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1529193600 t_93 (cost=0.00..47,010.70 rows=427,370 width=748) (never executed)

100. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1529280000 t_94 (cost=0.00..48,856.50 rows=444,150 width=748) (never executed)

101. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1529366400 t_95 (cost=0.00..37,863.10 rows=344,210 width=748) (never executed)

102. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1529452800 t_96 (cost=0.00..55,881.10 rows=508,010 width=748) (never executed)

103. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1529539200 t_97 (cost=0.00..50,394.30 rows=458,130 width=748) (never executed)

104. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1529625600 t_98 (cost=0.00..50,279.90 rows=457,090 width=748) (never executed)

105. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1529712000 t_99 (cost=0.00..49,084.20 rows=446,220 width=748) (never executed)

106. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1529798400 t_100 (cost=0.00..43,169.50 rows=392,450 width=748) (never executed)

107. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1529884800 t_101 (cost=0.00..45,573.00 rows=414,300 width=748) (never executed)

108. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1529971200 t_102 (cost=0.00..41,349.00 rows=375,900 width=748) (never executed)

109. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1530057600 t_103 (cost=0.00..45,799.60 rows=416,360 width=748) (never executed)

110. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1530144000 t_104 (cost=0.00..48,824.60 rows=443,860 width=748) (never executed)

111. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1530230400 t_105 (cost=0.00..50,309.60 rows=457,360 width=748) (never executed)

112. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1530316800 t_106 (cost=0.00..49,590.20 rows=450,820 width=748) (never executed)

113. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1530403200 t_107 (cost=0.00..45,010.90 rows=409,190 width=748) (never executed)

114. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1530489600 t_108 (cost=0.00..47,623.40 rows=432,940 width=748) (never executed)

115. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1530576000 t_109 (cost=0.00..45,717.10 rows=415,610 width=748) (never executed)

116. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1530662400 t_110 (cost=0.00..42,209.20 rows=383,720 width=748) (never executed)

117. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1530748800 t_111 (cost=0.00..39,376.70 rows=357,970 width=748) (never executed)

118. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1530835200 t_112 (cost=0.00..19,710.90 rows=179,190 width=748) (never executed)

119. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1530921600 t_113 (cost=0.00..11.00 rows=100 width=748) (never executed)

120. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1531008000 t_114 (cost=0.00..11.00 rows=100 width=748) (never executed)

121. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1531094400 t_115 (cost=0.00..11.00 rows=100 width=748) (never executed)

122. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1531180800 t_116 (cost=0.00..11.00 rows=100 width=748) (never executed)

123. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1531267200 t_117 (cost=0.00..50,750.70 rows=461,370 width=748) (never executed)

124. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1531353600 t_118 (cost=0.00..87,364.20 rows=794,220 width=748) (never executed)

125. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1531440000 t_119 (cost=0.00..83,352.50 rows=757,750 width=748) (never executed)

126. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1531526400 t_120 (cost=0.00..80,972.10 rows=736,110 width=748) (never executed)

127. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1531612800 t_121 (cost=0.00..82,766.20 rows=752,420 width=748) (never executed)

128. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1531699200 t_122 (cost=0.00..80,120.70 rows=728,370 width=748) (never executed)

129. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1531785600 t_123 (cost=0.00..82,163.40 rows=746,940 width=748) (never executed)

130. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..289,618.92 rows=5,597,504 width=752) (never executed)

131. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1531872000 rundata (cost=0.00..55.35 rows=1,435 width=72) (never executed)

132. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1531872000_endtime on bml_mv_routing_esme_1531872000 t_124 (cost=0.42..133.52 rows=3,901 width=744) (never executed)

  • Index Cond: (endtime = rundata.endtime)
133. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..251,853.22 rows=4,659,669 width=752) (never executed)

134. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1531958400 rundata_1 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

135. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1531958400_endtime on bml_mv_routing_esme_1531958400 t_125 (cost=0.42..135.13 rows=3,698 width=744) (never executed)

  • Index Cond: (endtime = rundata_1.endtime)
136. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..229,684.57 rows=4,163,156 width=752) (never executed)

137. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1532044800 rundata_2 (cost=0.00..45.90 rows=1,190 width=72) (never executed)

138. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1532044800_endtime on bml_mv_routing_esme_1532044800 t_126 (cost=0.42..131.76 rows=3,498 width=744) (never executed)

  • Index Cond: (endtime = rundata_2.endtime)
139. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..183,867.32 rows=3,256,456 width=752) (never executed)

140. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1532131200 rundata_3 (cost=0.00..43.20 rows=1,120 width=72) (never executed)

141. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1532131200_endtime on bml_mv_routing_esme_1532131200 t_127 (cost=0.42..113.24 rows=2,908 width=744) (never executed)

  • Index Cond: (endtime = rundata_3.endtime)
142. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..189,206.43 rows=3,496,878 width=752) (never executed)

143. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1532217600 rundata_4 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

144. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1532217600_endtime on bml_mv_routing_esme_1532217600 t_128 (cost=0.42..101.56 rows=2,775 width=744) (never executed)

  • Index Cond: (endtime = rundata_4.endtime)
145. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..222,129.43 rows=3,980,823 width=752) (never executed)

146. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1532304000 rundata_5 (cost=0.00..44.55 rows=1,155 width=72) (never executed)

147. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1532304000_endtime on bml_mv_routing_esme_1532304000 t_129 (cost=0.42..131.96 rows=3,447 width=744) (never executed)

  • Index Cond: (endtime = rundata_5.endtime)
148. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..240,695.58 rows=4,361,707 width=752) (never executed)

149. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1532390400 rundata_6 (cost=0.00..45.90 rows=1,190 width=72) (never executed)

150. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1532390400_endtime on bml_mv_routing_esme_1532390400 t_130 (cost=0.42..138.09 rows=3,665 width=744) (never executed)

  • Index Cond: (endtime = rundata_6.endtime)
151. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..211,467.01 rows=3,830,491 width=752) (never executed)

152. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1532476800 rundata_7 (cost=0.00..45.90 rows=1,190 width=72) (never executed)

153. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1532476800_endtime on bml_mv_routing_esme_1532476800 t_131 (cost=0.42..121.33 rows=3,219 width=744) (never executed)

  • Index Cond: (endtime = rundata_7.endtime)
154. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..186,626.28 rows=3,449,124 width=752) (never executed)

155. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1532563200 rundata_8 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

156. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1532563200_endtime on bml_mv_routing_esme_1532563200 t_132 (cost=0.42..100.18 rows=2,737 width=744) (never executed)

  • Index Cond: (endtime = rundata_8.endtime)
157. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..191,503.80 rows=3,539,340 width=752) (never executed)

158. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1532649600 rundata_9 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

159. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1532649600_endtime on bml_mv_routing_esme_1532649600 t_133 (cost=0.42..102.79 rows=2,809 width=744) (never executed)

  • Index Cond: (endtime = rundata_9.endtime)
160. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..174,998.67 rows=3,233,790 width=752) (never executed)

161. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1532736000 rundata_10 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

162. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1532736000_endtime on bml_mv_routing_esme_1532736000 t_134 (cost=0.42..93.94 rows=2,566 width=744) (never executed)

  • Index Cond: (endtime = rundata_10.endtime)
163. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..148,921.38 rows=2,749,698 width=752) (never executed)

164. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1532822400 rundata_11 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

165. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1532822400_endtime on bml_mv_routing_esme_1532822400 t_135 (cost=0.42..79.97 rows=2,182 width=744) (never executed)

  • Index Cond: (endtime = rundata_11.endtime)
166. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..192,397.05 rows=3,555,846 width=752) (never executed)

167. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1532908800 rundata_12 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

168. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1532908800_endtime on bml_mv_routing_esme_1532908800 t_136 (cost=0.42..103.27 rows=2,822 width=744) (never executed)

  • Index Cond: (endtime = rundata_12.endtime)
169. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..193,280.54 rows=3,572,226 width=752) (never executed)

170. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1532995200 rundata_13 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

171. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1532995200_endtime on bml_mv_routing_esme_1532995200 t_137 (cost=0.42..103.75 rows=2,835 width=744) (never executed)

  • Index Cond: (endtime = rundata_13.endtime)
172. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..241,583.44 rows=4,468,905 width=752) (never executed)

173. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1533081600 rundata_14 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

174. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1533081600_endtime on bml_mv_routing_esme_1533081600 t_138 (cost=0.42..129.62 rows=3,547 width=744) (never executed)

  • Index Cond: (endtime = rundata_14.endtime)
175. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..159,206.04 rows=2,525,731 width=752) (never executed)

176. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1533168000 rundata_15 (cost=0.00..33.75 rows=875 width=72) (never executed)

177. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1533168000_endtime on bml_mv_routing_esme_1533168000 t_139 (cost=0.42..131.39 rows=2,887 width=744) (never executed)

  • Index Cond: (endtime = rundata_15.endtime)
178. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=0.29..35.43 rows=175 width=752) (never executed)

  • Merge Cond: (t_140.endtime = rundata_16.endtime)
179. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1533254400_endtime on bml_mv_routing_esme_1533254400 t_140 (cost=0.14..13.74 rows=100 width=744) (never executed)

180. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_rundata_1533254400_endtime on bml_mv_rundata_1533254400 rundata_16 (cost=0.15..17.50 rows=350 width=72) (never executed)

181. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=0.29..35.43 rows=175 width=752) (never executed)

  • Merge Cond: (t_141.endtime = rundata_17.endtime)
182. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1533340800_endtime on bml_mv_routing_esme_1533340800 t_141 (cost=0.14..13.74 rows=100 width=744) (never executed)

183. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_rundata_1533340800_endtime on bml_mv_rundata_1533340800 rundata_17 (cost=0.15..17.50 rows=350 width=72) (never executed)

184. 0.000 0.000 ↓ 0.0 0

Merge Join (cost=0.29..35.43 rows=175 width=752) (never executed)

  • Merge Cond: (t_142.endtime = rundata_18.endtime)
185. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1533427200_endtime on bml_mv_routing_esme_1533427200 t_142 (cost=0.14..13.74 rows=100 width=744) (never executed)

186. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_rundata_1533427200_endtime on bml_mv_rundata_1533427200 rundata_18 (cost=0.15..17.50 rows=350 width=72) (never executed)

187. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..133,019.89 rows=2,011,009 width=752) (never executed)

188. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1533513600 rundata_19 (cost=0.00..29.70 rows=770 width=72) (never executed)

189. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1533513600_endtime on bml_mv_routing_esme_1533513600 t_143 (cost=0.42..127.01 rows=2,612 width=744) (never executed)

  • Index Cond: (endtime = rundata_19.endtime)
190. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..136,404.20 rows=2,017,648 width=752) (never executed)

191. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1533600000 rundata_20 (cost=0.00..28.35 rows=735 width=72) (never executed)

192. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1533600000_endtime on bml_mv_routing_esme_1533600000 t_144 (cost=0.42..137.51 rows=2,745 width=744) (never executed)

  • Index Cond: (endtime = rundata_20.endtime)
193. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..265,713.82 rows=4,917,150 width=752) (never executed)

194. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1533686400 rundata_21 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

195. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1533686400_endtime on bml_mv_routing_esme_1533686400 t_145 (cost=0.42..142.56 rows=3,902 width=744) (never executed)

  • Index Cond: (endtime = rundata_21.endtime)
196. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..35,305.92 rows=382,389 width=752) (never executed)

197. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1533772800 rundata_22 (cost=0.00..16.20 rows=420 width=72) (never executed)

198. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1533772800_endtime on bml_mv_routing_esme_1533772800 t_146 (cost=0.42..68.09 rows=910 width=744) (never executed)

  • Index Cond: (endtime = rundata_22.endtime)
199. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..254,016.81 rows=4,699,548 width=752) (never executed)

200. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1533859200 rundata_23 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

201. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1533859200_endtime on bml_mv_routing_esme_1533859200 t_147 (cost=0.42..136.29 rows=3,730 width=744) (never executed)

  • Index Cond: (endtime = rundata_23.endtime)
202. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..215,159.79 rows=3,979,332 width=752) (never executed)

203. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1533945600 rundata_24 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

204. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1533945600_endtime on bml_mv_routing_esme_1533945600 t_148 (cost=0.42..115.46 rows=3,158 width=744) (never executed)

  • Index Cond: (endtime = rundata_24.endtime)
205. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..187,535.64 rows=3,466,386 width=752) (never executed)

206. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1534032000 rundata_25 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

207. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1534032000_endtime on bml_mv_routing_esme_1534032000 t_149 (cost=0.42..100.66 rows=2,751 width=744) (never executed)

  • Index Cond: (endtime = rundata_25.endtime)
208. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..264,257.19 rows=4,889,619 width=752) (never executed)

209. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1534118400 rundata_26 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

210. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1534118400_endtime on bml_mv_routing_esme_1534118400 t_150 (cost=0.42..141.77 rows=3,881 width=744) (never executed)

  • Index Cond: (endtime = rundata_26.endtime)
211. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..224,355.14 rows=4,149,306 width=752) (never executed)

212. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1534204800 rundata_27 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

213. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1534204800_endtime on bml_mv_routing_esme_1534204800 t_151 (cost=0.42..120.39 rows=3,293 width=744) (never executed)

  • Index Cond: (endtime = rundata_27.endtime)
214. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..195,961.31 rows=3,622,248 width=752) (never executed)

215. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1534291200 rundata_28 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

216. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1534291200_endtime on bml_mv_routing_esme_1534291200 t_152 (cost=0.42..105.18 rows=2,875 width=744) (never executed)

  • Index Cond: (endtime = rundata_28.endtime)
217. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..255,638.41 rows=4,729,788 width=752) (never executed)

218. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1534377600 rundata_29 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

219. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1534377600_endtime on bml_mv_routing_esme_1534377600 t_153 (cost=0.42..137.16 rows=3,754 width=744) (never executed)

  • Index Cond: (endtime = rundata_29.endtime)
220. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..237,463.66 rows=4,392,675 width=752) (never executed)

221. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1534464000 rundata_30 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

222. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1534464000_endtime on bml_mv_routing_esme_1534464000 t_154 (cost=0.42..127.42 rows=3,486 width=744) (never executed)

  • Index Cond: (endtime = rundata_30.endtime)
223. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..196,968.53 rows=3,568,334 width=752) (never executed)

224. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1534550400 rundata_31 (cost=0.00..45.90 rows=1,190 width=72) (never executed)

225. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1534550400_endtime on bml_mv_routing_esme_1534550400 t_155 (cost=0.42..113.00 rows=2,999 width=744) (never executed)

  • Index Cond: (endtime = rundata_31.endtime)
226. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..178,163.03 rows=3,292,191 width=752) (never executed)

227. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1534636800 rundata_32 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

228. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1534636800_endtime on bml_mv_routing_esme_1534636800 t_156 (cost=0.42..95.63 rows=2,613 width=744) (never executed)

  • Index Cond: (endtime = rundata_32.endtime)
229. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..233,806.43 rows=4,324,950 width=752) (never executed)

230. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1534723200 rundata_33 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

231. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1534723200_endtime on bml_mv_routing_esme_1534723200 t_157 (cost=0.42..125.46 rows=3,432 width=744) (never executed)

  • Index Cond: (endtime = rundata_33.endtime)
232. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..234,514.97 rows=4,337,802 width=752) (never executed)

233. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1534809600 rundata_34 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

234. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1534809600_endtime on bml_mv_routing_esme_1534809600 t_158 (cost=0.42..125.83 rows=3,443 width=744) (never executed)

  • Index Cond: (endtime = rundata_34.endtime)
235. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..229,175.06 rows=4,238,955 width=752) (never executed)

236. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1534896000 rundata_35 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

237. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1534896000_endtime on bml_mv_routing_esme_1534896000 t_159 (cost=0.42..122.97 rows=3,364 width=744) (never executed)

  • Index Cond: (endtime = rundata_35.endtime)
238. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..239,006.90 rows=4,421,340 width=752) (never executed)

239. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1534982400 rundata_36 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

240. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1534982400_endtime on bml_mv_routing_esme_1534982400 t_160 (cost=0.42..128.24 rows=3,509 width=744) (never executed)

  • Index Cond: (endtime = rundata_36.endtime)
241. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..213,842.36 rows=3,833,907 width=752) (never executed)

242. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1535068800 rundata_37 (cost=0.00..44.55 rows=1,155 width=72) (never executed)

243. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1535068800_endtime on bml_mv_routing_esme_1535068800 t_161 (cost=0.42..127.02 rows=3,319 width=744) (never executed)

  • Index Cond: (endtime = rundata_37.endtime)
244. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..230,126.16 rows=4,257,162 width=752) (never executed)

245. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1535155200 rundata_38 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

246. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1535155200_endtime on bml_mv_routing_esme_1535155200 t_162 (cost=0.42..123.47 rows=3,379 width=744) (never executed)

  • Index Cond: (endtime = rundata_38.endtime)
247. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..181,067.88 rows=3,346,371 width=752) (never executed)

248. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1535241600 rundata_39 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

249. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1535241600_endtime on bml_mv_routing_esme_1535241600 t_163 (cost=0.42..97.19 rows=2,656 width=744) (never executed)

  • Index Cond: (endtime = rundata_39.endtime)
250. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..251,904.39 rows=4,660,992 width=752) (never executed)

251. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1535328000 rundata_40 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

252. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1535328000_endtime on bml_mv_routing_esme_1535328000 t_164 (cost=0.42..135.15 rows=3,699 width=744) (never executed)

  • Index Cond: (endtime = rundata_40.endtime)
253. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..180,164.64 rows=3,153,118 width=752) (never executed)

254. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1535414400 rundata_41 (cost=0.00..41.85 rows=1,085 width=72) (never executed)

255. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1535414400_endtime on bml_mv_routing_esme_1535414400 t_165 (cost=0.42..115.16 rows=2,906 width=744) (never executed)

  • Index Cond: (endtime = rundata_41.endtime)
256. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..236,425.01 rows=4,373,208 width=752) (never executed)

257. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1535500800 rundata_42 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

258. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1535500800_endtime on bml_mv_routing_esme_1535500800 t_166 (cost=0.42..126.86 rows=3,471 width=744) (never executed)

  • Index Cond: (endtime = rundata_42.endtime)
259. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..245,660.38 rows=4,544,631 width=752) (never executed)

260. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1535587200 rundata_43 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

261. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1535587200_endtime on bml_mv_routing_esme_1535587200 t_167 (cost=0.42..131.81 rows=3,607 width=744) (never executed)

  • Index Cond: (endtime = rundata_43.endtime)
262. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..266,895.28 rows=4,939,011 width=752) (never executed)

263. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1535673600 rundata_44 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

264. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1535673600_endtime on bml_mv_routing_esme_1535673600 t_168 (cost=0.42..143.18 rows=3,920 width=744) (never executed)

  • Index Cond: (endtime = rundata_44.endtime)
265. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..233,012.69 rows=4,310,712 width=752) (never executed)

266. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1535760000 rundata_45 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

267. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1535760000_endtime on bml_mv_routing_esme_1535760000 t_169 (cost=0.42..125.02 rows=3,421 width=744) (never executed)

  • Index Cond: (endtime = rundata_45.endtime)
268. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..191,143.92 rows=3,533,670 width=752) (never executed)

269. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1535846400 rundata_46 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

270. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1535846400_endtime on bml_mv_routing_esme_1535846400 t_170 (cost=0.42..102.59 rows=2,804 width=744) (never executed)

  • Index Cond: (endtime = rundata_46.endtime)
271. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..232,554.07 rows=4,301,262 width=752) (never executed)

272. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1535932800 rundata_47 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

273. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1535932800_endtime on bml_mv_routing_esme_1535932800 t_171 (cost=0.42..124.79 rows=3,414 width=744) (never executed)

  • Index Cond: (endtime = rundata_47.endtime)
274. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..227,479.81 rows=4,206,888 width=752) (never executed)

275. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1536019200 rundata_48 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

276. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1536019200_endtime on bml_mv_routing_esme_1536019200 t_172 (cost=0.42..122.07 rows=3,339 width=744) (never executed)

  • Index Cond: (endtime = rundata_48.endtime)
277. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..225,984.91 rows=4,179,168 width=752) (never executed)

278. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1536105600 rundata_49 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

279. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1536105600_endtime on bml_mv_routing_esme_1536105600 t_173 (cost=0.42..121.27 rows=3,317 width=744) (never executed)

  • Index Cond: (endtime = rundata_49.endtime)
280. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..226,052.11 rows=4,180,428 width=752) (never executed)

281. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1536192000 rundata_50 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

282. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1536192000_endtime on bml_mv_routing_esme_1536192000 t_174 (cost=0.42..121.30 rows=3,318 width=744) (never executed)

  • Index Cond: (endtime = rundata_50.endtime)
283. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..211,123.22 rows=3,902,976 width=752) (never executed)

284. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1536278400 rundata_51 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

285. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1536278400_endtime on bml_mv_routing_esme_1536278400 t_175 (cost=0.42..113.31 rows=3,098 width=744) (never executed)

  • Index Cond: (endtime = rundata_51.endtime)
286. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..172,483.67 rows=3,186,729 width=752) (never executed)

287. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1536364800 rundata_52 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

288. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1536364800_endtime on bml_mv_routing_esme_1536364800 t_176 (cost=0.42..92.59 rows=2,529 width=744) (never executed)

  • Index Cond: (endtime = rundata_52.endtime)
289. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.41..9,254.98 rows=86,870 width=752) (never executed)

290. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1536451200 rundata_53 (cost=0.00..13.50 rows=350 width=72) (never executed)

291. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1536451200_endtime on bml_mv_routing_esme_1536451200 t_177 (cost=0.41..22.06 rows=248 width=744) (never executed)

  • Index Cond: (endtime = rundata_53.endtime)
292. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..96,650.28 rows=1,427,296 width=752) (never executed)

293. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1536537600 rundata_54 (cost=0.00..28.35 rows=735 width=72) (never executed)

294. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1536537600_endtime on bml_mv_routing_esme_1536537600 t_178 (cost=0.42..97.47 rows=1,942 width=744) (never executed)

  • Index Cond: (endtime = rundata_54.endtime)
295. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..192,252.58 rows=3,553,011 width=752) (never executed)

296. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1536624000 rundata_55 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

297. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1536624000_endtime on bml_mv_routing_esme_1536624000 t_179 (cost=0.42..103.19 rows=2,820 width=744) (never executed)

  • Index Cond: (endtime = rundata_55.endtime)
298. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..192,820.53 rows=3,563,910 width=752) (never executed)

299. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1536710400 rundata_56 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

300. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1536710400_endtime on bml_mv_routing_esme_1536710400 t_180 (cost=0.42..103.50 rows=2,828 width=744) (never executed)

  • Index Cond: (endtime = rundata_56.endtime)
301. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..171,634.24 rows=3,139,369 width=752) (never executed)

302. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1536796800 rundata_57 (cost=0.00..47.25 rows=1,225 width=72) (never executed)

303. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1536796800_endtime on bml_mv_routing_esme_1536796800 t_181 (cost=0.42..95.22 rows=2,563 width=744) (never executed)

  • Index Cond: (endtime = rundata_57.endtime)
304. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..170,953.16 rows=3,158,001 width=752) (never executed)

305. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1536883200 rundata_58 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

306. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1536883200_endtime on bml_mv_routing_esme_1536883200 t_182 (cost=0.42..91.78 rows=2,506 width=744) (never executed)

  • Index Cond: (endtime = rundata_58.endtime)
307. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..161,000.51 rows=2,973,222 width=752) (never executed)

308. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1536969600 rundata_59 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

309. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1536969600_endtime on bml_mv_routing_esme_1536969600 t_183 (cost=0.42..86.44 rows=2,360 width=744) (never executed)

  • Index Cond: (endtime = rundata_59.endtime)
310. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..150,475.93 rows=2,778,111 width=752) (never executed)

311. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1537056000 rundata_60 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

312. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1537056000_endtime on bml_mv_routing_esme_1537056000 t_184 (cost=0.42..80.80 rows=2,205 width=744) (never executed)

  • Index Cond: (endtime = rundata_60.endtime)
313. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..173,769.18 rows=3,178,508 width=752) (never executed)

314. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1537142400 rundata_61 (cost=0.00..47.25 rows=1,225 width=72) (never executed)

315. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1537142400_endtime on bml_mv_routing_esme_1537142400 t_185 (cost=0.42..96.40 rows=2,595 width=744) (never executed)

  • Index Cond: (endtime = rundata_61.endtime)
316. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..171,711.77 rows=3,172,176 width=752) (never executed)

317. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1537228800 rundata_62 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

318. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1537228800_endtime on bml_mv_routing_esme_1537228800 t_186 (cost=0.42..92.18 rows=2,518 width=744) (never executed)

  • Index Cond: (endtime = rundata_62.endtime)
319. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..180,657.23 rows=3,304,744 width=752) (never executed)

320. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1537315200 rundata_63 (cost=0.00..47.25 rows=1,225 width=72) (never executed)

321. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1537315200_endtime on bml_mv_routing_esme_1537315200 t_187 (cost=0.42..100.22 rows=2,698 width=744) (never executed)

  • Index Cond: (endtime = rundata_63.endtime)
322. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..195,639.68 rows=3,615,444 width=752) (never executed)

323. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1537401600 rundata_64 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

324. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1537401600_endtime on bml_mv_routing_esme_1537401600 t_188 (cost=0.42..105.02 rows=2,869 width=744) (never executed)

  • Index Cond: (endtime = rundata_64.endtime)
325. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..189,775.14 rows=3,506,265 width=752) (never executed)

326. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1537488000 rundata_65 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

327. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1537488000_endtime on bml_mv_routing_esme_1537488000 t_189 (cost=0.42..101.88 rows=2,783 width=744) (never executed)

  • Index Cond: (endtime = rundata_65.endtime)
328. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..174,121.76 rows=3,216,528 width=752) (never executed)

329. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1537574400 rundata_66 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

330. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1537574400_endtime on bml_mv_routing_esme_1537574400 t_190 (cost=0.42..93.48 rows=2,553 width=744) (never executed)

  • Index Cond: (endtime = rundata_66.endtime)
331. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..161,511.00 rows=2,982,987 width=752) (never executed)

332. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1537660800 rundata_67 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

333. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1537660800_endtime on bml_mv_routing_esme_1537660800 t_191 (cost=0.42..86.72 rows=2,367 width=744) (never executed)

  • Index Cond: (endtime = rundata_67.endtime)
334. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..187,349.35 rows=3,461,787 width=752) (never executed)

335. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1537747200 rundata_68 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

336. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1537747200_endtime on bml_mv_routing_esme_1537747200 t_192 (cost=0.42..100.58 rows=2,747 width=744) (never executed)

  • Index Cond: (endtime = rundata_68.endtime)
337. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..183,186.82 rows=3,384,549 width=752) (never executed)

338. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1537833600 rundata_69 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

339. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1537833600_endtime on bml_mv_routing_esme_1537833600 t_193 (cost=0.42..98.34 rows=2,686 width=744) (never executed)

  • Index Cond: (endtime = rundata_69.endtime)
340. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..187,556.76 rows=3,465,315 width=752) (never executed)

341. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1537920000 rundata_70 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

342. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1537920000_endtime on bml_mv_routing_esme_1537920000 t_194 (cost=0.42..100.69 rows=2,750 width=744) (never executed)

  • Index Cond: (endtime = rundata_70.endtime)
343. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..153,678.82 rows=2,719,136 width=752) (never executed)

344. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1538006400 rundata_71 (cost=0.00..43.20 rows=1,120 width=72) (never executed)

345. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1538006400_endtime on bml_mv_routing_esme_1538006400 t_195 (cost=0.42..94.69 rows=2,428 width=744) (never executed)

  • Index Cond: (endtime = rundata_71.endtime)
346. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..174,797.49 rows=3,196,760 width=752) (never executed)

347. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1538092800 rundata_72 (cost=0.00..47.25 rows=1,225 width=72) (never executed)

348. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1538092800_endtime on bml_mv_routing_esme_1538092800 t_196 (cost=0.42..96.98 rows=2,610 width=744) (never executed)

  • Index Cond: (endtime = rundata_72.endtime)
349. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..155,243.11 rows=2,866,815 width=752) (never executed)

350. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1538179200 rundata_73 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

351. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1538179200_endtime on bml_mv_routing_esme_1538179200 t_197 (cost=0.42..83.36 rows=2,275 width=744) (never executed)

  • Index Cond: (endtime = rundata_73.endtime)
352. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..141,087.61 rows=2,604,042 width=752) (never executed)

353. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1538265600 rundata_74 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

354. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1538265600_endtime on bml_mv_routing_esme_1538265600 t_198 (cost=0.42..75.77 rows=2,067 width=744) (never executed)

  • Index Cond: (endtime = rundata_74.endtime)
355. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..165,073.07 rows=3,049,389 width=752) (never executed)

356. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1538352000 rundata_75 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

357. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1538352000_endtime on bml_mv_routing_esme_1538352000 t_199 (cost=0.42..88.62 rows=2,420 width=744) (never executed)

  • Index Cond: (endtime = rundata_75.endtime)
358. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..158,216.26 rows=2,922,381 width=752) (never executed)

359. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1538438400 rundata_76 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

360. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1538438400_endtime on bml_mv_routing_esme_1538438400 t_200 (cost=0.42..84.94 rows=2,319 width=744) (never executed)

  • Index Cond: (endtime = rundata_76.endtime)
361. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..121,486.42 rows=2,122,694 width=752) (never executed)

362. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1538524800 rundata_77 (cost=0.00..41.85 rows=1,085 width=72) (never executed)

363. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1538524800_endtime on bml_mv_routing_esme_1538524800 t_201 (cost=0.42..77.70 rows=1,956 width=744) (never executed)

  • Index Cond: (endtime = rundata_77.endtime)
364. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..147,138.27 rows=2,690,468 width=752) (never executed)

365. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1538611200 rundata_78 (cost=0.00..47.25 rows=1,225 width=72) (never executed)

366. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1538611200_endtime on bml_mv_routing_esme_1538611200 t_202 (cost=0.42..81.64 rows=2,196 width=744) (never executed)

  • Index Cond: (endtime = rundata_78.endtime)
367. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..163,077.59 rows=3,012,345 width=752) (never executed)

368. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1538697600 rundata_79 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

369. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1538697600_endtime on bml_mv_routing_esme_1538697600 t_203 (cost=0.42..87.55 rows=2,391 width=744) (never executed)

  • Index Cond: (endtime = rundata_79.endtime)
370. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..151,139.13 rows=2,790,711 width=752) (never executed)

371. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1538784000 rundata_80 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

372. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1538784000_endtime on bml_mv_routing_esme_1538784000 t_204 (cost=0.42..81.15 rows=2,215 width=744) (never executed)

  • Index Cond: (endtime = rundata_80.endtime)
373. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..143,588.47 rows=2,650,536 width=752) (never executed)

374. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1538870400 rundata_81 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

375. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1538870400_endtime on bml_mv_routing_esme_1538870400 t_205 (cost=0.42..77.10 rows=2,104 width=744) (never executed)

  • Index Cond: (endtime = rundata_81.endtime)
376. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..174,661.09 rows=3,226,986 width=752) (never executed)

377. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1538956800 rundata_82 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

378. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1538956800_endtime on bml_mv_routing_esme_1538956800 t_206 (cost=0.42..93.76 rows=2,561 width=744) (never executed)

  • Index Cond: (endtime = rundata_82.endtime)
379. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..195,705.93 rows=3,616,578 width=752) (never executed)

380. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1539043200 rundata_83 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

381. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1539043200_endtime on bml_mv_routing_esme_1539043200 t_207 (cost=0.42..105.06 rows=2,870 width=744) (never executed)

  • Index Cond: (endtime = rundata_83.endtime)
382. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..183,854.10 rows=3,396,960 width=752) (never executed)

383. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1539129600 rundata_84 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

384. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1539129600_endtime on bml_mv_routing_esme_1539129600 t_208 (cost=0.42..98.70 rows=2,696 width=744) (never executed)

  • Index Cond: (endtime = rundata_84.endtime)
385. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..192,369.92 rows=3,554,649 width=752) (never executed)

386. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1539216000 rundata_85 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

387. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1539216000_endtime on bml_mv_routing_esme_1539216000 t_209 (cost=0.42..103.27 rows=2,821 width=744) (never executed)

  • Index Cond: (endtime = rundata_85.endtime)
388. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..168,573.15 rows=3,050,744 width=752) (never executed)

389. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1539302400 rundata_86 (cost=0.00..45.90 rows=1,190 width=72) (never executed)

390. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1539302400_endtime on bml_mv_routing_esme_1539302400 t_210 (cost=0.42..96.75 rows=2,564 width=744) (never executed)

  • Index Cond: (endtime = rundata_86.endtime)
391. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..162,513.80 rows=3,001,194 width=752) (never executed)

392. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1539388800 rundata_87 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

393. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1539388800_endtime on bml_mv_routing_esme_1539388800 t_211 (cost=0.42..87.26 rows=2,382 width=744) (never executed)

  • Index Cond: (endtime = rundata_87.endtime)
394. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..158,364.47 rows=2,923,956 width=752) (never executed)

395. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1539475200 rundata_88 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

396. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1539475200_endtime on bml_mv_routing_esme_1539475200 t_212 (cost=0.42..85.03 rows=2,321 width=744) (never executed)

  • Index Cond: (endtime = rundata_88.endtime)
397. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..180,583.24 rows=3,336,165 width=752) (never executed)

398. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1539561600 rundata_89 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

399. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1539561600_endtime on bml_mv_routing_esme_1539561600 t_213 (cost=0.42..96.94 rows=2,648 width=744) (never executed)

  • Index Cond: (endtime = rundata_89.endtime)
400. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..190,318.55 rows=3,516,534 width=752) (never executed)

401. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1539648000 rundata_90 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

402. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1539648000_endtime on bml_mv_routing_esme_1539648000 t_214 (cost=0.42..102.17 rows=2,791 width=744) (never executed)

  • Index Cond: (endtime = rundata_90.endtime)
403. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..183,511.49 rows=3,390,219 width=752) (never executed)

404. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1539734400 rundata_91 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

405. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1539734400_endtime on bml_mv_routing_esme_1539734400 t_215 (cost=0.42..98.52 rows=2,691 width=744) (never executed)

  • Index Cond: (endtime = rundata_91.endtime)
406. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..178,434.57 rows=3,296,790 width=752) (never executed)

407. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1539820800 rundata_92 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

408. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1539820800_endtime on bml_mv_routing_esme_1539820800 t_216 (cost=0.42..95.79 rows=2,616 width=744) (never executed)

  • Index Cond: (endtime = rundata_92.endtime)
409. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..147,287.12 rows=2,636,114 width=752) (never executed)

410. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1539907200 rundata_93 (cost=0.00..44.55 rows=1,155 width=72) (never executed)

411. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1539907200_endtime on bml_mv_routing_esme_1539907200 t_217 (cost=0.42..87.55 rows=2,282 width=744) (never executed)

  • Index Cond: (endtime = rundata_93.endtime)
412. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..151,047.60 rows=2,761,701 width=752) (never executed)

413. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1539993600 rundata_94 (cost=0.00..47.25 rows=1,225 width=72) (never executed)

414. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1539993600_endtime on bml_mv_routing_esme_1539993600 t_218 (cost=0.42..83.82 rows=2,254 width=744) (never executed)

  • Index Cond: (endtime = rundata_94.endtime)
415. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..146,470.28 rows=2,703,897 width=752) (never executed)

416. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1540080000 rundata_95 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

417. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1540080000_endtime on bml_mv_routing_esme_1540080000 t_219 (cost=0.42..78.65 rows=2,146 width=744) (never executed)

  • Index Cond: (endtime = rundata_95.endtime)
418. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.29..1,479,304.59 rows=36,822,082 width=752) (never executed)

419. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1540166400 t_220 (cost=0.00..53,826.30 rows=489,330 width=744) (never executed)

420. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_rundata_1540166400_endtime on bml_mv_rundata_1540166400 rundata_96 (cost=0.29..1.60 rows=75 width=72) (never executed)

  • Index Cond: (endtime = t_220.endtime)
421. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..175,952.57 rows=3,218,565 width=752) (never executed)

422. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1540252800 rundata_97 (cost=0.00..47.25 rows=1,225 width=72) (never executed)

423. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1540252800_endtime on bml_mv_routing_esme_1540252800 t_221 (cost=0.42..97.62 rows=2,627 width=744) (never executed)

  • Index Cond: (endtime = rundata_97.endtime)
424. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..171,265.71 rows=3,132,141 width=752) (never executed)

425. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1540339200 rundata_98 (cost=0.00..47.25 rows=1,225 width=72) (never executed)

426. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1540339200_endtime on bml_mv_routing_esme_1540339200 t_222 (cost=0.42..95.02 rows=2,557 width=744) (never executed)

  • Index Cond: (endtime = rundata_98.endtime)
427. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..183,675.76 rows=3,393,495 width=752) (never executed)

428. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1540425600 rundata_99 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

429. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1540425600_endtime on bml_mv_routing_esme_1540425600 t_223 (cost=0.42..98.61 rows=2,693 width=744) (never executed)

  • Index Cond: (endtime = rundata_99.endtime)
430. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..177,399.21 rows=3,276,882 width=752) (never executed)

431. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1540512000 rundata_100 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

432. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1540512000_endtime on bml_mv_routing_esme_1540512000 t_224 (cost=0.42..95.24 rows=2,601 width=744) (never executed)

  • Index Cond: (endtime = rundata_100.endtime)
433. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..153,662.92 rows=2,836,890 width=752) (never executed)

434. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1540598400 rundata_101 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

435. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1540598400_endtime on bml_mv_routing_esme_1540598400 t_225 (cost=0.42..82.51 rows=2,252 width=744) (never executed)

  • Index Cond: (endtime = rundata_101.endtime)
436. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..141,855.59 rows=2,618,658 width=752) (never executed)

437. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1540684800 rundata_102 (cost=0.00..48.60 rows=1,260 width=72) (never executed)

438. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1540684800_endtime on bml_mv_routing_esme_1540684800 t_226 (cost=0.42..76.18 rows=2,078 width=744) (never executed)

  • Index Cond: (endtime = rundata_102.endtime)
439. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..138,394.06 rows=2,448,208 width=752) (never executed)

440. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1540771200 rundata_103 (cost=0.00..43.20 rows=1,120 width=72) (never executed)

441. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1540771200_endtime on bml_mv_routing_esme_1540771200 t_227 (cost=0.42..85.27 rows=2,186 width=744) (never executed)

  • Index Cond: (endtime = rundata_103.endtime)
442. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..851,247.61 rows=22,536,647 width=752) (never executed)

443. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1540857600 rundata_104 (cost=0.00..63.22 rows=2,822 width=72) (never executed)

444. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1540857600_endtime on bml_mv_routing_esme_1540857600 t_228 (cost=0.43..161.87 rows=7,986 width=744) (never executed)

  • Index Cond: (endtime = rundata_104.endtime)
445. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..865,028.11 rows=22,932,250 width=752) (never executed)

446. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1540944000 rundata_105 (cost=0.00..64.74 rows=2,874 width=72) (never executed)

447. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1540944000_endtime on bml_mv_routing_esme_1540944000 t_229 (cost=0.43..161.33 rows=7,979 width=744) (never executed)

  • Index Cond: (endtime = rundata_105.endtime)
448. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..595,618.69 rows=15,573,265 width=752) (never executed)

449. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1541030400 rundata_106 (cost=0.00..54.05 rows=2,405 width=72) (never executed)

450. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1541030400_endtime on bml_mv_routing_esme_1541030400 t_230 (cost=0.43..134.32 rows=6,475 width=744) (never executed)

  • Index Cond: (endtime = rundata_106.endtime)
451. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..821,642.63 rows=21,764,779 width=752) (never executed)

452. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1541116800 rundata_107 (cost=0.00..64.49 rows=2,849 width=72) (never executed)

453. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1541116800_endtime on bml_mv_routing_esme_1541116800 t_231 (cost=0.43..154.69 rows=7,639 width=744) (never executed)

  • Index Cond: (endtime = rundata_107.endtime)
454. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..663,851.36 rows=17,518,307 width=752) (never executed)

455. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1541203200 rundata_108 (cost=0.00..61.15 rows=2,715 width=72) (never executed)

456. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1541203200_endtime on bml_mv_routing_esme_1541203200 t_232 (cost=0.43..131.58 rows=6,452 width=744) (never executed)

  • Index Cond: (endtime = rundata_108.endtime)
457. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..707,609.67 rows=18,753,619 width=752) (never executed)

458. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1541289600 rundata_109 (cost=0.00..64.79 rows=2,879 width=72) (never executed)

459. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1541289600_endtime on bml_mv_routing_esme_1541289600 t_233 (cost=0.43..131.77 rows=6,514 width=744) (never executed)

  • Index Cond: (endtime = rundata_109.endtime)
460. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..834,451.20 rows=22,118,774 width=752) (never executed)

461. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1541376000 rundata_110 (cost=0.00..64.80 rows=2,880 width=72) (never executed)

462. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1541376000_endtime on bml_mv_routing_esme_1541376000 t_234 (cost=0.43..155.32 rows=7,680 width=744) (never executed)

  • Index Cond: (endtime = rundata_110.endtime)
463. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.29..2,488,598.02 rows=58,658,661 width=752) (never executed)

464. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1541462400 t_235 (cost=0.00..55,109.99 rows=1,309,199 width=744) (never executed)

465. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_rundata_1541462400_endtime on bml_mv_rundata_1541462400 rundata_111 (cost=0.29..1.07 rows=45 width=72) (never executed)

  • Index Cond: (endtime = t_235.endtime)
466. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..703,974.91 rows=18,598,601 width=752) (never executed)

467. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1541548800 rundata_112 (cost=0.00..62.58 rows=2,758 width=72) (never executed)

468. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1541548800_endtime on bml_mv_routing_esme_1541548800 t_236 (cost=0.43..137.21 rows=6,744 width=744) (never executed)

  • Index Cond: (endtime = rundata_112.endtime)
469. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..745,679.03 rows=19,757,830 width=752) (never executed)

470. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1541635200 rundata_113 (cost=0.00..64.74 rows=2,874 width=72) (never executed)

471. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1541635200_endtime on bml_mv_routing_esme_1541635200 t_237 (cost=0.43..139.12 rows=6,875 width=744) (never executed)

  • Index Cond: (endtime = rundata_113.endtime)
472. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..763,760.65 rows=20,225,713 width=752) (never executed)

473. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1541721600 rundata_114 (cost=0.00..64.40 rows=2,840 width=72) (never executed)

474. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1541721600_endtime on bml_mv_routing_esme_1541721600 t_238 (cost=0.43..144.27 rows=7,122 width=744) (never executed)

  • Index Cond: (endtime = rundata_114.endtime)
475. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..698,333.12 rows=18,510,523 width=752) (never executed)

476. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1541808000 rundata_115 (cost=0.00..64.80 rows=2,880 width=72) (never executed)

477. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1541808000_endtime on bml_mv_routing_esme_1541808000 t_239 (cost=0.43..129.98 rows=6,427 width=744) (never executed)

  • Index Cond: (endtime = rundata_115.endtime)
478. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..657,791.44 rows=17,434,858 width=752) (never executed)

479. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1541894400 rundata_116 (cost=0.00..64.80 rows=2,880 width=72) (never executed)

480. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1541894400_endtime on bml_mv_routing_esme_1541894400 t_240 (cost=0.43..122.43 rows=6,054 width=744) (never executed)

  • Index Cond: (endtime = rundata_116.endtime)
481. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..783,243.87 rows=20,759,548 width=752) (never executed)

482. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1541980800 rundata_117 (cost=0.00..64.79 rows=2,879 width=72) (never executed)

483. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1541980800_endtime on bml_mv_routing_esme_1541980800 t_241 (cost=0.43..145.84 rows=7,211 width=744) (never executed)

  • Index Cond: (endtime = rundata_117.endtime)
484. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..215,379.72 rows=5,374,615 width=752) (never executed)

485. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1542067200 rundata_118 (cost=0.00..35.53 rows=1,553 width=72) (never executed)

486. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1542067200_endtime on bml_mv_routing_esme_1542067200 t_242 (cost=0.42..78.10 rows=3,461 width=744) (never executed)

  • Index Cond: (endtime = rundata_118.endtime)
487. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..502,716.01 rows=13,279,557 width=752) (never executed)

488. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1542153600 rundata_119 (cost=0.00..62.82 rows=2,782 width=72) (never executed)

489. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1542153600_endtime on bml_mv_routing_esme_1542153600 t_243 (cost=0.42..97.15 rows=4,773 width=744) (never executed)

  • Index Cond: (endtime = rundata_119.endtime)
490. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..793,565.68 rows=21,028,641 width=752) (never executed)

491. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1542240000 rundata_120 (cost=0.00..64.74 rows=2,874 width=72) (never executed)

492. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1542240000_endtime on bml_mv_routing_esme_1542240000 t_244 (cost=0.43..148.05 rows=7,317 width=744) (never executed)

  • Index Cond: (endtime = rundata_120.endtime)
493. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..786,996.16 rows=20,859,062 width=752) (never executed)

494. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1542326400 rundata_121 (cost=0.00..64.80 rows=2,880 width=72) (never executed)

495. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1542326400_endtime on bml_mv_routing_esme_1542326400 t_245 (cost=0.43..146.49 rows=7,243 width=744) (never executed)

  • Index Cond: (endtime = rundata_121.endtime)
496. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..706,361.26 rows=18,721,915 width=752) (never executed)

497. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1542412800 rundata_122 (cost=0.00..64.80 rows=2,880 width=72) (never executed)

498. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1542412800_endtime on bml_mv_routing_esme_1542412800 t_246 (cost=0.43..131.48 rows=6,501 width=744) (never executed)

  • Index Cond: (endtime = rundata_122.endtime)
499. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.42..262,021.58 rows=6,671,497 width=752) (never executed)

500. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1542499200 rundata_123 (cost=0.00..41.37 rows=1,837 width=72) (never executed)

501. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1542499200_endtime on bml_mv_routing_esme_1542499200 t_247 (cost=0.42..79.06 rows=3,632 width=744) (never executed)

  • Index Cond: (endtime = rundata_123.endtime)
502. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..804,815.14 rows=21,333,732 width=752) (never executed)

503. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1542585600 rundata_124 (cost=0.00..64.77 rows=2,877 width=72) (never executed)

504. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1542585600_endtime on bml_mv_routing_esme_1542585600 t_248 (cost=0.43..149.95 rows=7,415 width=744) (never executed)

  • Index Cond: (endtime = rundata_124.endtime)
505. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..818,755.95 rows=21,698,386 width=752) (never executed)

506. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1542672000 rundata_125 (cost=0.00..64.71 rows=2,871 width=72) (never executed)

507. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1542672000_endtime on bml_mv_routing_esme_1542672000 t_249 (cost=0.43..152.90 rows=7,558 width=744) (never executed)

  • Index Cond: (endtime = rundata_125.endtime)
508. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..797,548.95 rows=21,139,114 width=752) (never executed)

509. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1542758400 rundata_126 (cost=0.00..64.80 rows=2,880 width=72) (never executed)

510. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1542758400_endtime on bml_mv_routing_esme_1542758400 t_250 (cost=0.43..148.45 rows=7,340 width=744) (never executed)

  • Index Cond: (endtime = rundata_126.endtime)
511. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..820,859.20 rows=21,755,917 width=752) (never executed)

512. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1542844800 rundata_127 (cost=0.00..64.77 rows=2,877 width=72) (never executed)

513. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1542844800_endtime on bml_mv_routing_esme_1542844800 t_251 (cost=0.43..152.96 rows=7,562 width=744) (never executed)

  • Index Cond: (endtime = rundata_127.endtime)
514. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..824,162.37 rows=21,825,144 width=752) (never executed)

515. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1542931200 rundata_128 (cost=0.00..64.41 rows=2,841 width=72) (never executed)

516. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1542931200_endtime on bml_mv_routing_esme_1542931200 t_252 (cost=0.43..155.64 rows=7,682 width=744) (never executed)

  • Index Cond: (endtime = rundata_128.endtime)
517. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..767,629.72 rows=20,347,949 width=752) (never executed)

518. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1543017600 rundata_129 (cost=0.00..64.80 rows=2,880 width=72) (never executed)

519. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1543017600_endtime on bml_mv_routing_esme_1543017600 t_253 (cost=0.43..142.88 rows=7,065 width=744) (never executed)

  • Index Cond: (endtime = rundata_129.endtime)
520. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..723,595.07 rows=19,181,150 width=752) (never executed)

521. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1543104000 rundata_130 (cost=0.00..64.78 rows=2,878 width=72) (never executed)

522. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1543104000_endtime on bml_mv_routing_esme_1543104000 t_254 (cost=0.43..134.76 rows=6,665 width=744) (never executed)

  • Index Cond: (endtime = rundata_130.endtime)
523. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..875,145.77 rows=23,197,810 width=752) (never executed)

524. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1543190400 rundata_131 (cost=0.00..64.80 rows=2,880 width=72) (never executed)

525. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1543190400_endtime on bml_mv_routing_esme_1543190400 t_255 (cost=0.43..162.89 rows=8,055 width=744) (never executed)

  • Index Cond: (endtime = rundata_131.endtime)
526. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..827,467.11 rows=21,921,733 width=752) (never executed)

527. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1543276800 rundata_132 (cost=0.00..64.66 rows=2,866 width=72) (never executed)

528. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1543276800_endtime on bml_mv_routing_esme_1543276800 t_256 (cost=0.43..154.84 rows=7,649 width=744) (never executed)

  • Index Cond: (endtime = rundata_132.endtime)
529. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..838,068.77 rows=22,216,262 width=752) (never executed)

530. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1543363200 rundata_133 (cost=0.00..64.80 rows=2,880 width=72) (never executed)

531. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1543363200_endtime on bml_mv_routing_esme_1543363200 t_257 (cost=0.43..155.98 rows=7,714 width=744) (never executed)

  • Index Cond: (endtime = rundata_133.endtime)
532. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..857,348.61 rows=22,729,288 width=752) (never executed)

533. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1543449600 rundata_134 (cost=0.00..64.79 rows=2,879 width=72) (never executed)

534. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1543449600_endtime on bml_mv_routing_esme_1543449600 t_258 (cost=0.43..159.61 rows=7,895 width=744) (never executed)

  • Index Cond: (endtime = rundata_134.endtime)
535. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..852,150.60 rows=22,587,883 width=752) (never executed)

536. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1543536000 rundata_135 (cost=0.00..64.75 rows=2,875 width=72) (never executed)

537. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1543536000_endtime on bml_mv_routing_esme_1543536000 t_259 (cost=0.43..158.88 rows=7,857 width=744) (never executed)

  • Index Cond: (endtime = rundata_135.endtime)
538. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..699,225.75 rows=18,437,080 width=752) (never executed)

539. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1543622400 rundata_136 (cost=0.00..60.83 rows=2,683 width=72) (never executed)

540. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1543622400_endtime on bml_mv_routing_esme_1543622400 t_260 (cost=0.43..140.33 rows=6,872 width=744) (never executed)

  • Index Cond: (endtime = rundata_136.endtime)
541. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..743,105.51 rows=19,699,644 width=752) (never executed)

542. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1543708800 rundata_137 (cost=0.00..64.79 rows=2,879 width=72) (never executed)

543. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1543708800_endtime on bml_mv_routing_esme_1543708800 t_261 (cost=0.43..138.34 rows=6,843 width=744) (never executed)

  • Index Cond: (endtime = rundata_137.endtime)
544. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..863,903.55 rows=22,900,133 width=752) (never executed)

545. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1543795200 rundata_138 (cost=0.00..64.74 rows=2,874 width=72) (never executed)

546. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1543795200_endtime on bml_mv_routing_esme_1543795200 t_262 (cost=0.43..161.13 rows=7,968 width=744) (never executed)

  • Index Cond: (endtime = rundata_138.endtime)
547. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..861,083.58 rows=22,816,293 width=752) (never executed)

548. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1543881600 rundata_139 (cost=0.00..64.62 rows=2,862 width=72) (never executed)

549. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1543881600_endtime on bml_mv_routing_esme_1543881600 t_263 (cost=0.43..161.33 rows=7,972 width=744) (never executed)

  • Index Cond: (endtime = rundata_139.endtime)
550. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..862,318.41 rows=22,856,931 width=752) (never executed)

551. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1543968000 rundata_140 (cost=0.00..64.77 rows=2,877 width=72) (never executed)

552. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1543968000_endtime on bml_mv_routing_esme_1543968000 t_264 (cost=0.43..160.67 rows=7,945 width=744) (never executed)

  • Index Cond: (endtime = rundata_140.endtime)
553. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..836,039.83 rows=22,159,796 width=752) (never executed)

554. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1544054400 rundata_141 (cost=0.00..64.75 rows=2,875 width=72) (never executed)

555. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1544054400_endtime on bml_mv_routing_esme_1544054400 t_265 (cost=0.43..155.89 rows=7,708 width=744) (never executed)

  • Index Cond: (endtime = rundata_141.endtime)
556. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..832,808.52 rows=22,073,071 width=752) (never executed)

557. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1544140800 rundata_142 (cost=0.00..64.75 rows=2,875 width=72) (never executed)

558. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1544140800_endtime on bml_mv_routing_esme_1544140800 t_266 (cost=0.43..155.29 rows=7,678 width=744) (never executed)

  • Index Cond: (endtime = rundata_142.endtime)
559. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..744,501.80 rows=19,733,947 width=752) (never executed)

560. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1544227200 rundata_143 (cost=0.00..64.80 rows=2,880 width=72) (never executed)

561. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1544227200_endtime on bml_mv_routing_esme_1544227200 t_267 (cost=0.43..138.57 rows=6,852 width=744) (never executed)

  • Index Cond: (endtime = rundata_143.endtime)
562. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..703,567.28 rows=18,650,491 width=752) (never executed)

563. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1544313600 rundata_144 (cost=0.00..64.80 rows=2,880 width=72) (never executed)

564. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1544313600_endtime on bml_mv_routing_esme_1544313600 t_268 (cost=0.43..130.94 rows=6,476 width=744) (never executed)

  • Index Cond: (endtime = rundata_144.endtime)
565. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..833,779.65 rows=22,100,786 width=752) (never executed)

566. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1544400000 rundata_145 (cost=0.00..64.75 rows=2,875 width=72) (never executed)

567. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1544400000_endtime on bml_mv_routing_esme_1544400000 t_269 (cost=0.43..155.46 rows=7,687 width=744) (never executed)

  • Index Cond: (endtime = rundata_145.endtime)
568. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..846,147.32 rows=22,428,200 width=752) (never executed)

569. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1544486400 rundata_146 (cost=0.00..64.77 rows=2,877 width=72) (never executed)

570. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1544486400_endtime on bml_mv_routing_esme_1544486400 t_270 (cost=0.43..157.66 rows=7,796 width=744) (never executed)

  • Index Cond: (endtime = rundata_146.endtime)
571. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..818,264.44 rows=21,681,139 width=752) (never executed)

572. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1544572800 rundata_147 (cost=0.00..64.64 rows=2,864 width=72) (never executed)

573. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1544572800_endtime on bml_mv_routing_esme_1544572800 t_271 (cost=0.43..153.21 rows=7,570 width=744) (never executed)

  • Index Cond: (endtime = rundata_147.endtime)
574. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..805,726.80 rows=21,352,976 width=752) (never executed)

575. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1544659200 rundata_148 (cost=0.00..64.78 rows=2,878 width=72) (never executed)

576. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1544659200_endtime on bml_mv_routing_esme_1544659200 t_272 (cost=0.43..150.10 rows=7,419 width=744) (never executed)

  • Index Cond: (endtime = rundata_148.endtime)
577. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..778,448.85 rows=20,623,778 width=752) (never executed)

578. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1544745600 rundata_149 (cost=0.00..64.69 rows=2,869 width=72) (never executed)

579. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1544745600_endtime on bml_mv_routing_esme_1544745600 t_273 (cost=0.43..145.51 rows=7,188 width=744) (never executed)

  • Index Cond: (endtime = rundata_149.endtime)
580. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..744,363.95 rows=19,726,375 width=752) (never executed)

581. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1544832000 rundata_150 (cost=0.00..64.79 rows=2,879 width=72) (never executed)

582. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1544832000_endtime on bml_mv_routing_esme_1544832000 t_274 (cost=0.43..138.62 rows=6,852 width=744) (never executed)

  • Index Cond: (endtime = rundata_150.endtime)
583. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..692,060.49 rows=18,343,217 width=752) (never executed)

584. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1544918400 rundata_151 (cost=0.00..64.79 rows=2,879 width=72) (never executed)

585. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1544918400_endtime on bml_mv_routing_esme_1544918400 t_275 (cost=0.43..128.86 rows=6,371 width=744) (never executed)

  • Index Cond: (endtime = rundata_151.endtime)
586. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..819,897.28 rows=21,725,527 width=752) (never executed)

587. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1545004800 rundata_152 (cost=0.00..64.75 rows=2,875 width=72) (never executed)

588. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1545004800_endtime on bml_mv_routing_esme_1545004800 t_276 (cost=0.43..152.91 rows=7,557 width=744) (never executed)

  • Index Cond: (endtime = rundata_152.endtime)
589. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..822,718.24 rows=21,802,151 width=752) (never executed)

590. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1545091200 rundata_153 (cost=0.00..64.77 rows=2,877 width=72) (never executed)

591. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1545091200_endtime on bml_mv_routing_esme_1545091200 t_277 (cost=0.43..153.33 rows=7,578 width=744) (never executed)

  • Index Cond: (endtime = rundata_153.endtime)
592. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..840,173.25 rows=22,265,970 width=752) (never executed)

593. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1545177600 rundata_154 (cost=0.00..64.79 rows=2,879 width=72) (never executed)

594. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1545177600_endtime on bml_mv_routing_esme_1545177600 t_278 (cost=0.43..156.46 rows=7,734 width=744) (never executed)

  • Index Cond: (endtime = rundata_154.endtime)
595. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..831,656.16 rows=22,038,510 width=752) (never executed)

596. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1545264000 rundata_155 (cost=0.00..64.77 rows=2,877 width=72) (never executed)

597. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1545264000_endtime on bml_mv_routing_esme_1545264000 t_279 (cost=0.43..155.00 rows=7,660 width=744) (never executed)

  • Index Cond: (endtime = rundata_155.endtime)
598. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..811,813.20 rows=21,507,149 width=752) (never executed)

599. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1545350400 rundata_156 (cost=0.00..64.73 rows=2,873 width=72) (never executed)

600. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1545350400_endtime on bml_mv_routing_esme_1545350400 t_280 (cost=0.43..151.54 rows=7,486 width=744) (never executed)

  • Index Cond: (endtime = rundata_156.endtime)
601. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..779,646.12 rows=20,660,789 width=752) (never executed)

602. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1545436800 rundata_157 (cost=0.00..64.80 rows=2,880 width=72) (never executed)

603. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1545436800_endtime on bml_mv_routing_esme_1545436800 t_281 (cost=0.43..145.14 rows=7,174 width=744) (never executed)

  • Index Cond: (endtime = rundata_157.endtime)
604. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..701,438.28 rows=18,589,997 width=752) (never executed)

605. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1545523200 rundata_158 (cost=0.00..64.80 rows=2,880 width=72) (never executed)

606. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1545523200_endtime on bml_mv_routing_esme_1545523200 t_282 (cost=0.43..130.57 rows=6,455 width=744) (never executed)

  • Index Cond: (endtime = rundata_158.endtime)
607. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..780,377.65 rows=20,677,160 width=752) (never executed)

608. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1545609600 rundata_159 (cost=0.00..64.76 rows=2,876 width=72) (never executed)

609. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1545609600_endtime on bml_mv_routing_esme_1545609600 t_283 (cost=0.43..145.50 rows=7,190 width=744) (never executed)

  • Index Cond: (endtime = rundata_159.endtime)
610. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..718,763.83 rows=19,050,898 width=752) (never executed)

611. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1545696000 rundata_160 (cost=0.00..64.80 rows=2,880 width=72) (never executed)

612. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1545696000_endtime on bml_mv_routing_esme_1545696000 t_284 (cost=0.43..133.79 rows=6,615 width=744) (never executed)

  • Index Cond: (endtime = rundata_160.endtime)
613. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..747,732.14 rows=19,815,739 width=752) (never executed)

614. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1545782400 rundata_161 (cost=0.00..64.80 rows=2,880 width=72) (never executed)

615. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1545782400_endtime on bml_mv_routing_esme_1545782400 t_285 (cost=0.43..139.20 rows=6,880 width=744) (never executed)

  • Index Cond: (endtime = rundata_161.endtime)
616. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..795,356.06 rows=21,076,848 width=752) (never executed)

617. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1545868800 rundata_162 (cost=0.00..64.80 rows=2,880 width=72) (never executed)

618. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1545868800_endtime on bml_mv_routing_esme_1545868800 t_286 (cost=0.43..148.08 rows=7,318 width=744) (never executed)

  • Index Cond: (endtime = rundata_162.endtime)
619. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..782,458.77 rows=20,731,615 width=752) (never executed)

620. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1545955200 rundata_163 (cost=0.00..64.78 rows=2,878 width=72) (never executed)

621. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1545955200_endtime on bml_mv_routing_esme_1545955200 t_287 (cost=0.43..145.80 rows=7,203 width=744) (never executed)

  • Index Cond: (endtime = rundata_163.endtime)
622. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..763,213.34 rows=20,224,325 width=752) (never executed)

623. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1546041600 rundata_164 (cost=0.00..64.80 rows=2,880 width=72) (never executed)

624. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1546041600_endtime on bml_mv_routing_esme_1546041600 t_288 (cost=0.43..142.09 rows=7,022 width=744) (never executed)

  • Index Cond: (endtime = rundata_164.endtime)
625. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..707,428.00 rows=18,747,429 width=752) (never executed)

626. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1546128000 rundata_165 (cost=0.00..64.79 rows=2,879 width=72) (never executed)

627. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1546128000_endtime on bml_mv_routing_esme_1546128000 t_289 (cost=0.43..131.74 rows=6,512 width=744) (never executed)

  • Index Cond: (endtime = rundata_165.endtime)
628. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..763,836.26 rows=20,237,798 width=752) (never executed)

629. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1546214400 rundata_166 (cost=0.00..64.68 rows=2,868 width=72) (never executed)

630. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1546214400_endtime on bml_mv_routing_esme_1546214400 t_290 (cost=0.43..142.82 rows=7,056 width=744) (never executed)

  • Index Cond: (endtime = rundata_166.endtime)
631. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..699,520.17 rows=18,537,291 width=752) (never executed)

632. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1546300800 rundata_167 (cost=0.00..64.79 rows=2,879 width=72) (never executed)

633. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1546300800_endtime on bml_mv_routing_esme_1546300800 t_291 (cost=0.43..130.27 rows=6,439 width=744) (never executed)

  • Index Cond: (endtime = rundata_167.endtime)
634. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..788,086.69 rows=20,882,379 width=752) (never executed)

635. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1546387200 rundata_168 (cost=0.00..64.78 rows=2,878 width=72) (never executed)

636. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1546387200_endtime on bml_mv_routing_esme_1546387200 t_292 (cost=0.43..146.83 rows=7,256 width=744) (never executed)

  • Index Cond: (endtime = rundata_168.endtime)
637. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..1,011,566.02 rows=26,809,565 width=752) (never executed)

638. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1546473600 rundata_169 (cost=0.00..64.79 rows=2,879 width=72) (never executed)

639. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1546473600_endtime on bml_mv_routing_esme_1546473600 t_293 (cost=0.43..188.38 rows=9,312 width=744) (never executed)

  • Index Cond: (endtime = rundata_169.endtime)
640. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..981,678.33 rows=26,018,372 width=752) (never executed)

641. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1546560000 rundata_170 (cost=0.00..64.79 rows=2,879 width=72) (never executed)

642. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1546560000_endtime on bml_mv_routing_esme_1546560000 t_294 (cost=0.43..182.81 rows=9,037 width=744) (never executed)

  • Index Cond: (endtime = rundata_170.endtime)
643. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..787,814.40 rows=20,877,667 width=752) (never executed)

644. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1546646400 rundata_171 (cost=0.00..64.80 rows=2,880 width=72) (never executed)

645. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1546646400_endtime on bml_mv_routing_esme_1546646400 t_295 (cost=0.43..146.67 rows=7,249 width=744) (never executed)

  • Index Cond: (endtime = rundata_171.endtime)
646. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..728,420.91 rows=19,306,128 width=752) (never executed)

647. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1546732800 rundata_172 (cost=0.00..64.79 rows=2,879 width=72) (never executed)

648. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1546732800_endtime on bml_mv_routing_esme_1546732800 t_296 (cost=0.43..135.64 rows=6,706 width=744) (never executed)

  • Index Cond: (endtime = rundata_172.endtime)
649. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..859,190.13 rows=22,767,081 width=752) (never executed)

650. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1546819200 rundata_173 (cost=0.00..64.78 rows=2,878 width=72) (never executed)

651. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1546819200_endtime on bml_mv_routing_esme_1546819200 t_297 (cost=0.43..160.07 rows=7,911 width=744) (never executed)

  • Index Cond: (endtime = rundata_173.endtime)
652. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..860,482.18 rows=22,799,873 width=752) (never executed)

653. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1546905600 rundata_174 (cost=0.00..64.74 rows=2,874 width=72) (never executed)

654. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1546905600_endtime on bml_mv_routing_esme_1546905600 t_298 (cost=0.43..160.55 rows=7,933 width=744) (never executed)

  • Index Cond: (endtime = rundata_174.endtime)
655. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..872,858.75 rows=23,130,217 width=752) (never executed)

656. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1546992000 rundata_175 (cost=0.00..64.79 rows=2,879 width=72) (never executed)

657. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1546992000_endtime on bml_mv_routing_esme_1546992000 t_299 (cost=0.43..162.56 rows=8,034 width=744) (never executed)

  • Index Cond: (endtime = rundata_175.endtime)
658. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..858,043.86 rows=22,737,823 width=752) (never executed)

659. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1547078400 rundata_176 (cost=0.00..64.77 rows=2,877 width=72) (never executed)

660. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1547078400_endtime on bml_mv_routing_esme_1547078400 t_300 (cost=0.43..159.92 rows=7,903 width=744) (never executed)

  • Index Cond: (endtime = rundata_176.endtime)
661. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..838,428.23 rows=22,212,672 width=752) (never executed)

662. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1547164800 rundata_177 (cost=0.00..64.74 rows=2,874 width=72) (never executed)

663. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1547164800_endtime on bml_mv_routing_esme_1547164800 t_301 (cost=0.43..156.45 rows=7,729 width=744) (never executed)

  • Index Cond: (endtime = rundata_177.endtime)
664. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..756,194.93 rows=20,037,989 width=752) (never executed)

665. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1547251200 rundata_178 (cost=0.00..64.78 rows=2,878 width=72) (never executed)

666. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1547251200_endtime on bml_mv_routing_esme_1547251200 t_302 (cost=0.43..140.89 rows=6,962 width=744) (never executed)

  • Index Cond: (endtime = rundata_178.endtime)
667. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..738,276.90 rows=19,564,590 width=752) (never executed)

668. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1547337600 rundata_179 (cost=0.00..64.79 rows=2,879 width=72) (never executed)

669. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1547337600_endtime on bml_mv_routing_esme_1547337600 t_303 (cost=0.43..137.49 rows=6,796 width=744) (never executed)

  • Index Cond: (endtime = rundata_179.endtime)
670. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..843,717.46 rows=22,356,647 width=752) (never executed)

671. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1547424000 rundata_180 (cost=0.00..64.75 rows=2,875 width=72) (never executed)

672. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1547424000_endtime on bml_mv_routing_esme_1547424000 t_304 (cost=0.43..157.36 rows=7,776 width=744) (never executed)

  • Index Cond: (endtime = rundata_180.endtime)
673. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..834,790.02 rows=22,119,618 width=752) (never executed)

674. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1547510400 rundata_181 (cost=0.00..64.75 rows=2,875 width=72) (never executed)

675. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1547510400_endtime on bml_mv_routing_esme_1547510400 t_305 (cost=0.43..155.70 rows=7,694 width=744) (never executed)

  • Index Cond: (endtime = rundata_181.endtime)
676. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..849,145.80 rows=22,498,190 width=752) (never executed)

677. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1547596800 rundata_182 (cost=0.00..64.73 rows=2,873 width=72) (never executed)

678. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1547596800_endtime on bml_mv_routing_esme_1547596800 t_306 (cost=0.43..158.50 rows=7,831 width=744) (never executed)

  • Index Cond: (endtime = rundata_182.endtime)
679. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..845,497.96 rows=22,404,788 width=752) (never executed)

680. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1547683200 rundata_183 (cost=0.00..64.76 rows=2,876 width=72) (never executed)

681. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1547683200_endtime on bml_mv_routing_esme_1547683200 t_307 (cost=0.43..157.63 rows=7,790 width=744) (never executed)

  • Index Cond: (endtime = rundata_183.endtime)
682. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..869,785.59 rows=23,047,201 width=752) (never executed)

683. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1547769600 rundata_184 (cost=0.00..64.77 rows=2,877 width=72) (never executed)

684. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1547769600_endtime on bml_mv_routing_esme_1547769600 t_308 (cost=0.43..162.11 rows=8,011 width=744) (never executed)

  • Index Cond: (endtime = rundata_184.endtime)
685. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..804,251.91 rows=21,313,118 width=752) (never executed)

686. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1547856000 rundata_185 (cost=0.00..64.77 rows=2,877 width=72) (never executed)

687. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1547856000_endtime on bml_mv_routing_esme_1547856000 t_309 (cost=0.43..149.88 rows=7,408 width=744) (never executed)

  • Index Cond: (endtime = rundata_185.endtime)
688. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..743,021.60 rows=19,691,525 width=752) (never executed)

689. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1547942400 rundata_186 (cost=0.00..64.79 rows=2,879 width=72) (never executed)

690. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1547942400_endtime on bml_mv_routing_esme_1547942400 t_310 (cost=0.43..138.36 rows=6,840 width=744) (never executed)

  • Index Cond: (endtime = rundata_186.endtime)
691. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..876,656.10 rows=23,223,624 width=752) (never executed)

692. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1548028800 rundata_187 (cost=0.00..64.70 rows=2,870 width=72) (never executed)

693. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1548028800_endtime on bml_mv_routing_esme_1548028800 t_311 (cost=0.43..163.82 rows=8,092 width=744) (never executed)

  • Index Cond: (endtime = rundata_187.endtime)
694. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..865,160.19 rows=22,922,561 width=752) (never executed)

695. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1548115200 rundata_188 (cost=0.00..64.73 rows=2,873 width=72) (never executed)

696. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1548115200_endtime on bml_mv_routing_esme_1548115200 t_312 (cost=0.43..161.48 rows=7,979 width=744) (never executed)

  • Index Cond: (endtime = rundata_188.endtime)
697. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..828,803.73 rows=21,962,445 width=752) (never executed)

698. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1548201600 rundata_189 (cost=0.00..64.76 rows=2,876 width=72) (never executed)

699. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1548201600_endtime on bml_mv_routing_esme_1548201600 t_313 (cost=0.43..154.52 rows=7,636 width=744) (never executed)

  • Index Cond: (endtime = rundata_189.endtime)
700. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..841,596.73 rows=22,301,694 width=752) (never executed)

701. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1548288000 rundata_190 (cost=0.00..64.78 rows=2,878 width=72) (never executed)

702. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1548288000_endtime on bml_mv_routing_esme_1548288000 t_314 (cost=0.43..156.79 rows=7,749 width=744) (never executed)

  • Index Cond: (endtime = rundata_190.endtime)
703. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..731,057.22 rows=19,280,778 width=752) (never executed)

704. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1548374400 rundata_191 (cost=0.00..61.01 rows=2,701 width=72) (never executed)

705. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1548374400_endtime on bml_mv_routing_esme_1548374400 t_315 (cost=0.43..145.72 rows=7,138 width=744) (never executed)

  • Index Cond: (endtime = rundata_191.endtime)
706. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..768,093.76 rows=20,358,634 width=752) (never executed)

707. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1548460800 rundata_192 (cost=0.00..64.80 rows=2,880 width=72) (never executed)

708. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1548460800_endtime on bml_mv_routing_esme_1548460800 t_316 (cost=0.43..142.97 rows=7,069 width=744) (never executed)

  • Index Cond: (endtime = rundata_192.endtime)
709. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..729,614.23 rows=19,338,704 width=752) (never executed)

710. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1548547200 rundata_193 (cost=0.00..64.79 rows=2,879 width=72) (never executed)

711. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1548547200_endtime on bml_mv_routing_esme_1548547200 t_317 (cost=0.43..135.86 rows=6,717 width=744) (never executed)

  • Index Cond: (endtime = rundata_193.endtime)
712. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..833,504.65 rows=22,071,217 width=752) (never executed)

713. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1548633600 rundata_194 (cost=0.00..64.49 rows=2,849 width=72) (never executed)

714. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1548633600_endtime on bml_mv_routing_esme_1548633600 t_318 (cost=0.43..156.97 rows=7,747 width=744) (never executed)

  • Index Cond: (endtime = rundata_194.endtime)
715. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..830,737.58 rows=22,009,649 width=752) (never executed)

716. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1548720000 rundata_195 (cost=0.00..64.75 rows=2,875 width=72) (never executed)

717. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1548720000_endtime on bml_mv_routing_esme_1548720000 t_319 (cost=0.43..154.95 rows=7,656 width=744) (never executed)

  • Index Cond: (endtime = rundata_195.endtime)
718. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..827,115.63 rows=21,916,373 width=752) (never executed)

719. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1548806400 rundata_196 (cost=0.00..64.79 rows=2,879 width=72) (never executed)

720. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1548806400_endtime on bml_mv_routing_esme_1548806400 t_320 (cost=0.43..154.06 rows=7,612 width=744) (never executed)

  • Index Cond: (endtime = rundata_196.endtime)
721. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..804,724.88 rows=21,287,185 width=752) (never executed)

722. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1548892800 rundata_197 (cost=0.00..63.15 rows=2,815 width=72) (never executed)

723. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1548892800_endtime on bml_mv_routing_esme_1548892800 t_321 (cost=0.43..153.51 rows=7,562 width=744) (never executed)

  • Index Cond: (endtime = rundata_197.endtime)
724. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..831,383.90 rows=22,027,648 width=752) (never executed)

725. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1548979200 rundata_198 (cost=0.00..64.67 rows=2,867 width=72) (never executed)

726. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1548979200_endtime on bml_mv_routing_esme_1548979200 t_322 (cost=0.43..155.51 rows=7,683 width=744) (never executed)

  • Index Cond: (endtime = rundata_198.endtime)
727. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..776,901.59 rows=20,588,650 width=752) (never executed)

728. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1549065600 rundata_199 (cost=0.00..64.79 rows=2,879 width=72) (never executed)

729. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1549065600_endtime on bml_mv_routing_esme_1549065600 t_323 (cost=0.43..144.68 rows=7,151 width=744) (never executed)

  • Index Cond: (endtime = rundata_199.endtime)
730. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..726,466.66 rows=19,252,222 width=752) (never executed)

731. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1549152000 rundata_200 (cost=0.00..64.77 rows=2,877 width=72) (never executed)

732. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1549152000_endtime on bml_mv_routing_esme_1549152000 t_324 (cost=0.43..135.38 rows=6,692 width=744) (never executed)

  • Index Cond: (endtime = rundata_200.endtime)
733. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..835,135.17 rows=22,123,352 width=752) (never executed)

734. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1549238400 rundata_201 (cost=0.00..64.71 rows=2,871 width=72) (never executed)

735. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1549238400_endtime on bml_mv_routing_esme_1549238400 t_325 (cost=0.43..156.01 rows=7,706 width=744) (never executed)

  • Index Cond: (endtime = rundata_201.endtime)
736. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..821,009.52 rows=21,748,426 width=752) (never executed)

737. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1549324800 rundata_202 (cost=0.00..64.75 rows=2,875 width=72) (never executed)

738. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1549324800_endtime on bml_mv_routing_esme_1549324800 t_326 (cost=0.43..153.16 rows=7,565 width=744) (never executed)

  • Index Cond: (endtime = rundata_202.endtime)
739. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..838,057.18 rows=22,200,486 width=752) (never executed)

740. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1549411200 rundata_203 (cost=0.00..64.77 rows=2,877 width=72) (never executed)

741. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1549411200_endtime on bml_mv_routing_esme_1549411200 t_327 (cost=0.43..156.23 rows=7,717 width=744) (never executed)

  • Index Cond: (endtime = rundata_203.endtime)
742. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..817,070.96 rows=21,647,849 width=752) (never executed)

743. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1549497600 rundata_204 (cost=0.00..64.79 rows=2,879 width=72) (never executed)

744. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1549497600_endtime on bml_mv_routing_esme_1549497600 t_328 (cost=0.43..152.20 rows=7,519 width=744) (never executed)

  • Index Cond: (endtime = rundata_204.endtime)
745. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..555,785.66 rows=14,557,626 width=752) (never executed)

746. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1549584000 rundata_205 (cost=0.00..55.89 rows=2,489 width=72) (never executed)

747. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1549584000_endtime on bml_mv_routing_esme_1549584000 t_329 (cost=0.43..120.92 rows=5,849 width=744) (never executed)

  • Index Cond: (endtime = rundata_205.endtime)
748. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..1,713,985.22 rows=33,874,131 width=752) (never executed)

749. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1549670400 t_330 (cost=0.00..66,422.64 rows=1,570,064 width=744) (never executed)

750. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_rundata_1549670400_endtime on bml_mv_rundata_1549670400 rundata_206 (cost=0.28..0.67 rows=22 width=72) (never executed)

  • Index Cond: (endtime = t_330.endtime)
751. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..1,623,875.75 rows=32,102,732 width=752) (never executed)

752. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1549756800 t_331 (cost=0.00..62,772.15 rows=1,487,615 width=744) (never executed)

753. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_rundata_1549756800_endtime on bml_mv_rundata_1549756800 rundata_207 (cost=0.28..0.67 rows=22 width=72) (never executed)

  • Index Cond: (endtime = t_331.endtime)
754. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..1,836,288.99 rows=36,367,148 width=752) (never executed)

755. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1549843200 t_332 (cost=0.00..73,431.94 rows=1,732,594 width=744) (never executed)

756. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_rundata_1549843200_endtime on bml_mv_rundata_1549843200 rundata_208 (cost=0.28..0.65 rows=21 width=72) (never executed)

  • Index Cond: (endtime = t_332.endtime)
757. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..1,889,102.14 rows=37,615,640 width=752) (never executed)

758. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1549929600 t_333 (cost=0.00..75,576.22 rows=1,780,622 width=744) (never executed)

759. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_rundata_1549929600_endtime on bml_mv_rundata_1549929600 rundata_209 (cost=0.28..0.65 rows=21 width=72) (never executed)

  • Index Cond: (endtime = t_333.endtime)
760. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..1,874,392.03 rows=37,593,589 width=752) (never executed)

761. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1550016000 t_334 (cost=0.00..74,859.43 rows=1,764,543 width=744) (never executed)

762. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_rundata_1550016000_endtime on bml_mv_rundata_1550016000 rundata_210 (cost=0.28..0.65 rows=21 width=72) (never executed)

  • Index Cond: (endtime = t_334.endtime)
763. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..1,580,392.88 rows=30,559,221 width=752) (never executed)

764. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1550102400 t_335 (cost=0.00..67,836.22 rows=1,599,122 width=744) (never executed)

765. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_rundata_1550102400_endtime on bml_mv_rundata_1550102400 rundata_211 (cost=0.28..0.61 rows=19 width=72) (never executed)

  • Index Cond: (endtime = t_335.endtime)
766. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.28..1,744,321.12 rows=34,577,064 width=752) (never executed)

767. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_routing_esme_1550188800 t_336 (cost=0.00..72,223.46 rows=1,702,046 width=744) (never executed)

768. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_rundata_1550188800_endtime on bml_mv_rundata_1550188800 rundata_212 (cost=0.28..0.63 rows=20 width=72) (never executed)

  • Index Cond: (endtime = t_336.endtime)
769. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..846,045.32 rows=22,683,214 width=752) (never executed)

770. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1550275200 rundata_213 (cost=0.00..77.56 rows=3,456 width=72) (never executed)

771. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1550275200_endtime on bml_mv_routing_esme_1550275200 t_337 (cost=0.43..129.93 rows=6,563 width=744) (never executed)

  • Index Cond: (endtime = rundata_213.endtime)
772. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..781,955.39 rows=20,966,014 width=752) (never executed)

773. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1550361600 rundata_214 (cost=0.00..77.56 rows=3,456 width=72) (never executed)

774. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1550361600_endtime on bml_mv_routing_esme_1550361600 t_338 (cost=0.43..120.07 rows=6,067 width=744) (never executed)

  • Index Cond: (endtime = rundata_214.endtime)
775. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..930,294.74 rows=24,938,122 width=752) (never executed)

776. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1550448000 rundata_215 (cost=0.00..77.54 rows=3,454 width=72) (never executed)

777. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1550448000_endtime on bml_mv_routing_esme_1550448000 t_339 (cost=0.43..142.97 rows=7,220 width=744) (never executed)

  • Index Cond: (endtime = rundata_215.endtime)
778. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..967,628.06 rows=25,937,987 width=752) (never executed)

779. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1550534400 rundata_216 (cost=0.00..77.44 rows=3,444 width=72) (never executed)

780. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1550534400_endtime on bml_mv_routing_esme_1550534400 t_340 (cost=0.43..149.14 rows=7,531 width=744) (never executed)

  • Index Cond: (endtime = rundata_216.endtime)
781. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..995,943.28 rows=26,704,587 width=752) (never executed)

782. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1550620800 rundata_217 (cost=0.00..77.50 rows=3,450 width=72) (never executed)

783. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1550620800_endtime on bml_mv_routing_esme_1550620800 t_341 (cost=0.43..153.20 rows=7,740 width=744) (never executed)

  • Index Cond: (endtime = rundata_217.endtime)
784. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..994,819.51 rows=26,670,296 width=752) (never executed)

785. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1550707200 rundata_218 (cost=0.00..77.41 rows=3,441 width=72) (never executed)

786. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1550707200_endtime on bml_mv_routing_esme_1550707200 t_342 (cost=0.43..153.44 rows=7,751 width=744) (never executed)

  • Index Cond: (endtime = rundata_218.endtime)
787. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..948,709.10 rows=25,428,532 width=752) (never executed)

788. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1550793600 rundata_219 (cost=0.00..77.42 rows=3,442 width=72) (never executed)

789. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1550793600_endtime on bml_mv_routing_esme_1550793600 t_343 (cost=0.43..146.32 rows=7,388 width=744) (never executed)

  • Index Cond: (endtime = rundata_219.endtime)
790. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..871,778.69 rows=23,374,449 width=752) (never executed)

791. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1550880000 rundata_220 (cost=0.00..77.56 rows=3,456 width=72) (never executed)

792. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1550880000_endtime on bml_mv_routing_esme_1550880000 t_344 (cost=0.43..133.87 rows=6,763 width=744) (never executed)

  • Index Cond: (endtime = rundata_220.endtime)
793. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..829,528.26 rows=22,242,522 width=752) (never executed)

794. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1550966400 rundata_221 (cost=0.00..77.56 rows=3,456 width=72) (never executed)

795. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1550966400_endtime on bml_mv_routing_esme_1550966400 t_345 (cost=0.43..127.37 rows=6,436 width=744) (never executed)

  • Index Cond: (endtime = rundata_221.endtime)
796. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..953,647.73 rows=25,560,541 width=752) (never executed)

797. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1551052800 rundata_222 (cost=0.00..77.44 rows=3,444 width=72) (never executed)

798. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1551052800_endtime on bml_mv_routing_esme_1551052800 t_346 (cost=0.43..147.00 rows=7,422 width=744) (never executed)

  • Index Cond: (endtime = rundata_222.endtime)
799. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..907,554.32 rows=24,300,073 width=752) (never executed)

800. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1551139200 rundata_223 (cost=0.00..75.94 rows=3,394 width=72) (never executed)

801. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1551139200_endtime on bml_mv_routing_esme_1551139200 t_347 (cost=0.43..142.08 rows=7,160 width=744) (never executed)

  • Index Cond: (endtime = rundata_223.endtime)
802. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..954,610.44 rows=25,583,818 width=752) (never executed)

803. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1551225600 rundata_224 (cost=0.00..77.41 rows=3,441 width=72) (never executed)

804. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1551225600_endtime on bml_mv_routing_esme_1551225600 t_348 (cost=0.43..147.29 rows=7,435 width=744) (never executed)

  • Index Cond: (endtime = rundata_224.endtime)
805. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..970,850.29 rows=26,022,465 width=752) (never executed)

806. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1551312000 rundata_225 (cost=0.00..77.40 rows=3,440 width=72) (never executed)

807. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1551312000_endtime on bml_mv_routing_esme_1551312000 t_349 (cost=0.43..149.82 rows=7,565 width=744) (never executed)

  • Index Cond: (endtime = rundata_225.endtime)
808. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..917,524.75 rows=24,595,233 width=752) (never executed)

809. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1551398400 rundata_226 (cost=0.00..77.45 rows=3,445 width=72) (never executed)

810. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1551398400_endtime on bml_mv_routing_esme_1551398400 t_350 (cost=0.43..141.38 rows=7,139 width=744) (never executed)

  • Index Cond: (endtime = rundata_226.endtime)
811. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..831,387.65 rows=22,296,108 width=752) (never executed)

812. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1551484800 rundata_227 (cost=0.00..77.56 rows=3,456 width=72) (never executed)

813. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1551484800_endtime on bml_mv_routing_esme_1551484800 t_351 (cost=0.43..127.65 rows=6,451 width=744) (never executed)

  • Index Cond: (endtime = rundata_227.endtime)
814. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..770,251.97 rows=20,657,946 width=752) (never executed)

815. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1551571200 rundata_228 (cost=0.00..77.56 rows=3,456 width=72) (never executed)

816. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1551571200_endtime on bml_mv_routing_esme_1551571200 t_352 (cost=0.43..118.25 rows=5,977 width=744) (never executed)

  • Index Cond: (endtime = rundata_228.endtime)
817. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..988,508.41 rows=26,511,618 width=752) (never executed)

818. 0.000 0.000 ↓ 0.0 0

Seq Scan on bml_mv_rundata_1551657600 rundata_229 (cost=0.00..77.47 rows=3,447 width=72) (never executed)

819. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_mv_routing_esme_1551657600_endtime on bml_mv_routing_esme_1551657600 t_353 (cost=0.43..152.16 rows=7,691 width=744) (never executed)

  • Index Cond: (endtime = rundata_229.endtime)