explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9Mfq

Settings
# exclusive inclusive rows x rows loops node
1. 3.336 158,848.544 ↑ 4.7 5,360 1

GroupAggregate (cost=171,758.03..176,036.95 rows=25,087 width=60) (actual time=158,834.567..158,848.544 rows=5,360 loops=1)

  • Group Key: tv_143.id_parameter, (timezone('Etc/UTC'::text, to_timestamp((floor((date_part('epoch'::text, tv_143.refresh_time) / '300'::double precision)) * '300'::double precision)))), tp.description
2. 1,286.601 158,845.208 ↑ 3.9 5,412 1

Gather Merge (cost=171,758.03..174,615.35 rows=20,906 width=92) (actual time=158,834.552..158,845.208 rows=5,412 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 6.232 157,558.607 ↑ 5.8 1,804 3 / 3

GroupAggregate (cost=170,758.01..171,202.26 rows=10,453 width=92) (actual time=157,551.683..157,558.607 rows=1,804 loops=3)

  • Group Key: tv_143.id_parameter, (timezone('Etc/UTC'::text, to_timestamp((floor((date_part('epoch'::text, tv_143.refresh_time) / '300'::double precision)) * '300'::double precision)))), tp.description
4. 13.204 157,552.375 ↑ 1.2 8,717 3 / 3

Sort (cost=170,758.01..170,784.14 rows=10,453 width=22) (actual time=157,551.657..157,552.375 rows=8,717 loops=3)

  • Sort Key: tv_143.id_parameter, (timezone('Etc/UTC'::text, to_timestamp((floor((date_part('epoch'::text, tv_143.refresh_time) / '300'::double precision)) * '300'::double precision)))), tp.description
  • Sort Method: quicksort Memory: 1,057kB
5. 53.205 157,539.171 ↑ 1.2 8,717 3 / 3

Nested Loop (cost=21.24..170,060.18 rows=10,453 width=22) (actual time=1,158.279..157,539.171 rows=8,717 loops=3)

6. 3.270 157,442.379 ↑ 1.2 8,717 3 / 3

Append (cost=20.82..93,606.94 rows=10,464 width=14) (actual time=1,150.481..157,442.379 rows=8,717 loops=3)

7. 1,200.113 1,318.388 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_1500 tv_143 (cost=20.83..943.35 rows=144 width=14) (actual time=1,061.182..3,955.165 rows=240 loops=1)

8. 118.276 118.276 ↑ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_1500_id_parameter_refresh_time_idx (cost=0..20.77 rows=245 width=0) (actual time=354.827..354.827 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
9. 1,132.565 1,228.130 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_1800 tv_77 (cost=20.82..883.64 rows=143 width=14) (actual time=946.835..3,684.389 rows=240 loops=1)

10. 95.565 95.565 ↑ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_1800_id_parameter_refresh_time_idx (cost=0..20.76 rows=243 width=0) (actual time=286.695..286.695 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
11. 857.772 997.743 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_0700 tv_66 (cost=20.82..928.81 rows=142 width=14) (actual time=517.369..2,993.229 rows=240 loops=1)

12. 139.971 139.971 ↑ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_0700_id_parameter_refresh_time_idx (cost=0..20.76 rows=242 width=0) (actual time=419.912..419.912 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
13. 514.342 576.111 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_1900 tv_54 (cost=20.82..871.16 rows=142 width=14) (actual time=292.882..1,728.333 rows=240 loops=1)

14. 61.769 61.769 ↑ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_1900_id_parameter_refresh_time_idx (cost=0..20.76 rows=242 width=0) (actual time=185.308..185.308 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
15. 2,105.630 2,263.950 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_22_1900 tv_123 (cost=20.78..914.55 rows=142 width=14) (actual time=542.445..6,791.851 rows=240 loops=1)

16. 158.321 158.321 ↑ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_22_1900_id_parameter_refresh_time_idx (cost=0..20.72 rows=242 width=0) (actual time=474.962..474.962 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
17. 2,087.890 2,198.327 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_0600 tv_134 (cost=20.78..903.51 rows=141 width=14) (actual time=442.413..6,594.982 rows=240 loops=1)

18. 110.438 110.438 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_0600_id_parameter_refresh_time_idx (cost=0..20.72 rows=239 width=0) (actual time=331.313..331.313 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
19. 2,655.299 2,734.971 ↓ 1.7 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_1600 tv_75 (cost=20.77..891.04 rows=142 width=14) (actual time=521.214..8,204.914 rows=236 loops=1)

20. 79.672 79.672 ↑ 1.0 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_1600_id_parameter_refresh_time_idx (cost=0..20.71 rows=241 width=0) (actual time=239.017..239.017 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
21. 2,273.950 2,545.860 ↓ 1.6 232 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_0100 tv_12 (cost=20.77..877.35 rows=142 width=14) (actual time=917.087..7,637.58 rows=232 loops=1)

22. 271.910 271.910 ↑ 1.0 232 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_0100_id_parameter_refresh_time_idx (cost=0..20.71 rows=241 width=0) (actual time=815.731..815.731 rows=232 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
23. 1,348.385 1,572.754 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_2000 tv_55 (cost=20.77..864.35 rows=141 width=14) (actual time=802.717..4,718.262 rows=240 loops=1)

24. 224.369 224.369 ↑ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_2000_id_parameter_refresh_time_idx (cost=0..20.71 rows=240 width=0) (actual time=673.108..673.108 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
25. 1,013.890 1,448.801 ↓ 1.7 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_1200 tv_71 (cost=20.77..864.19 rows=141 width=14) (actual time=1,449.505..4,346.403 rows=236 loops=1)

26. 434.911 434.911 ↑ 1.0 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_1200_id_parameter_refresh_time_idx (cost=0..20.71 rows=240 width=0) (actual time=1,304.733..1,304.733 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
27. 1,837.061 1,925.440 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_0800 tv_67 (cost=20.77..915.05 rows=141 width=14) (actual time=415.308..5,776.319 rows=240 loops=1)

28. 88.379 88.379 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_0800_id_parameter_refresh_time_idx (cost=0..20.71 rows=239 width=0) (actual time=265.136..265.136 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
29. 1,404.675 1,515.082 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_17_1600 tv_3 (cost=20.77..870.12 rows=141 width=14) (actual time=376.313..4,545.245 rows=240 loops=1)

30. 110.407 110.407 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_17_1600_id_parameter_refresh_time_idx (cost=0..20.71 rows=239 width=0) (actual time=331.22..331.22 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
31. 987.084 1,110.338 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_2100 tv_56 (cost=20.77..861.11 rows=141 width=14) (actual time=442.129..3,331.015 rows=240 loops=1)

32. 123.254 123.254 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_2100_id_parameter_refresh_time_idx (cost=0..20.71 rows=239 width=0) (actual time=369.762..369.762 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
33. 1,379.453 1,684.762 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_1500 tv_50 (cost=20.77..861.04 rows=141 width=14) (actual time=1,003.566..5,054.287 rows=240 loops=1)

34. 305.309 305.309 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_1500_id_parameter_refresh_time_idx (cost=0..20.71 rows=239 width=0) (actual time=915.928..915.928 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
35. 1,307.108 1,702.001 ↓ 1.7 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_0900 tv_44 (cost=20.77..860.97 rows=141 width=14) (actual time=1,631.411..5,106.003 rows=236 loops=1)

36. 394.893 394.893 ↑ 1.0 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_0900_id_parameter_refresh_time_idx (cost=0..20.71 rows=239 width=0) (actual time=1,184.68..1,184.68 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
37. 1,463.865 1,925.625 ↓ 1.7 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_1200 tv_47 (cost=20.77..860.89 rows=141 width=14) (actual time=1,761.432..5,776.876 rows=236 loops=1)

38. 461.761 461.761 ↑ 1.0 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_1200_id_parameter_refresh_time_idx (cost=0..20.71 rows=239 width=0) (actual time=1,385.282..1,385.282 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
39. 1,477.042 2,095.413 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_0900 tv_68 (cost=20.77..900.36 rows=140 width=14) (actual time=2,186.893..6,286.238 rows=240 loops=1)

40. 618.371 618.371 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_0900_id_parameter_refresh_time_idx (cost=0..20.71 rows=238 width=0) (actual time=1,855.113..1,855.113 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
41. 1,100.907 1,401.925 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_1300 tv_48 (cost=20.77..857.87 rows=140 width=14) (actual time=1,092.998..4,205.774 rows=240 loops=1)

42. 301.018 301.018 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_1300_id_parameter_refresh_time_idx (cost=0..20.71 rows=238 width=0) (actual time=903.054..903.054 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
43. 1,435.508 1,616.464 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_1800 tv_146 (cost=20.73..896.59 rows=139 width=14) (actual time=753.26..4,849.393 rows=240 loops=1)

44. 180.957 180.957 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_1800_id_parameter_refresh_time_idx (cost=0..20.67 rows=237 width=0) (actual time=542.87..542.87 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
45. 2,062.448 2,237.845 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_22_1500 tv_119 (cost=20.73..896.16 rows=139 width=14) (actual time=777.991..6,713.535 rows=240 loops=1)

46. 175.397 175.397 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_22_1500_id_parameter_refresh_time_idx (cost=0..20.67 rows=237 width=0) (actual time=526.19..526.19 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
47. 1,527.758 1,724.688 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_1400 tv_142 (cost=20.73..891.81 rows=138 width=14) (actual time=781.982..5,174.063 rows=240 loops=1)

48. 196.929 196.929 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_1400_id_parameter_refresh_time_idx (cost=0..20.67 rows=235 width=0) (actual time=590.787..590.788 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
49. 1,049.313 1,212.403 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_1000 tv_45 (cost=20.72..857.82 rows=140 width=14) (actual time=677.036..3,637.209 rows=240 loops=1)

50. 163.090 163.090 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_1000_id_parameter_refresh_time_idx (cost=0..20.66 rows=238 width=0) (actual time=489.271..489.271 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
51. 747.513 869.507 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_1400 tv_49 (cost=20.72..857.82 rows=140 width=14) (actual time=452.297..2,608.52 rows=240 loops=1)

52. 121.994 121.994 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_1400_id_parameter_refresh_time_idx (cost=0..20.66 rows=238 width=0) (actual time=365.982..365.982 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
53. 909.735 985.092 ↓ 1.7 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_1600 tv_51 (cost=20.72..857.61 rows=140 width=14) (actual time=308.513..2,955.275 rows=236 loops=1)

54. 75.357 75.357 ↑ 1.0 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_1600_id_parameter_refresh_time_idx (cost=0..20.66 rows=238 width=0) (actual time=226.071..226.071 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
55. 1,044.392 1,224.576 ↓ 1.7 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_1500 tv_74 (cost=20.72..889.42 rows=139 width=14) (actual time=644.847..3,673.728 rows=236 loops=1)

56. 180.184 180.184 ↑ 1.0 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_1500_id_parameter_refresh_time_idx (cost=0..20.66 rows=237 width=0) (actual time=540.552..540.552 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
57. 1,078.317 1,186.974 ↓ 1.7 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_0500 tv_16 (cost=20.72..863.21 rows=139 width=14) (actual time=445.791..3,560.921 rows=236 loops=1)

58. 108.657 108.657 ↑ 1.0 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_0500_id_parameter_refresh_time_idx (cost=0..20.66 rows=237 width=0) (actual time=325.971..325.971 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
59. 1,264.126 1,426.468 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_21_0200 tv_85 (cost=20.72..863.02 rows=139 width=14) (actual time=685.182..4,279.404 rows=240 loops=1)

60. 162.342 162.342 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_21_0200_id_parameter_refresh_time_idx (cost=0..20.66 rows=237 width=0) (actual time=487.025..487.025 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
61. 983.207 1,128.834 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_0800 tv_43 (cost=20.72..854.29 rows=139 width=14) (actual time=591.202..3,386.502 rows=240 loops=1)

62. 145.627 145.627 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_0800_id_parameter_refresh_time_idx (cost=0..20.66 rows=237 width=0) (actual time=436.88..436.88 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
63. 992.811 1,088.844 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_1100 tv_46 (cost=20.72..854.22 rows=139 width=14) (actual time=498.642..3,266.531 rows=240 loops=1)

64. 96.032 96.032 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_1100_id_parameter_refresh_time_idx (cost=0..20.66 rows=237 width=0) (actual time=288.097..288.097 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
65. 962.140 1,035.791 ↓ 1.7 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_1000 tv_69 (cost=20.72..853.85 rows=139 width=14) (actual time=296.331..3,107.372 rows=236 loops=1)

66. 73.651 73.651 ↑ 1.0 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_1000_id_parameter_refresh_time_idx (cost=0..20.66 rows=237 width=0) (actual time=220.952..220.952 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
67. 820.385 957.465 ↓ 1.7 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_2200 tv_57 (cost=20.72..850.38 rows=139 width=14) (actual time=456.172..2,872.396 rows=236 loops=1)

68. 137.081 137.081 ↑ 1.0 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_2200_id_parameter_refresh_time_idx (cost=0..20.66 rows=236 width=0) (actual time=411.242..411.242 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
69. 1,031.733 1,172.421 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_17_2300 tv_10 (cost=20.72..855.47 rows=138 width=14) (actual time=475.527..3,517.263 rows=240 loops=1)

70. 140.688 140.688 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_17_2300_id_parameter_refresh_time_idx (cost=0..20.66 rows=235 width=0) (actual time=422.064..422.064 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
71. 1,171.306 1,244.023 ↓ 1.7 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_0900 tv_20 (cost=20.72..852.25 rows=138 width=14) (actual time=354.892..3,732.068 rows=236 loops=1)

72. 72.717 72.717 ↓ 1.0 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_0900_id_parameter_refresh_time_idx (cost=0..20.66 rows=234 width=0) (actual time=218.151..218.151 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
73. 1,342.087 1,418.348 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_2300 tv_82 (cost=20.72..851.85 rows=138 width=14) (actual time=335.275..4,255.044 rows=240 loops=1)

74. 76.261 76.261 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_2300_id_parameter_refresh_time_idx (cost=0..20.66 rows=234 width=0) (actual time=228.783..228.783 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
75. 1,296.881 1,399.926 ↓ 1.7 228 1 / 3

Bitmap Heap Scan on t_values_p2020_07_22_0008 tv_112 (cost=20.68..900.84 rows=137 width=14) (actual time=407.488..4,199.778 rows=228 loops=1)

76. 103.045 103.045 ↑ 1.0 228 1 / 3

Bitmap Index Scan on t_values_p2020_07_22_0008_id_parameter_refresh_time_idx (cost=0..20.62 rows=233 width=0) (actual time=309.134..309.134 rows=228 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
77. 1,275.764 1,384.945 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_22_1600 tv_120 (cost=20.68..881.38 rows=137 width=14) (actual time=392.054..4,154.835 rows=240 loops=1)

78. 109.181 109.181 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_22_1600_id_parameter_refresh_time_idx (cost=0..20.62 rows=233 width=0) (actual time=327.544..327.544 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
79. 1,667.683 1,859.670 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_0800 tv_136 (cost=20.68..872.58 rows=135 width=14) (actual time=663.358..5,579.009 rows=240 loops=1)

80. 191.986 191.986 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_0800_id_parameter_refresh_time_idx (cost=0..20.62 rows=230 width=0) (actual time=575.959..575.959 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
81. 1,357.903 1,462.263 ↓ 1.7 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_1700 tv_28 (cost=20.67..852.53 rows=138 width=14) (actual time=404.839..4,386.789 rows=240 loops=1)

82. 104.360 104.360 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_1700_id_parameter_refresh_time_idx (cost=0..20.61 rows=234 width=0) (actual time=313.079..313.079 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
83. 1,240.956 1,375.564 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_1400 tv_25 (cost=20.67..849.48 rows=137 width=14) (actual time=442.628..4,126.693 rows=240 loops=1)

84. 134.609 134.609 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_1400_id_parameter_refresh_time_idx (cost=0..20.61 rows=233 width=0) (actual time=403.826..403.826 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
85. 2,018.485 2,115.347 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_0700 tv_18 (cost=20.67..845.35 rows=136 width=14) (actual time=430.873..6,346.04 rows=240 loops=1)

86. 96.862 96.862 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_0700_id_parameter_refresh_time_idx (cost=0..20.61 rows=232 width=0) (actual time=290.585..290.585 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
87. 906.307 1,196.394 ↓ 1.7 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_1100 tv_70 (cost=20.67..836.83 rows=136 width=14) (actual time=1,031.343..3,589.183 rows=236 loops=1)

88. 290.087 290.087 ↓ 1.0 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_1100_id_parameter_refresh_time_idx (cost=0..20.61 rows=232 width=0) (actual time=870.262..870.262 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
89. 1,817.403 1,900.604 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_21_0300 tv_86 (cost=20.67..842.26 rows=136 width=14) (actual time=327.95..5,701.811 rows=240 loops=1)

90. 83.201 83.201 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_21_0300_id_parameter_refresh_time_idx (cost=0..20.61 rows=231 width=0) (actual time=249.603..249.603 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
91. 1,075.787 1,191.340 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_1900 tv_30 (cost=20.67..842.12 rows=136 width=14) (actual time=500.495..3,574.019 rows=240 loops=1)

92. 115.553 115.553 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_1900_id_parameter_refresh_time_idx (cost=0..20.61 rows=231 width=0) (actual time=346.659..346.659 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
93. 1,730.338 1,941.387 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_0600 tv_17 (cost=20.67..842.09 rows=136 width=14) (actual time=794.075..5,824.162 rows=240 loops=1)

94. 211.049 211.049 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_0600_id_parameter_refresh_time_idx (cost=0..20.61 rows=231 width=0) (actual time=633.148..633.148 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
95. 1,318.553 1,503.750 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_1600 tv_144 (cost=20.63..874.9 rows=135 width=14) (actual time=847.069..4,511.249 rows=240 loops=1)

96. 185.197 185.197 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_1600_id_parameter_refresh_time_idx (cost=0..20.57 rows=230 width=0) (actual time=555.591..555.591 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
97. 1,112.053 1,246.140 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_0400 tv_132 (cost=20.63..865.69 rows=135 width=14) (actual time=485.157..3,738.419 rows=240 loops=1)

98. 134.087 134.087 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_0400_id_parameter_refresh_time_idx (cost=0..20.57 rows=229 width=0) (actual time=402.261..402.261 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
99. 972.507 1,076.240 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_1700 tv_145 (cost=20.63..862.13 rows=134 width=14) (actual time=442.545..3,228.72 rows=240 loops=1)

100. 103.733 103.733 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_1700_id_parameter_refresh_time_idx (cost=0..20.57 rows=228 width=0) (actual time=311.198..311.198 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
101. 875.267 1,019.411 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_1900 tv_147 (cost=20.63..873.94 rows=134 width=14) (actual time=584.329..3,058.232 rows=240 loops=1)

102. 144.143 144.143 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_1900_id_parameter_refresh_time_idx (cost=0..20.57 rows=227 width=0) (actual time=432.43..432.43 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
103. 1,316.919 1,479.178 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_0900 tv_137 (cost=20.63..856.45 rows=133 width=14) (actual time=591.986..4,437.534 rows=240 loops=1)

104. 162.259 162.259 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_0900_id_parameter_refresh_time_idx (cost=0..20.57 rows=226 width=0) (actual time=486.778..486.778 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
105. 693.095 855.423 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_2200 tv_150 (cost=20.63..855.99 rows=133 width=14) (actual time=554.539..2,566.268 rows=240 loops=1)

106. 162.327 162.327 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_2200_id_parameter_refresh_time_idx (cost=0..20.57 rows=226 width=0) (actual time=486.982..486.982 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
107. 854.969 915.204 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_2200 tv_81 (cost=20.62..838.85 rows=135 width=14) (actual time=232.86..2,745.613 rows=240 loops=1)

108. 60.235 60.235 ↓ 1.0 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_2200_id_parameter_refresh_time_idx (cost=0..20.56 rows=230 width=0) (actual time=180.705..180.705 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
109. 959.830 1,036.142 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_0300 tv_14 (cost=20.62..829.9 rows=134 width=14) (actual time=271.728..3,108.425 rows=240 loops=1)

110. 76.312 76.312 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_0300_id_parameter_refresh_time_idx (cost=0..20.56 rows=228 width=0) (actual time=228.935..228.935 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
111. 996.298 1,126.047 ↓ 1.8 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_0000 tv_11 (cost=20.62..828.98 rows=134 width=14) (actual time=477.699..3,378.141 rows=236 loops=1)

112. 129.749 129.749 ↓ 1.0 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_0000_id_parameter_refresh_time_idx (cost=0..20.56 rows=228 width=0) (actual time=389.247..389.247 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
113. 1,074.316 1,213.814 ↓ 1.8 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_2000 tv_79 (cost=20.62..826.1 rows=134 width=14) (actual time=507.363..3,641.441 rows=236 loops=1)

114. 139.498 139.498 ↓ 1.0 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_2000_id_parameter_refresh_time_idx (cost=0..20.56 rows=227 width=0) (actual time=418.493..418.493 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
115. 1,326.331 1,420.123 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_0200 tv_13 (cost=20.62..823.39 rows=133 width=14) (actual time=454.67..4,260.369 rows=240 loops=1)

116. 93.792 93.792 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_0200_id_parameter_refresh_time_idx (cost=0..20.56 rows=226 width=0) (actual time=281.377..281.377 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
117. 1,564.762 1,678.099 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_1300 tv_141 (cost=20.58..856.86 rows=133 width=14) (actual time=549.27..5,034.296 rows=240 loops=1)

118. 113.337 113.337 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_1300_id_parameter_refresh_time_idx (cost=0..20.52 rows=226 width=0) (actual time=340.01..340.01 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
119. 990.039 1,225.079 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_1200 tv_140 (cost=20.58..852.38 rows=132 width=14) (actual time=824.775..3,675.236 rows=240 loops=1)

120. 235.039 235.039 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_1200_id_parameter_refresh_time_idx (cost=0..20.52 rows=225 width=0) (actual time=705.118..705.118 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
121. 854.390 942.166 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_2000 tv_148 (cost=20.58..851.41 rows=132 width=14) (actual time=387.719..2,826.499 rows=240 loops=1)

122. 87.776 87.776 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_2000_id_parameter_refresh_time_idx (cost=0..20.52 rows=225 width=0) (actual time=263.329..263.329 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
123. 1,017.055 1,139.985 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_22_2200 tv_126 (cost=20.58..849.27 rows=132 width=14) (actual time=525.573..3,419.955 rows=240 loops=1)

124. 122.930 122.930 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_22_2200_id_parameter_refresh_time_idx (cost=0..20.52 rows=224 width=0) (actual time=368.789..368.789 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
125. 925.211 1,048.610 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_1100 tv_139 (cost=20.58..845.26 rows=131 width=14) (actual time=495.86..3,145.83 rows=240 loops=1)

126. 123.399 123.399 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_1100_id_parameter_refresh_time_idx (cost=0..20.52 rows=223 width=0) (actual time=370.198..370.198 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
127. 746.852 848.878 ↓ 1.7 220 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_0400 tv_63 (cost=20.57..866.15 rows=133 width=14) (actual time=442.32..2,546.635 rows=220 loops=1)

128. 102.026 102.026 ↑ 1.0 220 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_0400_id_parameter_refresh_time_idx (cost=0..20.51 rows=226 width=0) (actual time=306.079..306.079 rows=220 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
129. 945.433 1,025.081 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_0400 tv_15 (cost=20.57..818.77 rows=132 width=14) (actual time=369.087..3,075.242 rows=240 loops=1)

130. 79.647 79.647 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_0400_id_parameter_refresh_time_idx (cost=0..20.51 rows=225 width=0) (actual time=238.942..238.942 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
131. 991.547 1,113.922 ↓ 1.8 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_17_2000 tv_7 (cost=20.57..819.15 rows=132 width=14) (actual time=523.514..3,341.767 rows=236 loops=1)

132. 122.376 122.376 ↓ 1.1 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_17_2000_id_parameter_refresh_time_idx (cost=0..20.51 rows=224 width=0) (actual time=367.127..367.127 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
133. 1,149.435 1,284.986 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_17_1700 tv_4 (cost=20.57..813.92 rows=131 width=14) (actual time=453.887..3,854.957 rows=240 loops=1)

134. 135.551 135.551 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_17_1700_id_parameter_refresh_time_idx (cost=0..20.51 rows=223 width=0) (actual time=406.653..406.653 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
135. 1,118.886 1,248.929 ↓ 1.8 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_17_1800 tv_5 (cost=20.57..812.39 rows=131 width=14) (actual time=484.892..3,746.787 rows=236 loops=1)

136. 130.043 130.043 ↓ 1.1 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_17_1800_id_parameter_refresh_time_idx (cost=0..20.51 rows=222 width=0) (actual time=390.128..390.128 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
137. 1,975.969 2,102.598 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_0200 tv_130 (cost=20.53..842.08 rows=131 width=14) (actual time=512.575..6,307.795 rows=240 loops=1)

138. 126.629 126.629 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_0200_id_parameter_refresh_time_idx (cost=0..20.47 rows=222 width=0) (actual time=379.888..379.888 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
139. 1,352.128 1,641.779 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_22_2000 tv_124 (cost=20.53..839.39 rows=130 width=14) (actual time=1,106.686..4,925.338 rows=240 loops=1)

140. 289.651 289.651 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_22_2000_id_parameter_refresh_time_idx (cost=0..20.47 rows=221 width=0) (actual time=868.954..868.954 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
141. 1,200.499 1,259.519 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_0100 tv_129 (cost=20.53..838.51 rows=130 width=14) (actual time=339.952..3,778.557 rows=240 loops=1)

142. 59.020 59.020 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_0100_id_parameter_refresh_time_idx (cost=0..20.47 rows=221 width=0) (actual time=177.061..177.061 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
143. 1,643.945 1,682.746 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_22_2100 tv_125 (cost=20.53..838.51 rows=130 width=14) (actual time=288.881..5,048.239 rows=240 loops=1)

144. 38.801 38.801 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_22_2100_id_parameter_refresh_time_idx (cost=0..20.47 rows=221 width=0) (actual time=116.403..116.403 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
145. 978.284 1,114.574 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_2100 tv_149 (cost=20.52..834.94 rows=129 width=14) (actual time=462.717..3,343.723 rows=240 loops=1)

146. 136.290 136.290 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_2100_id_parameter_refresh_time_idx (cost=0..20.47 rows=220 width=0) (actual time=408.87..408.87 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
147. 1,128.044 1,245.089 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_22_2300 tv_127 (cost=20.52..834.94 rows=129 width=14) (actual time=421.39..3,735.267 rows=240 loops=1)

148. 117.045 117.045 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_22_2300_id_parameter_refresh_time_idx (cost=0..20.47 rows=220 width=0) (actual time=351.135..351.135 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
149. 1,765.595 1,834.134 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_0000 tv_128 (cost=20.52..831.36 rows=129 width=14) (actual time=260.084..5,502.402 rows=240 loops=1)

150. 68.539 68.539 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_0000_id_parameter_refresh_time_idx (cost=0..20.47 rows=219 width=0) (actual time=205.616..205.616 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
151. 1,775.084 1,879.950 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_22_1300 tv_117 (cost=20.52..831.28 rows=129 width=14) (actual time=426.312..5,639.85 rows=240 loops=1)

152. 104.866 104.866 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_22_1300_id_parameter_refresh_time_idx (cost=0..20.47 rows=219 width=0) (actual time=314.597..314.597 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
153. 1,299.970 1,417.520 ↑ 1.6 80 3 / 3

Bitmap Heap Scan on t_values_p2020_07_23_1000 tv_138 (cost=20.52..830.92 rows=129 width=14) (actual time=337.317..1,417.52 rows=80 loops=3)

  • Heap Blocks: exact=31
154. 117.550 117.550 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_1000_id_parameter_refresh_time_idx (cost=0..20.47 rows=219 width=0) (actual time=352.649..352.649 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
155. 1,611.175 1,706.584 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_22_1800 tv_122 (cost=20.52..829.39 rows=129 width=14) (actual time=482.806..5,119.751 rows=240 loops=1)

  • Heap Blocks: exact=60
156. 95.408 95.408 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_22_1800_id_parameter_refresh_time_idx (cost=0..20.47 rows=219 width=0) (actual time=286.225..286.225 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
157. 1,200.241 1,252.874 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_0300 tv_131 (cost=20.52..827.79 rows=128 width=14) (actual time=250.318..3,758.623 rows=240 loops=1)

  • Heap Blocks: exact=60
158. 52.633 52.633 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_0300_id_parameter_refresh_time_idx (cost=0..20.47 rows=218 width=0) (actual time=157.899..157.899 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
159. 1,136.646 1,189.334 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_17_2100 tv_8 (cost=20.52..812.23 rows=131 width=14) (actual time=228.062..3,568.001 rows=240 loops=1)

  • Heap Blocks: exact=62
160. 52.688 52.688 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_17_2100_id_parameter_refresh_time_idx (cost=0..20.46 rows=222 width=0) (actual time=158.063..158.063 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
161. 1,677.084 1,865.307 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_17_2200 tv_9 (cost=20.52..810.97 rows=131 width=14) (actual time=814.085..5,595.921 rows=240 loops=1)

  • Heap Blocks: exact=63
162. 188.223 188.223 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_17_2200_id_parameter_refresh_time_idx (cost=0..20.46 rows=222 width=0) (actual time=564.668..564.668 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
163. 1,072.985 1,128.869 ↓ 1.8 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_21_0000 tv_83 (cost=20.52..806.92 rows=130 width=14) (actual time=209.354..3,386.607 rows=240 loops=1)

  • Heap Blocks: exact=62
164. 55.884 55.884 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_21_0000_id_parameter_refresh_time_idx (cost=0..20.46 rows=221 width=0) (actual time=167.65..167.651 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
165. 1,260.265 1,330.091 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_17_1900 tv_6 (cost=20.52..805.58 rows=129 width=14) (actual time=280.608..3,990.273 rows=240 loops=1)

  • Heap Blocks: exact=60
166. 69.826 69.826 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_17_1900_id_parameter_refresh_time_idx (cost=0..20.46 rows=220 width=0) (actual time=209.479..209.479 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
167. 985.119 1,051.577 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_21_0900 tv_92 (cost=20.52..804.7 rows=129 width=14) (actual time=292.488..3,154.732 rows=240 loops=1)

  • Heap Blocks: exact=60
168. 66.458 66.458 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_21_0900_id_parameter_refresh_time_idx (cost=0..20.46 rows=220 width=0) (actual time=199.375..199.375 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
169. 1,012.305 1,058.335 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_21_0100 tv_84 (cost=20.52..803.64 rows=129 width=14) (actual time=189.684..3,175.006 rows=240 loops=1)

  • Heap Blocks: exact=61
170. 46.030 46.030 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_21_0100_id_parameter_refresh_time_idx (cost=0..20.46 rows=220 width=0) (actual time=138.091..138.091 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
171. 1,360.485 1,465.334 ↓ 1.8 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_1800 tv_29 (cost=20.52..802.07 rows=129 width=14) (actual time=430.742..4,396.001 rows=236 loops=1)

  • Heap Blocks: exact=62
172. 104.848 104.848 ↓ 1.1 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_1800_id_parameter_refresh_time_idx (cost=0..20.46 rows=220 width=0) (actual time=314.545..314.545 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
173. 1,180.359 1,259.080 ↓ 1.8 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_1700 tv_76 (cost=20.52..801.95 rows=129 width=14) (actual time=337.086..3,777.239 rows=236 loops=1)

  • Heap Blocks: exact=60
174. 78.721 78.721 ↓ 1.1 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_1700_id_parameter_refresh_time_idx (cost=0..20.46 rows=220 width=0) (actual time=236.162..236.162 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
175. 1,149.805 1,224.900 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_1900 tv_78 (cost=20.51..802.78 rows=128 width=14) (actual time=316.591..3,674.7 rows=240 loops=1)

  • Heap Blocks: exact=61
176. 75.095 75.095 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_1900_id_parameter_refresh_time_idx (cost=0..20.46 rows=218 width=0) (actual time=225.284..225.285 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
177. 1,141.293 1,192.370 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_21_1100 tv_94 (cost=20.47..827.44 rows=128 width=14) (actual time=420.41..3,577.111 rows=240 loops=1)

  • Heap Blocks: exact=60
178. 51.077 51.077 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_21_1100_id_parameter_refresh_time_idx (cost=0..20.42 rows=218 width=0) (actual time=153.232..153.232 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
179. 1,267.814 1,382.726 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_22_1700 tv_121 (cost=20.47..824.58 rows=128 width=14) (actual time=515.04..4,148.177 rows=240 loops=1)

  • Heap Blocks: exact=65
180. 114.912 114.912 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_22_1700_id_parameter_refresh_time_idx (cost=0..20.42 rows=217 width=0) (actual time=344.735..344.735 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
181. 1,255.619 1,410.223 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_0500 tv_133 (cost=20.47..825 rows=127 width=14) (actual time=658.885..4,230.668 rows=240 loops=1)

  • Heap Blocks: exact=60
182. 154.604 154.604 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_0500_id_parameter_refresh_time_idx (cost=0..20.42 rows=216 width=0) (actual time=463.811..463.811 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
183. 1,354.794 1,429.860 ↓ 1.8 228 1 / 3

Bitmap Heap Scan on t_values_p2020_07_22_0900 tv_113 (cost=20.47..813.08 rows=126 width=14) (actual time=425.663..4,289.58 rows=228 loops=1)

  • Heap Blocks: exact=57
184. 75.066 75.066 ↓ 1.1 228 1 / 3

Bitmap Index Scan on t_values_p2020_07_22_0900_id_parameter_refresh_time_idx (cost=0..20.42 rows=214 width=0) (actual time=225.199..225.199 rows=228 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
185. 863.150 962.007 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_1200 tv_23 (cost=20.46..799.28 rows=128 width=14) (actual time=422.182..2,886.02 rows=240 loops=1)

  • Heap Blocks: exact=61
186. 98.857 98.857 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_1200_id_parameter_refresh_time_idx (cost=0..20.41 rows=217 width=0) (actual time=296.571..296.571 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
187. 2,119.413 2,217.419 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_1000 tv_21 (cost=20.46..799.27 rows=128 width=14) (actual time=435.621..6,652.257 rows=240 loops=1)

  • Heap Blocks: exact=63
188. 98.006 98.006 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_1000_id_parameter_refresh_time_idx (cost=0..20.41 rows=217 width=0) (actual time=294.018..294.018 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
189. 1,361.228 1,676.396 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_1600 tv_27 (cost=20.46..799.23 rows=128 width=14) (actual time=1,040.96..5,029.189 rows=240 loops=1)

  • Heap Blocks: exact=63
190. 315.169 315.169 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_1600_id_parameter_refresh_time_idx (cost=0..20.41 rows=217 width=0) (actual time=945.506..945.506 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
191. 1,179.594 1,283.017 ↓ 1.8 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_1100 tv_22 (cost=20.46..793.94 rows=128 width=14) (actual time=414.053..3,849.05 rows=236 loops=1)

  • Heap Blocks: exact=60
192. 103.423 103.423 ↓ 1.1 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_1100_id_parameter_refresh_time_idx (cost=0..20.41 rows=217 width=0) (actual time=310.268..310.268 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
193. 935.460 1,079.631 ↓ 1.9 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_1500 tv_26 (cost=20.46..795.27 rows=127 width=14) (actual time=540.302..3,238.893 rows=236 loops=1)

  • Heap Blocks: exact=61
194. 144.171 144.171 ↓ 1.1 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_1500_id_parameter_refresh_time_idx (cost=0..20.41 rows=216 width=0) (actual time=432.513..432.513 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
195. 1,088.970 1,134.114 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_0800 tv_19 (cost=20.46..795.11 rows=127 width=14) (actual time=289.089..3,402.343 rows=240 loops=1)

  • Heap Blocks: exact=63
196. 45.144 45.144 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_0800_id_parameter_refresh_time_idx (cost=0..20.41 rows=216 width=0) (actual time=135.432..135.432 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
197. 1,085.807 1,177.439 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_2000 tv_31 (cost=20.46..791.64 rows=127 width=14) (actual time=402.5..3,532.318 rows=240 loops=1)

  • Heap Blocks: exact=61
198. 91.633 91.633 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_2000_id_parameter_refresh_time_idx (cost=0..20.41 rows=216 width=0) (actual time=274.898..274.898 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
199. 1,277.324 1,343.750 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_2100 tv_80 (cost=20.46..791.88 rows=126 width=14) (actual time=258.667..4,031.249 rows=240 loops=1)

  • Heap Blocks: exact=60
200. 66.425 66.425 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_2100_id_parameter_refresh_time_idx (cost=0..20.41 rows=215 width=0) (actual time=199.276..199.276 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
201. 971.823 1,070.330 ↓ 1.8 232 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_1300 tv_24 (cost=20.46..791.84 rows=126 width=14) (actual time=388.339..3,210.991 rows=232 loops=1)

  • Heap Blocks: exact=59
202. 98.507 98.507 ↓ 1.1 232 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_1300_id_parameter_refresh_time_idx (cost=0..20.41 rows=215 width=0) (actual time=295.522..295.522 rows=232 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
203. 1,022.513 1,115.818 ↓ 1.8 232 1 / 3

Bitmap Heap Scan on t_values_p2020_07_22_1400 tv_118 (cost=20.42..810.7 rows=126 width=14) (actual time=418.637..3,347.454 rows=232 loops=1)

  • Heap Blocks: exact=58
204. 93.305 93.305 ↓ 1.1 232 1 / 3

Bitmap Index Scan on t_values_p2020_07_22_1400_id_parameter_refresh_time_idx (cost=0..20.37 rows=214 width=0) (actual time=279.915..279.915 rows=232 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
205. 1,364.666 1,509.565 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_22_1200 tv_116 (cost=20.42..808.69 rows=124 width=14) (actual time=541.39..4,528.694 rows=240 loops=1)

  • Heap Blocks: exact=62
206. 144.898 144.898 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_22_1200_id_parameter_refresh_time_idx (cost=0..20.37 rows=211 width=0) (actual time=434.695..434.695 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
207. 2,974.565 3,332.957 ↓ 1.9 240 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_0700 tv_135 (cost=20.42..807.03 rows=124 width=14) (actual time=1,200.806..9,998.871 rows=240 loops=1)

  • Heap Blocks: exact=61
208. 358.392 358.392 ↓ 1.1 240 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_0700_id_parameter_refresh_time_idx (cost=0..20.37 rows=211 width=0) (actual time=1,075.177..1,075.177 rows=240 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
209. 1,485.046 1,666.816 ↓ 1.7 208 1 / 3

Bitmap Heap Scan on t_values_p2020_07_21_1200 tv_95 (cost=20.37..783.57 rows=122 width=14) (actual time=726.429..5,000.449 rows=208 loops=1)

  • Heap Blocks: exact=53
210. 181.770 181.770 ↓ 1.0 208 1 / 3

Bitmap Index Scan on t_values_p2020_07_21_1200_id_parameter_refresh_time_idx (cost=0..20.32 rows=207 width=0) (actual time=545.311..545.311 rows=208 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
211. 1,339.676 1,370.245 ↓ 2.1 236 1 / 3

Bitmap Heap Scan on t_values_p2020_07_21_1000 tv_93 (cost=20.11..706.25 rows=111 width=14) (actual time=192.55..4,110.735 rows=236 loops=1)

  • Heap Blocks: exact=59
212. 30.569 30.569 ↓ 1.2 236 1 / 3

Bitmap Index Scan on t_values_p2020_07_21_1000_id_parameter_refresh_time_idx (cost=0..20.06 rows=189 width=0) (actual time=91.707..91.707 rows=236 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
213. 1,347.359 1,496.074 ↓ 1.7 188 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_0500 tv_64 (cost=20.11..719.72 rows=110 width=14) (actual time=1,074.145..4,488.222 rows=188 loops=1)

  • Heap Blocks: exact=49
214. 148.715 148.715 ↓ 1.0 188 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_0500_id_parameter_refresh_time_idx (cost=0..20.06 rows=187 width=0) (actual time=446.146..446.146 rows=188 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
215. 939.762 1,025.981 ↓ 1.6 172 1 / 3

Bitmap Heap Scan on t_values_p2020_07_22_0007 tv_111 (cost=20.02..699.54 rows=106 width=14) (actual time=476.614..3,077.944 rows=172 loops=1)

  • Heap Blocks: exact=47
216. 86.219 86.219 ↑ 1.0 172 1 / 3

Bitmap Index Scan on t_values_p2020_07_22_0007_id_parameter_refresh_time_idx (cost=0..19.97 rows=180 width=0) (actual time=258.658..258.658 rows=172 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
217. 1,587.103 1,784.632 ↓ 2.1 208 1 / 3

Bitmap Heap Scan on t_values_p2020_07_22_1100 tv_115 (cost=19.85..659.32 rows=100 width=14) (actual time=977.095..5,353.896 rows=208 loops=1)

  • Heap Blocks: exact=52
218. 197.529 197.529 ↓ 1.2 208 1 / 3

Bitmap Index Scan on t_values_p2020_07_22_1100_id_parameter_refresh_time_idx (cost=0..19.81 rows=170 width=0) (actual time=592.587..592.587 rows=208 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
219. 707.984 952.012 ↓ 1.7 128 1 / 3

Bitmap Heap Scan on t_values_p2020_07_23_2300 tv_151 (cost=19.35..504.55 rows=75 width=14) (actual time=799.229..2,856.037 rows=128 loops=1)

  • Heap Blocks: exact=32
220. 244.028 244.028 ↑ 1.0 128 1 / 3

Bitmap Index Scan on t_values_p2020_07_23_2300_id_parameter_refresh_time_idx (cost=0..19.32 rows=128 width=0) (actual time=732.084..732.084 rows=128 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
221. 1,025.917 1,118.086 ↓ 1.8 140 1 / 3

Bitmap Heap Scan on t_values_p2020_07_22_1000 tv_114 (cost=19.34..501.8 rows=76 width=14) (actual time=460.172..3,354.257 rows=140 loops=1)

  • Heap Blocks: exact=36
222. 92.168 92.168 ↓ 1.1 140 1 / 3

Bitmap Index Scan on t_values_p2020_07_22_1000_id_parameter_refresh_time_idx (cost=0..19.31 rows=130 width=0) (actual time=276.505..276.505 rows=140 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
223. 648.854 786.669 ↓ 1.7 108 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_1800 tv_53 (cost=19.08..394.99 rows=63 width=14) (actual time=529.988..2,360.008 rows=108 loops=1)

  • Heap Blocks: exact=27
224. 137.815 137.815 ↓ 1.0 108 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_1800_id_parameter_refresh_time_idx (cost=0..19.05 rows=107 width=0) (actual time=413.445..413.445 rows=108 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
225. 844.296 908.046 ↓ 1.8 104 1 / 3

Bitmap Heap Scan on t_values_p2020_07_21_0400 tv_87 (cost=18.97..374.31 rows=58 width=14) (actual time=402.85..2,724.138 rows=104 loops=1)

  • Heap Blocks: exact=26
226. 63.750 63.750 ↓ 1.1 104 1 / 3

Bitmap Index Scan on t_values_p2020_07_21_0400_id_parameter_refresh_time_idx (cost=0..18.95 rows=99 width=0) (actual time=191.25..191.25 rows=104 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
227. 397.380 452.810 ↓ 1.7 96 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_0700 tv_42 (cost=18.92..355.4 rows=55 width=14) (actual time=233.192..1,358.431 rows=96 loops=1)

  • Heap Blocks: exact=25
228. 55.430 55.430 ↓ 1.0 96 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_0700_id_parameter_refresh_time_idx (cost=0..18.9 rows=94 width=0) (actual time=166.29..166.29 rows=96 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
229. 304.505 333.863 ↓ 1.8 84 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_1300 tv_72 (cost=18.71..305.66 rows=48 width=14) (actual time=133.207..1,001.59 rows=84 loops=1)

  • Heap Blocks: exact=21
230. 29.359 29.359 ↓ 1.0 84 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_1300_id_parameter_refresh_time_idx (cost=0..18.69 rows=81 width=0) (actual time=88.076..88.076 rows=84 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
231. 196.798 222.697 ↓ 1.7 80 1 / 3

Bitmap Heap Scan on t_values_p2020_07_21_0800 tv_91 (cost=18.71..298.04 rows=46 width=14) (actual time=151.534..668.092 rows=80 loops=1)

  • Heap Blocks: exact=21
232. 25.899 25.899 ↓ 1.0 80 1 / 3

Bitmap Index Scan on t_values_p2020_07_21_0800_id_parameter_refresh_time_idx (cost=0..18.69 rows=78 width=0) (actual time=77.697..77.697 rows=80 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
233. 248.917 314.256 ↓ 1.7 76 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_0600 tv_65 (cost=18.66..303.01 rows=45 width=14) (actual time=267.705..942.767 rows=76 loops=1)

  • Heap Blocks: exact=19
234. 65.339 65.339 ↑ 1.0 76 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_0600_id_parameter_refresh_time_idx (cost=0..18.64 rows=76 width=0) (actual time=196.016..196.016 rows=76 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
235. 192.416 272.373 ↓ 1.6 36 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_1400 tv_73 (cost=18.14..158.09 rows=22 width=14) (actual time=357.261..817.118 rows=36 loops=1)

  • Heap Blocks: exact=10
236. 79.957 79.957 ↑ 1.1 36 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_1400_id_parameter_refresh_time_idx (cost=0..18.13 rows=38 width=0) (actual time=239.871..239.871 rows=36 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
237. 124.725 168.957 ↓ 1.6 36 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_0200 tv_37 (cost=18.14..150.75 rows=22 width=14) (actual time=211.777..506.871 rows=36 loops=1)

  • Heap Blocks: exact=10
238. 44.232 44.232 ↑ 1.0 36 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_0200_id_parameter_refresh_time_idx (cost=0..18.13 rows=37 width=0) (actual time=132.697..132.697 rows=36 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
239. 107.383 171.274 ↓ 2.4 40 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_2100 tv_32 (cost=18.04..120.71 rows=17 width=14) (actual time=237.976..513.821 rows=40 loops=1)

  • Heap Blocks: exact=10
240. 63.890 63.890 ↓ 1.4 40 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_2100_id_parameter_refresh_time_idx (cost=0..18.03 rows=29 width=0) (actual time=191.671..191.671 rows=40 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
241. 76.800 96.172 ↓ 1.6 24 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_2300 tv_34 (cost=17.99..107.17 rows=15 width=14) (actual time=132.276..288.517 rows=24 loops=1)

  • Heap Blocks: exact=6
242. 19.372 19.372 ↑ 1.0 24 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_2300_id_parameter_refresh_time_idx (cost=0..17.98 rows=25 width=0) (actual time=58.117..58.117 rows=24 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
243. 64.431 124.411 ↓ 1.1 16 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_1700 tv_52 (cost=17.99..102.84 rows=14 width=14) (actual time=213.191..373.232 rows=16 loops=1)

  • Heap Blocks: exact=5
244. 59.980 59.980 ↑ 1.5 16 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_1700_id_parameter_refresh_time_idx (cost=0..17.98 rows=24 width=0) (actual time=179.94..179.94 rows=16 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
245. 29.039 94.379 ↑ 3.8 4 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_2300 tv_58 (cost=17.98..104.09 rows=15 width=14) (actual time=283.135..283.137 rows=4 loops=1)

  • Heap Blocks: exact=1
246. 65.340 65.340 ↑ 6.2 4 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_2300_id_parameter_refresh_time_idx (cost=0..17.97 rows=25 width=0) (actual time=196.02..196.02 rows=4 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
247. 0.002 68.658 ↓ 0.0 0 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_0000 tv_59 (cost=17.98..97.17 rows=14 width=14) (actual time=205.975..205.975 rows=0 loops=1)

248. 68.656 68.656 ↓ 0.0 0 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_0000_id_parameter_refresh_time_idx (cost=0..17.97 rows=23 width=0) (actual time=205.968..205.968 rows=0 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
249. 100.636 126.620 ↓ 2.3 28 1 / 3

Bitmap Heap Scan on t_values_p2020_07_17_1500 tv_2 (cost=17.93..93.15 rows=12 width=14) (actual time=99.641..379.86 rows=28 loops=1)

  • Heap Blocks: exact=7
250. 25.984 25.984 ↓ 1.3 28 1 / 3

Bitmap Index Scan on t_values_p2020_07_17_1500_id_parameter_refresh_time_idx (cost=0..17.92 rows=21 width=0) (actual time=77.951..77.951 rows=28 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
251. 12.484 70.850 ↑ 3.0 4 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_0200 tv_61 (cost=17.93..90.61 rows=12 width=14) (actual time=212.549..212.551 rows=4 loops=1)

  • Heap Blocks: exact=1
252. 58.366 58.366 ↑ 5.2 4 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_0200_id_parameter_refresh_time_idx (cost=0..17.92 rows=21 width=0) (actual time=175.098..175.098 rows=4 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
253. 73.918 125.589 ↓ 2.3 28 1 / 3

Bitmap Heap Scan on t_values_p2020_07_18_2200 tv_33 (cost=17.93..88.54 rows=12 width=14) (actual time=228.625..376.767 rows=28 loops=1)

  • Heap Blocks: exact=7
254. 51.671 51.671 ↓ 1.4 28 1 / 3

Bitmap Index Scan on t_values_p2020_07_18_2200_id_parameter_refresh_time_idx (cost=0..17.92 rows=20 width=0) (actual time=155.013..155.013 rows=28 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
255. 0.002 25.652 ↓ 0.0 0 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_0300 tv_62 (cost=17.42..79.34 rows=11 width=14) (actual time=76.955..76.955 rows=0 loops=1)

256. 25.650 25.650 ↓ 0.0 0 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_0300_id_parameter_refresh_time_idx (cost=0..17.42 rows=18 width=0) (actual time=76.949..76.949 rows=0 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
257. 46.103 73.236 ↑ 2.2 4 1 / 3

Bitmap Heap Scan on t_values_p2020_07_20_0100 tv_60 (cost=17.37..69.83 rows=9 width=14) (actual time=219.704..219.707 rows=4 loops=1)

  • Heap Blocks: exact=1
258. 27.133 27.133 ↑ 3.8 4 1 / 3

Bitmap Index Scan on t_values_p2020_07_20_0100_id_parameter_refresh_time_idx (cost=0..17.37 rows=15 width=0) (actual time=81.399..81.399 rows=4 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
259. 14.377 29.795 ↑ 1.0 4 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_0000 tv_35 (cost=17.2..38.28 rows=4 width=14) (actual time=89.382..89.384 rows=4 loops=1)

  • Heap Blocks: exact=1
260. 15.418 15.418 ↑ 1.5 4 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_0000_id_parameter_refresh_time_idx (cost=0..17.2 rows=6 width=0) (actual time=46.253..46.253 rows=4 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
261. 228.129 301.318 ↓ 1.3 4 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_0100 tv_36 (cost=17.2..35.04 rows=3 width=14) (actual time=903.95..903.954 rows=4 loops=1)

  • Heap Blocks: exact=1
262. 73.189 73.189 ↑ 1.2 4 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_0100_id_parameter_refresh_time_idx (cost=0..17.2 rows=5 width=0) (actual time=219.566..219.566 rows=4 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
263. 0.112 16.425 ↓ 0.0 0 1 / 3

Bitmap Heap Scan on t_values_p2020_07_19_0300 tv_38 (cost=17.17..29.92 rows=2 width=14) (actual time=49.274..49.274 rows=0 loops=1)

264. 16.312 16.312 ↓ 0.0 0 1 / 3

Bitmap Index Scan on t_values_p2020_07_19_0300_id_parameter_refresh_time_idx (cost=0..17.17 rows=4 width=0) (actual time=48.937..48.937 rows=0 loops=1)

  • Index Cond: ((id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])) AND (refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
265. 8.557 8.557 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_17_1300_refresh_time_id_parameter_key on t_values_p2020_07_17_1300 tv (cost=0.14..8.16 rows=1 width=528) (actual time=25.672..25.672 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
266. 8.882 8.882 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_17_1400_refresh_time_id_parameter_key on t_values_p2020_07_17_1400 tv_1 (cost=0.14..8.16 rows=1 width=528) (actual time=26.645..26.645 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
267. 0.026 0.026 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_19_0400_refresh_time_id_parameter_key on t_values_p2020_07_19_0400 tv_39 (cost=0.14..8.16 rows=1 width=528) (actual time=0.077..0.077 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
268. 10.427 10.427 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_19_0500_refresh_time_id_parameter_key on t_values_p2020_07_19_0500 tv_40 (cost=0.14..8.16 rows=1 width=528) (actual time=31.28..31.28 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
269. 5.065 5.065 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_19_0600_refresh_time_id_parameter_key on t_values_p2020_07_19_0600 tv_41 (cost=0.14..8.16 rows=1 width=528) (actual time=15.195..15.195 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
270. 12.279 12.279 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_21_0500_refresh_time_id_parameter_key on t_values_p2020_07_21_0500 tv_88 (cost=0.14..8.16 rows=1 width=528) (actual time=36.837..36.837 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
271. 11.802 11.802 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_21_0600_refresh_time_id_parameter_key on t_values_p2020_07_21_0600 tv_89 (cost=0.14..8.16 rows=1 width=528) (actual time=35.406..35.406 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
272. 0.023 0.023 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_21_0700_refresh_time_id_parameter_key on t_values_p2020_07_21_0700 tv_90 (cost=0.14..8.16 rows=1 width=528) (actual time=0.069..0.07 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
273. 3.919 3.919 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_21_1300_refresh_time_id_parameter_key on t_values_p2020_07_21_1300 tv_96 (cost=0.14..8.16 rows=1 width=528) (actual time=11.756..11.756 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
274. 3.750 3.750 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_21_1400_refresh_time_id_parameter_key on t_values_p2020_07_21_1400 tv_97 (cost=0.14..8.16 rows=1 width=528) (actual time=11.25..11.25 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
275. 0.014 0.014 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_21_1500_refresh_time_id_parameter_key on t_values_p2020_07_21_1500 tv_98 (cost=0.14..8.16 rows=1 width=528) (actual time=0.043..0.043 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
276. 4.153 4.153 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_21_1600_refresh_time_id_parameter_key on t_values_p2020_07_21_1600 tv_99 (cost=0.14..8.16 rows=1 width=528) (actual time=12.458..12.458 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
277. 3.774 3.774 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_21_1700_refresh_time_id_parameter_key on t_values_p2020_07_21_1700 tv_100 (cost=0.14..8.16 rows=1 width=528) (actual time=11.322..11.322 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
278. 0.162 0.162 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_21_1800_refresh_time_id_parameter_key on t_values_p2020_07_21_1800 tv_101 (cost=0.14..8.16 rows=1 width=528) (actual time=0.487..0.487 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
279. 12.594 12.594 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_21_1900_refresh_time_id_parameter_key on t_values_p2020_07_21_1900 tv_102 (cost=0.14..8.16 rows=1 width=528) (actual time=37.781..37.781 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
280. 4.176 4.176 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_21_2000_refresh_time_id_parameter_key on t_values_p2020_07_21_2000 tv_103 (cost=0.14..8.16 rows=1 width=528) (actual time=12.527..12.527 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
281. 15.916 15.916 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_22_0000_refresh_time_id_parameter_key on t_values_p2020_07_22_0000 tv_104 (cost=0.14..8.16 rows=1 width=528) (actual time=47.749..47.749 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
282. 16.325 16.325 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_22_0001_refresh_time_id_parameter_key on t_values_p2020_07_22_0001 tv_105 (cost=0.14..8.16 rows=1 width=528) (actual time=48.975..48.975 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
283. 16.936 16.936 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_22_0002_refresh_time_id_parameter_key on t_values_p2020_07_22_0002 tv_106 (cost=0.14..8.16 rows=1 width=528) (actual time=50.808..50.808 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
284. 24.580 24.580 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_22_0003_refresh_time_id_parameter_key on t_values_p2020_07_22_0003 tv_107 (cost=0.14..8.16 rows=1 width=528) (actual time=73.739..73.739 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
285. 0.007 0.007 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_22_0004_refresh_time_id_parameter_key on t_values_p2020_07_22_0004 tv_108 (cost=0.14..8.16 rows=1 width=528) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
286. 0.006 0.006 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_22_0005_refresh_time_id_parameter_key on t_values_p2020_07_22_0005 tv_109 (cost=0.14..8.16 rows=1 width=528) (actual time=0.019..0.019 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
287. 0.016 0.016 ↓ 0.0 0 1 / 3

Index Scan using t_values_p2020_07_22_0006_refresh_time_id_parameter_key on t_values_p2020_07_22_0006 tv_110 (cost=0.14..8.16 rows=1 width=528) (actual time=0.047..0.047 rows=0 loops=1)

  • Index Cond: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone))
  • Filter: (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[]))
288. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on t_values_default tv_152 (cost=0..28.82 rows=1 width=14) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((refresh_time >= '2020-07-17 00:00:00'::timestamp without time zone) AND (refresh_time <= '2020-07-23 23:32:00'::timestamp without time zone) AND (id_parameter = ANY ('{1404,1405,1406,1407}'::integer[])))
289. 43.587 43.587 ↑ 1.0 1 26,152 / 3

Index Scan using t_parameters_pkey on t_parameters tp (cost=0.41..7.29 rows=1 width=12) (actual time=0.005..0.005 rows=1 loops=26,152)

  • Index Cond: (id_parameter = tv_143.id_parameter)
Planning time : 26,806.51 ms
Execution time : 158,924.151 ms