explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dYr1

Settings
# exclusive inclusive rows x rows loops node
1. 0.556 490.631 ↑ 6,987,267.3 124 1

Nested Loop (cost=12,102.18..29,630,766.77 rows=866,421,150 width=5,346) (actual time=61.941..490.631 rows=124 loops=1)

2. 0.074 473.707 ↑ 2,740.1 124 1

Hash Join (cost=12,101.54..3,638,131.64 rows=339,773 width=173) (actual time=61.645..473.707 rows=124 loops=1)

  • Hash Cond: (a.id_activity_group = g.id)
3. 0.106 473.546 ↑ 2,740.1 124 1

Hash Join (cost=12,089.55..3,637,215.58 rows=339,773 width=180) (actual time=61.553..473.546 rows=124 loops=1)

  • Hash Cond: (a.id_activity = f.id)
4. 0.171 467.977 ↑ 2,740.1 124 1

Hash Join (cost=11,334.11..3,635,568.03 rows=339,773 width=161) (actual time=56.061..467.977 rows=124 loops=1)

  • Hash Cond: (a.id_vehicle_operator = e.id)
5. 0.086 432.916 ↑ 2,740.1 124 1

Hash Join (cost=6,095.77..3,629,437.76 rows=339,773 width=138) (actual time=21.069..432.916 rows=124 loops=1)

  • Hash Cond: (a.id_workfront = d.id)
6. 0.163 432.664 ↑ 2,740.1 124 1

Nested Loop (cost=6,071.05..3,628,513.88 rows=339,773 width=131) (actual time=20.895..432.664 rows=124 loops=1)

7. 0.019 0.019 ↑ 1.0 1 1

Seq Scan on company c (cost=0.00..8.18 rows=1 width=36) (actual time=0.010..0.019 rows=1 loops=1)

  • Filter: (id = 25)
  • Rows Removed by Filter: 93
8. 0.077 432.482 ↑ 2,740.1 124 1

Hash Join (cost=6,071.05..3,625,107.97 rows=339,773 width=111) (actual time=20.766..432.482 rows=124 loops=1)

  • Hash Cond: (b.id_vehicle_type = b1.id_vehicle_type)
9. 0.474 432.289 ↑ 2,633.9 129 1

Hash Join (cost=6,055.06..3,620,420.10 rows=339,773 width=111) (actual time=20.645..432.289 rows=129 loops=1)

  • Hash Cond: (a.id_vehicle = b.id)
10. 0.266 429.996 ↑ 3,804.5 2,779 1

Append (cost=4,705.42..3,591,306.47 rows=10,572,658 width=73) (actual time=5.486..429.996 rows=2,779 loops=1)

11. 0.040 5.515 ↑ 3,489.6 32 1

Bitmap Heap Scan on fact_monitoring_structure_summary_00_2020 a (cost=4,705.42..36,749.44 rows=111,668 width=73) (actual time=5.484..5.515 rows=32 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=23
12. 0.002 5.475 ↓ 0.0 0 1

BitmapOr (cost=4,705.42..4,705.42 rows=111,668 width=0) (actual time=5.475..5.475 rows=0 loops=1)

13. 5.468 5.468 ↑ 3,489.6 32 1

Bitmap Index Scan on fact_monitoring_structure_sum_end_time_start_time_id_vehic_idx5 (cost=0.00..4,645.15 rows=111,668 width=0) (actual time=5.468..5.468 rows=32 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
14. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_sum_end_time_start_time_id_vehic_idx5 (cost=0.00..4.44 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
15. 0.042 0.042 ↑ 1.0 23 1

Seq Scan on fact_monitoring_structure_summary_00_null a_1 (cost=0.00..25.82 rows=23 width=212) (actual time=0.009..0.042 rows=23 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 32
16. 0.042 13.217 ↑ 7,629.3 39 1

Bitmap Heap Scan on fact_monitoring_structure_summary_01_2020 a_2 (cost=12,758.41..102,826.53 rows=297,541 width=72) (actual time=13.183..13.217 rows=39 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=28
17. 0.001 13.175 ↓ 0.0 0 1

BitmapOr (cost=12,758.41..12,758.41 rows=297,541 width=0) (actual time=13.175..13.175 rows=0 loops=1)

18. 13.168 13.168 ↑ 7,629.3 39 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx11 (cost=0.00..12,605.20 rows=297,541 width=0) (actual time=13.168..13.168 rows=39 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
19. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx11 (cost=0.00..4.44 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
20. 0.081 0.081 ↑ 2.4 28 1

Seq Scan on fact_monitoring_structure_summary_01_null a_3 (cost=0.00..64.43 rows=67 width=212) (actual time=0.016..0.081 rows=28 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 40
21. 0.070 9.084 ↑ 6,309.0 34 1

Bitmap Heap Scan on fact_monitoring_structure_summary_02_2020 a_4 (cost=9,199.19..74,993.77 rows=214,505 width=73) (actual time=9.024..9.084 rows=34 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=23
22. 0.001 9.014 ↓ 0.0 0 1

BitmapOr (cost=9,199.19..9,199.19 rows=214,505 width=0) (actual time=9.014..9.014 rows=0 loops=1)

23. 9.008 9.008 ↑ 6,309.0 34 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx17 (cost=0.00..9,087.50 rows=214,505 width=0) (actual time=9.008..9.008 rows=34 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
24. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx17 (cost=0.00..4.44 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
25. 0.101 0.101 ↑ 4.5 21 1

Seq Scan on fact_monitoring_structure_summary_02_null a_5 (cost=0.00..61.77 rows=94 width=212) (actual time=0.012..0.101 rows=21 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 35
26. 0.049 8.777 ↑ 6,163.1 38 1

Bitmap Heap Scan on fact_monitoring_structure_summary_03_2020 a_6 (cost=9,886.84..86,597.79 rows=234,197 width=72) (actual time=8.735..8.777 rows=38 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=28
27. 0.001 8.728 ↓ 0.0 0 1

BitmapOr (cost=9,886.84..9,886.84 rows=234,197 width=0) (actual time=8.728..8.728 rows=0 loops=1)

28. 8.723 8.723 ↑ 6,163.1 38 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx23 (cost=0.00..9,765.30 rows=234,197 width=0) (actual time=8.723..8.723 rows=38 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
29. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx23 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
30. 0.040 0.040 ↑ 1.0 24 1

Seq Scan on fact_monitoring_structure_summary_03_null a_7 (cost=0.00..16.95 rows=25 width=212) (actual time=0.009..0.040 rows=24 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 39
31. 0.030 8.628 ↑ 8,463.3 27 1

Bitmap Heap Scan on fact_monitoring_structure_summary_04_2020 a_8 (cost=9,652.34..77,172.96 rows=228,508 width=72) (actual time=8.604..8.628 rows=27 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=18
32. 0.002 8.598 ↓ 0.0 0 1

BitmapOr (cost=9,652.34..9,652.34 rows=228,508 width=0) (actual time=8.598..8.598 rows=0 loops=1)

33. 8.592 8.592 ↑ 8,463.3 27 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx29 (cost=0.00..9,533.65 rows=228,508 width=0) (actual time=8.592..8.592 rows=27 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
34. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx29 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
35. 0.055 0.055 ↑ 1.0 26 1

Seq Scan on fact_monitoring_structure_summary_04_null a_9 (cost=0.00..47.77 rows=26 width=212) (actual time=0.010..0.055 rows=26 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 25
36. 0.043 9.124 ↑ 5,873.1 38 1

Bitmap Heap Scan on fact_monitoring_structure_summary_05_2020 a_10 (cost=9,470.99..80,573.63 rows=223,176 width=74) (actual time=9.088..9.124 rows=38 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=31
37. 0.001 9.081 ↓ 0.0 0 1

BitmapOr (cost=9,470.99..9,470.99 rows=223,176 width=0) (actual time=9.081..9.081 rows=0 loops=1)

38. 9.076 9.076 ↑ 5,873.1 38 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx35 (cost=0.00..9,354.96 rows=223,176 width=0) (actual time=9.076..9.076 rows=38 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
39. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx35 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
40. 0.036 0.036 ↑ 1.0 21 1

Seq Scan on fact_monitoring_structure_summary_05_null a_11 (cost=0.00..16.91 rows=22 width=212) (actual time=0.008..0.036 rows=21 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 40
41. 0.039 13.126 ↑ 8,881.4 35 1

Bitmap Heap Scan on fact_monitoring_structure_summary_06_2020 a_12 (cost=13,530.00..98,835.72 rows=310,848 width=72) (actual time=13.095..13.126 rows=35 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=25
42. 0.000 13.087 ↓ 0.0 0 1

BitmapOr (cost=13,530.00..13,530.00 rows=310,848 width=0) (actual time=13.087..13.087 rows=0 loops=1)

43. 13.083 13.083 ↑ 8,881.4 35 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx41 (cost=0.00..13,370.14 rows=310,848 width=0) (actual time=13.083..13.083 rows=35 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
44. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx41 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
45. 0.135 0.135 ↑ 7.8 18 1

Seq Scan on fact_monitoring_structure_summary_06_null a_13 (cost=0.00..158.21 rows=141 width=212) (actual time=0.010..0.135 rows=18 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 34
46. 0.034 6.414 ↑ 5,523.4 28 1

Bitmap Heap Scan on fact_monitoring_structure_summary_07_2020 a_14 (cost=6,812.55..53,848.39 rows=154,656 width=73) (actual time=6.388..6.414 rows=28 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=19
47. 0.001 6.380 ↓ 0.0 0 1

BitmapOr (cost=6,812.55..6,812.55 rows=154,656 width=0) (actual time=6.380..6.380 rows=0 loops=1)

48. 6.375 6.375 ↑ 5,523.4 28 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx47 (cost=0.00..6,730.79 rows=154,656 width=0) (actual time=6.375..6.375 rows=28 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
49. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx47 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
50. 0.049 0.049 ↑ 1.0 17 1

Seq Scan on fact_monitoring_structure_summary_07_null a_15 (cost=0.00..32.69 rows=17 width=212) (actual time=0.010..0.049 rows=17 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 29
51. 0.044 11.229 ↑ 7,453.9 38 1

Bitmap Heap Scan on fact_monitoring_structure_summary_08_2020 a_16 (cost=12,128.58..97,072.32 rows=283,250 width=72) (actual time=11.193..11.229 rows=38 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=31
52. 0.002 11.185 ↓ 0.0 0 1

BitmapOr (cost=12,128.58..12,128.58 rows=283,250 width=0) (actual time=11.185..11.185 rows=0 loops=1)

53. 11.179 11.179 ↑ 7,453.9 38 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx53 (cost=0.00..11,982.51 rows=283,250 width=0) (actual time=11.179..11.179 rows=38 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
54. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx53 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
55. 0.059 0.059 ↑ 4.1 18 1

Seq Scan on fact_monitoring_structure_summary_08_null a_17 (cost=0.00..43.48 rows=74 width=212) (actual time=0.012..0.059 rows=18 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 40
56. 0.046 9.389 ↑ 5,587.1 41 1

Bitmap Heap Scan on fact_monitoring_structure_summary_09_2020 a_18 (cost=9,886.97..79,058.01 rows=229,070 width=73) (actual time=9.351..9.389 rows=41 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=26
57. 0.001 9.343 ↓ 0.0 0 1

BitmapOr (cost=9,886.97..9,886.97 rows=229,070 width=0) (actual time=9.343..9.343 rows=0 loops=1)

58. 9.339 9.339 ↑ 5,587.1 41 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx59 (cost=0.00..9,767.99 rows=229,070 width=0) (actual time=9.339..9.339 rows=41 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
59. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx59 (cost=0.00..4.44 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
60. 0.052 0.052 ↑ 1.0 23 1

Seq Scan on fact_monitoring_structure_summary_09_null a_19 (cost=0.00..25.96 rows=23 width=212) (actual time=0.008..0.052 rows=23 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 41
61. 0.032 5.537 ↑ 4,910.7 27 1

Bitmap Heap Scan on fact_monitoring_structure_summary_10_2020 a_20 (cost=5,705.89..43,034.74 rows=132,590 width=96) (actual time=5.512..5.537 rows=27 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=19
62. 0.001 5.505 ↓ 0.0 0 1

BitmapOr (cost=5,705.89..5,705.89 rows=132,590 width=0) (actual time=5.505..5.505 rows=0 loops=1)

63. 5.500 5.500 ↑ 4,910.7 27 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx65 (cost=0.00..5,635.16 rows=132,590 width=0) (actual time=5.500..5.500 rows=27 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
64. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx65 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
65. 0.047 0.047 ↑ 1.0 20 1

Seq Scan on fact_monitoring_structure_summary_10_null a_21 (cost=0.00..35.73 rows=20 width=212) (actual time=0.008..0.047 rows=20 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 29
66. 0.037 5.939 ↑ 4,365.0 37 1

Bitmap Heap Scan on fact_monitoring_structure_summary_11_2020 a_22 (cost=6,743.89..51,899.46 rows=161,505 width=72) (actual time=5.908..5.939 rows=37 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=24
67. 0.001 5.902 ↓ 0.0 0 1

BitmapOr (cost=6,743.89..6,743.89 rows=161,505 width=0) (actual time=5.902..5.902 rows=0 loops=1)

68. 5.897 5.897 ↑ 4,365.0 37 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx71 (cost=0.00..6,658.70 rows=161,505 width=0) (actual time=5.897..5.897 rows=37 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
69. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx71 (cost=0.00..4.44 rows=1 width=0) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
70. 0.033 0.033 ↑ 1.0 18 1

Seq Scan on fact_monitoring_structure_summary_11_null a_23 (cost=0.00..14.84 rows=18 width=212) (actual time=0.008..0.033 rows=18 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 38
71. 0.044 10.195 ↑ 7,114.0 34 1

Bitmap Heap Scan on fact_monitoring_structure_summary_12_2020 a_24 (cost=10,085.66..85,445.80 rows=241,876 width=73) (actual time=10.158..10.195 rows=34 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=28
72. 0.001 10.151 ↓ 0.0 0 1

BitmapOr (cost=10,085.66..10,085.66 rows=241,876 width=0) (actual time=10.151..10.151 rows=0 loops=1)

73. 10.147 10.147 ↑ 7,114.0 34 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx77 (cost=0.00..9,960.28 rows=241,876 width=0) (actual time=10.147..10.147 rows=34 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
74. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx77 (cost=0.00..4.44 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
75. 0.074 0.074 ↑ 6.2 29 1

Seq Scan on fact_monitoring_structure_summary_12_null a_25 (cost=0.00..77.91 rows=179 width=212) (actual time=0.009..0.074 rows=29 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 35
76. 0.034 7.678 ↑ 6,247.3 32 1

Bitmap Heap Scan on fact_monitoring_structure_summary_13_2020 a_26 (cost=8,642.19..72,815.91 rows=199,915 width=72) (actual time=7.650..7.678 rows=32 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=21
77. 0.000 7.644 ↓ 0.0 0 1

BitmapOr (cost=8,642.19..8,642.19 rows=199,915 width=0) (actual time=7.644..7.644 rows=0 loops=1)

78. 7.639 7.639 ↑ 6,247.3 32 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx83 (cost=0.00..8,537.79 rows=199,915 width=0) (actual time=7.638..7.639 rows=32 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
79. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx83 (cost=0.00..4.44 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
80. 0.100 0.100 ↑ 3.9 18 1

Seq Scan on fact_monitoring_structure_summary_13_null a_27 (cost=0.00..110.17 rows=71 width=212) (actual time=0.009..0.100 rows=18 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 34
81. 0.064 14.548 ↑ 6,659.1 53 1

Bitmap Heap Scan on fact_monitoring_structure_summary_14_2020 a_28 (cost=14,948.13..119,336.11 rows=352,932 width=73) (actual time=14.493..14.548 rows=53 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=38
82. 0.001 14.484 ↓ 0.0 0 1

BitmapOr (cost=14,948.13..14,948.13 rows=352,932 width=0) (actual time=14.484..14.484 rows=0 loops=1)

83. 14.479 14.479 ↑ 6,659.1 53 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx89 (cost=0.00..14,767.22 rows=352,932 width=0) (actual time=14.479..14.479 rows=53 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
84. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx89 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
85. 0.100 0.100 ↑ 4.5 22 1

Seq Scan on fact_monitoring_structure_summary_14_null a_29 (cost=0.00..97.08 rows=99 width=212) (actual time=0.009..0.100 rows=22 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 54
86. 0.034 9.567 ↑ 7,971.7 30 1

Bitmap Heap Scan on fact_monitoring_structure_summary_15_2020 a_30 (cost=10,402.68..77,425.94 rows=239,151 width=73) (actual time=9.540..9.567 rows=30 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=19
87. 0.002 9.533 ↓ 0.0 0 1

BitmapOr (cost=10,402.68..10,402.68 rows=239,151 width=0) (actual time=9.533..9.533 rows=0 loops=1)

88. 9.528 9.528 ↑ 7,971.7 30 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx95 (cost=0.00..10,278.66 rows=239,151 width=0) (actual time=9.528..9.528 rows=30 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
89. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx95 (cost=0.00..4.44 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
90. 0.059 0.059 ↑ 1.0 19 1

Seq Scan on fact_monitoring_structure_summary_15_null a_31 (cost=0.00..34.75 rows=19 width=212) (actual time=0.008..0.059 rows=19 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 31
91. 0.042 9.577 ↑ 6,545.6 36 1

Bitmap Heap Scan on fact_monitoring_structure_summary_16_2020 a_32 (cost=10,063.25..79,145.87 rows=235,641 width=72) (actual time=9.544..9.577 rows=36 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=24
92. 0.011 9.535 ↓ 0.0 0 1

BitmapOr (cost=10,063.25..10,063.25 rows=235,641 width=0) (actual time=9.535..9.535 rows=0 loops=1)

93. 9.518 9.518 ↑ 6,545.6 36 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx101 (cost=0.00..9,940.99 rows=235,641 width=0) (actual time=9.518..9.518 rows=36 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
94. 0.006 0.006 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx101 (cost=0.00..4.44 rows=1 width=0) (actual time=0.006..0.006 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
95. 0.050 0.050 ↑ 1.0 28 1

Seq Scan on fact_monitoring_structure_summary_16_null a_33 (cost=0.00..33.96 rows=28 width=212) (actual time=0.009..0.050 rows=28 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 36
96. 0.031 9.331 ↑ 8,578.1 29 1

Bitmap Heap Scan on fact_monitoring_structure_summary_17_2020 a_34 (cost=10,446.86..86,125.34 rows=248,765 width=73) (actual time=9.306..9.331 rows=29 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=20
97. 0.001 9.300 ↓ 0.0 0 1

BitmapOr (cost=10,446.86..10,446.86 rows=248,765 width=0) (actual time=9.300..9.300 rows=0 loops=1)

98. 9.295 9.295 ↑ 8,578.1 29 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx107 (cost=0.00..10,318.04 rows=248,765 width=0) (actual time=9.295..9.295 rows=29 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
99. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx107 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
100. 0.049 0.049 ↑ 1.0 33 1

Seq Scan on fact_monitoring_structure_summary_17_null a_35 (cost=0.00..16.93 rows=33 width=212) (actual time=0.010..0.049 rows=33 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 29
101. 0.037 6.237 ↑ 4,840.8 32 1

Bitmap Heap Scan on fact_monitoring_structure_summary_18_2020 a_36 (cost=6,585.21..53,723.80 rows=154,906 width=72) (actual time=6.207..6.237 rows=32 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=20
102. 0.001 6.200 ↓ 0.0 0 1

BitmapOr (cost=6,585.21..6,585.21 rows=154,906 width=0) (actual time=6.200..6.200 rows=0 loops=1)

103. 6.196 6.196 ↑ 4,840.8 32 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx113 (cost=0.00..6,503.32 rows=154,906 width=0) (actual time=6.196..6.196 rows=32 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
104. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx113 (cost=0.00..4.44 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
105. 0.053 0.053 ↑ 1.0 18 1

Seq Scan on fact_monitoring_structure_summary_18_null a_37 (cost=0.00..34.75 rows=18 width=212) (actual time=0.016..0.053 rows=18 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 32
106. 0.033 4.470 ↑ 3,700.4 30 1

Bitmap Heap Scan on fact_monitoring_structure_summary_19_2020 a_38 (cost=4,684.34..39,939.51 rows=111,011 width=73) (actual time=4.443..4.470 rows=30 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=19
107. 0.001 4.437 ↓ 0.0 0 1

BitmapOr (cost=4,684.34..4,684.34 rows=111,011 width=0) (actual time=4.437..4.437 rows=0 loops=1)

108. 4.432 4.432 ↑ 3,700.4 30 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx119 (cost=0.00..4,624.40 rows=111,011 width=0) (actual time=4.432..4.432 rows=30 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
109. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx119 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
110. 0.104 0.104 ↑ 2.5 26 1

Seq Scan on fact_monitoring_structure_summary_19_null a_39 (cost=0.00..132.09 rows=65 width=212) (actual time=0.007..0.104 rows=26 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 29
111. 0.056 9.351 ↑ 5,251.0 42 1

Bitmap Heap Scan on fact_monitoring_structure_summary_20_2020 a_40 (cost=9,333.01..73,177.11 rows=220,540 width=72) (actual time=9.303..9.351 rows=42 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=35
112. 0.001 9.295 ↓ 0.0 0 1

BitmapOr (cost=9,333.01..9,333.01 rows=220,540 width=0) (actual time=9.295..9.295 rows=0 loops=1)

113. 9.290 9.290 ↑ 5,251.0 42 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx125 (cost=0.00..9,218.30 rows=220,540 width=0) (actual time=9.290..9.290 rows=42 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
114. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx125 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
115. 0.099 0.099 ↑ 5.2 18 1

Seq Scan on fact_monitoring_structure_summary_20_null a_41 (cost=0.00..124.65 rows=93 width=212) (actual time=0.009..0.099 rows=18 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 43
116. 0.037 11.049 ↑ 8,244.0 34 1

Bitmap Heap Scan on fact_monitoring_structure_summary_21_2020 a_42 (cost=11,993.30..93,661.72 rows=280,295 width=72) (actual time=11.020..11.049 rows=34 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=22
117. 0.000 11.012 ↓ 0.0 0 1

BitmapOr (cost=11,993.30..11,993.30 rows=280,295 width=0) (actual time=11.012..11.012 rows=0 loops=1)

118. 11.008 11.008 ↑ 8,244.0 34 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx131 (cost=0.00..11,848.71 rows=280,295 width=0) (actual time=11.008..11.008 rows=34 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
119. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx131 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
120. 0.068 0.068 ↑ 5.3 20 1

Seq Scan on fact_monitoring_structure_summary_21_null a_43 (cost=0.00..69.28 rows=107 width=212) (actual time=0.011..0.068 rows=20 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 34
121. 0.043 8.724 ↑ 5,532.6 40 1

Bitmap Heap Scan on fact_monitoring_structure_summary_22_2020 a_44 (cost=9,554.28..73,930.81 rows=221,302 width=73) (actual time=8.688..8.724 rows=40 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=26
122. 0.001 8.681 ↓ 0.0 0 1

BitmapOr (cost=9,554.28..9,554.28 rows=221,302 width=0) (actual time=8.681..8.681 rows=0 loops=1)

123. 8.676 8.676 ↑ 5,532.6 40 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx137 (cost=0.00..9,439.19 rows=221,302 width=0) (actual time=8.676..8.676 rows=40 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
124. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx137 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
125. 0.076 0.076 ↑ 2.5 20 1

Seq Scan on fact_monitoring_structure_summary_22_null a_45 (cost=0.00..53.15 rows=49 width=212) (actual time=0.007..0.076 rows=20 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 42
126. 0.054 7.991 ↑ 4,439.0 42 1

Bitmap Heap Scan on fact_monitoring_structure_summary_23_2020 a_46 (cost=8,003.25..58,460.81 rows=186,437 width=74) (actual time=7.945..7.991 rows=42 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=32
127. 0.001 7.937 ↓ 0.0 0 1

BitmapOr (cost=8,003.25..8,003.25 rows=186,437 width=0) (actual time=7.937..7.937 rows=0 loops=1)

128. 7.931 7.931 ↑ 4,143.0 45 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx143 (cost=0.00..7,905.60 rows=186,437 width=0) (actual time=7.931..7.931 rows=45 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
129. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx143 (cost=0.00..4.44 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
130. 0.113 0.113 ↑ 7.9 14 1

Seq Scan on fact_monitoring_structure_summary_23_null a_47 (cost=0.00..128.56 rows=111 width=212) (actual time=0.008..0.113 rows=14 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 42
131. 0.045 10.864 ↑ 7,411.6 36 1

Bitmap Heap Scan on fact_monitoring_structure_summary_24_2020 a_48 (cost=11,445.93..88,740.21 rows=266,819 width=73) (actual time=10.826..10.864 rows=36 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=28
132. 0.001 10.819 ↓ 0.0 0 1

BitmapOr (cost=11,445.93..11,445.93 rows=266,819 width=0) (actual time=10.819..10.819 rows=0 loops=1)

133. 10.814 10.814 ↑ 7,411.6 36 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx149 (cost=0.00..11,308.08 rows=266,819 width=0) (actual time=10.814..10.814 rows=36 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
134. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx149 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
135. 0.048 0.048 ↑ 1.1 20 1

Seq Scan on fact_monitoring_structure_summary_24_null a_49 (cost=0.00..24.86 rows=21 width=212) (actual time=0.011..0.048 rows=20 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 37
136. 0.046 10.414 ↑ 5,887.9 41 1

Bitmap Heap Scan on fact_monitoring_structure_summary_25_2020 a_50 (cost=10,546.77..73,472.85 rows=241,405 width=72) (actual time=10.375..10.414 rows=41 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=34
137. 0.001 10.368 ↓ 0.0 0 1

BitmapOr (cost=10,546.77..10,546.77 rows=241,405 width=0) (actual time=10.368..10.368 rows=0 loops=1)

138. 10.363 10.363 ↑ 5,887.9 41 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx155 (cost=0.00..10,421.63 rows=241,405 width=0) (actual time=10.363..10.363 rows=41 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
139. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx155 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
140. 0.049 0.049 ↑ 1.0 18 1

Seq Scan on fact_monitoring_structure_summary_25_null a_51 (cost=0.00..28.90 rows=18 width=212) (actual time=0.009..0.049 rows=18 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 42
141. 0.035 6.954 ↑ 6,097.4 28 1

Bitmap Heap Scan on fact_monitoring_structure_summary_26_2020 a_52 (cost=7,419.97..46,196.86 rows=170,726 width=72) (actual time=6.927..6.954 rows=28 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=20
142. 0.002 6.919 ↓ 0.0 0 1

BitmapOr (cost=7,419.97..7,419.97 rows=170,726 width=0) (actual time=6.919..6.919 rows=0 loops=1)

143. 6.913 6.913 ↑ 6,097.4 28 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx161 (cost=0.00..7,330.17 rows=170,726 width=0) (actual time=6.913..6.913 rows=28 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
144. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx161 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
145. 0.073 0.073 ↑ 5.7 32 1

Seq Scan on fact_monitoring_structure_summary_26_null a_53 (cost=0.00..82.30 rows=181 width=212) (actual time=0.007..0.073 rows=32 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 30
146. 0.047 8.156 ↑ 6,011.4 35 1

Bitmap Heap Scan on fact_monitoring_structure_summary_27_2020 a_54 (cost=8,993.25..73,503.25 rows=210,400 width=73) (actual time=8.117..8.156 rows=35 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=28
147. 0.000 8.109 ↓ 0.0 0 1

BitmapOr (cost=8,993.25..8,993.25 rows=210,400 width=0) (actual time=8.109..8.109 rows=0 loops=1)

148. 8.105 8.105 ↑ 6,011.4 35 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx167 (cost=0.00..8,883.61 rows=210,400 width=0) (actual time=8.105..8.105 rows=35 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
149. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx167 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
150. 0.053 0.053 ↑ 1.0 30 1

Seq Scan on fact_monitoring_structure_summary_27_null a_55 (cost=0.00..40.98 rows=30 width=212) (actual time=0.008..0.053 rows=30 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 35
151. 0.045 8.396 ↑ 5,881.2 35 1

Bitmap Heap Scan on fact_monitoring_structure_summary_28_2020 a_56 (cost=9,051.43..65,526.06 rows=205,842 width=72) (actual time=8.359..8.396 rows=35 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=28
152. 0.001 8.351 ↓ 0.0 0 1

BitmapOr (cost=9,051.43..9,051.43 rows=205,842 width=0) (actual time=8.351..8.351 rows=0 loops=1)

153. 8.345 8.345 ↑ 5,416.9 38 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx173 (cost=0.00..8,944.07 rows=205,842 width=0) (actual time=8.345..8.345 rows=38 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
154. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx173 (cost=0.00..4.44 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
155. 0.066 0.066 ↓ 1.0 26 1

Seq Scan on fact_monitoring_structure_summary_28_null a_57 (cost=0.00..34.91 rows=25 width=212) (actual time=0.008..0.066 rows=26 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 35
156. 0.041 10.641 ↑ 7,198.9 35 1

Bitmap Heap Scan on fact_monitoring_structure_summary_29_2020 a_58 (cost=11,102.25..75,123.65 rows=251,960 width=72) (actual time=10.609..10.641 rows=35 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=26
157. 0.000 10.600 ↓ 0.0 0 1

BitmapOr (cost=11,102.25..11,102.25 rows=251,960 width=0) (actual time=10.600..10.600 rows=0 loops=1)

158. 10.596 10.596 ↑ 7,198.9 35 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx179 (cost=0.00..10,971.83 rows=251,960 width=0) (actual time=10.596..10.596 rows=35 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
159. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx179 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
160. 0.065 0.065 ↑ 3.9 17 1

Seq Scan on fact_monitoring_structure_summary_29_null a_59 (cost=0.00..62.87 rows=67 width=212) (actual time=0.008..0.065 rows=17 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 38
161. 0.049 9.120 ↑ 6,354.2 37 1

Bitmap Heap Scan on fact_monitoring_structure_summary_30_2020 a_60 (cost=10,107.68..77,162.26 rows=235,105 width=72) (actual time=9.079..9.120 rows=37 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=29
162. 0.002 9.071 ↓ 0.0 0 1

BitmapOr (cost=10,107.68..10,107.68 rows=235,105 width=0) (actual time=9.071..9.071 rows=0 loops=1)

163. 9.065 9.065 ↑ 6,354.2 37 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx185 (cost=0.00..9,985.69 rows=235,105 width=0) (actual time=9.065..9.065 rows=37 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
164. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx185 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
165. 0.078 0.078 ↑ 6.1 23 1

Seq Scan on fact_monitoring_structure_summary_30_null a_61 (cost=0.00..66.34 rows=141 width=212) (actual time=0.009..0.078 rows=23 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 37
166. 0.044 8.877 ↑ 6,537.2 35 1

Bitmap Heap Scan on fact_monitoring_structure_summary_31_2020 a_62 (cost=9,798.40..72,365.42 rows=228,801 width=72) (actual time=8.840..8.877 rows=35 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=27
167. 0.001 8.833 ↓ 0.0 0 1

BitmapOr (cost=9,798.40..9,798.40 rows=228,801 width=0) (actual time=8.833..8.833 rows=0 loops=1)

168. 8.828 8.828 ↑ 6,537.2 35 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx191 (cost=0.00..9,679.56 rows=228,801 width=0) (actual time=8.828..8.828 rows=35 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
169. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx191 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
170. 0.050 0.050 ↑ 1.0 23 1

Seq Scan on fact_monitoring_structure_summary_31_null a_63 (cost=0.00..27.89 rows=23 width=212) (actual time=0.007..0.050 rows=23 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 36
171. 0.041 8.567 ↑ 6,646.4 33 1

Bitmap Heap Scan on fact_monitoring_structure_summary_32_2020 a_64 (cost=9,436.67..69,129.65 rows=219,332 width=73) (actual time=8.533..8.567 rows=33 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=24
172. 0.001 8.526 ↓ 0.0 0 1

BitmapOr (cost=9,436.67..9,436.67 rows=219,332 width=0) (actual time=8.526..8.526 rows=0 loops=1)

173. 8.521 8.521 ↑ 6,646.4 33 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx197 (cost=0.00..9,322.56 rows=219,332 width=0) (actual time=8.521..8.521 rows=33 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
174. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx197 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
175. 0.035 0.035 ↑ 1.0 21 1

Seq Scan on fact_monitoring_structure_summary_32_null a_65 (cost=0.00..20.81 rows=21 width=212) (actual time=0.008..0.035 rows=21 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 33
176. 0.032 10.403 ↑ 8,601.2 28 1

Bitmap Heap Scan on fact_monitoring_structure_summary_33_2020 a_66 (cost=10,475.79..74,500.30 rows=240,834 width=73) (actual time=10.379..10.403 rows=28 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=15
177. 0.001 10.371 ↓ 0.0 0 1

BitmapOr (cost=10,475.79..10,475.79 rows=240,834 width=0) (actual time=10.371..10.371 rows=0 loops=1)

178. 10.366 10.366 ↑ 8,601.2 28 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx203 (cost=0.00..10,350.93 rows=240,834 width=0) (actual time=10.365..10.366 rows=28 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
179. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx203 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
180. 0.044 0.044 ↑ 1.0 24 1

Seq Scan on fact_monitoring_structure_summary_33_null a_67 (cost=0.00..22.78 rows=24 width=212) (actual time=0.007..0.044 rows=24 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 28
181. 0.033 6.442 ↑ 4,732.3 33 1

Bitmap Heap Scan on fact_monitoring_structure_summary_34_2020 a_68 (cost=6,641.93..56,229.40 rows=156,165 width=73) (actual time=6.415..6.442 rows=33 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=20
182. 0.001 6.409 ↓ 0.0 0 1

BitmapOr (cost=6,641.93..6,641.93 rows=156,165 width=0) (actual time=6.408..6.409 rows=0 loops=1)

183. 6.405 6.405 ↑ 4,732.3 33 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx209 (cost=0.00..6,559.41 rows=156,165 width=0) (actual time=6.404..6.405 rows=33 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
184. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx209 (cost=0.00..4.44 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
185. 0.064 0.064 ↑ 4.4 23 1

Seq Scan on fact_monitoring_structure_summary_34_null a_69 (cost=0.00..60.72 rows=102 width=212) (actual time=0.009..0.064 rows=23 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 35
186. 0.036 7.564 ↑ 5,353.3 36 1

Bitmap Heap Scan on fact_monitoring_structure_summary_35_2020 a_70 (cost=8,266.33..68,150.13 rows=192,720 width=72) (actual time=7.534..7.564 rows=36 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=21
187. 0.001 7.528 ↓ 0.0 0 1

BitmapOr (cost=8,266.33..8,266.33 rows=192,720 width=0) (actual time=7.528..7.528 rows=0 loops=1)

188. 7.523 7.523 ↑ 5,353.3 36 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx215 (cost=0.00..8,165.53 rows=192,720 width=0) (actual time=7.523..7.523 rows=36 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
189. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx215 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
190. 0.045 0.045 ↑ 1.0 22 1

Seq Scan on fact_monitoring_structure_summary_35_null a_71 (cost=0.00..19.87 rows=22 width=212) (actual time=0.012..0.045 rows=22 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 36
191. 0.036 10.322 ↑ 9,161.3 29 1

Bitmap Heap Scan on fact_monitoring_structure_summary_36_2020 a_72 (cost=11,304.98..91,674.15 rows=265,678 width=72) (actual time=10.293..10.322 rows=29 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=23
192. 0.001 10.286 ↓ 0.0 0 1

BitmapOr (cost=11,304.98..11,304.98 rows=265,678 width=0) (actual time=10.286..10.286 rows=0 loops=1)

193. 10.282 10.282 ↑ 9,161.3 29 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx221 (cost=0.00..11,167.70 rows=265,678 width=0) (actual time=10.282..10.282 rows=29 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
194. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx221 (cost=0.00..4.44 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
195. 0.063 0.063 ↑ 4.6 17 1

Seq Scan on fact_monitoring_structure_summary_36_null a_73 (cost=0.00..59.15 rows=78 width=212) (actual time=0.009..0.063 rows=17 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 29
196. 0.054 5.480 ↑ 4,391.9 32 1

Bitmap Heap Scan on fact_monitoring_structure_summary_37_2020 a_74 (cost=5,869.73..48,956.86 rows=140,542 width=73) (actual time=5.433..5.480 rows=32 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=26
197. 0.001 5.426 ↓ 0.0 0 1

BitmapOr (cost=5,869.73..5,869.73 rows=140,542 width=0) (actual time=5.426..5.426 rows=0 loops=1)

198. 5.420 5.420 ↑ 4,391.9 32 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx227 (cost=0.00..5,795.02 rows=140,542 width=0) (actual time=5.420..5.420 rows=32 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
199. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx227 (cost=0.00..4.44 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
200. 0.037 0.037 ↑ 1.1 20 1

Seq Scan on fact_monitoring_structure_summary_37_null a_75 (cost=0.00..21.81 rows=21 width=212) (actual time=0.009..0.037 rows=20 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 34
201. 0.024 4.934 ↑ 6,484.0 20 1

Bitmap Heap Scan on fact_monitoring_structure_summary_38_2020 a_76 (cost=5,362.91..58,449.11 rows=129,680 width=73) (actual time=4.916..4.934 rows=20 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=16
202. 0.001 4.910 ↓ 0.0 0 1

BitmapOr (cost=5,362.91..5,362.91 rows=129,680 width=0) (actual time=4.910..4.910 rows=0 loops=1)

203. 4.906 4.906 ↑ 6,484.0 20 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx233 (cost=0.00..5,293.64 rows=129,680 width=0) (actual time=4.906..4.906 rows=20 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
204. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx233 (cost=0.00..4.44 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
205. 0.024 0.024 ↑ 1.0 20 1

Seq Scan on fact_monitoring_structure_summary_38_null a_77 (cost=0.00..9.62 rows=20 width=212) (actual time=0.007..0.024 rows=20 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 21
206. 0.041 3.417 ↑ 3,033.7 30 1

Bitmap Heap Scan on fact_monitoring_structure_summary_39_2020 a_78 (cost=3,618.79..48,131.97 rows=91,012 width=74) (actual time=3.382..3.417 rows=30 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=23
207. 0.000 3.376 ↓ 0.0 0 1

BitmapOr (cost=3,618.79..3,618.79 rows=91,012 width=0) (actual time=3.376..3.376 rows=0 loops=1)

208. 3.372 3.372 ↑ 3,033.7 30 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx239 (cost=0.00..3,568.85 rows=91,012 width=0) (actual time=3.371..3.372 rows=30 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
209. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx239 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
210. 0.046 0.046 ↑ 1.0 31 1

Seq Scan on fact_monitoring_structure_summary_39_null a_79 (cost=0.00..29.93 rows=31 width=212) (actual time=0.008..0.046 rows=31 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 31
211. 0.032 12.739 ↑ 13,170.1 24 1

Bitmap Heap Scan on fact_monitoring_structure_summary_40_2020 a_80 (cost=13,601.21..94,994.44 rows=316,082 width=73) (actual time=12.714..12.739 rows=24 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=18
212. 0.001 12.707 ↓ 0.0 0 1

BitmapOr (cost=13,601.21..13,601.21 rows=316,082 width=0) (actual time=12.707..12.707 rows=0 loops=1)

213. 12.701 12.701 ↑ 13,170.1 24 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx245 (cost=0.00..13,438.73 rows=316,082 width=0) (actual time=12.701..12.701 rows=24 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
214. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx245 (cost=0.00..4.44 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
215. 0.097 0.097 ↑ 10.9 21 1

Seq Scan on fact_monitoring_structure_summary_40_null a_81 (cost=0.00..121.42 rows=228 width=212) (actual time=0.011..0.097 rows=21 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 24
216. 0.044 9.099 ↑ 6,617.1 34 1

Bitmap Heap Scan on fact_monitoring_structure_summary_41_2020 a_82 (cost=9,596.08..72,371.80 rows=224,981 width=96) (actual time=9.063..9.099 rows=34 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=25
217. 0.000 9.055 ↓ 0.0 0 1

BitmapOr (cost=9,596.08..9,596.08 rows=224,981 width=0) (actual time=9.055..9.055 rows=0 loops=1)

218. 9.050 9.050 ↑ 6,617.1 34 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx251 (cost=0.00..9,479.15 rows=224,981 width=0) (actual time=9.050..9.050 rows=34 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
219. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx251 (cost=0.00..4.44 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
220. 0.056 0.056 ↑ 1.1 19 1

Seq Scan on fact_monitoring_structure_summary_41_null a_83 (cost=0.00..21.82 rows=20 width=212) (actual time=0.014..0.056 rows=19 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 36
221. 0.038 8.310 ↑ 6,725.0 31 1

Bitmap Heap Scan on fact_monitoring_structure_summary_42_2020 a_84 (cost=8,809.67..72,302.81 rows=208,476 width=72) (actual time=8.279..8.310 rows=31 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=21
222. 0.002 8.272 ↓ 0.0 0 1

BitmapOr (cost=8,809.67..8,809.67 rows=208,476 width=0) (actual time=8.272..8.272 rows=0 loops=1)

223. 8.266 8.266 ↑ 6,725.0 31 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx257 (cost=0.00..8,700.99 rows=208,476 width=0) (actual time=8.266..8.266 rows=31 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
224. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx257 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
225. 0.056 0.056 ↑ 2.9 19 1

Seq Scan on fact_monitoring_structure_summary_42_null a_85 (cost=0.00..43.15 rows=55 width=212) (actual time=0.009..0.056 rows=19 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 34
226. 0.041 4.059 ↑ 2,715.3 39 1

Bitmap Heap Scan on fact_monitoring_structure_summary_43_2020 a_86 (cost=4,458.35..39,294.79 rows=105,896 width=73) (actual time=4.025..4.059 rows=39 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=28
227. 0.001 4.018 ↓ 0.0 0 1

BitmapOr (cost=4,458.35..4,458.35 rows=105,896 width=0) (actual time=4.018..4.018 rows=0 loops=1)

228. 4.013 4.013 ↑ 2,715.3 39 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx263 (cost=0.00..4,400.97 rows=105,896 width=0) (actual time=4.013..4.013 rows=39 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
229. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx263 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
230. 0.043 0.043 ↑ 1.0 26 1

Seq Scan on fact_monitoring_structure_summary_43_null a_87 (cost=0.00..22.99 rows=26 width=212) (actual time=0.009..0.043 rows=26 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 40
231. 0.029 4.981 ↑ 4,881.0 27 1

Bitmap Heap Scan on fact_monitoring_structure_summary_44_2020 a_88 (cost=5,715.70..41,944.49 rows=131,786 width=72) (actual time=4.958..4.981 rows=27 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=18
232. 0.000 4.952 ↓ 0.0 0 1

BitmapOr (cost=5,715.70..5,715.70 rows=131,786 width=0) (actual time=4.952..4.952 rows=0 loops=1)

233. 4.948 4.948 ↑ 4,881.0 27 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx269 (cost=0.00..5,645.37 rows=131,786 width=0) (actual time=4.947..4.948 rows=27 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
234. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx269 (cost=0.00..4.44 rows=1 width=0) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
235. 0.052 0.052 ↑ 5.6 14 1

Seq Scan on fact_monitoring_structure_summary_44_null a_89 (cost=0.00..51.48 rows=78 width=212) (actual time=0.009..0.052 rows=14 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 28
236. 0.046 7.210 ↑ 5,658.8 33 1

Bitmap Heap Scan on fact_monitoring_structure_summary_45_2020 a_90 (cost=7,889.99..62,808.12 rows=186,742 width=72) (actual time=7.171..7.210 rows=33 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=28
237. 0.001 7.164 ↓ 0.0 0 1

BitmapOr (cost=7,889.99..7,889.99 rows=186,742 width=0) (actual time=7.164..7.164 rows=0 loops=1)

238. 7.159 7.159 ↑ 5,658.8 33 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx275 (cost=0.00..7,792.18 rows=186,742 width=0) (actual time=7.159..7.159 rows=33 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
239. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx275 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
240. 0.046 0.046 ↑ 1.0 22 1

Seq Scan on fact_monitoring_structure_summary_45_null a_91 (cost=0.00..29.81 rows=22 width=212) (actual time=0.007..0.046 rows=22 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 32
241. 0.043 5.784 ↑ 4,056.9 37 1

Bitmap Heap Scan on fact_monitoring_structure_summary_46_2020 a_92 (cost=6,469.66..48,270.23 rows=150,105 width=72) (actual time=5.748..5.784 rows=37 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=25
242. 0.001 5.741 ↓ 0.0 0 1

BitmapOr (cost=6,469.66..6,469.66 rows=150,105 width=0) (actual time=5.741..5.741 rows=0 loops=1)

243. 5.736 5.736 ↑ 4,056.9 37 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx281 (cost=0.00..6,390.17 rows=150,105 width=0) (actual time=5.736..5.736 rows=37 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
244. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx281 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
245. 0.071 0.071 ↑ 3.7 18 1

Seq Scan on fact_monitoring_structure_summary_46_null a_93 (cost=0.00..80.06 rows=66 width=212) (actual time=0.008..0.071 rows=18 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 38
246. 0.039 7.214 ↑ 5,470.6 34 1

Bitmap Heap Scan on fact_monitoring_structure_summary_47_2020 a_94 (cost=8,021.54..62,475.55 rows=186,001 width=73) (actual time=7.182..7.214 rows=34 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=21
247. 0.000 7.175 ↓ 0.0 0 1

BitmapOr (cost=8,021.54..8,021.54 rows=186,001 width=0) (actual time=7.175..7.175 rows=0 loops=1)

248. 7.171 7.171 ↑ 5,470.6 34 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx287 (cost=0.00..7,924.10 rows=186,001 width=0) (actual time=7.171..7.171 rows=34 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
249. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx287 (cost=0.00..4.44 rows=1 width=0) (actual time=0.003..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
250. 0.041 0.041 ↑ 1.0 21 1

Seq Scan on fact_monitoring_structure_summary_47_null a_95 (cost=0.00..21.86 rows=22 width=212) (actual time=0.009..0.041 rows=21 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 36
251. 0.036 6.280 ↑ 7,822.9 21 1

Bitmap Heap Scan on fact_monitoring_structure_summary_48_2020 a_96 (cost=7,157.88..57,634.08 rows=164,280 width=73) (actual time=6.251..6.280 rows=21 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=14
252. 0.000 6.244 ↓ 0.0 0 1

BitmapOr (cost=7,157.88..7,157.88 rows=164,280 width=0) (actual time=6.244..6.244 rows=0 loops=1)

253. 6.240 6.240 ↑ 7,822.9 21 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx293 (cost=0.00..7,071.31 rows=164,280 width=0) (actual time=6.240..6.240 rows=21 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
254. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx293 (cost=0.00..4.44 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
255. 0.031 0.031 ↑ 1.0 26 1

Seq Scan on fact_monitoring_structure_summary_48_null a_97 (cost=0.00..21.70 rows=26 width=212) (actual time=0.006..0.031 rows=26 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 21
256. 0.035 15.739 ↑ 11,691.9 32 1

Bitmap Heap Scan on fact_monitoring_structure_summary_49_2020 a_98 (cost=16,687.61..100,650.73 rows=374,141 width=72) (actual time=15.711..15.739 rows=32 loops=1)

  • Recheck Cond: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)) OR ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone)))
  • Heap Blocks: exact=20
257. 0.002 15.704 ↓ 0.0 0 1

BitmapOr (cost=16,687.61..16,687.61 rows=374,141 width=0) (actual time=15.703..15.704 rows=0 loops=1)

258. 15.697 15.697 ↑ 11,691.9 32 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx299 (cost=0.00..16,496.10 rows=374,141 width=0) (actual time=15.697..15.697 rows=32 loops=1)

  • Index Cond: ((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
259. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx299 (cost=0.00..4.44 rows=1 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((end_time IS NULL) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
260. 0.059 0.059 ↑ 3.4 21 1

Seq Scan on fact_monitoring_structure_summary_49_null a_99 (cost=0.00..46.70 rows=72 width=212) (actual time=0.013..0.059 rows=21 loops=1)

  • Filter: (((end_time >= '2020-08-27 00:00:00+00'::timestamp with time zone) OR (end_time IS NULL)) AND (start_time <= '2020-08-27 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 32
261. 0.037 1.819 ↑ 2.1 168 1

Hash (cost=1,345.25..1,345.25 rows=351 width=54) (actual time=1.818..1.819 rows=168 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 24kB
262. 1.757 1.782 ↑ 2.1 168 1

Bitmap Heap Scan on vehicle b (cost=147.13..1,345.25 rows=351 width=54) (actual time=0.038..1.782 rows=168 loops=1)

  • Recheck Cond: (id_company = 25)
  • Heap Blocks: exact=121
263. 0.025 0.025 ↑ 2.1 168 1

Bitmap Index Scan on uk_vehicle (cost=0.00..147.04 rows=351 width=0) (actual time=0.025..0.025 rows=168 loops=1)

  • Index Cond: (id_company = 25)
264. 0.048 0.116 ↑ 1.0 444 1

Hash (cost=10.44..10.44 rows=444 width=16) (actual time=0.116..0.116 rows=444 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 29kB
265. 0.068 0.068 ↑ 1.0 444 1

Seq Scan on table_model_equipament_type b1 (cost=0.00..10.44 rows=444 width=16) (actual time=0.005..0.068 rows=444 loops=1)

266. 0.079 0.166 ↑ 1.0 521 1

Hash (cost=18.21..18.21 rows=521 width=23) (actual time=0.166..0.166 rows=521 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 39kB
267. 0.087 0.087 ↑ 1.0 521 1

Seq Scan on workfront d (cost=0.00..18.21 rows=521 width=23) (actual time=0.007..0.087 rows=521 loops=1)

268. 17.857 34.890 ↑ 1.0 101,215 1

Hash (cost=3,973.15..3,973.15 rows=101,215 width=39) (actual time=34.890..34.890 rows=101,215 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 8,390kB
269. 17.033 17.033 ↑ 1.0 101,215 1

Seq Scan on vehicle_operator e (cost=0.00..3,973.15 rows=101,215 width=39) (actual time=0.005..17.033 rows=101,215 loops=1)

270. 2.862 5.463 ↓ 1.0 18,376 1

Hash (cost=525.75..525.75 rows=18,375 width=35) (actual time=5.463..5.463 rows=18,376 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,528kB
271. 2.601 2.601 ↓ 1.0 18,376 1

Seq Scan on activity f (cost=0.00..525.75 rows=18,375 width=35) (actual time=0.004..2.601 rows=18,376 loops=1)

272. 0.035 0.087 ↑ 1.0 311 1

Hash (cost=8.11..8.11 rows=311 width=9) (actual time=0.086..0.087 rows=311 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 23kB
273. 0.052 0.052 ↑ 1.0 311 1

Seq Scan on activity_group g (cost=0.00..8.11 rows=311 width=9) (actual time=0.007..0.052 rows=311 loops=1)

274. 16.368 16.368 ↑ 2,550.0 1 124

Function Scan on get_structure_by_levels_table_less y (cost=0.64..26.14 rows=2,550 width=5,160) (actual time=0.132..0.132 rows=1 loops=124)

Planning time : 27.340 ms
Execution time : 491.752 ms