explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Zp5V

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 5,220.182 5,220.182 ↑ 1.0 1,076 1

CTE Scan on r r (cost=457,351.2..457,372.98 rows=1,089 width=264) (actual time=5,067.929..5,220.182 rows=1,076 loops=1)

  • Buffers: shared hit=221823 read=43201
2.          

CTE lc

3. 1,321.117 5,138.190 ↑ 1.0 1,076 1

HashAggregate (cost=367,424.28..381,769.46 rows=1,089 width=16) (actual time=5,067.19..5,138.19 rows=1,076 loops=1)

  • Group Key: p.vehicle_id
  • Buffers: shared hit=146422 read=43201
4. 657.299 3,747.133 ↑ 1.0 8,918,901 1

Append (cost=0.29..345,101.99 rows=8,928,919 width=8) (actual time=0.022..3,747.133 rows=8,918,901 loops=1)

  • Buffers: shared hit=78705 read=43201
5. 299.313 299.313 ↑ 1.0 733,095 1

Seq Scan on bsmts_values_201911 p (cost=0..29,300.82 rows=735,115 width=8) (actual time=0.021..299.313 rows=733,095 loops=1)

  • Filter: (p.data_time > (now() - '3 mons'::interval))
  • Buffers: shared hit=12703
6. 813.677 813.677 ↑ 1.0 2,252,591 1

Seq Scan on bsmts_values_201912 p_1 (cost=0..69,458.28 rows=2,252,771 width=8) (actual time=0.016..813.677 rows=2,252,591 loops=1)

  • Filter: (p_1.data_time > (now() - '3 mons'::interval))
  • Buffers: shared hit=30034
7. 1,684.951 1,684.951 ↑ 1.0 5,016,931 1

Seq Scan on bsmts_values_202001 p_2 (cost=0..154,693.42 rows=5,017,581 width=8) (actual time=0.016..1,684.951 rows=5,016,931 loops=1)

  • Filter: (p_2.data_time > (now() - '3 mons'::interval))
  • Buffers: shared hit=23683 read=43201
8. 291.882 291.882 ↑ 1.0 916,284 1

Seq Scan on bsmts_values_202002 p_3 (cost=0..28,439.29 rows=923,084 width=8) (actual time=0.016..291.882 rows=916,284 loops=1)

  • Filter: (p_3.data_time > (now() - '3 mons'::interval))
  • Buffers: shared hit=12285
9. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on bsmts_values_202003 p_4 (cost=0..19.1 rows=173 width=8) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (p_4.data_time > (now() - '3 mons'::interval))
10. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on bsmts_values_p_def p_5 (cost=0..19.1 rows=173 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (p_5.data_time > (now() - '3 mons'::interval))
11.          

SubPlan (for HashAggregate)

12. 3.228 69.940 ↑ 1.0 1 1,076

Limit (cost=9.3..13.16 rows=1 width=16) (actual time=0.063..0.065 rows=1 loops=1,076)

  • Buffers: shared hit=67717
13. 12.912 66.712 ↑ 12,069.0 1 1,076

Merge Append (cost=9.3..46,636.49 rows=12,069 width=16) (actual time=0.062..0.062 rows=1 loops=1,076)

  • Buffers: shared hit=67717
14. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201801_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201801 v (cost=0.29..8.31 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: ((v.vehicle_id = p.vehicle_id) AND (v.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=2152
15. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201802_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201802 v_1 (cost=0.29..8.31 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: ((v_1.vehicle_id = p.vehicle_id) AND (v_1.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=2152
16. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201803_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201803 v_2 (cost=0.29..8.31 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: ((v_2.vehicle_id = p.vehicle_id) AND (v_2.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=2152
17. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201805_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201805 v_3 (cost=0.29..8.31 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: ((v_3.vehicle_id = p.vehicle_id) AND (v_3.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=2152
18. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201806_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201806 v_4 (cost=0.29..8.31 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: ((v_4.vehicle_id = p.vehicle_id) AND (v_4.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=2152
19. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201807_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201807 v_5 (cost=0.29..8.31 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: ((v_5.vehicle_id = p.vehicle_id) AND (v_5.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=2152
20. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201808_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201808 v_6 (cost=0.29..8.31 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: ((v_6.vehicle_id = p.vehicle_id) AND (v_6.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=2152
21. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201809_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201809 v_7 (cost=0.29..8.31 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: ((v_7.vehicle_id = p.vehicle_id) AND (v_7.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=2152
22. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201810_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201810 v_8 (cost=0.29..8.31 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: ((v_8.vehicle_id = p.vehicle_id) AND (v_8.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=2152
23. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201811_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201811 v_9 (cost=0.29..8.31 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: ((v_9.vehicle_id = p.vehicle_id) AND (v_9.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=2152
24. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201812_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201812 v_10 (cost=0.29..8.31 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: ((v_10.vehicle_id = p.vehicle_id) AND (v_10.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=2152
25. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201901_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201901 v_11 (cost=0.29..8.31 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: ((v_11.vehicle_id = p.vehicle_id) AND (v_11.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=2152
26. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201902_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201902 v_12 (cost=0.29..8.31 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: ((v_12.vehicle_id = p.vehicle_id) AND (v_12.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=2152
27. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201903_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201903 v_13 (cost=0.29..8.31 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: ((v_13.vehicle_id = p.vehicle_id) AND (v_13.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=2152
28. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201904_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201904 v_14 (cost=0.29..8.31 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: ((v_14.vehicle_id = p.vehicle_id) AND (v_14.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=2152
29. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201905_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201905 v_15 (cost=0.29..8.31 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: ((v_15.vehicle_id = p.vehicle_id) AND (v_15.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=2152
30. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201906_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201906 v_16 (cost=0.29..8.31 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: ((v_16.vehicle_id = p.vehicle_id) AND (v_16.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=2152
31. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201907_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201907 v_17 (cost=0.29..8.31 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: ((v_17.vehicle_id = p.vehicle_id) AND (v_17.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=2152
32. 2.152 2.152 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201908_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201908 v_18 (cost=0.42..8.44 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1,076)

  • Index Cond: ((v_18.vehicle_id = p.vehicle_id) AND (v_18.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=3228
33. 2.152 2.152 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201909_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201909 v_19 (cost=0.42..8.44 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1,076)

  • Index Cond: ((v_19.vehicle_id = p.vehicle_id) AND (v_19.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=3228
34. 2.152 2.152 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201910_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201910 v_20 (cost=0.43..8.45 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1,076)

  • Index Cond: ((v_20.vehicle_id = p.vehicle_id) AND (v_20.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=3228
35. 3.228 3.228 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201911_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201911 v_21 (cost=0.43..12,582.25 rows=3,517 width=16) (actual time=0.003..0.003 rows=0 loops=1,076)

  • Index Cond: ((v_21.vehicle_id = p.vehicle_id) AND (v_21.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=3454
36. 8.608 8.608 ↑ 2,311.0 1 1,076

Index Scan using bsmts_values_p_201912_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_201912 v_22 (cost=0.43..9,083.28 rows=2,311 width=16) (actual time=0.008..0.008 rows=1 loops=1,076)

  • Index Cond: ((v_22.vehicle_id = p.vehicle_id) AND (v_22.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=4235
37. 8.608 8.608 ↑ 5,216.0 1 1,076

Index Scan using bsmts_values_p_202001_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_202001 v_23 (cost=0.56..20,504.73 rows=5,216 width=16) (actual time=0.008..0.008 rows=1 loops=1,076)

  • Index Cond: ((v_23.vehicle_id = p.vehicle_id) AND (v_23.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=5304
38. 7.532 7.532 ↑ 1,002.0 1 1,076

Index Scan using bsmts_values_p_202002_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_202002 v_24 (cost=0.43..3,927.04 rows=1,002 width=16) (actual time=0.007..0.007 rows=1 loops=1,076)

  • Index Cond: ((v_24.vehicle_id = p.vehicle_id) AND (v_24.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=4152
39. 0.000 0.000 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_202003_vehicle_id_data_time_lat_lng_course_s_idx on bsmts_values_202003 v_25 (cost=0.15..8.17 rows=1 width=16) (actual time=0..0 rows=0 loops=1,076)

  • Index Cond: ((v_25.vehicle_id = p.vehicle_id) AND (v_25.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=1076
40. 0.000 0.000 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_def_vehicle_id_data_time_lat_lng_course_spee_idx on bsmts_values_p_def v_26 (cost=0.15..8.17 rows=1 width=16) (actual time=0..0 rows=0 loops=1,076)

  • Index Cond: ((v_26.vehicle_id = p.vehicle_id) AND (v_26.data_time > (now() - '3 mons'::interval)))
  • Buffers: shared hit=1076
41.          

CTE r

42. 39.104 5,219.005 ↑ 1.0 1,076 1

Nested Loop (cost=0.56..75,581.74 rows=1,089 width=193) (actual time=5,067.927..5,219.005 rows=1,076 loops=1)

  • Buffers: shared hit=221823 read=43201
43. 1.583 5,177.749 ↑ 1.0 1,076 1

Nested Loop (cost=0.29..74,435.58 rows=1,089 width=42) (actual time=5,067.369..5,177.749 rows=1,076 loops=1)

  • Buffers: shared hit=208848 read=43201
44. 5,138.506 5,138.506 ↑ 1.0 1,076 1

CTE Scan on lc lc (cost=0..21.78 rows=1,089 width=8) (actual time=5,067.192..5,138.506 rows=1,076 loops=1)

  • Buffers: shared hit=146422 read=43201
45. 7.532 37.660 ↑ 31.0 1 1,076

Append (cost=0.29..68.02 rows=31 width=50) (actual time=0.033..0.035 rows=1 loops=1,076)

  • Buffers: shared hit=62426
46. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201801_pkey on bsmts_values_201801 bv (cost=0.29..1.11 rows=1 width=56) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv.id = lc.l_id)
  • Buffers: shared hit=2152
47. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201802_pkey on bsmts_values_201802 bv_1 (cost=0.29..1.48 rows=1 width=55) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_1.id = lc.l_id)
  • Buffers: shared hit=2152
48. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201803_pkey on bsmts_values_201803 bv_2 (cost=0.29..1.07 rows=1 width=53) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_2.id = lc.l_id)
  • Buffers: shared hit=2152
49. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201805_pkey on bsmts_values_201805 bv_3 (cost=0.28..0.7 rows=1 width=54) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_3.id = lc.l_id)
  • Buffers: shared hit=2152
50. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201806_pkey on bsmts_values_201806 bv_4 (cost=0.28..0.69 rows=1 width=54) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_4.id = lc.l_id)
  • Buffers: shared hit=2152
51. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201807_pkey on bsmts_values_201807 bv_5 (cost=0.29..1.09 rows=1 width=55) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_5.id = lc.l_id)
  • Buffers: shared hit=2152
52. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201808_pkey on bsmts_values_201808 bv_6 (cost=0.29..1.48 rows=1 width=55) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_6.id = lc.l_id)
  • Buffers: shared hit=2152
53. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201809_pkey on bsmts_values_201809 bv_7 (cost=0.29..1.33 rows=1 width=54) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_7.id = lc.l_id)
  • Buffers: shared hit=2152
54. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201810_pkey on bsmts_values_201810 bv_8 (cost=0.29..1.1 rows=1 width=55) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_8.id = lc.l_id)
  • Buffers: shared hit=2152
55. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201811_pkey on bsmts_values_201811 bv_9 (cost=0.29..0.95 rows=1 width=52) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_9.id = lc.l_id)
  • Buffers: shared hit=2152
56. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201812_pkey on bsmts_values_201812 bv_10 (cost=0.29..1.47 rows=1 width=53) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_10.id = lc.l_id)
  • Buffers: shared hit=2152
57. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201901_pkey on bsmts_values_201901 bv_11 (cost=0.29..1.1 rows=1 width=54) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_11.id = lc.l_id)
  • Buffers: shared hit=2152
58. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201902_pkey on bsmts_values_201902 bv_12 (cost=0.29..1.08 rows=1 width=52) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_12.id = lc.l_id)
  • Buffers: shared hit=2152
59. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201903_pkey on bsmts_values_201903 bv_13 (cost=0.29..1.88 rows=1 width=52) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_13.id = lc.l_id)
  • Buffers: shared hit=2152
60. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201904_pkey on bsmts_values_201904 bv_14 (cost=0.29..1.51 rows=1 width=54) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_14.id = lc.l_id)
  • Buffers: shared hit=2152
61. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201905_pkey on bsmts_values_201905 bv_15 (cost=0.29..1.1 rows=1 width=52) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_15.id = lc.l_id)
  • Buffers: shared hit=2152
62. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201906_pkey on bsmts_values_201906 bv_16 (cost=0.28..0.7 rows=1 width=53) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_16.id = lc.l_id)
  • Buffers: shared hit=2152
63. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201907_pkey on bsmts_values_201907 bv_17 (cost=0.28..0.85 rows=1 width=52) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_17.id = lc.l_id)
  • Buffers: shared hit=2152
64. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201908_pkey on bsmts_values_201908 bv_18 (cost=0.29..3.53 rows=1 width=52) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_18.id = lc.l_id)
  • Buffers: shared hit=2152
65. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201909_pkey on bsmts_values_201909 bv_19 (cost=0.29..3.69 rows=1 width=53) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_19.id = lc.l_id)
  • Buffers: shared hit=2152
66. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201910_pkey on bsmts_values_201910 bv_20 (cost=0.42..7.01 rows=1 width=50) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_20.id = lc.l_id)
  • Buffers: shared hit=3229
67. 1.076 1.076 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201911_pkey on bsmts_values_201911 bv_21 (cost=0.42..7.88 rows=1 width=50) (actual time=0.001..0.001 rows=0 loops=1,076)

  • Index Cond: (bv_21.id = lc.l_id)
  • Buffers: shared hit=3251
68. 2.152 2.152 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_201912_pkey on bsmts_values_201912 bv_22 (cost=0.43..8.25 rows=1 width=49) (actual time=0.002..0.002 rows=0 loops=1,076)

  • Index Cond: (bv_22.id = lc.l_id)
  • Buffers: shared hit=3274
69. 2.152 2.152 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_202001_pkey on bsmts_values_202001 bv_23 (cost=0.43..8.36 rows=1 width=50) (actual time=0.002..0.002 rows=0 loops=1,076)

  • Index Cond: (bv_23.id = lc.l_id)
  • Buffers: shared hit=3313
70. 2.152 2.152 ↑ 1.0 1 1,076

Index Scan using bsmts_values_p_202002_pkey on bsmts_values_202002 bv_24 (cost=0.42..7.97 rows=1 width=48) (actual time=0.002..0.002 rows=1 loops=1,076)

  • Index Cond: (bv_24.id = lc.l_id)
  • Buffers: shared hit=4167
71. 0.000 0.000 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_202003_pkey on bsmts_values_202003 bv_25 (cost=0.15..0.24 rows=3 width=104) (actual time=0..0 rows=0 loops=1,076)

  • Index Cond: (bv_25.id = lc.l_id)
  • Buffers: shared hit=1076
72. 0.000 0.000 ↓ 0.0 0 1,076

Index Scan using bsmts_values_p_def_pkey on bsmts_values_p_def bv_26 (cost=0.15..0.24 rows=3 width=104) (actual time=0..0 rows=0 loops=1,076)

  • Index Cond: (bv_26.id = lc.l_id)
  • Buffers: shared hit=1076
73. 2.152 2.152 ↑ 1.0 1 1,076

Index Scan using depot_vehicle_pkey on vehicle vl (cost=0.28..0.3 rows=1 width=55) (actual time=0.002..0.002 rows=1 loops=1,076)

  • Index Cond: (vl.id = bv.vehicle_id)
  • Buffers: shared hit=3231
Planning time : 4.58 ms
Execution time : 5,220.865 ms