explain.depesz.com

PostgreSQL's explain analyze made readable

Result: avkM

Settings
# exclusive inclusive rows x rows loops node
1. 957,566.318 2,710,877.805 ↓ 32.3 32,731,234 1

GroupAggregate (cost=360,671,207.00..371,484,032.99 rows=1,013,861 width=40) (actual time=1,581,750.644..2,710,877.805 rows=32,731,234 loops=1)

  • Group Key: "values".datetime
2. 1,237,755.725 1,753,311.487 ↓ 1.0 1,440,271,096 1

Sort (cost=360,671,207.00..364,271,257.91 rows=1,440,020,364 width=20) (actual time=1,581,714.507..1,753,311.487 rows=1,440,271,096 loops=1)

  • Sort Key: "values".datetime
  • Sort Method: external merge Disk: 42278248kB
3. 55,193.975 515,555.762 ↓ 1.0 1,440,271,096 1

Append (cost=0.00..107,025,084.40 rows=1,440,020,364 width=20) (actual time=40.193..515,555.762 rows=1,440,271,096 loops=1)

4. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on "values" (cost=0.00..0.00 rows=1 width=20) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
5. 2,339.595 2,339.595 ↑ 1.0 10,368,004 1

Seq Scan on _hyper_3_274_chunk (cost=0.00..751,825.65 rows=10,373,453 width=20) (actual time=40.190..2,339.595 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 166129
6. 1,551.579 1,551.579 ↑ 1.0 5,184,002 1

Seq Scan on _hyper_3_275_chunk (cost=0.00..396,085.85 rows=5,186,443 width=20) (actual time=91.969..1,551.579 rows=5,184,002 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 365488
7. 2,453.278 2,453.278 ↑ 1.0 10,368,004 1

Seq Scan on _hyper_3_276_chunk (cost=0.00..766,068.22 rows=10,373,319 width=20) (actual time=96.126..2,453.278 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 365384
8. 3,860.158 3,860.158 ↑ 1.0 15,552,006 1

Seq Scan on _hyper_3_277_chunk (cost=0.00..1,119,959.06 rows=15,553,439 width=20) (actual time=35.693..3,860.158 rows=15,552,006 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 139518
9. 430.737 634.568 ↑ 1.0 2,592,001 1

Bitmap Heap Scan on _hyper_3_278_chunk (cost=29,564.02..217,946.62 rows=2,595,040 width=20) (actual time=205.569..634.568 rows=2,592,001 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=16510
10. 203.831 203.831 ↑ 1.0 2,592,001 1

Bitmap Index Scan on _hyper_3_278_chunk_values_variable_id_datetime (cost=0.00..28,915.26 rows=2,595,040 width=0) (actual time=203.831..203.831 rows=2,592,001 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
11. 2,256.610 2,256.610 ↑ 1.0 10,368,004 1

Seq Scan on _hyper_3_279_chunk (cost=0.00..763,496.35 rows=10,381,004 width=20) (actual time=70.853..2,256.610 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 329063
12. 2,419.105 2,419.105 ↑ 1.0 10,368,004 1

Seq Scan on _hyper_3_280_chunk (cost=0.00..753,034.31 rows=10,371,834 width=20) (actual time=45.059..2,419.105 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 182770
13. 3,748.277 3,748.277 ↓ 1.0 23,328,009 1

Seq Scan on _hyper_3_281_chunk (cost=0.00..1,675,579.48 rows=23,327,606 width=20) (actual time=0.013..3,748.277 rows=23,328,009 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 149384
14. 3,306.265 3,306.265 ↑ 1.0 15,552,006 1

Seq Scan on _hyper_3_282_chunk (cost=0.00..1,137,224.02 rows=15,555,973 width=20) (actual time=97.368..3,306.265 rows=15,552,006 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 382025
15. 2,405.992 2,405.992 ↑ 1.0 10,368,004 1

Seq Scan on _hyper_3_283_chunk (cost=0.00..766,053.84 rows=10,370,118 width=20) (actual time=85.970..2,405.992 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 365332
16. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on _hyper_3_284_chunk (cost=0.00..3.60 rows=27 width=20) (actual time=0.013..0.013 rows=0 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 40
17. 0.306 0.306 ↓ 0.0 0 1

Seq Scan on _hyper_3_285_chunk (cost=0.00..1.00 rows=1 width=20) (actual time=0.306..0.306 rows=0 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
18. 0.284 0.284 ↓ 0.0 0 1

Seq Scan on _hyper_3_286_chunk (cost=0.00..2.30 rows=18 width=20) (actual time=0.284..0.284 rows=0 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 20
19. 0.361 0.361 ↓ 0.0 0 1

Seq Scan on _hyper_3_287_chunk (cost=0.00..2.95 rows=23 width=20) (actual time=0.361..0.361 rows=0 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 30
20. 0.166 0.166 ↓ 0.0 0 1

Seq Scan on _hyper_3_288_chunk (cost=0.00..1.65 rows=10 width=20) (actual time=0.166..0.166 rows=0 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 10
21. 0.295 0.295 ↓ 0.0 0 1

Seq Scan on _hyper_3_289_chunk (cost=0.00..1.65 rows=10 width=20) (actual time=0.295..0.295 rows=0 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 10
22. 0.015 0.015 ↓ 0.0 0 1

Index Scan using _hyper_3_290_chunk_values_variable_id_datetime on _hyper_3_290_chunk (cost=0.15..9.25 rows=1 width=20) (actual time=0.015..0.015 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
23. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_3_291_chunk_values_variable_id_datetime on _hyper_3_291_chunk (cost=0.15..8.63 rows=1 width=20) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
24. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_3_292_chunk_values_variable_id_datetime on _hyper_3_292_chunk (cost=0.15..8.63 rows=1 width=20) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
25. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_3_293_chunk_values_variable_id_datetime on _hyper_3_293_chunk (cost=0.15..9.25 rows=1 width=20) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
26. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_3_294_chunk_values_variable_id_datetime on _hyper_3_294_chunk (cost=0.15..8.63 rows=1 width=20) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
27. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_3_295_chunk_values_variable_id_datetime on _hyper_3_295_chunk (cost=0.15..8.63 rows=1 width=20) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
28. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_3_296_chunk_values_variable_id_datetime on _hyper_3_296_chunk (cost=0.15..9.09 rows=1 width=20) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
29. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_3_297_chunk_values_variable_id_datetime on _hyper_3_297_chunk (cost=0.15..8.63 rows=1 width=20) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
30. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_3_298_chunk_values_variable_id_datetime on _hyper_3_298_chunk (cost=0.15..8.63 rows=1 width=20) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
31. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_3_299_chunk_values_variable_id_datetime on _hyper_3_299_chunk (cost=0.15..9.09 rows=1 width=20) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
32. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_3_300_chunk_values_variable_id_datetime on _hyper_3_300_chunk (cost=0.15..8.63 rows=1 width=20) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
33. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_3_301_chunk_values_variable_id_datetime on _hyper_3_301_chunk (cost=0.15..8.63 rows=1 width=20) (actual time=0.007..0.008 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
34. 0.007 0.007 ↓ 0.0 0 1

Index Scan using _hyper_3_302_chunk_values_variable_id_datetime on _hyper_3_302_chunk (cost=0.15..9.10 rows=1 width=20) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
35. 0.485 0.485 ↓ 0.0 0 1

Index Scan using _hyper_3_303_chunk_values_variable_id_datetime on _hyper_3_303_chunk (cost=0.28..53.84 rows=1 width=20) (actual time=0.485..0.485 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
36. 0.339 0.339 ↓ 0.0 0 1

Index Scan using _hyper_3_304_chunk_values_variable_id_datetime on _hyper_3_304_chunk (cost=0.28..53.84 rows=1 width=20) (actual time=0.338..0.339 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
37. 0.239 0.239 ↓ 0.0 0 1

Index Scan using _hyper_3_305_chunk_values_variable_id_datetime on _hyper_3_305_chunk (cost=0.28..53.32 rows=1 width=20) (actual time=0.239..0.239 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
38. 0.202 0.202 ↓ 0.0 0 1

Index Scan using _hyper_3_306_chunk_values_variable_id_datetime on _hyper_3_306_chunk (cost=0.28..53.84 rows=1 width=20) (actual time=0.202..0.202 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
39. 0.201 0.201 ↓ 0.0 0 1

Index Scan using _hyper_3_307_chunk_values_variable_id_datetime on _hyper_3_307_chunk (cost=0.28..53.32 rows=1 width=20) (actual time=0.201..0.201 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
40. 0.403 0.403 ↓ 0.0 0 1

Index Scan using _hyper_3_308_chunk_values_variable_id_datetime on _hyper_3_308_chunk (cost=0.42..66.60 rows=1 width=20) (actual time=0.403..0.403 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
41. 0.402 0.402 ↓ 0.0 0 1

Index Scan using _hyper_3_309_chunk_values_variable_id_datetime on _hyper_3_309_chunk (cost=0.42..68.27 rows=1 width=20) (actual time=0.402..0.402 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
42. 0.383 0.383 ↓ 0.0 0 1

Index Scan using _hyper_3_310_chunk_values_variable_id_datetime on _hyper_3_310_chunk (cost=0.42..68.15 rows=1 width=20) (actual time=0.383..0.383 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
43. 0.402 0.402 ↓ 0.0 0 1

Index Scan using _hyper_3_311_chunk_values_variable_id_datetime on _hyper_3_311_chunk (cost=0.42..68.54 rows=1 width=20) (actual time=0.402..0.402 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
44. 0.229 0.229 ↓ 0.0 0 1

Index Scan using _hyper_3_312_chunk_values_variable_id_datetime on _hyper_3_312_chunk (cost=0.29..57.58 rows=1 width=20) (actual time=0.229..0.229 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
45. 0.393 0.393 ↓ 0.0 0 1

Index Scan using _hyper_3_313_chunk_values_variable_id_datetime on _hyper_3_313_chunk (cost=0.42..68.30 rows=1 width=20) (actual time=0.393..0.393 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
46. 0.030 0.030 ↓ 0.0 0 1

Index Scan using _hyper_3_314_chunk_values_variable_id_datetime on _hyper_3_314_chunk (cost=0.42..66.60 rows=1 width=20) (actual time=0.030..0.030 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
47. 0.482 0.482 ↓ 0.0 0 1

Index Scan using _hyper_3_315_chunk_values_variable_id_datetime on _hyper_3_315_chunk (cost=0.42..68.36 rows=1 width=20) (actual time=0.482..0.482 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
48. 0.287 0.287 ↓ 0.0 0 1

Index Scan using _hyper_3_316_chunk_values_variable_id_datetime on _hyper_3_316_chunk (cost=0.42..68.28 rows=1 width=20) (actual time=0.287..0.287 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
49. 0.463 0.463 ↓ 0.0 0 1

Index Scan using _hyper_3_317_chunk_values_variable_id_datetime on _hyper_3_317_chunk (cost=0.42..68.52 rows=1 width=20) (actual time=0.463..0.463 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
50. 0.009 0.009 ↓ 0.0 0 1

Index Scan using _hyper_3_318_chunk_values_variable_id_datetime on _hyper_3_318_chunk (cost=0.15..8.63 rows=1 width=20) (actual time=0.008..0.009 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
51. 0.400 0.400 ↓ 0.0 0 1

Index Scan using _hyper_3_319_chunk_values_variable_id_datetime on _hyper_3_319_chunk (cost=0.42..68.36 rows=1 width=20) (actual time=0.400..0.400 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
52. 0.198 0.198 ↓ 0.0 0 1

Index Scan using _hyper_3_320_chunk_values_variable_id_datetime on _hyper_3_320_chunk (cost=0.29..57.58 rows=1 width=20) (actual time=0.198..0.198 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
53. 0.305 0.305 ↓ 0.0 0 1

Index Scan using _hyper_3_321_chunk_values_variable_id_datetime on _hyper_3_321_chunk (cost=0.42..67.04 rows=1 width=20) (actual time=0.305..0.305 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
54. 0.323 0.323 ↓ 0.0 0 1

Index Scan using _hyper_3_322_chunk_values_variable_id_datetime on _hyper_3_322_chunk (cost=0.42..65.86 rows=1 width=20) (actual time=0.323..0.323 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
55. 0.328 0.328 ↓ 0.0 0 1

Index Scan using _hyper_3_323_chunk_values_variable_id_datetime on _hyper_3_323_chunk (cost=0.42..67.19 rows=1 width=20) (actual time=0.328..0.328 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
56. 0.008 0.008 ↓ 0.0 0 1

Index Scan using _hyper_3_324_chunk_values_variable_id_datetime on _hyper_3_324_chunk (cost=0.15..8.63 rows=1 width=20) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
57. 0.336 0.336 ↓ 0.0 0 1

Index Scan using _hyper_3_325_chunk_values_variable_id_datetime on _hyper_3_325_chunk (cost=0.42..67.04 rows=1 width=20) (actual time=0.336..0.336 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
58. 0.024 0.024 ↓ 0.0 0 1

Index Scan using _hyper_3_326_chunk_values_variable_id_datetime on _hyper_3_326_chunk (cost=0.29..58.20 rows=1 width=20) (actual time=0.024..0.024 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
59. 0.401 0.401 ↓ 0.0 0 1

Index Scan using _hyper_3_327_chunk_values_variable_id_datetime on _hyper_3_327_chunk (cost=0.42..66.01 rows=1 width=20) (actual time=0.401..0.401 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
60. 0.315 0.315 ↓ 0.0 0 1

Index Scan using _hyper_3_328_chunk_values_variable_id_datetime on _hyper_3_328_chunk (cost=0.41..64.80 rows=1 width=20) (actual time=0.315..0.315 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
61. 0.300 0.300 ↓ 0.0 0 1

Index Scan using _hyper_3_329_chunk_values_variable_id_datetime on _hyper_3_329_chunk (cost=0.42..67.11 rows=1 width=20) (actual time=0.300..0.300 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
62. 0.198 0.198 ↓ 0.0 0 1

Index Scan using _hyper_3_330_chunk_values_variable_id_datetime on _hyper_3_330_chunk (cost=0.29..56.95 rows=1 width=20) (actual time=0.198..0.198 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
63. 0.456 0.456 ↓ 0.0 0 1

Index Scan using _hyper_3_331_chunk_values_variable_id_datetime on _hyper_3_331_chunk (cost=0.42..65.70 rows=1 width=20) (actual time=0.456..0.456 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
64. 0.199 0.199 ↓ 0.0 0 1

Index Scan using _hyper_3_332_chunk_values_variable_id_datetime on _hyper_3_332_chunk (cost=0.29..58.13 rows=1 width=20) (actual time=0.199..0.199 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
65. 0.214 0.214 ↓ 0.0 0 1

Index Scan using _hyper_3_333_chunk_values_variable_id_datetime on _hyper_3_333_chunk (cost=0.29..56.84 rows=1 width=20) (actual time=0.214..0.214 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
66. 0.229 0.229 ↓ 0.0 0 1

Index Scan using _hyper_3_334_chunk_values_variable_id_datetime on _hyper_3_334_chunk (cost=0.29..56.84 rows=1 width=20) (actual time=0.229..0.229 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
67. 0.211 0.211 ↓ 0.0 0 1

Index Scan using _hyper_3_335_chunk_values_variable_id_datetime on _hyper_3_335_chunk (cost=0.29..55.16 rows=1 width=20) (actual time=0.211..0.211 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
68. 0.339 0.339 ↓ 0.0 0 1

Index Scan using _hyper_3_336_chunk_values_variable_id_datetime on _hyper_3_336_chunk (cost=0.41..63.66 rows=1 width=20) (actual time=0.339..0.339 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
69. 0.322 0.322 ↓ 0.0 0 1

Index Scan using _hyper_3_337_chunk_values_variable_id_datetime on _hyper_3_337_chunk (cost=0.41..63.66 rows=1 width=20) (actual time=0.322..0.322 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
70. 0.029 0.029 ↓ 0.0 0 1

Index Scan using _hyper_3_338_chunk_values_variable_id_datetime on _hyper_3_338_chunk (cost=0.42..64.84 rows=1 width=20) (actual time=0.029..0.029 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
71. 0.216 0.216 ↓ 0.0 0 1

Index Scan using _hyper_3_339_chunk_values_variable_id_datetime on _hyper_3_339_chunk (cost=0.29..58.05 rows=1 width=20) (actual time=0.216..0.216 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
72. 0.217 0.217 ↓ 0.0 0 1

Index Scan using _hyper_3_340_chunk_values_variable_id_datetime on _hyper_3_340_chunk (cost=0.29..58.05 rows=1 width=20) (actual time=0.217..0.217 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
73. 0.207 0.207 ↓ 0.0 0 1

Index Scan using _hyper_3_341_chunk_values_variable_id_datetime on _hyper_3_341_chunk (cost=0.29..55.27 rows=1 width=20) (actual time=0.206..0.207 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
74. 0.340 0.340 ↓ 0.0 0 1

Index Scan using _hyper_3_342_chunk_values_variable_id_datetime on _hyper_3_342_chunk (cost=0.42..65.97 rows=1 width=20) (actual time=0.340..0.340 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
75. 0.433 0.433 ↓ 0.0 0 1

Index Scan using _hyper_3_343_chunk_values_variable_id_datetime on _hyper_3_343_chunk (cost=0.42..65.97 rows=1 width=20) (actual time=0.433..0.433 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
76. 0.020 0.020 ↓ 0.0 0 1

Index Scan using _hyper_3_344_chunk_values_variable_id_datetime on _hyper_3_344_chunk (cost=0.28..52.08 rows=1 width=20) (actual time=0.020..0.020 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
77. 0.306 0.306 ↓ 0.0 0 1

Index Scan using _hyper_3_345_chunk_values_variable_id_datetime on _hyper_3_345_chunk (cost=0.28..48.69 rows=1 width=20) (actual time=0.306..0.306 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
78. 0.267 0.267 ↓ 0.0 0 1

Index Scan using _hyper_3_346_chunk_values_variable_id_datetime on _hyper_3_346_chunk (cost=0.28..48.69 rows=1 width=20) (actual time=0.267..0.267 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
79. 0.356 0.356 ↓ 0.0 0 1

Seq Scan on _hyper_3_347_chunk (cost=0.00..40.20 rows=1 width=20) (actual time=0.356..0.356 rows=0 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 557
80. 0.247 0.247 ↓ 0.0 0 1

Index Scan using _hyper_3_348_chunk_values_variable_id_datetime on _hyper_3_348_chunk (cost=0.28..54.42 rows=1 width=20) (actual time=0.247..0.247 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
81. 0.227 0.227 ↓ 0.0 0 1

Index Scan using _hyper_3_349_chunk_values_variable_id_datetime on _hyper_3_349_chunk (cost=0.28..54.42 rows=1 width=20) (actual time=0.227..0.227 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
82. 0.028 0.028 ↓ 0.0 0 1

Index Scan using _hyper_3_350_chunk_values_variable_id_datetime on _hyper_3_350_chunk (cost=0.42..65.94 rows=1 width=20) (actual time=0.028..0.028 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
83. 0.306 0.306 ↓ 0.0 0 1

Index Scan using _hyper_3_351_chunk_values_variable_id_datetime on _hyper_3_351_chunk (cost=0.42..64.76 rows=1 width=20) (actual time=0.306..0.306 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
84. 0.338 0.338 ↓ 0.0 0 1

Index Scan using _hyper_3_352_chunk_values_variable_id_datetime on _hyper_3_352_chunk (cost=0.42..64.76 rows=1 width=20) (actual time=0.338..0.338 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
85. 0.343 0.343 ↓ 0.0 0 1

Index Scan using _hyper_3_353_chunk_values_variable_id_datetime on _hyper_3_353_chunk (cost=0.29..56.48 rows=1 width=20) (actual time=0.343..0.343 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
86. 0.333 0.333 ↓ 0.0 0 1

Index Scan using _hyper_3_354_chunk_values_variable_id_datetime on _hyper_3_354_chunk (cost=0.42..67.18 rows=1 width=20) (actual time=0.333..0.333 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
87. 0.317 0.317 ↓ 0.0 0 1

Index Scan using _hyper_3_355_chunk_values_variable_id_datetime on _hyper_3_355_chunk (cost=0.42..67.18 rows=1 width=20) (actual time=0.317..0.317 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
88. 0.029 0.029 ↓ 0.0 0 1

Index Scan using _hyper_3_356_chunk_values_variable_id_datetime on _hyper_3_356_chunk (cost=0.42..67.04 rows=1 width=20) (actual time=0.029..0.029 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
89. 0.385 0.385 ↓ 0.0 0 1

Index Scan using _hyper_3_357_chunk_values_variable_id_datetime on _hyper_3_357_chunk (cost=0.42..65.86 rows=1 width=20) (actual time=0.385..0.385 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
90. 0.334 0.334 ↓ 0.0 0 1

Index Scan using _hyper_3_358_chunk_values_variable_id_datetime on _hyper_3_358_chunk (cost=0.42..65.86 rows=1 width=20) (actual time=0.334..0.334 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
91. 0.214 0.214 ↓ 0.0 0 1

Index Scan using _hyper_3_359_chunk_values_variable_id_datetime on _hyper_3_359_chunk (cost=0.29..57.58 rows=1 width=20) (actual time=0.214..0.214 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
92. 0.396 0.396 ↓ 0.0 0 1

Index Scan using _hyper_3_360_chunk_values_variable_id_datetime on _hyper_3_360_chunk (cost=0.42..67.22 rows=1 width=20) (actual time=0.396..0.396 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
93. 0.322 0.322 ↓ 0.0 0 1

Index Scan using _hyper_3_361_chunk_values_variable_id_datetime on _hyper_3_361_chunk (cost=0.42..67.18 rows=1 width=20) (actual time=0.322..0.322 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
94. 9.160 12.591 ↑ 1.0 85,092 1

Bitmap Heap Scan on _hyper_3_362_chunk (cost=1,016.02..7,904.64 rows=85,148 width=20) (actual time=3.643..12.591 rows=85,092 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=543
95. 3.431 3.431 ↑ 1.0 85,092 1

Bitmap Index Scan on _hyper_3_362_chunk_values_variable_id_datetime (cost=0.00..994.73 rows=85,148 width=0) (actual time=3.431..3.431 rows=85,092 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
96. 10.464 14.315 ↑ 1.0 56,728 1

Bitmap Heap Scan on _hyper_3_363_chunk (cost=670.33..5,260.65 rows=56,728 width=20) (actual time=4.180..14.315 rows=56,728 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=363
97. 3.851 3.851 ↑ 1.0 56,728 1

Bitmap Index Scan on _hyper_3_363_chunk_values_variable_id_datetime (cost=0.00..656.15 rows=56,728 width=0) (actual time=3.851..3.851 rows=56,728 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
98. 15.445 22.755 ↓ 1.0 85,092 1

Bitmap Heap Scan on _hyper_3_364_chunk (cost=1,012.80..7,622.68 rows=85,029 width=20) (actual time=7.560..22.755 rows=85,092 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=543
99. 7.310 7.310 ↓ 1.0 85,092 1

Bitmap Index Scan on _hyper_3_364_chunk_values_variable_id_datetime (cost=0.00..991.54 rows=85,029 width=0) (actual time=7.310..7.310 rows=85,092 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
100. 10.079 14.891 ↑ 1.0 56,728 1

Bitmap Heap Scan on _hyper_3_365_chunk (cost=707.62..5,026.94 rows=56,728 width=20) (actual time=5.040..14.891 rows=56,728 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=362
101. 4.812 4.812 ↑ 1.0 56,728 1

Bitmap Index Scan on _hyper_3_365_chunk_values_variable_id_datetime (cost=0.00..693.44 rows=56,728 width=0) (actual time=4.812..4.812 rows=56,728 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
102. 10.288 15.839 ↑ 1.0 56,728 1

Bitmap Heap Scan on _hyper_3_366_chunk (cost=675.41..5,811.93 rows=56,808 width=20) (actual time=5.838..15.839 rows=56,728 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=363
103. 5.551 5.551 ↑ 1.0 56,728 1

Bitmap Index Scan on _hyper_3_366_chunk_values_variable_id_datetime (cost=0.00..661.21 rows=56,808 width=0) (actual time=5.551..5.551 rows=56,728 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
104. 6.465 9.857 ↓ 1.0 56,728 1

Bitmap Heap Scan on _hyper_3_367_chunk (cost=674.39..5,801.61 rows=56,665 width=20) (actual time=3.611..9.857 rows=56,728 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=363
105. 3.392 3.392 ↓ 1.0 56,728 1

Bitmap Index Scan on _hyper_3_367_chunk_values_variable_id_datetime (cost=0.00..660.22 rows=56,665 width=0) (actual time=3.392..3.392 rows=56,728 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
106. 1,194.844 1,194.844 ↑ 1.0 307,596 1

Seq Scan on _hyper_3_368_chunk (cost=0.00..23,100.55 rows=307,599 width=20) (actual time=3.571..1,194.844 rows=307,596 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 16074
107. 49.102 49.102 ↓ 1.0 205,064 1

Seq Scan on _hyper_3_369_chunk (cost=0.00..15,400.70 rows=204,958 width=20) (actual time=2.725..49.102 rows=205,064 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 10716
108. 62.284 62.284 ↓ 1.0 307,596 1

Seq Scan on _hyper_3_370_chunk (cost=0.00..22,718.28 rows=307,551 width=20) (actual time=3.045..62.284 rows=307,596 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 10716
109. 42.498 42.498 ↑ 1.0 205,064 1

Seq Scan on _hyper_3_371_chunk (cost=0.00..15,018.43 rows=205,094 width=20) (actual time=1.877..42.498 rows=205,064 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 5358
110. 52.750 52.750 ↑ 1.0 205,064 1

Seq Scan on _hyper_3_372_chunk (cost=0.00..16,165.24 rows=205,094 width=20) (actual time=4.111..52.750 rows=205,064 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 21432
111. 37.182 37.182 ↑ 1.0 205,064 1

Seq Scan on _hyper_3_373_chunk (cost=0.00..16,165.24 rows=205,144 width=20) (actual time=5.437..37.182 rows=205,064 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 21432
112. 1,159.894 1,159.894 ↑ 1.0 4,864,312 1

Seq Scan on _hyper_3_374_chunk (cost=0.00..364,397.97 rows=4,867,130 width=20) (actual time=60.902..1,159.894 rows=4,864,312 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 241426
113. 1,474.503 1,474.503 ↓ 1.0 7,296,468 1

Seq Scan on _hyper_3_375_chunk (cost=0.00..532,293.01 rows=7,294,674 width=20) (actual time=34.238..1,474.503 rows=7,296,468 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 161686
114. 197.383 289.180 ↑ 1.0 1,216,078 1

Bitmap Heap Scan on _hyper_3_376_chunk (cost=13,892.63..104,144.14 rows=1,216,454 width=20) (actual time=92.691..289.180 rows=1,216,078 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=7747
115. 91.797 91.797 ↑ 1.0 1,216,078 1

Bitmap Index Scan on _hyper_3_376_chunk_values_variable_id_datetime (cost=0.00..13,588.52 rows=1,216,454 width=0) (actual time=91.797..91.797 rows=1,216,078 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
116. 1,157.904 1,157.904 ↓ 1.0 4,864,312 1

Seq Scan on _hyper_3_377_chunk (cost=0.00..371,100.36 rows=4,864,011 width=20) (actual time=70.861..1,157.904 rows=4,864,312 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 335355
117. 1,074.221 1,074.221 ↑ 1.0 4,864,312 1

Seq Scan on _hyper_3_378_chunk (cost=0.00..376,695.52 rows=4,867,450 width=20) (actual time=97.842..1,074.221 rows=4,864,312 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 413696
118. 688.302 688.302 ↓ 1.0 2,432,156 1

Seq Scan on _hyper_3_379_chunk (cost=0.00..205,437.16 rows=2,431,554 width=20) (actual time=105.271..688.302 rows=2,432,156 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 446308
119. 2,350.959 2,350.959 ↑ 1.0 7,296,468 1

Seq Scan on _hyper_3_380_chunk (cost=0.00..547,713.63 rows=7,300,565 width=20) (actual time=91.688..2,350.959 rows=7,296,468 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 377834
120. 2,265.529 2,265.529 ↑ 1.0 10,944,702 1

Seq Scan on _hyper_3_381_chunk (cost=0.00..792,299.27 rows=10,944,977 width=20) (actual time=36.938..2,265.529 rows=10,944,702 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 156656
121. 925.662 925.662 ↓ 1.0 4,864,312 1

Seq Scan on _hyper_3_382_chunk (cost=0.00..363,998.90 rows=4,863,977 width=20) (actual time=43.793..925.662 rows=4,864,312 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 235871
122. 969.279 969.279 ↓ 1.0 4,864,312 1

Seq Scan on _hyper_3_383_chunk (cost=0.00..373,750.64 rows=4,862,735 width=20) (actual time=88.616..969.279 rows=4,864,312 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 372467
123. 5,527.582 5,527.582 ↓ 1.0 23,328,009 1

Seq Scan on _hyper_3_384_chunk (cost=0.00..1,694,725.52 rows=23,313,476 width=20) (actual time=95.472..5,527.582 rows=23,328,009 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 417799
124. 3,199.316 3,199.316 ↑ 1.0 15,552,006 1

Seq Scan on _hyper_3_385_chunk (cost=0.00..1,141,502.68 rows=15,554,964 width=20) (actual time=98.835..3,199.316 rows=15,552,006 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 442266
125. 1,373.317 1,373.317 ↑ 1.0 5,184,002 1

Seq Scan on _hyper_3_386_chunk (cost=0.00..419,399.71 rows=5,187,462 width=20) (actual time=159.344..1,373.317 rows=5,184,002 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 692455
126. 5,811.701 5,811.701 ↓ 1.0 10,368,004 1

Seq Scan on _hyper_3_387_chunk (cost=0.00..785,286.34 rows=10,367,720 width=20) (actual time=153.847..5,811.701 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 635109
127. 2,033.521 2,033.521 ↑ 1.0 10,368,004 1

Seq Scan on _hyper_3_388_chunk (cost=0.00..785,763.61 rows=10,372,402 width=20) (actual time=144.047..2,033.521 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 641790
128. 1,970.016 1,970.016 ↑ 1.0 10,368,004 1

Seq Scan on _hyper_3_389_chunk (cost=0.00..772,336.35 rows=10,369,682 width=20) (actual time=108.162..1,970.016 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 453663
129. 6,958.958 6,958.958 ↑ 1.0 5,184,002 1

Seq Scan on _hyper_3_390_chunk (cost=0.00..427,361.39 rows=5,186,132 width=20) (actual time=187.620..6,958.958 rows=5,184,002 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 804004
130. 3,245.748 3,245.748 ↑ 1.0 15,552,006 1

Seq Scan on _hyper_3_391_chunk (cost=0.00..1,155,732.38 rows=15,559,509 width=20) (actual time=152.594..3,245.748 rows=15,552,006 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 641646
131. 8,059.898 8,059.898 ↑ 1.0 10,368,004 1

Seq Scan on _hyper_3_392_chunk (cost=0.00..786,691.20 rows=10,372,237 width=20) (actual time=162.169..8,059.898 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 654799
132. 2,155.832 2,155.832 ↓ 1.0 10,368,004 1

Seq Scan on _hyper_3_393_chunk (cost=0.00..797,073.81 rows=10,355,972 width=20) (actual time=223.495..2,155.832 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 800270
133. 400.126 616.053 ↑ 1.0 2,592,001 1

Bitmap Heap Scan on _hyper_3_394_chunk (cost=29,592.71..221,846.53 rows=2,593,628 width=20) (actual time=221.616..616.053 rows=2,592,001 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=16510
134. 215.927 215.927 ↑ 1.0 2,592,001 1

Bitmap Index Scan on _hyper_3_394_chunk_values_variable_id_datetime (cost=0.00..28,944.30 rows=2,593,628 width=0) (actual time=215.927..215.927 rows=2,592,001 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
135. 2,379.247 2,379.247 ↑ 1.0 10,368,004 1

Seq Scan on _hyper_3_395_chunk (cost=0.00..810,330.17 rows=10,368,115 width=20) (actual time=233.201..2,379.247 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 986014
136. 2,593.302 2,593.302 ↑ 1.0 10,368,004 1

Seq Scan on _hyper_3_396_chunk (cost=0.00..797,582.33 rows=10,375,023 width=20) (actual time=219.270..2,593.302 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 807401
137. 8,998.217 8,998.217 ↑ 1.0 15,552,006 1

Seq Scan on _hyper_3_397_chunk (cost=0.00..1,179,923.26 rows=15,565,014 width=20) (actual time=239.426..8,998.217 rows=15,552,006 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 980598
138. 4,786.521 4,786.521 ↓ 1.0 23,328,009 1

Seq Scan on _hyper_3_398_chunk (cost=0.00..1,709,260.55 rows=23,324,549 width=20) (actual time=153.473..4,786.521 rows=23,328,009 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 621461
139. 7,809.486 7,809.486 ↓ 1.0 10,368,004 1

Seq Scan on _hyper_3_399_chunk (cost=0.00..786,533.48 rows=10,364,353 width=20) (actual time=156.996..7,809.486 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 652588
140. 2,417.947 2,417.947 ↑ 1.0 10,368,004 1

Seq Scan on _hyper_3_400_chunk (cost=0.00..772,421.12 rows=10,370,237 width=20) (actual time=109.020..2,417.947 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 454844
141. 396.411 584.167 ↓ 1.0 2,592,001 1

Bitmap Heap Scan on _hyper_3_401_chunk (cost=29,502.93..219,942.94 rows=2,589,154 width=20) (actual time=189.651..584.167 rows=2,592,001 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=16511
142. 187.756 187.756 ↓ 1.0 2,592,001 1

Bitmap Index Scan on _hyper_3_401_chunk_values_variable_id_datetime (cost=0.00..28,855.64 rows=2,589,154 width=0) (actual time=187.756..187.756 rows=2,592,001 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
143. 2,218.412 2,218.412 ↑ 1.0 10,368,004 1

Seq Scan on _hyper_3_402_chunk (cost=0.00..793,072.59 rows=10,382,285 width=20) (actual time=167.055..2,218.412 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 744205
144. 9,134.334 9,134.334 ↓ 1.0 15,552,006 1

Seq Scan on _hyper_3_403_chunk (cost=0.00..1,165,147.18 rows=15,549,788 width=20) (actual time=181.456..9,134.334 rows=15,552,006 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 773566
145. 1,316.498 1,316.498 ↑ 1.0 5,184,002 1

Seq Scan on _hyper_3_404_chunk (cost=0.00..400,812.82 rows=5,188,087 width=20) (actual time=104.136..1,316.498 rows=5,184,002 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 432026
146. 9,181.618 9,181.618 ↓ 1.0 15,552,006 1

Seq Scan on _hyper_3_405_chunk (cost=0.00..1,122,272.04 rows=15,549,432 width=20) (actual time=34.787..9,181.618 rows=15,552,006 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 172810
147. 2,320.313 2,320.313 ↑ 1.0 10,368,004 1

Seq Scan on _hyper_3_406_chunk (cost=0.00..755,375.91 rows=10,375,651 width=20) (actual time=46.088..2,320.313 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 216010
148. 2,011.801 2,011.801 ↓ 1.0 10,368,004 1

Seq Scan on _hyper_3_407_chunk (cost=0.00..770,792.95 rows=10,361,693 width=20) (actual time=104.655..2,011.801 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 432026
149. 399.963 588.807 ↑ 1.0 2,592,001 1

Bitmap Heap Scan on _hyper_3_408_chunk (cost=29,566.03..218,309.83 rows=2,594,720 width=20) (actual time=190.745..588.807 rows=2,592,001 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=16510
150. 188.844 188.844 ↑ 1.0 2,592,001 1

Bitmap Index Scan on _hyper_3_408_chunk_values_variable_id_datetime (cost=0.00..28,917.35 rows=2,594,720 width=0) (actual time=188.844..188.844 rows=2,592,001 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
151. 2,142.664 2,142.664 ↓ 1.0 10,368,004 1

Seq Scan on _hyper_3_409_chunk (cost=0.00..764,624.39 rows=10,367,199 width=20) (actual time=88.207..2,142.664 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 345602
152. 8,537.762 8,537.762 ↑ 1.0 10,368,004 1

Seq Scan on _hyper_3_410_chunk (cost=0.00..770,792.95 rows=10,370,117 width=20) (actual time=6,162.608..8,537.762 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 432026
153. 2,844.852 2,844.852 ↓ 1.0 15,552,006 1

Seq Scan on _hyper_3_411_chunk (cost=0.00..1,140,771.56 rows=15,549,689 width=20) (actual time=102.888..2,844.852 rows=15,552,006 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 432018
154. 10,774.037 10,774.037 ↑ 1.0 23,328,009 1

Seq Scan on _hyper_3_412_chunk (cost=0.00..1,680,325.34 rows=23,334,023 width=20) (actual time=54.193..10,774.037 rows=23,328,009 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 216026
155. 1,912.692 1,912.692 ↑ 1.0 10,368,004 1

Seq Scan on _hyper_3_413_chunk (cost=0.00..755,376.43 rows=10,370,225 width=20) (actual time=45.004..1,912.692 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 216018
156. 1,314.440 1,314.440 ↑ 1.0 5,183,918 1

Seq Scan on _hyper_3_414_chunk (cost=0.00..400,900.77 rows=5,186,118 width=20) (actual time=100.891..1,314.440 rows=5,183,918 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 433340
157. 3,152.709 3,152.709 ↑ 1.0 15,551,754 1

Seq Scan on _hyper_3_415_chunk (cost=0.00..1,122,316.34 rows=15,556,127 width=20) (actual time=36.154..3,152.709 rows=15,551,754 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 173682
158. 8,591.547 8,591.547 ↓ 1.0 10,367,836 1

Seq Scan on _hyper_3_416_chunk (cost=0.00..755,364.77 rows=10,361,529 width=20) (actual time=47.463..8,591.547 rows=10,367,836 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 216022
159. 2,000.802 2,000.802 ↑ 1.0 10,367,836 1

Seq Scan on _hyper_3_417_chunk (cost=0.00..770,812.54 rows=10,368,951 width=20) (actual time=100.917..2,000.802 rows=10,367,836 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 432480
160. 396.807 580.233 ↑ 1.0 2,591,959 1

Bitmap Heap Scan on _hyper_3_418_chunk (cost=29,559.96..218,245.53 rows=2,593,778 width=20) (actual time=185.659..580.233 rows=2,591,959 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=16510
161. 183.426 183.426 ↑ 1.0 2,591,959 1

Bitmap Index Scan on _hyper_3_418_chunk_values_variable_id_datetime (cost=0.00..28,911.52 rows=2,593,778 width=0) (actual time=183.426..183.426 rows=2,591,959 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
162. 2,133.782 2,133.782 ↓ 1.0 10,367,836 1

Seq Scan on _hyper_3_419_chunk (cost=0.00..764,704.71 rows=10,360,291 width=20) (actual time=88.714..2,133.782 rows=10,367,836 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 346898
163. 8,538.257 8,538.257 ↑ 1.0 10,367,836 1

Seq Scan on _hyper_3_420_chunk (cost=0.00..770,812.54 rows=10,371,256 width=20) (actual time=100.632..8,538.257 rows=10,367,836 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 432480
164. 3,202.109 3,202.109 ↓ 1.0 15,551,754 1

Seq Scan on _hyper_3_421_chunk (cost=0.00..1,140,877.15 rows=15,540,154 width=20) (actual time=102.848..3,202.109 rows=15,551,754 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 433756
165. 10,434.139 10,434.139 ↓ 1.0 23,327,631 1

Seq Scan on _hyper_3_422_chunk (cost=0.00..1,680,299.20 rows=23,326,299 width=20) (actual time=52.578..10,434.139 rows=23,327,631 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 216050
166. 1,920.131 1,920.131 ↑ 1.0 10,367,836 1

Seq Scan on _hyper_3_423_chunk (cost=0.00..755,365.68 rows=10,369,514 width=20) (actual time=45.990..1,920.131 rows=10,367,836 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 216036
167. 1,315.930 1,315.930 ↓ 1.0 5,184,134 1

Seq Scan on _hyper_3_424_chunk (cost=0.00..395,647.18 rows=5,182,314 width=20) (actual time=92.270..1,315.930 rows=5,184,134 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 359515
168. 8,241.496 8,241.496 ↑ 1.0 15,552,402 1

Seq Scan on _hyper_3_425_chunk (cost=0.00..1,119,848.55 rows=15,553,418 width=20) (actual time=28.384..8,241.496 rows=15,552,402 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 138468
169. 2,332.337 2,332.337 ↓ 1.0 10,368,268 1

Seq Scan on _hyper_3_426_chunk (cost=0.00..752,397.33 rows=10,368,194 width=20) (actual time=37.669..2,332.337 rows=10,368,268 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 174014
170. 1,973.176 1,973.176 ↓ 1.0 10,368,268 1

Seq Scan on _hyper_3_427_chunk (cost=0.00..765,090.39 rows=10,358,360 width=20) (actual time=84.539..1,973.176 rows=10,368,268 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 351861
171. 553.859 553.859 ↓ 1.0 2,592,067 1

Seq Scan on _hyper_3_428_chunk (cost=0.00..219,356.32 rows=2,590,328 width=20) (actual time=108.618..553.859 rows=2,592,067 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 481461
172. 7,511.152 7,511.152 ↓ 1.0 10,368,268 1

Seq Scan on _hyper_3_429_chunk (cost=0.00..763,963.95 rows=10,357,961 width=20) (actual time=79.234..7,511.152 rows=10,368,268 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 336085
173. 2,430.502 2,430.502 ↑ 1.0 10,368,268 1

Seq Scan on _hyper_3_430_chunk (cost=0.00..765,090.39 rows=10,382,302 width=20) (actual time=77.633..2,430.502 rows=10,368,268 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 351861
174. 3,196.581 3,196.581 ↑ 1.0 15,552,402 1

Seq Scan on _hyper_3_431_chunk (cost=0.00..1,137,395.71 rows=15,559,034 width=20) (actual time=91.361..3,196.581 rows=15,552,402 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 384332
175. 9,285.158 9,285.158 ↓ 1.0 23,328,603 1

Seq Scan on _hyper_3_432_chunk (cost=0.00..1,674,372.34 rows=23,328,318 width=20) (actual time=31.494..9,285.158 rows=23,328,603 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 132034
176. 1,906.014 1,906.014 ↑ 1.0 10,368,268 1

Seq Scan on _hyper_3_433_chunk (cost=0.00..750,898.98 rows=10,372,664 width=20) (actual time=31.473..1,906.014 rows=10,368,268 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 153024
177. 6,076.576 6,076.576 ↑ 1.0 5,184,024 1

Seq Scan on _hyper_3_434_chunk (cost=0.00..409,780.03 rows=5,187,940 width=20) (actual time=132.235..6,076.576 rows=5,184,024 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 557638
178. 3,146.741 3,146.741 ↓ 1.0 15,552,072 1

Seq Scan on _hyper_3_435_chunk (cost=0.00..1,128,252.82 rows=15,551,905 width=20) (actual time=59.029..3,146.741 rows=15,552,072 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 256556
179. 2,376.669 2,376.669 ↑ 1.0 10,368,048 1

Seq Scan on _hyper_3_436_chunk (cost=0.00..755,377.86 rows=10,375,680 width=20) (actual time=53.191..2,376.669 rows=10,368,048 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 215996
180. 6,761.278 6,761.278 ↑ 1.0 10,368,048 1

Seq Scan on _hyper_3_437_chunk (cost=0.00..773,782.19 rows=10,386,134 width=20) (actual time=113.696..6,761.278 rows=10,368,048 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 473878
181. 393.384 584.498 ↓ 1.0 2,592,012 1

Bitmap Heap Scan on _hyper_3_438_chunk (cost=28,580.22..212,017.34 rows=2,508,971 width=20) (actual time=193.082..584.498 rows=2,592,012 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=16511
182. 191.114 191.114 ↓ 1.0 2,592,012 1

Bitmap Index Scan on _hyper_3_438_chunk_values_variable_id_datetime (cost=0.00..27,952.98 rows=2,508,971 width=0) (actual time=191.114..191.114 rows=2,592,012 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
183. 2,158.679 2,158.679 ↓ 1.0 10,368,048 1

Seq Scan on _hyper_3_439_chunk (cost=0.00..773,594.40 rows=10,133,720 width=20) (actual time=105.824..2,158.679 rows=10,368,048 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 471235
184. 2,456.459 2,456.459 ↑ 1.0 10,368,048 1

Seq Scan on _hyper_3_440_chunk (cost=0.00..773,782.19 rows=10,370,162 width=20) (actual time=109.476..2,456.459 rows=10,368,048 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 473878
185. 6,334.182 6,334.182 ↑ 1.0 15,552,072 1

Seq Scan on _hyper_3_441_chunk (cost=0.00..1,152,730.29 rows=15,557,749 width=20) (actual time=141.608..6,334.182 rows=15,552,072 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 599517
186. 4,658.259 4,658.259 ↑ 1.0 23,328,108 1

Seq Scan on _hyper_3_442_chunk (cost=0.00..1,680,329.89 rows=23,329,074 width=20) (actual time=48.159..4,658.259 rows=23,328,108 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 215998
187. 1,930.004 1,930.004 ↑ 1.0 10,368,048 1

Seq Scan on _hyper_3_443_chunk (cost=0.00..755,377.93 rows=10,375,681 width=20) (actual time=48.897..1,930.004 rows=10,368,048 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 215997
188. 6,737.550 6,737.550 ↓ 1.0 5,177,824 1

Seq Scan on _hyper_3_444_chunk (cost=0.00..392,459.18 rows=5,146,488 width=20) (actual time=74.879..6,737.550 rows=5,177,824 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 321148
189. 3,110.103 3,110.103 ↓ 1.0 15,533,472 1

Seq Scan on _hyper_3_445_chunk (cost=0.00..1,117,852.63 rows=15,526,949 width=20) (actual time=30.500..3,110.103 rows=15,533,472 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 129430
190. 2,325.949 2,325.949 ↓ 1.0 10,355,648 1

Seq Scan on _hyper_3_446_chunk (cost=0.00..749,355.03 rows=10,346,577 width=20) (actual time=33.411..2,325.949 rows=10,355,648 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 144014
191. 7,191.532 7,191.532 ↓ 1.0 10,355,648 1

Seq Scan on _hyper_3_447_chunk (cost=0.00..760,421.80 rows=10,346,590 width=20) (actual time=70.000..7,191.532 rows=10,355,648 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 299072
192. 527.330 527.330 ↑ 1.0 2,588,912 1

Seq Scan on _hyper_3_448_chunk (cost=0.00..213,963.66 rows=2,589,484 width=20) (actual time=88.422..527.330 rows=2,588,912 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 409052
193. 2,103.172 2,103.172 ↑ 1.0 10,355,648 1

Seq Scan on _hyper_3_449_chunk (cost=0.00..760,969.74 rows=10,361,148 width=20) (actual time=72.187..2,103.172 rows=10,355,648 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 306748
194. 2,382.482 2,382.482 ↓ 1.0 10,355,648 1

Seq Scan on _hyper_3_450_chunk (cost=0.00..760,421.80 rows=10,325,418 width=20) (actual time=65.114..2,382.482 rows=10,355,648 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 299072
195. 7,972.633 7,972.633 ↓ 1.0 15,533,472 1

Seq Scan on _hyper_3_451_chunk (cost=0.00..1,133,725.37 rows=15,523,219 width=20) (actual time=82.584..7,972.633 rows=15,533,472 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 351826
196. 4,756.791 4,756.791 ↓ 1.0 23,300,208 1

Seq Scan on _hyper_3_452_chunk (cost=0.00..1,670,398.23 rows=23,291,663 width=20) (actual time=26.338..4,756.791 rows=23,300,208 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 104734
197. 5,627.471 5,627.471 ↑ 1.0 10,355,648 1

Seq Scan on _hyper_3_453_chunk (cost=0.00..747,953.43 rows=10,361,880 width=20) (actual time=21.664..5,627.471 rows=10,355,648 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 124374
198. 2,238.956 2,238.956 ↑ 1.0 10,368,012 1

Seq Scan on _hyper_3_454_chunk (cost=0.00..783,291.79 rows=10,377,460 width=20) (actual time=140.833..2,238.956 rows=10,368,012 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 607154
199. 3,228.471 3,228.471 ↑ 1.0 15,552,018 1

Seq Scan on _hyper_3_455_chunk (cost=0.00..1,144,995.39 rows=15,557,739 width=20) (actual time=115.488..3,228.471 rows=15,552,018 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 491188
200. 389.936 578.760 ↑ 1.0 2,592,003 1

Bitmap Heap Scan on _hyper_3_456_chunk (cost=29,584.12..219,426.21 rows=2,595,786 width=20) (actual time=190.538..578.760 rows=2,592,003 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=16510
201. 188.824 188.824 ↑ 1.0 2,592,003 1

Bitmap Index Scan on _hyper_3_456_chunk_values_variable_id_datetime (cost=0.00..28,935.17 rows=2,595,786 width=0) (actual time=188.824..188.824 rows=2,592,003 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
202. 5,377.627 5,377.627 ↓ 1.0 10,368,012 1

Seq Scan on _hyper_3_457_chunk (cost=0.00..779,238.31 rows=10,356,595 width=20) (actual time=129.063..5,377.627 rows=10,368,012 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 550362
203. 2,421.528 2,421.528 ↑ 1.0 10,368,012 1

Seq Scan on _hyper_3_458_chunk (cost=0.00..777,126.70 rows=10,376,499 width=20) (actual time=120.283..2,421.528 rows=10,368,012 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 520768
204. 1,345.086 1,345.086 ↑ 1.0 5,184,006 1

Seq Scan on _hyper_3_459_chunk (cost=0.00..402,121.53 rows=5,187,823 width=20) (actual time=106.094..1,345.086 rows=5,184,006 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 450356
205. 5,101.652 5,101.652 ↑ 1.0 10,368,012 1

Seq Scan on _hyper_3_460_chunk (cost=0.00..777,128.52 rows=10,387,705 width=20) (actual time=113.122..5,101.652 rows=10,368,012 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 520796
206. 2,463.513 2,463.513 ↓ 1.0 10,368,012 1

Seq Scan on _hyper_3_461_chunk (cost=0.00..778,100.82 rows=10,356,362 width=20) (actual time=124.714..2,463.513 rows=10,368,012 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 534416
207. 7,835.152 7,835.152 ↑ 1.0 23,328,027 1

Seq Scan on _hyper_3_462_chunk (cost=0.00..1,705,160.56 rows=23,335,820 width=20) (actual time=131.685..7,835.152 rows=23,328,027 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 563996
208. 3,231.942 3,231.942 ↓ 1.0 15,552,018 1

Seq Scan on _hyper_3_463_chunk (cost=0.00..1,151,162.30 rows=15,535,727 width=20) (actual time=132.473..3,231.942 rows=15,552,018 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 577602
209. 2,223.031 2,223.031 ↑ 1.0 10,368,004 1

Seq Scan on _hyper_3_464_chunk (cost=0.00..782,413.71 rows=10,377,367 width=20) (actual time=142.220..2,223.031 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 594853
210. 3,208.165 3,208.165 ↑ 1.0 15,552,006 1

Seq Scan on _hyper_3_465_chunk (cost=0.00..1,144,384.38 rows=15,555,216 width=20) (actual time=114.502..3,208.165 rows=15,552,006 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 482646
211. 3,345.660 3,544.262 ↑ 1.0 2,592,001 1

Bitmap Heap Scan on _hyper_3_466_chunk (cost=29,563.95..218,684.63 rows=2,593,872 width=20) (actual time=200.458..3,544.262 rows=2,592,001 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=16511
212. 198.602 198.602 ↑ 1.0 2,592,001 1

Bitmap Index Scan on _hyper_3_466_chunk_values_variable_id_datetime (cost=0.00..28,915.48 rows=2,593,872 width=0) (actual time=198.602..198.602 rows=2,592,001 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
213. 1,959.672 1,959.672 ↓ 1.0 10,368,004 1

Seq Scan on _hyper_3_467_chunk (cost=0.00..770,739.07 rows=10,359,389 width=20) (actual time=100.495..1,959.672 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 431274
214. 2,395.718 2,395.718 ↓ 1.0 10,368,004 1

Seq Scan on _hyper_3_468_chunk (cost=0.00..770,755.80 rows=10,365,669 width=20) (actual time=93.296..2,395.718 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 431516
215. 1,311.221 1,311.221 ↓ 1.0 5,184,002 1

Seq Scan on _hyper_3_469_chunk (cost=0.00..396,966.39 rows=5,180,641 width=20) (actual time=88.543..1,311.221 rows=5,184,002 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 378127
216. 5,088.417 5,088.417 ↑ 1.0 10,368,004 1

Seq Scan on _hyper_3_470_chunk (cost=0.00..772,546.07 rows=10,372,857 width=20) (actual time=3,213.022..5,088.417 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 456597
217. 2,454.350 2,454.350 ↑ 1.0 10,368,004 1

Seq Scan on _hyper_3_471_chunk (cost=0.00..775,629.07 rows=10,369,694 width=20) (actual time=116.627..2,454.350 rows=10,368,004 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 499797
218. 7,859.821 7,859.821 ↓ 1.0 23,328,009 1

Seq Scan on _hyper_3_472_chunk (cost=0.00..1,698,752.60 rows=23,324,450 width=20) (actual time=0.245..7,859.821 rows=23,328,009 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 474232
219. 2,752.548 2,752.548 ↑ 1.0 15,552,006 1

Seq Scan on _hyper_3_473_chunk (cost=0.00..1,154,182.10 rows=15,576,708 width=20) (actual time=143.154..2,752.548 rows=15,552,006 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 619934
220. 0.255 0.255 ↓ 0.0 0 1

Seq Scan on _hyper_3_474_chunk (cost=0.00..2.95 rows=23 width=20) (actual time=0.255..0.255 rows=0 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 30
221. 0.161 0.161 ↓ 0.0 0 1

Seq Scan on _hyper_3_475_chunk (cost=0.00..1.65 rows=10 width=20) (actual time=0.161..0.161 rows=0 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 10
222. 585.567 585.567 ↑ 1.0 3,193,380 1

Seq Scan on _hyper_3_476_chunk (cost=0.00..237,162.89 rows=3,194,872 width=20) (actual time=33.193..585.567 rows=3,193,380 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 129649
223. 297.485 297.485 ↑ 1.0 1,064,460 1

Seq Scan on _hyper_3_477_chunk (cost=0.00..88,308.00 rows=1,065,047 width=20) (actual time=45.588..297.485 rows=1,064,460 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 172863
224. 436.207 436.207 ↑ 1.0 2,128,920 1

Seq Scan on _hyper_3_478_chunk (cost=0.00..155,024.97 rows=2,129,014 width=20) (actual time=7.713..436.207 rows=2,128,920 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 43218
225. 84.662 124.890 ↓ 1.0 532,230 1

Bitmap Heap Scan on _hyper_3_479_chunk (cost=6,082.75..45,087.54 rows=530,966 width=20) (actual time=40.656..124.890 rows=532,230 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=3391
226. 40.228 40.228 ↓ 1.0 532,230 1

Bitmap Index Scan on _hyper_3_479_chunk_values_variable_id_datetime (cost=0.00..5,950.01 rows=530,966 width=0) (actual time=40.228..40.228 rows=532,230 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
227. 528.508 528.508 ↓ 1.0 2,128,920 1

Seq Scan on _hyper_3_480_chunk (cost=0.00..164,277.77 rows=2,128,688 width=20) (actual time=33.352..528.508 rows=2,128,920 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 172861
228. 423.898 423.898 ↓ 1.0 2,128,920 1

Seq Scan on _hyper_3_481_chunk (cost=0.00..164,277.77 rows=2,127,628 width=20) (actual time=42.944..423.898 rows=2,128,920 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 172861
229. 657.886 657.886 ↓ 1.0 3,193,380 1

Seq Scan on _hyper_3_482_chunk (cost=0.00..234,078.78 rows=3,192,044 width=20) (actual time=15.413..657.886 rows=3,193,380 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 86432
230. 3,480.972 3,480.972 ↑ 1.0 10,368,076 1

Seq Scan on _hyper_3_483_chunk (cost=0.00..740,915.84 rows=10,368,471 width=20) (actual time=3.987..3,480.972 rows=10,368,076 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 13337
231. 3,091.290 3,091.290 ↑ 1.0 15,552,114 1

Seq Scan on _hyper_3_484_chunk (cost=0.00..1,110,952.04 rows=15,553,244 width=20) (actual time=3.221..3,091.290 rows=15,552,114 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 14102
232. 443.610 443.610 ↑ 1.0 2,592,019 1

Seq Scan on _hyper_3_485_chunk (cost=0.00..186,619.27 rows=2,592,034 width=20) (actual time=4.525..443.610 rows=2,592,019 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 22816
233. 1,875.253 1,875.253 ↑ 1.0 10,368,076 1

Seq Scan on _hyper_3_486_chunk (cost=0.00..741,153.04 rows=10,368,816 width=20) (actual time=3.986..1,875.253 rows=10,368,076 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 16663
234. 5,339.549 5,339.549 ↑ 1.0 10,368,076 1

Seq Scan on _hyper_3_487_chunk (cost=0.00..740,970.57 rows=10,369,584 width=20) (actual time=4.305..5,339.549 rows=10,368,076 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 14102
235. 1,229.103 1,229.103 ↓ 1.0 5,184,038 1

Seq Scan on _hyper_3_488_chunk (cost=0.00..371,161.92 rows=5,183,372 width=20) (actual time=5.245..1,229.103 rows=5,184,038 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 16530
236. 1,892.856 1,892.856 ↓ 1.0 10,368,076 1

Seq Scan on _hyper_3_489_chunk (cost=0.00..741,336.50 rows=10,366,664 width=20) (actual time=6.663..1,892.856 rows=10,368,076 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 19224
237. 5,382.821 5,382.821 ↓ 1.0 10,368,076 1

Seq Scan on _hyper_3_490_chunk (cost=0.00..741,399.87 rows=10,367,913 width=20) (actual time=4.783..5,382.821 rows=10,368,076 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 20122
238. 4,627.187 4,627.187 ↓ 1.0 23,328,171 1

Seq Scan on _hyper_3_491_chunk (cost=0.00..1,666,354.98 rows=23,327,439 width=20) (actual time=4.072..4,627.187 rows=23,328,171 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 20122
239. 5,721.557 5,721.557 ↓ 1.0 15,552,114 1

Seq Scan on _hyper_3_492_chunk (cost=0.00..1,111,263.25 rows=15,551,999 width=20) (actual time=4.806..5,721.557 rows=15,552,114 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 18459
240. 0.657 0.657 ↓ 0.0 0 1

Index Scan using _hyper_3_493_chunk_values_variable_id_datetime on _hyper_3_493_chunk (cost=0.28..53.84 rows=1 width=20) (actual time=0.657..0.657 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
241. 0.297 0.297 ↓ 0.0 0 1

Index Scan using _hyper_3_494_chunk_values_variable_id_datetime on _hyper_3_494_chunk (cost=0.28..53.32 rows=1 width=20) (actual time=0.297..0.297 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
242. 0.268 0.268 ↓ 0.0 0 1

Index Scan using _hyper_3_495_chunk_values_variable_id_datetime on _hyper_3_495_chunk (cost=0.28..53.84 rows=1 width=20) (actual time=0.268..0.268 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
243. 0.479 0.479 ↓ 0.0 0 1

Index Scan using _hyper_3_496_chunk_values_variable_id_datetime on _hyper_3_496_chunk (cost=0.42..68.15 rows=1 width=20) (actual time=0.478..0.479 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
244. 0.586 0.586 ↓ 0.0 0 1

Index Scan using _hyper_3_497_chunk_values_variable_id_datetime on _hyper_3_497_chunk (cost=0.42..68.38 rows=1 width=20) (actual time=0.586..0.586 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
245. 0.589 0.589 ↓ 0.0 0 1

Index Scan using _hyper_3_498_chunk_values_variable_id_datetime on _hyper_3_498_chunk (cost=0.42..68.27 rows=1 width=20) (actual time=0.589..0.589 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
246. 0.492 0.492 ↓ 0.0 0 1

Index Scan using _hyper_3_499_chunk_values_variable_id_datetime on _hyper_3_499_chunk (cost=0.42..68.36 rows=1 width=20) (actual time=0.492..0.492 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
247. 0.594 0.594 ↓ 0.0 0 1

Index Scan using _hyper_3_500_chunk_values_variable_id_datetime on _hyper_3_500_chunk (cost=0.42..68.50 rows=1 width=20) (actual time=0.594..0.594 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
248. 0.627 0.627 ↓ 0.0 0 1

Index Scan using _hyper_3_501_chunk_values_variable_id_datetime on _hyper_3_501_chunk (cost=0.42..68.28 rows=1 width=20) (actual time=0.627..0.627 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
249. 0.367 0.367 ↓ 0.0 0 1

Index Scan using _hyper_3_502_chunk_values_variable_id_datetime on _hyper_3_502_chunk (cost=0.42..67.04 rows=1 width=20) (actual time=0.367..0.367 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
250. 0.418 0.418 ↓ 0.0 0 1

Index Scan using _hyper_3_503_chunk_values_variable_id_datetime on _hyper_3_503_chunk (cost=0.42..67.18 rows=1 width=20) (actual time=0.418..0.418 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
251. 0.365 0.365 ↓ 0.0 0 1

Index Scan using _hyper_3_504_chunk_values_variable_id_datetime on _hyper_3_504_chunk (cost=0.42..65.86 rows=1 width=20) (actual time=0.365..0.365 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
252. 0.397 0.397 ↓ 0.0 0 1

Index Scan using _hyper_3_505_chunk_values_variable_id_datetime on _hyper_3_505_chunk (cost=0.42..65.70 rows=1 width=20) (actual time=0.397..0.397 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
253. 0.484 0.484 ↓ 0.0 0 1

Index Scan using _hyper_3_506_chunk_values_variable_id_datetime on _hyper_3_506_chunk (cost=0.42..67.11 rows=1 width=20) (actual time=0.484..0.484 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
254. 0.353 0.353 ↓ 0.0 0 1

Index Scan using _hyper_3_507_chunk_values_variable_id_datetime on _hyper_3_507_chunk (cost=0.42..64.49 rows=1 width=20) (actual time=0.353..0.353 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
255. 0.257 0.257 ↓ 0.0 0 1

Index Scan using _hyper_3_508_chunk_values_variable_id_datetime on _hyper_3_508_chunk (cost=0.29..55.82 rows=1 width=20) (actual time=0.257..0.257 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
256. 0.351 0.351 ↓ 0.0 0 1

Index Scan using _hyper_3_509_chunk_values_variable_id_datetime on _hyper_3_509_chunk (cost=0.41..63.66 rows=1 width=20) (actual time=0.351..0.351 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
257. 0.334 0.334 ↓ 0.0 0 1

Index Scan using _hyper_3_510_chunk_values_variable_id_datetime on _hyper_3_510_chunk (cost=0.41..63.66 rows=1 width=20) (actual time=0.334..0.334 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
258. 0.204 0.204 ↓ 0.0 0 1

Index Scan using _hyper_3_511_chunk_values_variable_id_datetime on _hyper_3_511_chunk (cost=0.29..58.13 rows=1 width=20) (actual time=0.204..0.204 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
259. 0.335 0.335 ↓ 0.0 0 1

Index Scan using _hyper_3_512_chunk_values_variable_id_datetime on _hyper_3_512_chunk (cost=0.41..63.66 rows=1 width=20) (actual time=0.335..0.335 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
260. 0.361 0.361 ↓ 0.0 0 1

Index Scan using _hyper_3_513_chunk_values_variable_id_datetime on _hyper_3_513_chunk (cost=0.42..65.97 rows=1 width=20) (actual time=0.361..0.361 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
261. 0.314 0.314 ↓ 0.0 0 1

Index Scan using _hyper_3_514_chunk_values_variable_id_datetime on _hyper_3_514_chunk (cost=0.42..65.97 rows=1 width=20) (actual time=0.314..0.314 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
262. 0.299 0.299 ↓ 0.0 0 1

Index Scan using _hyper_3_515_chunk_values_variable_id_datetime on _hyper_3_515_chunk (cost=0.42..64.84 rows=1 width=20) (actual time=0.299..0.299 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
263. 0.320 0.320 ↓ 0.0 0 1

Index Scan using _hyper_3_516_chunk_values_variable_id_datetime on _hyper_3_516_chunk (cost=0.42..65.97 rows=1 width=20) (actual time=0.320..0.320 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
264. 0.220 0.220 ↓ 0.0 0 1

Index Scan using _hyper_3_517_chunk_values_variable_id_datetime on _hyper_3_517_chunk (cost=0.28..54.42 rows=1 width=20) (actual time=0.220..0.220 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
265. 0.224 0.224 ↓ 0.0 0 1

Index Scan using _hyper_3_518_chunk_values_variable_id_datetime on _hyper_3_518_chunk (cost=0.28..54.42 rows=1 width=20) (actual time=0.224..0.224 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
266. 0.216 0.216 ↓ 0.0 0 1

Index Scan using _hyper_3_519_chunk_values_variable_id_datetime on _hyper_3_519_chunk (cost=0.28..52.08 rows=1 width=20) (actual time=0.216..0.216 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
267. 0.218 0.218 ↓ 0.0 0 1

Index Scan using _hyper_3_520_chunk_values_variable_id_datetime on _hyper_3_520_chunk (cost=0.28..54.42 rows=1 width=20) (actual time=0.218..0.218 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
268. 0.360 0.360 ↓ 0.0 0 1

Index Scan using _hyper_3_521_chunk_values_variable_id_datetime on _hyper_3_521_chunk (cost=0.42..67.18 rows=1 width=20) (actual time=0.360..0.360 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
269. 0.301 0.301 ↓ 0.0 0 1

Index Scan using _hyper_3_522_chunk_values_variable_id_datetime on _hyper_3_522_chunk (cost=0.42..67.18 rows=1 width=20) (actual time=0.301..0.301 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
270. 0.300 0.300 ↓ 0.0 0 1

Index Scan using _hyper_3_523_chunk_values_variable_id_datetime on _hyper_3_523_chunk (cost=0.42..65.94 rows=1 width=20) (actual time=0.300..0.300 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
271. 0.386 0.386 ↓ 0.0 0 1

Index Scan using _hyper_3_524_chunk_values_variable_id_datetime on _hyper_3_524_chunk (cost=0.42..67.18 rows=1 width=20) (actual time=0.386..0.386 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
272. 0.284 0.284 ↓ 0.0 0 1

Index Scan using _hyper_3_525_chunk_values_variable_id_datetime on _hyper_3_525_chunk (cost=0.42..67.18 rows=1 width=20) (actual time=0.284..0.284 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
273. 0.387 0.387 ↓ 0.0 0 1

Index Scan using _hyper_3_526_chunk_values_variable_id_datetime on _hyper_3_526_chunk (cost=0.42..67.18 rows=1 width=20) (actual time=0.387..0.387 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
274. 0.285 0.285 ↓ 0.0 0 1

Index Scan using _hyper_3_527_chunk_values_variable_id_datetime on _hyper_3_527_chunk (cost=0.42..67.04 rows=1 width=20) (actual time=0.285..0.285 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
275. 0.311 0.311 ↓ 0.0 0 1

Index Scan using _hyper_3_528_chunk_values_variable_id_datetime on _hyper_3_528_chunk (cost=0.42..67.22 rows=1 width=20) (actual time=0.311..0.311 rows=0 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
276. 12.686 12.686 ↓ 14,182.0 14,182 1

Index Scan using _hyper_3_529_chunk_values_variable_id_datetime on _hyper_3_529_chunk (cost=0.42..67.18 rows=1 width=20) (actual time=0.568..12.686 rows=14,182 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
277. 18.732 24.481 ↑ 1.0 127,638 1

Bitmap Heap Scan on _hyper_3_530_chunk (cost=1,513.07..11,708.05 rows=127,692 width=20) (actual time=5.997..24.481 rows=127,638 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=814
278. 5.749 5.749 ↑ 1.0 127,638 1

Bitmap Index Scan on _hyper_3_530_chunk_values_variable_id_datetime (cost=0.00..1,481.15 rows=127,692 width=0) (actual time=5.749..5.749 rows=127,638 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
279. 10.170 15.770 ↓ 1.0 56,728 1

Bitmap Heap Scan on _hyper_3_531_chunk (cost=671.50..5,521.16 rows=56,564 width=20) (actual time=5.777..15.770 rows=56,728 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=362
280. 5.600 5.600 ↓ 1.0 56,728 1

Bitmap Index Scan on _hyper_3_531_chunk_values_variable_id_datetime (cost=0.00..657.36 rows=56,564 width=0) (actual time=5.600..5.600 rows=56,728 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
281. 5.512 8.415 ↑ 1.0 28,364 1

Bitmap Heap Scan on _hyper_3_532_chunk (cost=372.63..3,480.32 rows=28,380 width=20) (actual time=3.130..8.415 rows=28,364 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=182
282. 2.903 2.903 ↑ 1.0 28,364 1

Bitmap Index Scan on _hyper_3_532_chunk_values_variable_id_datetime (cost=0.00..365.53 rows=28,380 width=0) (actual time=2.903..2.903 rows=28,364 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
283. 9.365 14.273 ↑ 1.0 51,266 1

Bitmap Heap Scan on _hyper_3_533_chunk (cost=623.54..4,419.83 rows=51,266 width=20) (actual time=5.043..14.273 rows=51,266 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=328
284. 4.908 4.908 ↑ 1.0 51,266 1

Bitmap Index Scan on _hyper_3_533_chunk_values_variable_id_datetime (cost=0.00..610.72 rows=51,266 width=0) (actual time=4.908..4.908 rows=51,266 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
285. 96.135 96.135 ↑ 1.0 461,394 1

Seq Scan on _hyper_3_534_chunk (cost=0.00..34,459.69 rows=461,479 width=20) (actual time=5.639..96.135 rows=461,394 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 21432
286. 44.368 44.368 ↑ 1.0 205,064 1

Seq Scan on _hyper_3_535_chunk (cost=0.00..15,782.97 rows=205,067 width=20) (actual time=3.794..44.368 rows=205,064 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 16074
287. 18.992 28.176 ↑ 1.0 102,532 1

Bitmap Heap Scan on _hyper_3_536_chunk (cost=1,226.50..8,681.08 rows=102,532 width=20) (actual time=9.545..28.176 rows=102,532 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=654
288. 9.184 9.184 ↑ 1.0 102,532 1

Bitmap Index Scan on _hyper_3_536_chunk_values_variable_id_datetime (cost=0.00..1,200.87 rows=102,532 width=0) (actual time=9.184..9.184 rows=102,532 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
289. 997.351 997.351 ↓ 1.0 4,790,070 1

Seq Scan on _hyper_3_537_chunk (cost=0.00..354,202.45 rows=4,788,301 width=20) (actual time=29.892..997.351 rows=4,790,070 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 172860
290. 419.746 419.746 ↓ 1.0 2,128,920 1

Seq Scan on _hyper_3_538_chunk (cost=0.00..161,192.73 rows=2,128,457 width=20) (actual time=33.424..419.746 rows=2,128,920 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 129645
291. 496.902 496.902 ↑ 1.0 2,128,920 1

Seq Scan on _hyper_3_539_chunk (cost=0.00..158,108.75 rows=2,129,335 width=20) (actual time=16.385..496.902 rows=2,128,920 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 86430
292. 1,459.640 2,205.070 ↓ 1.0 9,642,804 1

Bitmap Heap Scan on _hyper_3_540_chunk (cost=109,663.96..811,470.03 rows=9,635,155 width=20) (actual time=752.686..2,205.070 rows=9,642,804 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=61420
293. 745.430 745.430 ↓ 1.0 9,642,804 1

Bitmap Index Scan on _hyper_3_540_chunk_values_variable_id_datetime (cost=0.00..107,255.17 rows=9,635,155 width=0) (actual time=745.430..745.430 rows=9,642,804 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
294. 4,703.942 5,440.542 ↓ 1.0 9,642,804 1

Bitmap Heap Scan on _hyper_3_541_chunk (cost=109,718.18..815,219.36 rows=9,637,772 width=20) (actual time=743.917..5,440.542 rows=9,642,804 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=61420
295. 736.600 736.600 ↓ 1.0 9,642,804 1

Bitmap Index Scan on _hyper_3_541_chunk_values_variable_id_datetime (cost=0.00..107,308.74 rows=9,637,772 width=0) (actual time=736.600..736.600 rows=9,642,804 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
296. 5,349.106 5,349.106 ↓ 1.0 21,696,309 1

Seq Scan on _hyper_3_542_chunk (cost=0.00..1,627,440.04 rows=21,688,709 width=20) (actual time=273.649..5,349.106 rows=21,696,309 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 1106708
297. 903.461 1,279.436 ↑ 1.0 4,821,402 1

Bitmap Heap Scan on _hyper_3_543_chunk (cost=55,220.59..424,904.63 rows=4,835,339 width=20) (actual time=379.440..1,279.436 rows=4,821,402 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=30710
298. 375.975 375.975 ↑ 1.0 4,821,402 1

Bitmap Index Scan on _hyper_3_543_chunk_values_variable_id_datetime (cost=0.00..54,011.76 rows=4,835,339 width=0) (actual time=375.975..375.975 rows=4,821,402 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
299. 7,627.860 8,719.527 ↑ 1.0 14,464,206 1

Bitmap Heap Scan on _hyper_3_544_chunk (cost=164,696.33..1,218,699.65 rows=14,472,651 width=20) (actual time=1,102.242..8,719.527 rows=14,464,206 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=92130
300. 1,091.667 1,091.667 ↑ 1.0 14,464,206 1

Bitmap Index Scan on _hyper_3_544_chunk_values_variable_id_datetime (cost=0.00..161,078.17 rows=14,472,651 width=0) (actual time=1,091.667..1,091.667 rows=14,464,206 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
301. 2,026.066 2,026.066 ↑ 1.0 9,642,804 1

Seq Scan on _hyper_3_545_chunk (cost=0.00..767,188.28 rows=9,654,567 width=20) (actual time=263.743..2,026.066 rows=9,642,804 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 1106708
302. 366.552 542.380 ↑ 1.0 2,410,701 1

Bitmap Heap Scan on _hyper_3_546_chunk (cost=27,606.18..213,968.47 rows=2,413,943 width=20) (actual time=177.458..542.380 rows=2,410,701 loops=1)

  • Recheck Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Heap Blocks: exact=15355
303. 175.828 175.828 ↑ 1.0 2,410,701 1

Bitmap Index Scan on _hyper_3_546_chunk_values_variable_id_datetime (cost=0.00..27,002.69 rows=2,413,943 width=0) (actual time=175.828..175.828 rows=2,410,701 loops=1)

  • Index Cond: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
304. 3,134.153 3,134.153 ↓ 1.0 14,464,206 1

Seq Scan on _hyper_3_547_chunk (cost=0.00..1,111,289.41 rows=14,454,583 width=20) (actual time=258.417..3,134.153 rows=14,464,206 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 1106708
305. 2,243.882 2,243.882 ↓ 1.0 9,642,804 1

Seq Scan on _hyper_3_548_chunk (cost=0.00..727,695.27 rows=9,638,224 width=20) (actual time=120.871..2,243.882 rows=9,642,804 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 553354
306. 2,276.241 2,276.241 ↑ 1.0 9,642,804 1

Seq Scan on _hyper_3_549_chunk (cost=0.00..727,695.27 rows=9,648,760 width=20) (actual time=126.813..2,276.241 rows=9,642,804 loops=1)

  • Filter: (variable_id = ANY ('{316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359}'::integer[]))
  • Rows Removed by Filter: 553354