explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qTFb

Settings
# exclusive inclusive rows x rows loops node
1. 1.188 18,944.756 ↑ 6,977,046.8 124 1

Nested Loop (cost=12,297.65..29,953,118.14 rows=865,153,800 width=5,346) (actual time=134.980..18,944.756 rows=124 loops=1)

2. 0.281 18,913.312 ↑ 2,736.1 124 1

Hash Join (cost=12,297.01..3,998,503.50 rows=339,276 width=173) (actual time=131.990..18,913.312 rows=124 loops=1)

  • Hash Cond: (a.id_activity = f.id)
3. 0.239 18,903.451 ↑ 2,736.1 124 1

Hash Join (cost=11,541.58..3,996,857.26 rows=339,276 width=154) (actual time=122.357..18,903.451 rows=124 loops=1)

  • Hash Cond: (a.id_workfront = d.id)
4. 0.294 18,902.938 ↑ 2,736.1 124 1

Nested Loop (cost=11,516.85..3,995,934.70 rows=339,276 width=147) (actual time=122.069..18,902.938 rows=124 loops=1)

5. 0.025 0.025 ↑ 1.0 1 1

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

  • Filter: (id = 25)
  • Rows Removed by Filter: 93
6. 8.974 18,902.619 ↑ 2,736.1 124 1

Hash Join (cost=11,516.85..3,992,533.76 rows=339,276 width=127) (actual time=121.886..18,902.619 rows=124 loops=1)

  • Hash Cond: (a.id_vehicle_operator = e.id)
7. 0.199 18,830.349 ↑ 2,736.1 124 1

Hash Join (cost=5,487.52..3,974,218.79 rows=339,276 width=104) (actual time=58.513..18,830.349 rows=124 loops=1)

  • Hash Cond: (a.id_activity_group = g.id)
8. 0.248 18,829.992 ↑ 2,736.1 124 1

Hash Join (cost=5,475.52..3,973,304.06 rows=339,276 width=111) (actual time=58.343..18,829.992 rows=124 loops=1)

  • Hash Cond: (b.id_vehicle_type = b1.id_vehicle_type)
9. 0.953 18,829.554 ↑ 2,630.0 129 1

Hash Join (cost=5,459.53..3,968,623.02 rows=339,276 width=111) (actual time=58.147..18,829.554 rows=129 loops=1)

  • Hash Cond: (a.id_vehicle = b.id)
10. 0.434 18,828.041 ↑ 3,804.3 2,779 1

Append (cost=4,705.42..3,940,094.72 rows=10,572,083 width=73) (actual time=31.100..18,828.041 rows=2,779 loops=1)

11. 0.058 31.143 ↑ 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=31.098..31.143 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 31.085 ↓ 0.0 0 1

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

13. 31.076 31.076 ↑ 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=31.076..31.076 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.007 0.007 ↓ 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.007..0.007 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.060 0.060 ↑ 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.011..0.060 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.068 26.321 ↑ 7,629.1 39 1

Bitmap Heap Scan on fact_monitoring_structure_summary_01_2020 a_2 (cost=12,758.33..131,378.74 rows=297,534 width=72) (actual time=26.264..26.321 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.002 26.253 ↓ 0.0 0 1

BitmapOr (cost=12,758.33..12,758.33 rows=297,534 width=0) (actual time=26.253..26.253 rows=0 loops=1)

18. 26.238 26.238 ↑ 7,629.1 39 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx11 (cost=0.00..12,605.12 rows=297,534 width=0) (actual time=26.238..26.238 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.013 0.013 ↓ 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.013..0.013 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.5 28 1

Seq Scan on fact_monitoring_structure_summary_01_null a_3 (cost=0.00..64.58 rows=71 width=212) (actual time=0.009..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.049 55.769 ↑ 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=55.732..55.769 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 55.720 ↓ 0.0 0 1

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

23. 55.713 55.713 ↑ 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=55.713..55.713 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.006 0.006 ↓ 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.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))
25. 0.092 0.092 ↑ 3.6 21 1

Seq Scan on fact_monitoring_structure_summary_02_null a_5 (cost=0.00..61.05 rows=76 width=212) (actual time=0.008..0.092 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.056 27.110 ↑ 6,163.1 38 1

Bitmap Heap Scan on fact_monitoring_structure_summary_03_2020 a_6 (cost=9,886.84..108,752.31 rows=234,197 width=72) (actual time=27.066..27.110 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 27.054 ↓ 0.0 0 1

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

28. 27.047 27.047 ↑ 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=27.047..27.047 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.006 0.006 ↓ 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.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))
30. 0.045 0.045 ↑ 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.045 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.041 45.239 ↑ 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=45.208..45.239 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.001 45.198 ↓ 0.0 0 1

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

33. 45.192 45.192 ↑ 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=45.192..45.192 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.005 0.005 ↓ 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.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))
35. 0.082 0.082 ↑ 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.015..0.082 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.054 13.134 ↑ 5,873.0 38 1

Bitmap Heap Scan on fact_monitoring_structure_summary_05_2020 a_10 (cost=9,470.95..99,487.41 rows=223,173 width=74) (actual time=13.091..13.134 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 13.080 ↓ 0.0 0 1

BitmapOr (cost=9,470.95..9,470.95 rows=223,173 width=0) (actual time=13.080..13.080 rows=0 loops=1)

38. 13.072 13.072 ↑ 5,873.0 38 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx35 (cost=0.00..9,354.92 rows=223,173 width=0) (actual time=13.072..13.072 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.007 0.007 ↓ 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.006..0.007 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.049 0.049 ↑ 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.010..0.049 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.062 26.867 ↑ 8,881.4 35 1

Bitmap Heap Scan on fact_monitoring_structure_summary_06_2020 a_12 (cost=13,530.00..124,283.42 rows=310,848 width=72) (actual time=26.816..26.867 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.001 26.805 ↓ 0.0 0 1

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

43. 26.797 26.797 ↑ 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=26.797..26.797 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.007 0.007 ↓ 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.007..0.007 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.248 0.248 ↑ 2.6 18 1

Seq Scan on fact_monitoring_structure_summary_06_null a_13 (cost=0.00..154.06 rows=47 width=212) (actual time=0.016..0.248 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.070 13.787 ↑ 5,523.3 28 1

Bitmap Heap Scan on fact_monitoring_structure_summary_07_2020 a_14 (cost=6,812.51..53,847.31 rows=154,653 width=73) (actual time=13.744..13.787 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 13.717 ↓ 0.0 0 1

BitmapOr (cost=6,812.51..6,812.51 rows=154,653 width=0) (actual time=13.717..13.717 rows=0 loops=1)

48. 13.680 13.680 ↑ 5,523.3 28 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx47 (cost=0.00..6,730.75 rows=154,653 width=0) (actual time=13.680..13.680 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.036 0.036 ↓ 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.035..0.036 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.078 0.078 ↑ 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.011..0.078 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.058 46.197 ↑ 7,453.8 38 1

Bitmap Heap Scan on fact_monitoring_structure_summary_08_2020 a_16 (cost=12,128.53..122,666.73 rows=283,246 width=72) (actual time=46.150..46.197 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.001 46.139 ↓ 0.0 0 1

BitmapOr (cost=12,128.53..12,128.53 rows=283,246 width=0) (actual time=46.139..46.139 rows=0 loops=1)

53. 46.127 46.127 ↑ 7,453.8 38 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx53 (cost=0.00..11,982.47 rows=283,246 width=0) (actual time=46.127..46.127 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.011 0.011 ↓ 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.011..0.011 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.009..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.056 14.546 ↑ 5,586.9 41 1

Bitmap Heap Scan on fact_monitoring_structure_summary_09_2020 a_18 (cost=9,886.88..96,826.88 rows=229,063 width=73) (actual time=14.500..14.546 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 14.490 ↓ 0.0 0 1

BitmapOr (cost=9,886.88..9,886.88 rows=229,063 width=0) (actual time=14.490..14.490 rows=0 loops=1)

58. 14.478 14.478 ↑ 5,586.9 41 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx59 (cost=0.00..9,767.91 rows=229,063 width=0) (actual time=14.478..14.478 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.011 0.011 ↓ 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.011..0.011 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.046 0.046 ↑ 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.046 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.056 11.765 ↑ 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=11.721..11.765 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 11.709 ↓ 0.0 0 1

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

63. 11.702 11.702 ↑ 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=11.702..11.702 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.006 0.006 ↓ 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.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))
65. 0.085 0.085 ↑ 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.015..0.085 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. 10.026 23.832 ↑ 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=13.824..23.832 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.003 13.806 ↓ 0.0 0 1

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

68. 13.792 13.792 ↑ 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=13.792..13.792 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.011 0.011 ↓ 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.011..0.011 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.726 0.726 ↑ 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.014..0.726 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. 34.629 57.100 ↑ 7,114.0 34 1

Bitmap Heap Scan on fact_monitoring_structure_summary_12_2020 a_24 (cost=10,085.66..106,455.91 rows=241,876 width=73) (actual time=22.486..57.100 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.002 22.471 ↓ 0.0 0 1

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

73. 22.459 22.459 ↑ 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=22.459..22.459 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.010 0.010 ↓ 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.010..0.010 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.445 0.445 ↑ 4.3 29 1

Seq Scan on fact_monitoring_structure_summary_12_null a_25 (cost=0.00..76.16 rows=126 width=212) (actual time=0.011..0.445 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.660 18.918 ↑ 6,247.2 32 1

Bitmap Heap Scan on fact_monitoring_structure_summary_13_2020 a_26 (cost=8,642.11..72,813.75 rows=199,909 width=72) (actual time=18.276..18.918 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.001 18.258 ↓ 0.0 0 1

BitmapOr (cost=8,642.11..8,642.11 rows=199,909 width=0) (actual time=18.258..18.258 rows=0 loops=1)

78. 18.244 18.244 ↑ 6,247.2 32 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx83 (cost=0.00..8,537.72 rows=199,909 width=0) (actual time=18.244..18.244 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.013 0.013 ↓ 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.013..0.013 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. 9.911 9.911 ↑ 11.1 18 1

Seq Scan on fact_monitoring_structure_summary_13_null a_27 (cost=0.00..115.91 rows=199 width=212) (actual time=0.016..9.911 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.150 31.851 ↑ 6,659.0 53 1

Bitmap Heap Scan on fact_monitoring_structure_summary_14_2020 a_28 (cost=14,948.04..154,737.25 rows=352,925 width=73) (actual time=31.714..31.851 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 31.701 ↓ 0.0 0 1

BitmapOr (cost=14,948.04..14,948.04 rows=352,925 width=0) (actual time=31.701..31.701 rows=0 loops=1)

83. 31.693 31.693 ↑ 6,659.0 53 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehic_idx89 (cost=0.00..14,767.14 rows=352,925 width=0) (actual time=31.692..31.693 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.007 0.007 ↓ 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.007..0.007 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.534 0.534 ↑ 4.5 22 1

Seq Scan on fact_monitoring_structure_summary_14_null a_29 (cost=0.00..97.01 rows=98 width=212) (actual time=0.018..0.534 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.064 32.003 ↑ 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=31.952..32.003 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 31.939 ↓ 0.0 0 1

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

88. 31.932 31.932 ↑ 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=31.932..31.932 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.005 0.005 ↓ 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.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))
90. 0.273 0.273 ↑ 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.015..0.273 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.547 20.938 ↑ 6,545.4 36 1

Bitmap Heap Scan on fact_monitoring_structure_summary_16_2020 a_32 (cost=10,059.17..96,640.85 rows=235,634 width=72) (actual time=20.410..20.938 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.001 20.391 ↓ 0.0 0 1

BitmapOr (cost=10,059.17..10,059.17 rows=235,634 width=0) (actual time=20.391..20.391 rows=0 loops=1)

93. 20.378 20.378 ↑ 6,545.4 36 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx101 (cost=0.00..9,936.91 rows=235,634 width=0) (actual time=20.378..20.378 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.012 0.012 ↓ 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.012..0.012 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.813 0.813 ↑ 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.015..0.813 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. 19.078 38.824 ↑ 8,578.0 29 1

Bitmap Heap Scan on fact_monitoring_structure_summary_17_2020 a_34 (cost=10,446.83..107,100.46 rows=248,762 width=73) (actual time=19.767..38.824 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 19.746 ↓ 0.0 0 1

BitmapOr (cost=10,446.83..10,446.83 rows=248,762 width=0) (actual time=19.746..19.746 rows=0 loops=1)

98. 19.738 19.738 ↑ 8,578.0 29 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx107 (cost=0.00..10,318.01 rows=248,762 width=0) (actual time=19.738..19.738 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.007 0.007 ↓ 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.007..0.007 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.127 0.127 ↑ 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.015..0.127 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. 13.551 26.433 ↑ 4,840.7 32 1

Bitmap Heap Scan on fact_monitoring_structure_summary_18_2020 a_36 (cost=6,581.17..53,718.71 rows=154,903 width=72) (actual time=12.899..26.433 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 12.882 ↓ 0.0 0 1

BitmapOr (cost=6,581.17..6,581.17 rows=154,903 width=0) (actual time=12.882..12.882 rows=0 loops=1)

103. 12.868 12.868 ↑ 4,840.7 32 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx113 (cost=0.00..6,499.28 rows=154,903 width=0) (actual time=12.868..12.868 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.013 0.013 ↓ 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.013..0.013 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.217 0.217 ↑ 1.0 18 1

Seq Scan on fact_monitoring_structure_summary_18_null a_37 (cost=0.00..34.77 rows=18 width=212) (actual time=0.010..0.217 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: 33
106. 0.493 37.942 ↑ 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=37.468..37.942 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.002 37.449 ↓ 0.0 0 1

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

108. 37.435 37.435 ↑ 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=37.435..37.435 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.012 0.012 ↓ 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.012..0.012 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. 1.775 1.775 ↑ 1.8 26 1

Seq Scan on fact_monitoring_structure_summary_19_null a_39 (cost=0.00..131.47 rows=46 width=212) (actual time=0.015..1.775 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. 10.072 57.038 ↑ 5,250.9 42 1

Bitmap Heap Scan on fact_monitoring_structure_summary_20_2020 a_40 (cost=9,332.97..73,176.02 rows=220,537 width=72) (actual time=46.977..57.038 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.002 46.966 ↓ 0.0 0 1

BitmapOr (cost=9,332.97..9,332.97 rows=220,537 width=0) (actual time=46.966..46.966 rows=0 loops=1)

113. 46.958 46.958 ↑ 5,250.9 42 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx125 (cost=0.00..9,218.26 rows=220,537 width=0) (actual time=46.958..46.958 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.006 0.006 ↓ 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.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))
115. 0.555 0.555 ↑ 3.0 18 1

Seq Scan on fact_monitoring_structure_summary_20_null a_41 (cost=0.00..122.72 rows=54 width=212) (actual time=0.012..0.555 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. 1.135 23.884 ↑ 8,243.9 34 1

Bitmap Heap Scan on fact_monitoring_structure_summary_21_2020 a_42 (cost=11,993.26..117,525.14 rows=280,292 width=72) (actual time=22.760..23.884 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.002 22.749 ↓ 0.0 0 1

BitmapOr (cost=11,993.26..11,993.26 rows=280,292 width=0) (actual time=22.749..22.749 rows=0 loops=1)

118. 22.741 22.741 ↑ 8,243.9 34 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx131 (cost=0.00..11,848.67 rows=280,292 width=0) (actual time=22.741..22.741 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.006 0.006 ↓ 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.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))
120. 0.388 0.388 ↑ 4.2 20 1

Seq Scan on fact_monitoring_structure_summary_21_null a_43 (cost=0.00..68.34 rows=84 width=212) (actual time=0.012..0.388 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. 9.593 28.041 ↑ 5,532.4 40 1

Bitmap Heap Scan on fact_monitoring_structure_summary_22_2020 a_44 (cost=9,554.20..73,928.62 rows=221,295 width=73) (actual time=18.471..28.041 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 18.448 ↓ 0.0 0 1

BitmapOr (cost=9,554.20..9,554.20 rows=221,295 width=0) (actual time=18.448..18.448 rows=0 loops=1)

123. 18.441 18.441 ↑ 5,532.4 40 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx137 (cost=0.00..9,439.11 rows=221,295 width=0) (actual time=18.441..18.441 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.006 0.006 ↓ 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.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))
125. 0.330 0.330 ↑ 1.7 20 1

Seq Scan on fact_monitoring_structure_summary_22_null a_45 (cost=0.00..52.45 rows=34 width=212) (actual time=0.027..0.330 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. 12.750 68.104 ↑ 4,438.7 42 1

Bitmap Heap Scan on fact_monitoring_structure_summary_23_2020 a_46 (cost=8,003.12..58,457.49 rows=186,425 width=74) (actual time=66.754..68.104 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 55.354 ↓ 0.0 0 1

BitmapOr (cost=8,003.12..8,003.12 rows=186,425 width=0) (actual time=55.354..55.354 rows=0 loops=1)

128. 55.341 55.341 ↑ 4,142.8 45 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx143 (cost=0.00..7,905.47 rows=186,425 width=0) (actual time=55.341..55.341 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.012 0.012 ↓ 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.012..0.012 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. 1.430 1.430 ↑ 5.1 14 1

Seq Scan on fact_monitoring_structure_summary_23_null a_47 (cost=0.00..126.17 rows=71 width=212) (actual time=0.028..1.430 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.346 30.226 ↑ 7,411.5 36 1

Bitmap Heap Scan on fact_monitoring_structure_summary_24_2020 a_48 (cost=11,445.89..110,410.30 rows=266,815 width=73) (actual time=29.891..30.226 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.002 29.880 ↓ 0.0 0 1

BitmapOr (cost=11,445.89..11,445.89 rows=266,815 width=0) (actual time=29.880..29.880 rows=0 loops=1)

133. 29.872 29.872 ↑ 7,411.5 36 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx149 (cost=0.00..11,308.04 rows=266,815 width=0) (actual time=29.872..29.872 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.006 0.006 ↓ 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.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))
135. 0.159 0.159 ↑ 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.010..0.159 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. 1.204 26.084 ↑ 5,887.7 41 1

Bitmap Heap Scan on fact_monitoring_structure_summary_25_2020 a_50 (cost=10,546.68..73,470.63 rows=241,397 width=72) (actual time=24.892..26.084 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.002 24.880 ↓ 0.0 0 1

BitmapOr (cost=10,546.68..10,546.68 rows=241,397 width=0) (actual time=24.880..24.880 rows=0 loops=1)

138. 24.871 24.871 ↑ 5,887.7 41 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx155 (cost=0.00..10,421.54 rows=241,397 width=0) (actual time=24.871..24.871 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.007 0.007 ↓ 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.007..0.007 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.180 0.180 ↑ 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.018..0.180 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. 25.201 39.282 ↑ 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=14.093..39.282 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.001 14.081 ↓ 0.0 0 1

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

143. 14.067 14.067 ↑ 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=14.067..14.067 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.013 0.013 ↓ 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.013..0.013 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.369 0.369 ↑ 3.8 32 1

Seq Scan on fact_monitoring_structure_summary_26_null a_53 (cost=0.00..80.54 rows=121 width=212) (actual time=0.009..0.369 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. 1.005 29.959 ↑ 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=28.969..29.959 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.002 28.954 ↓ 0.0 0 1

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

148. 28.945 28.945 ↑ 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=28.945..28.945 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.007 0.007 ↓ 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.007..0.007 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.258 0.258 ↑ 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.029..0.258 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. 11.265 29.193 ↑ 5,881.1 35 1

Bitmap Heap Scan on fact_monitoring_structure_summary_28_2020 a_56 (cost=9,051.39..65,524.96 rows=205,838 width=72) (actual time=17.942..29.193 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.002 17.928 ↓ 0.0 0 1

BitmapOr (cost=9,051.39..9,051.39 rows=205,838 width=0) (actual time=17.928..17.928 rows=0 loops=1)

153. 17.919 17.919 ↑ 5,416.8 38 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx173 (cost=0.00..8,944.03 rows=205,838 width=0) (actual time=17.919..17.919 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.007 0.007 ↓ 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.007..0.007 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.133 0.133 ↓ 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.013..0.133 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. 14.798 46.096 ↑ 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=31.313..46.096 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.001 31.298 ↓ 0.0 0 1

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

158. 31.286 31.286 ↑ 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=31.286..31.286 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.011 0.011 ↓ 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.011..0.011 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.330 0.330 ↑ 2.0 17 1

Seq Scan on fact_monitoring_structure_summary_29_null a_59 (cost=0.00..61.47 rows=34 width=212) (actual time=0.009..0.330 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.165 18.041 ↑ 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=17.897..18.041 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 17.876 ↓ 0.0 0 1

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

163. 17.866 17.866 ↑ 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=17.866..17.866 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.008 0.008 ↓ 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.008..0.008 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. 35.499 35.499 ↑ 6.0 23 1

Seq Scan on fact_monitoring_structure_summary_30_null a_61 (cost=0.00..66.23 rows=138 width=212) (actual time=0.012..35.499 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. 2.482 43.880 ↑ 6,537.1 35 1

Bitmap Heap Scan on fact_monitoring_structure_summary_31_2020 a_62 (cost=9,798.36..72,364.33 rows=228,798 width=72) (actual time=41.419..43.880 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.002 41.398 ↓ 0.0 0 1

BitmapOr (cost=9,798.36..9,798.36 rows=228,798 width=0) (actual time=41.398..41.398 rows=0 loops=1)

168. 41.381 41.381 ↑ 6,537.1 35 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx191 (cost=0.00..9,679.52 rows=228,798 width=0) (actual time=41.381..41.381 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.015 0.015 ↓ 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.015..0.015 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.187 0.187 ↑ 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.014..0.187 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. 1.421 19.932 ↑ 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=18.531..19.932 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.002 18.511 ↓ 0.0 0 1

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

173. 18.495 18.495 ↑ 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=18.495..18.495 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.014 0.014 ↓ 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.014..0.014 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.155 0.155 ↑ 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.015..0.155 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. 9.473 33.298 ↑ 8,601.1 28 1

Bitmap Heap Scan on fact_monitoring_structure_summary_33_2020 a_66 (cost=10,475.74..74,499.19 rows=240,830 width=73) (actual time=23.836..33.298 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 23.825 ↓ 0.0 0 1

BitmapOr (cost=10,475.74..10,475.74 rows=240,830 width=0) (actual time=23.825..23.825 rows=0 loops=1)

178. 23.818 23.818 ↑ 8,601.1 28 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx203 (cost=0.00..10,350.89 rows=240,830 width=0) (actual time=23.818..23.818 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.006 0.006 ↓ 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.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))
180. 0.157 0.157 ↑ 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.011..0.157 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.078 166.132 ↑ 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=166.075..166.132 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.002 166.054 ↓ 0.0 0 1

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

183. 166.044 166.044 ↑ 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=166.044..166.044 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.008 0.008 ↓ 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.008..0.008 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.656 0.656 ↑ 1.0 23 1

Seq Scan on fact_monitoring_structure_summary_34_null a_69 (cost=0.00..57.87 rows=24 width=212) (actual time=0.025..0.656 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.858 16.633 ↑ 5,353.2 36 1

Bitmap Heap Scan on fact_monitoring_structure_summary_35_2020 a_70 (cost=8,266.30..68,149.04 rows=192,716 width=72) (actual time=15.794..16.633 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 15.775 ↓ 0.0 0 1

BitmapOr (cost=8,266.30..8,266.30 rows=192,716 width=0) (actual time=15.775..15.775 rows=0 loops=1)

188. 15.761 15.761 ↑ 5,353.2 36 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx215 (cost=0.00..8,165.50 rows=192,716 width=0) (actual time=15.761..15.761 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.013 0.013 ↓ 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.013..0.013 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.058 0.058 ↑ 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.011..0.058 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. 33.759 80.408 ↑ 9,161.2 29 1

Bitmap Heap Scan on fact_monitoring_structure_summary_36_2020 a_72 (cost=11,304.95..115,006.38 rows=265,675 width=72) (actual time=79.952..80.408 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 46.649 ↓ 0.0 0 1

BitmapOr (cost=11,304.95..11,304.95 rows=265,675 width=0) (actual time=46.649..46.649 rows=0 loops=1)

193. 46.636 46.636 ↑ 9,161.2 29 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx221 (cost=0.00..11,167.67 rows=265,675 width=0) (actual time=46.636..46.636 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.012 0.012 ↓ 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.012..0.012 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. 3.684 3.684 ↑ 2.8 17 1

Seq Scan on fact_monitoring_structure_summary_36_null a_73 (cost=0.00..57.95 rows=48 width=212) (actual time=0.010..3.684 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.984 9.918 ↑ 4,391.8 32 1

Bitmap Heap Scan on fact_monitoring_structure_summary_37_2020 a_74 (cost=5,869.68..48,955.77 rows=140,539 width=73) (actual time=8.945..9.918 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.002 8.934 ↓ 0.0 0 1

BitmapOr (cost=5,869.68..5,869.68 rows=140,539 width=0) (actual time=8.934..8.934 rows=0 loops=1)

198. 8.926 8.926 ↑ 4,391.8 32 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx227 (cost=0.00..5,794.98 rows=140,539 width=0) (actual time=8.926..8.926 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.006 0.006 ↓ 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.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))
200. 0.043 0.043 ↑ 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.010..0.043 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. 41.392 48.529 ↑ 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=7.153..48.529 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.002 7.137 ↓ 0.0 0 1

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

203. 7.124 7.124 ↑ 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=7.124..7.124 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.011 0.011 ↓ 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.011..0.011 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.029 0.029 ↑ 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.010..0.029 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. 26.549 32.195 ↑ 3,033.7 30 1

Bitmap Heap Scan on fact_monitoring_structure_summary_39_2020 a_78 (cost=3,618.77..48,130.92 rows=91,010 width=74) (actual time=5.657..32.195 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.001 5.646 ↓ 0.0 0 1

BitmapOr (cost=3,618.77..3,618.77 rows=91,010 width=0) (actual time=5.646..5.646 rows=0 loops=1)

208. 5.638 5.638 ↑ 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.83 rows=91,010 width=0) (actual time=5.638..5.638 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.007 0.007 ↓ 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.007..0.007 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.200 0.200 ↑ 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.011..0.200 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.766 43.926 ↑ 13,170.1 24 1

Bitmap Heap Scan on fact_monitoring_structure_summary_40_2020 a_80 (cost=13,601.21..118,053.09 rows=316,082 width=73) (actual time=43.178..43.926 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.002 43.160 ↓ 0.0 0 1

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

213. 43.152 43.152 ↑ 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=43.152..43.152 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.006 0.006 ↓ 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.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))
215. 16.184 16.184 ↑ 6.3 21 1

Seq Scan on fact_monitoring_structure_summary_40_null a_81 (cost=0.00..118.29 rows=132 width=212) (actual time=0.016..16.184 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. 29.675 63.463 ↑ 6,616.7 34 1

Bitmap Heap Scan on fact_monitoring_structure_summary_41_2020 a_82 (cost=9,595.94..72,368.48 rows=224,969 width=96) (actual time=45.306..63.463 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.001 33.788 ↓ 0.0 0 1

BitmapOr (cost=9,595.94..9,595.94 rows=224,969 width=0) (actual time=33.788..33.788 rows=0 loops=1)

218. 33.779 33.779 ↑ 6,616.7 34 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx251 (cost=0.00..9,479.02 rows=224,969 width=0) (actual time=33.779..33.779 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.008 0.008 ↓ 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.008..0.008 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.069 0.069 ↑ 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.011..0.069 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. 8.723 27.079 ↑ 6,724.9 31 1

Bitmap Heap Scan on fact_monitoring_structure_summary_42_2020 a_84 (cost=8,809.64..72,301.73 rows=208,473 width=72) (actual time=18.376..27.079 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.000 18.356 ↓ 0.0 0 1

BitmapOr (cost=8,809.64..8,809.64 rows=208,473 width=0) (actual time=18.356..18.356 rows=0 loops=1)

223. 18.348 18.348 ↑ 6,724.9 31 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx257 (cost=0.00..8,700.96 rows=208,473 width=0) (actual time=18.348..18.348 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.008 0.008 ↓ 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.008..0.008 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. 6.574 6.574 ↑ 4.4 19 1

Seq Scan on fact_monitoring_structure_summary_42_null a_85 (cost=0.00..44.28 rows=84 width=212) (actual time=0.013..6.574 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.148 7.657 ↑ 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=7.519..7.657 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.002 7.509 ↓ 0.0 0 1

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

228. 6.976 6.976 ↑ 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=6.976..6.976 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.531 0.531 ↓ 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.531..0.531 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.113 0.113 ↑ 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.010..0.113 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. 19.866 27.686 ↑ 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=7.837..27.686 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.001 7.820 ↓ 0.0 0 1

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

233. 7.809 7.809 ↑ 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=7.809..7.809 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.010 0.010 ↓ 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.010..0.010 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.232 0.232 ↑ 5.1 14 1

Seq Scan on fact_monitoring_structure_summary_44_null a_89 (cost=0.00..51.18 rows=71 width=212) (actual time=0.010..0.232 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.135 19.790 ↑ 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=19.691..19.790 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.002 19.655 ↓ 0.0 0 1

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

238. 19.643 19.643 ↑ 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=19.643..19.643 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.010 0.010 ↓ 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.010..0.010 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. 8.746 8.746 ↑ 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.009..8.746 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.113 9.029 ↑ 4,056.8 37 1

Bitmap Heap Scan on fact_monitoring_structure_summary_46_2020 a_92 (cost=6,469.62..48,269.13 rows=150,101 width=72) (actual time=8.932..9.029 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.002 8.916 ↓ 0.0 0 1

BitmapOr (cost=6,469.62..6,469.62 rows=150,101 width=0) (actual time=8.916..8.916 rows=0 loops=1)

243. 8.908 8.908 ↑ 4,056.8 37 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx281 (cost=0.00..6,390.13 rows=150,101 width=0) (actual time=8.908..8.908 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.006 0.006 ↓ 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.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))
245. 0.365 0.365 ↑ 6.8 18 1

Seq Scan on fact_monitoring_structure_summary_46_null a_93 (cost=0.00..82.62 rows=122 width=212) (actual time=0.011..0.365 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.065 19.193 ↑ 5,470.5 34 1

Bitmap Heap Scan on fact_monitoring_structure_summary_47_2020 a_94 (cost=8,021.49..62,474.46 rows=185,998 width=73) (actual time=19.137..19.193 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.001 19.128 ↓ 0.0 0 1

BitmapOr (cost=8,021.49..8,021.49 rows=185,998 width=0) (actual time=19.128..19.128 rows=0 loops=1)

248. 19.120 19.120 ↑ 5,470.5 34 1

Bitmap Index Scan on fact_monitoring_structure_su_end_time_start_time_id_vehi_idx287 (cost=0.00..7,924.06 rows=185,998 width=0) (actual time=19.120..19.120 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.007 0.007 ↓ 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.007..0.007 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.104 0.104 ↑ 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.012..0.104 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.089 23.057 ↑ 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=22.987..23.057 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.002 22.968 ↓ 0.0 0 1

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

253. 22.953 22.953 ↑ 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=22.953..22.953 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.013 0.013 ↓ 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.013..0.013 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.134 0.134 ↑ 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.012..0.134 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. 17,046.851 17,046.851 ↑ 11,691.9 32 1

Seq Scan on fact_monitoring_structure_summary_49_2020 a_98 (cost=0.00..124,251.17 rows=374,141 width=72) (actual time=15,082.427..17,046.851 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: 3,059,025
257. 0.217 0.217 ↑ 1.0 21 1

Seq Scan on fact_monitoring_structure_summary_49_null a_99 (cost=0.00..44.80 rows=21 width=212) (actual time=0.010..0.217 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
258. 0.063 0.560 ↑ 1.0 168 1

Hash (cost=752.01..752.01 rows=168 width=54) (actual time=0.560..0.560 rows=168 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 24kB
259. 0.327 0.497 ↑ 1.0 168 1

Bitmap Heap Scan on vehicle b (cost=145.71..752.01 rows=168 width=54) (actual time=0.189..0.497 rows=168 loops=1)

  • Recheck Cond: (id_company = 25)
  • Heap Blocks: exact=121
260. 0.170 0.170 ↑ 1.0 168 1

Bitmap Index Scan on uk_vehicle (cost=0.00..145.67 rows=168 width=0) (actual time=0.170..0.170 rows=168 loops=1)

  • Index Cond: (id_company = 25)
261. 0.091 0.190 ↑ 1.0 444 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 29kB
262. 0.099 0.099 ↑ 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.099 rows=444 loops=1)

263. 0.065 0.158 ↑ 1.0 311 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 23kB
264. 0.093 0.093 ↑ 1.0 311 1

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

265. 37.129 63.296 ↑ 1.0 101,215 1

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

  • Buckets: 65,536 Batches: 4 Memory Usage: 2,368kB
266. 26.167 26.167 ↑ 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.006..26.167 rows=101,215 loops=1)

267. 0.133 0.274 ↑ 1.0 521 1

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

  • Buckets: 1,024 Batches: 1 Memory Usage: 39kB
268. 0.141 0.141 ↑ 1.0 521 1

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

269. 5.232 9.580 ↓ 1.0 18,376 1

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

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

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

271. 30.256 30.256 ↑ 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.244..0.244 rows=1 loops=124)

Planning time : 74.946 ms
Execution time : 18,946.485 ms