explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NYMC

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 51.404 ↑ 3.0 203 1

Custom Scan (ConstraintAwareAppend) (cost=41.58..5,714.36 rows=607 width=233) (actual time=45.731..51.404 rows=203 loops=1)

  • Hypertable: price
  • Chunks left after exclusion: 133
2.          

Initplan (forCustom Scan (ConstraintAwareAppend))

3. 0.004 9.458 ↑ 1.0 1 1

Result (cost=41.57..41.58 rows=1 width=4) (actual time=9.458..9.458 rows=1 loops=1)

4.          

Initplan (forResult)

5. 0.059 9.454 ↑ 1.0 1 1

Limit (cost=41.46..41.57 rows=1 width=8) (actual time=9.397..9.454 rows=1 loops=1)

6. 0.022 9.395 ↑ 126,186.0 1 1

Merge Append (cost=41.46..13,838.07 rows=126,186 width=8) (actual time=9.395..9.395 rows=1 loops=1)

  • Sort Key: price_1.date DESC
7. 0.008 0.008 ↓ 0.0 0 1

Index Only Scan Backward using price_date_symbol_idx on price price_1 (cost=0.13..8.14 rows=1 width=8) (actual time=0.007..0.008 rows=0 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 0
8. 0.157 0.157 ↑ 900.0 1 1

Index Only Scan using _hyper_9_100_chunk_price_date_idx on _hyper_9_100_chunk _hyper_9_100_chunk_1 (cost=0.28..66.03 rows=900 width=8) (actual time=0.156..0.157 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
9. 0.064 0.064 ↑ 900.0 1 1

Index Only Scan using _hyper_9_101_chunk_price_date_idx on _hyper_9_101_chunk _hyper_9_101_chunk_1 (cost=0.28..66.03 rows=900 width=8) (actual time=0.063..0.064 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
10. 0.056 0.056 ↑ 900.0 1 1

Index Only Scan using _hyper_9_102_chunk_price_date_idx on _hyper_9_102_chunk _hyper_9_102_chunk_1 (cost=0.28..66.03 rows=900 width=8) (actual time=0.056..0.056 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
11. 0.053 0.053 ↑ 900.0 1 1

Index Only Scan using _hyper_9_103_chunk_price_date_idx on _hyper_9_103_chunk _hyper_9_103_chunk_1 (cost=0.28..66.03 rows=900 width=8) (actual time=0.053..0.053 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
12. 0.048 0.048 ↑ 900.0 1 1

Index Only Scan using _hyper_9_104_chunk_price_date_idx on _hyper_9_104_chunk _hyper_9_104_chunk_1 (cost=0.28..66.43 rows=900 width=8) (actual time=0.047..0.048 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
13. 0.102 0.102 ↑ 900.0 1 1

Index Only Scan using _hyper_9_105_chunk_price_date_idx on _hyper_9_105_chunk _hyper_9_105_chunk_1 (cost=0.28..66.05 rows=900 width=8) (actual time=0.102..0.102 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
14. 0.047 0.047 ↑ 906.0 1 1

Index Only Scan using _hyper_9_106_chunk_price_date_idx on _hyper_9_106_chunk _hyper_9_106_chunk_1 (cost=0.28..66.13 rows=906 width=8) (actual time=0.047..0.047 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
15. 0.048 0.048 ↑ 905.0 1 1

Index Only Scan using _hyper_9_107_chunk_price_date_idx on _hyper_9_107_chunk _hyper_9_107_chunk_1 (cost=0.28..66.26 rows=905 width=8) (actual time=0.048..0.048 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
16. 0.051 0.051 ↑ 905.0 1 1

Index Only Scan using _hyper_9_108_chunk_price_date_idx on _hyper_9_108_chunk _hyper_9_108_chunk_1 (cost=0.28..66.15 rows=905 width=8) (actual time=0.051..0.051 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
17. 0.561 0.561 ↑ 724.0 1 1

Index Only Scan using _hyper_9_109_chunk_price_date_idx on _hyper_9_109_chunk _hyper_9_109_chunk_1 (cost=0.28..53.95 rows=724 width=8) (actual time=0.560..0.561 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
18. 0.055 0.055 ↑ 905.0 1 1

Index Only Scan using _hyper_9_110_chunk_price_date_idx on _hyper_9_110_chunk _hyper_9_110_chunk_1 (cost=0.28..66.12 rows=905 width=8) (actual time=0.055..0.055 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
19. 0.055 0.055 ↑ 905.0 1 1

Index Only Scan using _hyper_9_111_chunk_price_date_idx on _hyper_9_111_chunk _hyper_9_111_chunk_1 (cost=0.28..66.13 rows=905 width=8) (actual time=0.055..0.055 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
20. 0.047 0.047 ↑ 905.0 1 1

Index Only Scan using _hyper_9_112_chunk_price_date_idx on _hyper_9_112_chunk _hyper_9_112_chunk_1 (cost=0.28..66.13 rows=905 width=8) (actual time=0.047..0.047 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
21. 0.078 0.078 ↑ 904.0 1 1

Index Only Scan using _hyper_9_113_chunk_price_date_idx on _hyper_9_113_chunk _hyper_9_113_chunk_1 (cost=0.28..66.12 rows=904 width=8) (actual time=0.078..0.078 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
22. 0.151 0.151 ↑ 718.0 1 1

Index Only Scan using _hyper_9_114_chunk_price_date_idx on _hyper_9_114_chunk _hyper_9_114_chunk_1 (cost=0.28..53.84 rows=718 width=8) (actual time=0.150..0.151 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
23. 0.050 0.050 ↑ 899.0 1 1

Index Only Scan using _hyper_9_115_chunk_price_date_idx on _hyper_9_115_chunk _hyper_9_115_chunk_1 (cost=0.28..66.35 rows=899 width=8) (actual time=0.050..0.050 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
24. 0.049 0.049 ↑ 720.0 1 1

Index Only Scan using _hyper_9_116_chunk_price_date_idx on _hyper_9_116_chunk _hyper_9_116_chunk_1 (cost=0.28..53.88 rows=720 width=8) (actual time=0.049..0.049 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
25. 0.053 0.053 ↑ 900.0 1 1

Index Only Scan using _hyper_9_117_chunk_price_date_idx on _hyper_9_117_chunk _hyper_9_117_chunk_1 (cost=0.28..66.04 rows=900 width=8) (actual time=0.053..0.053 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
26. 0.046 0.046 ↑ 901.0 1 1

Index Only Scan using _hyper_9_118_chunk_price_date_idx on _hyper_9_118_chunk _hyper_9_118_chunk_1 (cost=0.28..66.04 rows=901 width=8) (actual time=0.046..0.046 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
27. 0.049 0.049 ↑ 778.0 1 1

Index Only Scan using _hyper_9_119_chunk_price_date_idx on _hyper_9_119_chunk _hyper_9_119_chunk_1 (cost=0.28..59.89 rows=778 width=8) (actual time=0.049..0.049 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
28. 0.045 0.045 ↑ 971.0 1 1

Index Only Scan using _hyper_9_120_chunk_price_date_idx on _hyper_9_120_chunk _hyper_9_120_chunk_1 (cost=0.28..69.34 rows=971 width=8) (actual time=0.045..0.045 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
29. 0.055 0.055 ↑ 776.0 1 1

Index Only Scan using _hyper_9_121_chunk_price_date_idx on _hyper_9_121_chunk _hyper_9_121_chunk_1 (cost=0.28..59.85 rows=776 width=8) (actual time=0.055..0.055 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
30. 0.047 0.047 ↑ 970.0 1 1

Index Only Scan using _hyper_9_122_chunk_price_date_idx on _hyper_9_122_chunk _hyper_9_122_chunk_1 (cost=0.28..69.25 rows=970 width=8) (actual time=0.047..0.047 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
31. 0.045 0.045 ↑ 836.0 1 1

Index Only Scan using _hyper_9_123_chunk_price_date_idx on _hyper_9_123_chunk _hyper_9_123_chunk_1 (cost=0.28..62.95 rows=836 width=8) (actual time=0.045..0.045 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
32. 0.101 0.101 ↑ 1,045.0 1 1

Index Only Scan using _hyper_9_124_chunk_price_date_idx on _hyper_9_124_chunk _hyper_9_124_chunk_1 (cost=0.28..72.57 rows=1,045 width=8) (actual time=0.100..0.101 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
33. 0.060 0.060 ↑ 1,045.0 1 1

Index Only Scan using _hyper_9_125_chunk_price_date_idx on _hyper_9_125_chunk _hyper_9_125_chunk_1 (cost=0.28..72.70 rows=1,045 width=8) (actual time=0.060..0.060 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
34. 0.047 0.047 ↑ 1,046.0 1 1

Index Only Scan using _hyper_9_126_chunk_price_date_idx on _hyper_9_126_chunk _hyper_9_126_chunk_1 (cost=0.28..72.62 rows=1,046 width=8) (actual time=0.047..0.047 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
35. 0.056 0.056 ↑ 1,070.0 1 1

Index Only Scan using _hyper_9_127_chunk_price_date_idx on _hyper_9_127_chunk _hyper_9_127_chunk_1 (cost=0.28..74.00 rows=1,070 width=8) (actual time=0.056..0.056 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
36. 0.044 0.044 ↑ 1,070.0 1 1

Index Only Scan using _hyper_9_128_chunk_price_date_idx on _hyper_9_128_chunk _hyper_9_128_chunk_1 (cost=0.28..74.00 rows=1,070 width=8) (actual time=0.044..0.044 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
37. 0.053 0.053 ↑ 1,070.0 1 1

Index Only Scan using _hyper_9_129_chunk_price_date_idx on _hyper_9_129_chunk _hyper_9_129_chunk_1 (cost=0.28..74.07 rows=1,070 width=8) (actual time=0.053..0.053 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
38. 0.111 0.111 ↑ 1,070.0 1 1

Index Only Scan using _hyper_9_130_chunk_price_date_idx on _hyper_9_130_chunk _hyper_9_130_chunk_1 (cost=0.28..74.20 rows=1,070 width=8) (actual time=0.111..0.111 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
39. 0.063 0.063 ↑ 857.0 1 1

Index Only Scan using _hyper_9_131_chunk_price_date_idx on _hyper_9_131_chunk _hyper_9_131_chunk_1 (cost=0.28..64.50 rows=857 width=8) (actual time=0.063..0.063 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
40. 0.042 0.042 ↑ 1,093.0 1 1

Index Only Scan using _hyper_9_132_chunk_price_date_idx on _hyper_9_132_chunk _hyper_9_132_chunk_1 (cost=0.28..75.47 rows=1,093 width=8) (actual time=0.042..0.042 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
41. 0.047 0.047 ↑ 1,092.0 1 1

Index Only Scan using _hyper_9_133_chunk_price_date_idx on _hyper_9_133_chunk _hyper_9_133_chunk_1 (cost=0.28..75.70 rows=1,092 width=8) (actual time=0.047..0.047 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
42. 0.041 0.041 ↑ 1,090.0 1 1

Index Only Scan using _hyper_9_134_chunk_price_date_idx on _hyper_9_134_chunk _hyper_9_134_chunk_1 (cost=0.28..75.36 rows=1,090 width=8) (actual time=0.041..0.041 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
43. 0.046 0.046 ↑ 1,092.0 1 1

Index Only Scan using _hyper_9_135_chunk_price_date_idx on _hyper_9_135_chunk _hyper_9_135_chunk_1 (cost=0.28..75.39 rows=1,092 width=8) (actual time=0.046..0.046 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
44. 0.044 0.044 ↑ 1,090.0 1 1

Index Only Scan using _hyper_9_136_chunk_price_date_idx on _hyper_9_136_chunk _hyper_9_136_chunk_1 (cost=0.28..75.35 rows=1,090 width=8) (actual time=0.043..0.044 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
45. 0.055 0.055 ↑ 1,092.0 1 1

Index Only Scan using _hyper_9_137_chunk_price_date_idx on _hyper_9_137_chunk _hyper_9_137_chunk_1 (cost=0.28..75.39 rows=1,092 width=8) (actual time=0.055..0.055 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
46. 0.067 0.067 ↑ 873.0 1 1

Index Only Scan using _hyper_9_138_chunk_price_date_idx on _hyper_9_138_chunk _hyper_9_138_chunk_1 (cost=0.28..64.60 rows=873 width=8) (actual time=0.067..0.067 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
47. 0.063 0.063 ↑ 1,090.0 1 1

Index Only Scan using _hyper_9_139_chunk_price_date_idx on _hyper_9_139_chunk _hyper_9_139_chunk_1 (cost=0.28..75.35 rows=1,090 width=8) (actual time=0.063..0.063 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
48. 0.047 0.047 ↑ 873.0 1 1

Index Only Scan using _hyper_9_140_chunk_price_date_idx on _hyper_9_140_chunk _hyper_9_140_chunk_1 (cost=0.28..64.57 rows=873 width=8) (actual time=0.047..0.047 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
49. 0.095 0.095 ↑ 1,085.0 1 1

Index Only Scan using _hyper_9_141_chunk_price_date_idx on _hyper_9_141_chunk _hyper_9_141_chunk_1 (cost=0.28..74.27 rows=1,085 width=8) (actual time=0.095..0.095 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
50. 0.078 0.078 ↑ 1,085.0 1 1

Index Only Scan using _hyper_9_142_chunk_price_date_idx on _hyper_9_142_chunk _hyper_9_142_chunk_1 (cost=0.28..74.30 rows=1,085 width=8) (actual time=0.078..0.078 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
51. 0.053 0.053 ↑ 1,085.0 1 1

Index Only Scan using _hyper_9_143_chunk_price_date_idx on _hyper_9_143_chunk _hyper_9_143_chunk_1 (cost=0.28..74.30 rows=1,085 width=8) (actual time=0.053..0.053 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
52. 0.095 0.095 ↑ 1,086.0 1 1

Index Only Scan using _hyper_9_144_chunk_price_date_idx on _hyper_9_144_chunk _hyper_9_144_chunk_1 (cost=0.28..75.35 rows=1,086 width=8) (actual time=0.094..0.095 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
53. 0.056 0.056 ↑ 868.0 1 1

Index Only Scan using _hyper_9_145_chunk_price_date_idx on _hyper_9_145_chunk _hyper_9_145_chunk_1 (cost=0.28..64.47 rows=868 width=8) (actual time=0.056..0.056 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
54. 0.064 0.064 ↑ 1,086.0 1 1

Index Only Scan using _hyper_9_146_chunk_price_date_idx on _hyper_9_146_chunk _hyper_9_146_chunk_1 (cost=0.28..74.28 rows=1,086 width=8) (actual time=0.064..0.064 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
55. 1.041 1.041 ↑ 1,084.0 1 1

Index Only Scan using _hyper_9_147_chunk_price_date_idx on _hyper_9_147_chunk _hyper_9_147_chunk_1 (cost=0.28..74.41 rows=1,084 width=8) (actual time=1.041..1.041 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
56. 0.045 0.045 ↑ 861.0 1 1

Index Only Scan using _hyper_9_148_chunk_price_date_idx on _hyper_9_148_chunk _hyper_9_148_chunk_1 (cost=0.28..64.35 rows=861 width=8) (actual time=0.044..0.045 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
57. 0.052 0.052 ↑ 1,075.0 1 1

Index Only Scan using _hyper_9_149_chunk_price_date_idx on _hyper_9_149_chunk _hyper_9_149_chunk_1 (cost=0.28..74.10 rows=1,075 width=8) (actual time=0.051..0.052 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
58. 0.045 0.045 ↑ 1,075.0 1 1

Index Only Scan using _hyper_9_150_chunk_price_date_idx on _hyper_9_150_chunk _hyper_9_150_chunk_1 (cost=0.28..74.31 rows=1,075 width=8) (actual time=0.044..0.045 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
59. 0.046 0.046 ↑ 1,075.0 1 1

Index Only Scan using _hyper_9_151_chunk_price_date_idx on _hyper_9_151_chunk _hyper_9_151_chunk_1 (cost=0.28..74.43 rows=1,075 width=8) (actual time=0.046..0.046 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
60. 0.041 0.041 ↑ 1,075.0 1 1

Index Only Scan using _hyper_9_152_chunk_price_date_idx on _hyper_9_152_chunk _hyper_9_152_chunk_1 (cost=0.28..74.09 rows=1,075 width=8) (actual time=0.041..0.041 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
61. 0.051 0.051 ↑ 1,076.0 1 1

Index Only Scan using _hyper_9_153_chunk_price_date_idx on _hyper_9_153_chunk _hyper_9_153_chunk_1 (cost=0.28..74.15 rows=1,076 width=8) (actual time=0.051..0.051 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
62. 0.049 0.049 ↑ 1,070.0 1 1

Index Only Scan using _hyper_9_154_chunk_price_date_idx on _hyper_9_154_chunk _hyper_9_154_chunk_1 (cost=0.28..74.00 rows=1,070 width=8) (actual time=0.049..0.049 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
63. 0.065 0.065 ↑ 1,071.0 1 1

Index Only Scan using _hyper_9_155_chunk_price_date_idx on _hyper_9_155_chunk _hyper_9_155_chunk_1 (cost=0.28..74.05 rows=1,071 width=8) (actual time=0.065..0.065 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
64. 0.045 0.045 ↑ 1,070.0 1 1

Index Only Scan using _hyper_9_156_chunk_price_date_idx on _hyper_9_156_chunk _hyper_9_156_chunk_1 (cost=0.28..74.00 rows=1,070 width=8) (actual time=0.045..0.045 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
65. 0.047 0.047 ↑ 857.0 1 1

Index Only Scan using _hyper_9_157_chunk_price_date_idx on _hyper_9_157_chunk _hyper_9_157_chunk_1 (cost=0.28..64.27 rows=857 width=8) (actual time=0.047..0.047 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
66. 0.042 0.042 ↑ 1,074.0 1 1

Index Only Scan using _hyper_9_158_chunk_price_date_idx on _hyper_9_158_chunk _hyper_9_158_chunk_1 (cost=0.28..74.07 rows=1,074 width=8) (actual time=0.042..0.042 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
67. 0.100 0.100 ↑ 1,075.0 1 1

Index Only Scan using _hyper_9_159_chunk_price_date_idx on _hyper_9_159_chunk _hyper_9_159_chunk_1 (cost=0.28..74.09 rows=1,075 width=8) (actual time=0.099..0.100 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
68. 0.051 0.051 ↑ 1,075.0 1 1

Index Only Scan using _hyper_9_160_chunk_price_date_idx on _hyper_9_160_chunk _hyper_9_160_chunk_1 (cost=0.28..74.14 rows=1,075 width=8) (actual time=0.051..0.051 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
69. 0.050 0.050 ↑ 1,074.0 1 1

Index Only Scan using _hyper_9_161_chunk_price_date_idx on _hyper_9_161_chunk _hyper_9_161_chunk_1 (cost=0.28..74.07 rows=1,074 width=8) (actual time=0.050..0.050 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
70. 0.050 0.050 ↑ 851.0 1 1

Index Only Scan using _hyper_9_162_chunk_price_date_idx on _hyper_9_162_chunk _hyper_9_162_chunk_1 (cost=0.28..64.36 rows=851 width=8) (actual time=0.049..0.050 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
71. 0.050 0.050 ↑ 1,066.0 1 1

Index Only Scan using _hyper_9_163_chunk_price_date_idx on _hyper_9_163_chunk _hyper_9_163_chunk_1 (cost=0.28..73.93 rows=1,066 width=8) (actual time=0.050..0.050 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
72. 0.045 0.045 ↑ 851.0 1 1

Index Only Scan using _hyper_9_164_chunk_price_date_idx on _hyper_9_164_chunk _hyper_9_164_chunk_1 (cost=0.28..64.17 rows=851 width=8) (actual time=0.045..0.045 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
73. 0.071 0.071 ↑ 1,065.0 1 1

Index Only Scan using _hyper_9_165_chunk_price_date_idx on _hyper_9_165_chunk _hyper_9_165_chunk_1 (cost=0.28..74.02 rows=1,065 width=8) (actual time=0.070..0.071 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
74. 0.045 0.045 ↑ 1,060.0 1 1

Index Only Scan using _hyper_9_166_chunk_price_date_idx on _hyper_9_166_chunk _hyper_9_166_chunk_1 (cost=0.28..73.83 rows=1,060 width=8) (actual time=0.045..0.045 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
75. 0.049 0.049 ↑ 849.0 1 1

Index Only Scan using _hyper_9_167_chunk_price_date_idx on _hyper_9_167_chunk _hyper_9_167_chunk_1 (cost=0.28..64.13 rows=849 width=8) (actual time=0.048..0.049 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
76. 0.054 0.054 ↑ 1,062.0 1 1

Index Only Scan using _hyper_9_168_chunk_price_date_idx on _hyper_9_168_chunk _hyper_9_168_chunk_1 (cost=0.28..73.86 rows=1,062 width=8) (actual time=0.053..0.054 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
77. 0.053 0.053 ↑ 1,060.0 1 1

Index Only Scan using _hyper_9_169_chunk_price_date_idx on _hyper_9_169_chunk _hyper_9_169_chunk_1 (cost=0.28..73.88 rows=1,060 width=8) (actual time=0.053..0.053 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
78. 0.048 0.048 ↑ 849.0 1 1

Index Only Scan using _hyper_9_170_chunk_price_date_idx on _hyper_9_170_chunk _hyper_9_170_chunk_1 (cost=0.28..63.13 rows=849 width=8) (actual time=0.048..0.048 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
79. 0.051 0.051 ↑ 844.0 1 1

Index Only Scan using _hyper_9_171_chunk_price_date_idx on _hyper_9_171_chunk _hyper_9_171_chunk_1 (cost=0.28..63.04 rows=844 width=8) (actual time=0.051..0.051 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
80. 0.048 0.048 ↑ 1,057.0 1 1

Index Only Scan using _hyper_9_172_chunk_price_date_idx on _hyper_9_172_chunk _hyper_9_172_chunk_1 (cost=0.28..73.78 rows=1,057 width=8) (actual time=0.048..0.048 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
81. 0.049 0.049 ↑ 1,057.0 1 1

Index Only Scan using _hyper_9_173_chunk_price_date_idx on _hyper_9_173_chunk _hyper_9_173_chunk_1 (cost=0.28..73.78 rows=1,057 width=8) (actual time=0.049..0.049 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
82. 0.085 0.085 ↑ 1,055.0 1 1

Index Only Scan using _hyper_9_174_chunk_price_date_idx on _hyper_9_174_chunk _hyper_9_174_chunk_1 (cost=0.28..73.92 rows=1,055 width=8) (actual time=0.085..0.085 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
83. 0.051 0.051 ↑ 840.0 1 1

Index Only Scan using _hyper_9_175_chunk_price_date_idx on _hyper_9_175_chunk _hyper_9_175_chunk_1 (cost=0.28..62.99 rows=840 width=8) (actual time=0.051..0.051 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
84. 0.047 0.047 ↑ 1,051.0 1 1

Index Only Scan using _hyper_9_176_chunk_price_date_idx on _hyper_9_176_chunk _hyper_9_176_chunk_1 (cost=0.28..73.67 rows=1,051 width=8) (actual time=0.047..0.047 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
85. 0.094 0.094 ↑ 1,053.0 1 1

Index Only Scan using _hyper_9_177_chunk_price_date_idx on _hyper_9_177_chunk _hyper_9_177_chunk_1 (cost=0.28..73.70 rows=1,053 width=8) (actual time=0.094..0.094 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
86. 0.055 0.055 ↑ 1,051.0 1 1

Index Only Scan using _hyper_9_178_chunk_price_date_idx on _hyper_9_178_chunk _hyper_9_178_chunk_1 (cost=0.28..73.68 rows=1,051 width=8) (actual time=0.055..0.055 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
87. 0.054 0.054 ↑ 1,053.0 1 1

Index Only Scan using _hyper_9_179_chunk_price_date_idx on _hyper_9_179_chunk _hyper_9_179_chunk_1 (cost=0.28..72.81 rows=1,053 width=8) (actual time=0.054..0.054 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
88. 0.049 0.049 ↑ 1,048.0 1 1

Index Only Scan using _hyper_9_180_chunk_price_date_idx on _hyper_9_180_chunk _hyper_9_180_chunk_1 (cost=0.28..72.70 rows=1,048 width=8) (actual time=0.048..0.049 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
89. 0.055 0.055 ↑ 1,051.0 1 1

Index Only Scan using _hyper_9_181_chunk_price_date_idx on _hyper_9_181_chunk _hyper_9_181_chunk_1 (cost=0.28..72.67 rows=1,051 width=8) (actual time=0.054..0.055 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
90. 0.047 0.047 ↑ 1,051.0 1 1

Index Only Scan using _hyper_9_182_chunk_price_date_idx on _hyper_9_182_chunk _hyper_9_182_chunk_1 (cost=0.28..72.67 rows=1,051 width=8) (actual time=0.047..0.047 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
91. 0.069 0.069 ↑ 1,050.0 1 1

Index Only Scan using _hyper_9_183_chunk_price_date_idx on _hyper_9_183_chunk _hyper_9_183_chunk_1 (cost=0.28..72.65 rows=1,050 width=8) (actual time=0.069..0.069 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
92. 0.045 0.045 ↑ 1,050.0 1 1

Index Only Scan using _hyper_9_184_chunk_price_date_idx on _hyper_9_184_chunk _hyper_9_184_chunk_1 (cost=0.28..72.68 rows=1,050 width=8) (actual time=0.045..0.045 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
93. 0.048 0.048 ↑ 1,050.0 1 1

Index Only Scan using _hyper_9_185_chunk_price_date_idx on _hyper_9_185_chunk _hyper_9_185_chunk_1 (cost=0.28..72.70 rows=1,050 width=8) (actual time=0.048..0.048 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
94. 0.051 0.051 ↑ 1,050.0 1 1

Index Only Scan using _hyper_9_186_chunk_price_date_idx on _hyper_9_186_chunk _hyper_9_186_chunk_1 (cost=0.28..73.65 rows=1,050 width=8) (actual time=0.051..0.051 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
95. 0.047 0.047 ↑ 1,049.0 1 1

Index Only Scan using _hyper_9_187_chunk_price_date_idx on _hyper_9_187_chunk _hyper_9_187_chunk_1 (cost=0.28..72.64 rows=1,049 width=8) (actual time=0.047..0.047 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
96. 0.047 0.047 ↑ 1,050.0 1 1

Index Only Scan using _hyper_9_188_chunk_price_date_idx on _hyper_9_188_chunk _hyper_9_188_chunk_1 (cost=0.28..72.76 rows=1,050 width=8) (actual time=0.047..0.047 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
97. 0.048 0.048 ↑ 1,049.0 1 1

Index Only Scan using _hyper_9_189_chunk_price_date_idx on _hyper_9_189_chunk _hyper_9_189_chunk_1 (cost=0.28..72.64 rows=1,049 width=8) (actual time=0.048..0.048 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
98. 0.064 0.064 ↑ 840.0 1 1

Index Only Scan using _hyper_9_190_chunk_price_date_idx on _hyper_9_190_chunk _hyper_9_190_chunk_1 (cost=0.28..63.71 rows=840 width=8) (actual time=0.063..0.064 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
99. 0.049 0.049 ↑ 840.0 1 1

Index Only Scan using _hyper_9_191_chunk_price_date_idx on _hyper_9_191_chunk _hyper_9_191_chunk_1 (cost=0.28..62.97 rows=840 width=8) (actual time=0.048..0.049 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
100. 0.045 0.045 ↑ 1,049.0 1 1

Index Only Scan using _hyper_9_192_chunk_price_date_idx on _hyper_9_192_chunk _hyper_9_192_chunk_1 (cost=0.28..72.76 rows=1,049 width=8) (actual time=0.045..0.045 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
101. 0.054 0.054 ↑ 1,050.0 1 1

Index Only Scan using _hyper_9_193_chunk_price_date_idx on _hyper_9_193_chunk _hyper_9_193_chunk_1 (cost=0.28..72.65 rows=1,050 width=8) (actual time=0.054..0.054 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
102. 0.048 0.048 ↑ 840.0 1 1

Index Only Scan using _hyper_9_194_chunk_price_date_idx on _hyper_9_194_chunk _hyper_9_194_chunk_1 (cost=0.28..62.97 rows=840 width=8) (actual time=0.048..0.048 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
103. 0.091 0.091 ↑ 840.0 1 1

Index Only Scan using _hyper_9_195_chunk_price_date_idx on _hyper_9_195_chunk _hyper_9_195_chunk_1 (cost=0.28..62.97 rows=840 width=8) (actual time=0.090..0.091 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
104. 0.060 0.060 ↑ 1,047.0 1 1

Index Only Scan using _hyper_9_196_chunk_price_date_idx on _hyper_9_196_chunk _hyper_9_196_chunk_1 (cost=0.28..72.61 rows=1,047 width=8) (actual time=0.059..0.060 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
105. 0.060 0.060 ↑ 832.0 1 1

Index Only Scan using _hyper_9_197_chunk_price_date_idx on _hyper_9_197_chunk _hyper_9_197_chunk_1 (cost=0.28..63.02 rows=832 width=8) (actual time=0.060..0.060 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
106. 0.051 0.051 ↑ 1,040.0 1 1

Index Only Scan using _hyper_9_198_chunk_price_date_idx on _hyper_9_198_chunk _hyper_9_198_chunk_1 (cost=0.28..72.57 rows=1,040 width=8) (actual time=0.051..0.051 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
107. 0.056 0.056 ↑ 831.0 1 1

Index Only Scan using _hyper_9_199_chunk_price_date_idx on _hyper_9_199_chunk _hyper_9_199_chunk_1 (cost=0.28..62.82 rows=831 width=8) (actual time=0.056..0.056 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
108. 0.047 0.047 ↑ 1,036.0 1 1

Index Only Scan using _hyper_9_200_chunk_price_date_idx on _hyper_9_200_chunk _hyper_9_200_chunk_1 (cost=0.28..72.41 rows=1,036 width=8) (actual time=0.047..0.047 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
109. 0.071 0.071 ↑ 1,038.0 1 1

Index Only Scan using _hyper_9_201_chunk_price_date_idx on _hyper_9_201_chunk _hyper_9_201_chunk_1 (cost=0.28..72.44 rows=1,038 width=8) (actual time=0.071..0.071 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
110. 0.065 0.065 ↑ 832.0 1 1

Index Only Scan using _hyper_9_202_chunk_price_date_idx on _hyper_9_202_chunk _hyper_9_202_chunk_1 (cost=0.28..62.84 rows=832 width=8) (actual time=0.046..0.065 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
111. 0.049 0.049 ↑ 1,037.0 1 1

Index Only Scan using _hyper_9_203_chunk_price_date_idx on _hyper_9_203_chunk _hyper_9_203_chunk_1 (cost=0.28..72.43 rows=1,037 width=8) (actual time=0.049..0.049 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
112. 0.087 0.087 ↑ 1,037.0 1 1

Index Only Scan using _hyper_9_204_chunk_price_date_idx on _hyper_9_204_chunk _hyper_9_204_chunk_1 (cost=0.28..72.48 rows=1,037 width=8) (actual time=0.087..0.087 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
113. 0.051 0.051 ↑ 828.0 1 1

Index Only Scan using _hyper_9_205_chunk_price_date_idx on _hyper_9_205_chunk _hyper_9_205_chunk_1 (cost=0.28..62.83 rows=828 width=8) (actual time=0.051..0.051 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
114. 0.046 0.046 ↑ 1,024.0 1 1

Index Only Scan using _hyper_9_206_chunk_price_date_idx on _hyper_9_206_chunk _hyper_9_206_chunk_1 (cost=0.28..72.20 rows=1,024 width=8) (actual time=0.045..0.046 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
115. 0.047 0.047 ↑ 1,023.0 1 1

Index Only Scan using _hyper_9_207_chunk_price_date_idx on _hyper_9_207_chunk _hyper_9_207_chunk_1 (cost=0.28..72.23 rows=1,023 width=8) (actual time=0.046..0.047 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
116. 0.047 0.047 ↑ 1,021.0 1 1

Index Only Scan using _hyper_9_208_chunk_price_date_idx on _hyper_9_208_chunk _hyper_9_208_chunk_1 (cost=0.28..72.24 rows=1,021 width=8) (actual time=0.047..0.047 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
117. 0.053 0.053 ↑ 818.0 1 1

Index Only Scan using _hyper_9_209_chunk_price_date_idx on _hyper_9_209_chunk _hyper_9_209_chunk_1 (cost=0.28..62.70 rows=818 width=8) (actual time=0.052..0.053 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
118. 0.047 0.047 ↑ 1,015.0 1 1

Index Only Scan using _hyper_9_210_chunk_price_date_idx on _hyper_9_210_chunk _hyper_9_210_chunk_1 (cost=0.28..71.04 rows=1,015 width=8) (actual time=0.046..0.047 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
119. 0.050 0.050 ↑ 812.0 1 1

Index Only Scan using _hyper_9_390_chunk_price_date_idx on _hyper_9_390_chunk _hyper_9_390_chunk_1 (cost=0.28..61.49 rows=812 width=8) (actual time=0.050..0.050 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
120. 0.251 0.251 ↑ 203.0 1 1

Index Only Scan using _hyper_9_391_chunk_price_date_idx on _hyper_9_391_chunk _hyper_9_391_chunk_1 (cost=0.14..35.62 rows=203 width=8) (actual time=0.250..0.251 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
121. 0.065 0.065 ↑ 713.0 1 1

Index Only Scan using _hyper_9_80_chunk_price_date_idx on _hyper_9_80_chunk _hyper_9_80_chunk_1 (cost=0.28..52.75 rows=713 width=8) (actual time=0.064..0.065 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
122. 0.053 0.053 ↑ 890.0 1 1

Index Only Scan using _hyper_9_81_chunk_price_date_idx on _hyper_9_81_chunk _hyper_9_81_chunk_1 (cost=0.28..64.86 rows=890 width=8) (actual time=0.053..0.053 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
123. 0.049 0.049 ↑ 890.0 1 1

Index Only Scan using _hyper_9_82_chunk_price_date_idx on _hyper_9_82_chunk _hyper_9_82_chunk_1 (cost=0.28..65.85 rows=890 width=8) (actual time=0.049..0.049 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
124. 0.067 0.067 ↑ 890.0 1 1

Index Only Scan using _hyper_9_83_chunk_price_date_idx on _hyper_9_83_chunk _hyper_9_83_chunk_1 (cost=0.28..65.85 rows=890 width=8) (actual time=0.067..0.067 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
125. 0.044 0.044 ↑ 885.0 1 1

Index Only Scan using _hyper_9_84_chunk_price_date_idx on _hyper_9_84_chunk _hyper_9_84_chunk_1 (cost=0.28..65.76 rows=885 width=8) (actual time=0.044..0.044 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
126. 0.047 0.047 ↑ 885.0 1 1

Index Only Scan using _hyper_9_85_chunk_price_date_idx on _hyper_9_85_chunk _hyper_9_85_chunk_1 (cost=0.28..65.76 rows=885 width=8) (actual time=0.047..0.047 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
127. 0.050 0.050 ↑ 709.0 1 1

Index Only Scan using _hyper_9_86_chunk_price_date_idx on _hyper_9_86_chunk _hyper_9_86_chunk_1 (cost=0.28..52.68 rows=709 width=8) (actual time=0.050..0.050 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
128. 0.049 0.049 ↑ 887.0 1 1

Index Only Scan using _hyper_9_87_chunk_price_date_idx on _hyper_9_87_chunk _hyper_9_87_chunk_1 (cost=0.28..65.81 rows=887 width=8) (actual time=0.049..0.049 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
129. 0.050 0.050 ↑ 887.0 1 1

Index Only Scan using _hyper_9_88_chunk_price_date_idx on _hyper_9_88_chunk _hyper_9_88_chunk_1 (cost=0.28..65.80 rows=887 width=8) (actual time=0.050..0.050 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
130. 0.043 0.043 ↑ 710.0 1 1

Index Only Scan using _hyper_9_89_chunk_price_date_idx on _hyper_9_89_chunk _hyper_9_89_chunk_1 (cost=0.28..52.70 rows=710 width=8) (actual time=0.043..0.043 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
131. 0.045 0.045 ↑ 709.0 1 1

Index Only Scan using _hyper_9_90_chunk_price_date_idx on _hyper_9_90_chunk _hyper_9_90_chunk_1 (cost=0.28..52.68 rows=709 width=8) (actual time=0.045..0.045 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
132. 0.050 0.050 ↑ 886.0 1 1

Index Only Scan using _hyper_9_91_chunk_price_date_idx on _hyper_9_91_chunk _hyper_9_91_chunk_1 (cost=0.28..65.78 rows=886 width=8) (actual time=0.049..0.050 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
133. 0.044 0.044 ↑ 886.0 1 1

Index Only Scan using _hyper_9_92_chunk_price_date_idx on _hyper_9_92_chunk _hyper_9_92_chunk_1 (cost=0.28..65.78 rows=886 width=8) (actual time=0.044..0.044 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
134. 0.049 0.049 ↑ 902.0 1 1

Index Only Scan using _hyper_9_93_chunk_price_date_idx on _hyper_9_93_chunk _hyper_9_93_chunk_1 (cost=0.28..66.06 rows=902 width=8) (actual time=0.048..0.049 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
135. 0.043 0.043 ↑ 541.0 1 1

Index Only Scan using _hyper_9_94_chunk_price_date_idx on _hyper_9_94_chunk _hyper_9_94_chunk_1 (cost=0.28..44.74 rows=541 width=8) (actual time=0.043..0.043 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
136. 0.050 0.050 ↑ 902.0 1 1

Index Only Scan using _hyper_9_95_chunk_price_date_idx on _hyper_9_95_chunk _hyper_9_95_chunk_1 (cost=0.28..66.06 rows=902 width=8) (actual time=0.050..0.050 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
137. 0.096 0.096 ↑ 900.0 1 1

Index Only Scan using _hyper_9_96_chunk_price_date_idx on _hyper_9_96_chunk _hyper_9_96_chunk_1 (cost=0.28..66.03 rows=900 width=8) (actual time=0.096..0.096 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
138. 0.149 0.149 ↑ 720.0 1 1

Index Only Scan using _hyper_9_97_chunk_price_date_idx on _hyper_9_97_chunk _hyper_9_97_chunk_1 (cost=0.28..53.92 rows=720 width=8) (actual time=0.149..0.149 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
139. 0.070 0.070 ↑ 900.0 1 1

Index Only Scan using _hyper_9_98_chunk_price_date_idx on _hyper_9_98_chunk _hyper_9_98_chunk_1 (cost=0.28..66.03 rows=900 width=8) (actual time=0.069..0.070 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
140. 0.048 0.048 ↑ 720.0 1 1

Index Only Scan using _hyper_9_99_chunk_price_date_idx on _hyper_9_99_chunk _hyper_9_99_chunk_1 (cost=0.28..53.88 rows=720 width=8) (actual time=0.047..0.048 rows=1 loops=1)

  • Index Cond: (date IS NOT NULL)
  • Heap Fetches: 1
141. 0.097 51.361 ↑ 3.0 203 1

Append (cost=0.00..5,672.78 rows=607 width=234) (actual time=45.730..51.361 rows=203 loops=1)

142. 9.751 9.751 ↓ 0.0 0 1

Seq Scan on _hyper_9_100_chunk (cost=0.00..40.50 rows=4 width=234) (actual time=9.751..9.751 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 900
143. 0.274 0.274 ↓ 0.0 0 1

Seq Scan on _hyper_9_101_chunk (cost=0.00..40.50 rows=4 width=234) (actual time=0.274..0.274 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 900
144. 0.332 0.332 ↓ 0.0 0 1

Seq Scan on _hyper_9_102_chunk (cost=0.00..40.50 rows=4 width=234) (actual time=0.332..0.332 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 900
145. 0.268 0.268 ↓ 0.0 0 1

Seq Scan on _hyper_9_103_chunk (cost=0.00..40.50 rows=4 width=233) (actual time=0.268..0.268 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 900
146. 0.250 0.250 ↓ 0.0 0 1

Seq Scan on _hyper_9_104_chunk (cost=0.00..40.50 rows=4 width=234) (actual time=0.250..0.250 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 900
147. 0.291 0.291 ↓ 0.0 0 1

Seq Scan on _hyper_9_105_chunk (cost=0.00..40.50 rows=4 width=233) (actual time=0.291..0.291 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 900
148. 0.342 0.342 ↓ 0.0 0 1

Seq Scan on _hyper_9_106_chunk (cost=0.00..40.59 rows=5 width=233) (actual time=0.342..0.342 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 906
149. 0.251 0.251 ↓ 0.0 0 1

Seq Scan on _hyper_9_107_chunk (cost=0.00..40.58 rows=5 width=234) (actual time=0.251..0.251 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 905
150. 0.257 0.257 ↓ 0.0 0 1

Seq Scan on _hyper_9_108_chunk (cost=0.00..40.58 rows=5 width=234) (actual time=0.257..0.257 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 905
151. 0.271 0.271 ↓ 0.0 0 1

Seq Scan on _hyper_9_109_chunk (cost=0.00..32.86 rows=4 width=234) (actual time=0.271..0.271 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 724
152. 0.283 0.283 ↓ 0.0 0 1

Seq Scan on _hyper_9_110_chunk (cost=0.00..40.58 rows=5 width=233) (actual time=0.283..0.283 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 905
153. 0.231 0.231 ↓ 0.0 0 1

Seq Scan on _hyper_9_111_chunk (cost=0.00..40.58 rows=5 width=233) (actual time=0.231..0.231 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 905
154. 0.234 0.234 ↓ 0.0 0 1

Seq Scan on _hyper_9_112_chunk (cost=0.00..40.58 rows=5 width=233) (actual time=0.233..0.234 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 905
155. 0.307 0.307 ↓ 0.0 0 1

Seq Scan on _hyper_9_113_chunk (cost=0.00..40.56 rows=5 width=233) (actual time=0.307..0.307 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 904
156. 0.218 0.218 ↓ 0.0 0 1

Seq Scan on _hyper_9_114_chunk (cost=0.00..32.77 rows=4 width=233) (actual time=0.218..0.218 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 718
157. 0.260 0.260 ↓ 0.0 0 1

Seq Scan on _hyper_9_115_chunk (cost=0.00..40.48 rows=4 width=233) (actual time=0.260..0.260 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 899
158. 0.284 0.284 ↓ 0.0 0 1

Seq Scan on _hyper_9_116_chunk (cost=0.00..32.80 rows=4 width=233) (actual time=0.284..0.284 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 720
159. 0.284 0.284 ↓ 0.0 0 1

Seq Scan on _hyper_9_117_chunk (cost=0.00..40.50 rows=4 width=233) (actual time=0.284..0.284 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 900
160. 0.297 0.297 ↓ 0.0 0 1

Seq Scan on _hyper_9_118_chunk (cost=0.00..40.52 rows=5 width=233) (actual time=0.296..0.297 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 901
161. 0.207 0.207 ↓ 0.0 0 1

Seq Scan on _hyper_9_119_chunk (cost=0.00..34.67 rows=4 width=231) (actual time=0.207..0.207 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 778
162. 0.342 0.342 ↓ 0.0 0 1

Seq Scan on _hyper_9_120_chunk (cost=0.00..43.56 rows=5 width=232) (actual time=0.342..0.342 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 971
163. 0.257 0.257 ↓ 0.0 0 1

Seq Scan on _hyper_9_121_chunk (cost=0.00..34.64 rows=4 width=232) (actual time=0.257..0.257 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 776
164. 0.249 0.249 ↓ 0.0 0 1

Seq Scan on _hyper_9_122_chunk (cost=0.00..43.55 rows=5 width=232) (actual time=0.249..0.249 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 970
165. 0.268 0.268 ↓ 0.0 0 1

Seq Scan on _hyper_9_123_chunk (cost=0.00..37.54 rows=4 width=232) (actual time=0.268..0.268 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 836
166. 0.394 0.394 ↓ 0.0 0 1

Seq Scan on _hyper_9_124_chunk (cost=0.00..46.67 rows=5 width=232) (actual time=0.394..0.394 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1045
167. 0.328 0.328 ↓ 0.0 0 1

Seq Scan on _hyper_9_125_chunk (cost=0.00..46.67 rows=5 width=232) (actual time=0.327..0.328 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1045
168. 0.262 0.262 ↓ 0.0 0 1

Seq Scan on _hyper_9_126_chunk (cost=0.00..46.69 rows=5 width=232) (actual time=0.262..0.262 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1046
169. 0.345 0.345 ↓ 0.0 0 1

Seq Scan on _hyper_9_127_chunk (cost=0.00..48.05 rows=5 width=232) (actual time=0.345..0.345 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1070
170. 0.316 0.316 ↓ 0.0 0 1

Seq Scan on _hyper_9_128_chunk (cost=0.00..48.05 rows=5 width=232) (actual time=0.316..0.316 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1070
171. 0.269 0.269 ↓ 0.0 0 1

Seq Scan on _hyper_9_129_chunk (cost=0.00..48.05 rows=5 width=233) (actual time=0.269..0.269 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1070
172. 0.379 0.379 ↓ 0.0 0 1

Seq Scan on _hyper_9_130_chunk (cost=0.00..48.05 rows=5 width=233) (actual time=0.379..0.379 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1070
173. 0.261 0.261 ↓ 0.0 0 1

Seq Scan on _hyper_9_131_chunk (cost=0.00..38.85 rows=4 width=232) (actual time=0.261..0.261 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 857
174. 0.426 0.426 ↓ 0.0 0 1

Seq Scan on _hyper_9_132_chunk (cost=0.00..49.39 rows=5 width=233) (actual time=0.426..0.426 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1093
175. 0.451 0.451 ↓ 0.0 0 1

Seq Scan on _hyper_9_133_chunk (cost=0.00..49.38 rows=5 width=233) (actual time=0.451..0.451 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1092
176. 0.309 0.309 ↓ 0.0 0 1

Seq Scan on _hyper_9_134_chunk (cost=0.00..49.35 rows=5 width=233) (actual time=0.309..0.309 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1090
177. 0.300 0.300 ↓ 0.0 0 1

Seq Scan on _hyper_9_135_chunk (cost=0.00..49.38 rows=5 width=233) (actual time=0.300..0.300 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1092
178. 0.420 0.420 ↓ 0.0 0 1

Seq Scan on _hyper_9_136_chunk (cost=0.00..49.35 rows=5 width=233) (actual time=0.420..0.420 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1090
179. 0.298 0.298 ↓ 0.0 0 1

Seq Scan on _hyper_9_137_chunk (cost=0.00..49.38 rows=5 width=234) (actual time=0.298..0.298 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1092
180. 0.221 0.221 ↓ 0.0 0 1

Seq Scan on _hyper_9_138_chunk (cost=0.00..39.09 rows=4 width=234) (actual time=0.221..0.221 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 873
181. 0.367 0.367 ↓ 0.0 0 1

Seq Scan on _hyper_9_139_chunk (cost=0.00..49.35 rows=5 width=234) (actual time=0.367..0.367 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1090
182. 0.261 0.261 ↓ 0.0 0 1

Seq Scan on _hyper_9_140_chunk (cost=0.00..39.09 rows=4 width=234) (actual time=0.261..0.261 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 873
183. 0.278 0.278 ↓ 0.0 0 1

Seq Scan on _hyper_9_141_chunk (cost=0.00..48.27 rows=5 width=233) (actual time=0.278..0.278 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1085
184. 0.364 0.364 ↓ 0.0 0 1

Seq Scan on _hyper_9_142_chunk (cost=0.00..48.27 rows=5 width=234) (actual time=0.363..0.364 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1085
185. 0.321 0.321 ↓ 0.0 0 1

Seq Scan on _hyper_9_143_chunk (cost=0.00..48.27 rows=5 width=234) (actual time=0.321..0.321 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1085
186. 0.277 0.277 ↓ 0.0 0 1

Seq Scan on _hyper_9_144_chunk (cost=0.00..49.29 rows=5 width=233) (actual time=0.277..0.277 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1086
187. 0.260 0.260 ↓ 0.0 0 1

Seq Scan on _hyper_9_145_chunk (cost=0.00..39.02 rows=4 width=234) (actual time=0.260..0.260 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 868
188. 0.346 0.346 ↓ 0.0 0 1

Seq Scan on _hyper_9_146_chunk (cost=0.00..48.29 rows=5 width=234) (actual time=0.346..0.346 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1086
189. 0.309 0.309 ↓ 0.0 0 1

Seq Scan on _hyper_9_147_chunk (cost=0.00..48.26 rows=5 width=234) (actual time=0.309..0.309 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1084
190. 0.261 0.261 ↓ 0.0 0 1

Seq Scan on _hyper_9_148_chunk (cost=0.00..38.91 rows=4 width=234) (actual time=0.261..0.261 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 861
191. 0.377 0.377 ↓ 0.0 0 1

Seq Scan on _hyper_9_149_chunk (cost=0.00..48.13 rows=5 width=234) (actual time=0.377..0.377 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1075
192. 0.361 0.361 ↓ 0.0 0 1

Seq Scan on _hyper_9_150_chunk (cost=0.00..48.13 rows=5 width=233) (actual time=0.361..0.361 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1075
193. 0.393 0.393 ↓ 0.0 0 1

Seq Scan on _hyper_9_151_chunk (cost=0.00..48.13 rows=5 width=233) (actual time=0.393..0.393 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1075
194. 0.387 0.387 ↓ 0.0 0 1

Seq Scan on _hyper_9_152_chunk (cost=0.00..48.13 rows=5 width=234) (actual time=0.387..0.387 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1075
195. 0.326 0.326 ↓ 0.0 0 1

Seq Scan on _hyper_9_153_chunk (cost=0.00..48.14 rows=5 width=234) (actual time=0.326..0.326 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1076
196. 0.518 0.518 ↓ 0.0 0 1

Seq Scan on _hyper_9_154_chunk (cost=0.00..48.05 rows=5 width=233) (actual time=0.518..0.518 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1070
197. 0.388 0.388 ↓ 0.0 0 1

Seq Scan on _hyper_9_155_chunk (cost=0.00..48.06 rows=5 width=234) (actual time=0.388..0.388 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1071
198. 0.330 0.330 ↓ 0.0 0 1

Seq Scan on _hyper_9_156_chunk (cost=0.00..48.05 rows=5 width=234) (actual time=0.330..0.330 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1070
199. 0.272 0.272 ↓ 0.0 0 1

Seq Scan on _hyper_9_157_chunk (cost=0.00..38.85 rows=4 width=234) (actual time=0.272..0.272 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 857
200. 0.315 0.315 ↓ 0.0 0 1

Seq Scan on _hyper_9_158_chunk (cost=0.00..48.11 rows=5 width=233) (actual time=0.315..0.315 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1074
201. 0.289 0.289 ↓ 0.0 0 1

Seq Scan on _hyper_9_159_chunk (cost=0.00..48.13 rows=5 width=233) (actual time=0.289..0.289 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1075
202. 0.358 0.358 ↓ 0.0 0 1

Seq Scan on _hyper_9_160_chunk (cost=0.00..48.13 rows=5 width=233) (actual time=0.357..0.358 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1075
203. 0.305 0.305 ↓ 0.0 0 1

Seq Scan on _hyper_9_161_chunk (cost=0.00..48.11 rows=5 width=233) (actual time=0.304..0.305 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1074
204. 0.215 0.215 ↓ 0.0 0 1

Seq Scan on _hyper_9_162_chunk (cost=0.00..38.77 rows=4 width=233) (actual time=0.215..0.215 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 851
205. 0.310 0.310 ↓ 0.0 0 1

Seq Scan on _hyper_9_163_chunk (cost=0.00..47.99 rows=5 width=233) (actual time=0.309..0.310 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1066
206. 0.300 0.300 ↓ 0.0 0 1

Seq Scan on _hyper_9_164_chunk (cost=0.00..38.77 rows=4 width=234) (actual time=0.300..0.300 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 851
207. 0.301 0.301 ↓ 0.0 0 1

Seq Scan on _hyper_9_165_chunk (cost=0.00..47.98 rows=5 width=234) (actual time=0.301..0.301 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1065
208. 0.289 0.289 ↓ 0.0 0 1

Seq Scan on _hyper_9_166_chunk (cost=0.00..47.90 rows=5 width=234) (actual time=0.289..0.289 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1060
209. 0.307 0.307 ↓ 0.0 0 1

Seq Scan on _hyper_9_167_chunk (cost=0.00..38.73 rows=4 width=233) (actual time=0.307..0.307 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 849
210. 0.279 0.279 ↓ 0.0 0 1

Seq Scan on _hyper_9_168_chunk (cost=0.00..47.93 rows=5 width=233) (actual time=0.279..0.279 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1062
211. 0.259 0.259 ↓ 0.0 0 1

Seq Scan on _hyper_9_169_chunk (cost=0.00..47.90 rows=5 width=234) (actual time=0.259..0.259 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1060
212. 0.267 0.267 ↓ 0.0 0 1

Seq Scan on _hyper_9_170_chunk (cost=0.00..37.73 rows=4 width=234) (actual time=0.267..0.267 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 849
213. 0.311 0.311 ↓ 0.0 0 1

Seq Scan on _hyper_9_171_chunk (cost=0.00..37.66 rows=4 width=234) (actual time=0.311..0.311 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 844
214. 0.438 0.438 ↓ 0.0 0 1

Seq Scan on _hyper_9_172_chunk (cost=0.00..47.85 rows=5 width=234) (actual time=0.438..0.438 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1057
215. 0.529 0.529 ↓ 0.0 0 1

Seq Scan on _hyper_9_173_chunk (cost=0.00..47.85 rows=5 width=234) (actual time=0.529..0.529 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1057
216. 0.691 0.691 ↓ 0.0 0 1

Seq Scan on _hyper_9_174_chunk (cost=0.00..47.83 rows=5 width=233) (actual time=0.691..0.691 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1055
217. 0.309 0.309 ↓ 0.0 0 1

Seq Scan on _hyper_9_175_chunk (cost=0.00..37.60 rows=4 width=233) (actual time=0.309..0.309 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 840
218. 0.586 0.586 ↓ 0.0 0 1

Seq Scan on _hyper_9_176_chunk (cost=0.00..47.77 rows=5 width=233) (actual time=0.586..0.586 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1051
219. 0.512 0.512 ↓ 0.0 0 1

Seq Scan on _hyper_9_177_chunk (cost=0.00..47.80 rows=5 width=233) (actual time=0.512..0.512 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1053
220. 0.531 0.531 ↓ 0.0 0 1

Seq Scan on _hyper_9_178_chunk (cost=0.00..47.77 rows=5 width=234) (actual time=0.531..0.531 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1051
221. 0.379 0.379 ↓ 0.0 0 1

Seq Scan on _hyper_9_179_chunk (cost=0.00..46.80 rows=5 width=234) (actual time=0.379..0.379 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1053
222. 0.330 0.330 ↓ 0.0 0 1

Seq Scan on _hyper_9_180_chunk (cost=0.00..46.72 rows=5 width=233) (actual time=0.330..0.330 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1048
223. 0.309 0.309 ↓ 0.0 0 1

Seq Scan on _hyper_9_181_chunk (cost=0.00..46.77 rows=5 width=234) (actual time=0.309..0.309 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1051
224. 0.365 0.365 ↓ 0.0 0 1

Seq Scan on _hyper_9_182_chunk (cost=0.00..46.77 rows=5 width=233) (actual time=0.365..0.365 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1051
225. 0.282 0.282 ↓ 0.0 0 1

Seq Scan on _hyper_9_183_chunk (cost=0.00..46.75 rows=5 width=233) (actual time=0.282..0.282 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1050
226. 0.311 0.311 ↓ 0.0 0 1

Seq Scan on _hyper_9_184_chunk (cost=0.00..46.75 rows=5 width=233) (actual time=0.311..0.311 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1050
227. 0.343 0.343 ↓ 0.0 0 1

Seq Scan on _hyper_9_185_chunk (cost=0.00..46.75 rows=5 width=233) (actual time=0.343..0.343 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1050
228. 0.280 0.280 ↓ 0.0 0 1

Seq Scan on _hyper_9_186_chunk (cost=0.00..47.75 rows=5 width=234) (actual time=0.280..0.280 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1050
229. 0.281 0.281 ↓ 0.0 0 1

Seq Scan on _hyper_9_187_chunk (cost=0.00..46.73 rows=5 width=233) (actual time=0.281..0.281 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1049
230. 0.346 0.346 ↓ 0.0 0 1

Seq Scan on _hyper_9_188_chunk (cost=0.00..46.75 rows=5 width=233) (actual time=0.346..0.346 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1050
231. 0.363 0.363 ↓ 0.0 0 1

Seq Scan on _hyper_9_189_chunk (cost=0.00..46.73 rows=5 width=234) (actual time=0.363..0.363 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1049
232. 0.215 0.215 ↓ 0.0 0 1

Seq Scan on _hyper_9_190_chunk (cost=0.00..37.60 rows=4 width=234) (actual time=0.215..0.215 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 840
233. 0.257 0.257 ↓ 0.0 0 1

Seq Scan on _hyper_9_191_chunk (cost=0.00..37.60 rows=4 width=234) (actual time=0.257..0.257 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 840
234. 0.386 0.386 ↓ 0.0 0 1

Seq Scan on _hyper_9_192_chunk (cost=0.00..46.73 rows=5 width=234) (actual time=0.385..0.386 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1049
235. 0.320 0.320 ↓ 0.0 0 1

Seq Scan on _hyper_9_193_chunk (cost=0.00..46.75 rows=5 width=233) (actual time=0.320..0.320 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1050
236. 0.362 0.362 ↓ 0.0 0 1

Seq Scan on _hyper_9_194_chunk (cost=0.00..37.60 rows=4 width=233) (actual time=0.362..0.362 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 840
237. 0.293 0.293 ↓ 0.0 0 1

Seq Scan on _hyper_9_195_chunk (cost=0.00..37.60 rows=4 width=233) (actual time=0.293..0.293 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 840
238. 0.346 0.346 ↓ 0.0 0 1

Seq Scan on _hyper_9_196_chunk (cost=0.00..46.70 rows=5 width=233) (actual time=0.346..0.346 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1047
239. 0.355 0.355 ↓ 0.0 0 1

Seq Scan on _hyper_9_197_chunk (cost=0.00..37.48 rows=4 width=234) (actual time=0.355..0.355 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 832
240. 0.360 0.360 ↓ 0.0 0 1

Seq Scan on _hyper_9_198_chunk (cost=0.00..46.60 rows=5 width=234) (actual time=0.360..0.360 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1040
241. 0.261 0.261 ↓ 0.0 0 1

Seq Scan on _hyper_9_199_chunk (cost=0.00..37.47 rows=4 width=234) (actual time=0.261..0.261 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 831
242. 0.419 0.419 ↓ 0.0 0 1

Seq Scan on _hyper_9_200_chunk (cost=0.00..46.54 rows=5 width=234) (actual time=0.419..0.419 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1036
243. 0.306 0.306 ↓ 0.0 0 1

Seq Scan on _hyper_9_201_chunk (cost=0.00..46.57 rows=5 width=233) (actual time=0.306..0.306 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1038
244. 0.263 0.263 ↓ 0.0 0 1

Seq Scan on _hyper_9_202_chunk (cost=0.00..37.48 rows=4 width=233) (actual time=0.262..0.263 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 832
245. 0.313 0.313 ↓ 0.0 0 1

Seq Scan on _hyper_9_203_chunk (cost=0.00..46.56 rows=5 width=234) (actual time=0.313..0.313 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1037
246. 0.373 0.373 ↓ 0.0 0 1

Seq Scan on _hyper_9_204_chunk (cost=0.00..46.56 rows=5 width=233) (actual time=0.373..0.373 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1037
247. 0.294 0.294 ↓ 0.0 0 1

Seq Scan on _hyper_9_205_chunk (cost=0.00..37.42 rows=4 width=233) (actual time=0.294..0.294 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 828
248. 0.349 0.349 ↓ 0.0 0 1

Seq Scan on _hyper_9_206_chunk (cost=0.00..46.36 rows=5 width=233) (actual time=0.349..0.349 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1024
249. 0.347 0.347 ↓ 0.0 0 1

Seq Scan on _hyper_9_207_chunk (cost=0.00..46.34 rows=5 width=233) (actual time=0.347..0.347 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1023
250. 0.288 0.288 ↓ 0.0 0 1

Seq Scan on _hyper_9_208_chunk (cost=0.00..46.31 rows=5 width=234) (actual time=0.288..0.288 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1021
251. 0.229 0.229 ↓ 0.0 0 1

Seq Scan on _hyper_9_209_chunk (cost=0.00..37.27 rows=4 width=234) (actual time=0.229..0.229 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 818
252. 0.359 0.359 ↓ 0.0 0 1

Seq Scan on _hyper_9_210_chunk (cost=0.00..45.23 rows=5 width=234) (actual time=0.359..0.359 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 1015
253. 0.300 0.300 ↓ 0.0 0 1

Seq Scan on _hyper_9_390_chunk (cost=0.00..36.18 rows=4 width=234) (actual time=0.300..0.300 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 812
254. 0.080 0.080 ↓ 203.0 203 1

Seq Scan on _hyper_9_391_chunk (cost=0.00..10.05 rows=1 width=227) (actual time=0.011..0.080 rows=203 loops=1)

  • Filter: (date(date) = $1)
255. 0.284 0.284 ↓ 0.0 0 1

Seq Scan on _hyper_9_80_chunk (cost=0.00..31.70 rows=4 width=233) (actual time=0.284..0.284 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 713
256. 0.298 0.298 ↓ 0.0 0 1

Seq Scan on _hyper_9_81_chunk (cost=0.00..39.35 rows=4 width=233) (actual time=0.298..0.298 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 890
257. 0.314 0.314 ↓ 0.0 0 1

Seq Scan on _hyper_9_82_chunk (cost=0.00..40.35 rows=4 width=233) (actual time=0.314..0.314 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 890
258. 0.346 0.346 ↓ 0.0 0 1

Seq Scan on _hyper_9_83_chunk (cost=0.00..40.35 rows=4 width=232) (actual time=0.346..0.346 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 890
259. 0.286 0.286 ↓ 0.0 0 1

Seq Scan on _hyper_9_84_chunk (cost=0.00..40.27 rows=4 width=232) (actual time=0.286..0.286 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 885
260. 0.289 0.289 ↓ 0.0 0 1

Seq Scan on _hyper_9_85_chunk (cost=0.00..40.27 rows=4 width=233) (actual time=0.289..0.289 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 885
261. 0.231 0.231 ↓ 0.0 0 1

Seq Scan on _hyper_9_86_chunk (cost=0.00..31.63 rows=4 width=234) (actual time=0.231..0.231 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 709
262. 0.307 0.307 ↓ 0.0 0 1

Seq Scan on _hyper_9_87_chunk (cost=0.00..40.31 rows=4 width=234) (actual time=0.307..0.307 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 887
263. 0.297 0.297 ↓ 0.0 0 1

Seq Scan on _hyper_9_88_chunk (cost=0.00..40.31 rows=4 width=233) (actual time=0.297..0.297 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 887
264. 0.188 0.188 ↓ 0.0 0 1

Seq Scan on _hyper_9_89_chunk (cost=0.00..31.65 rows=4 width=233) (actual time=0.188..0.188 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 710
265. 0.181 0.181 ↓ 0.0 0 1

Seq Scan on _hyper_9_90_chunk (cost=0.00..31.63 rows=4 width=233) (actual time=0.181..0.181 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 709
266. 0.284 0.284 ↓ 0.0 0 1

Seq Scan on _hyper_9_91_chunk (cost=0.00..40.29 rows=4 width=233) (actual time=0.284..0.284 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 886
267. 0.306 0.306 ↓ 0.0 0 1

Seq Scan on _hyper_9_92_chunk (cost=0.00..40.29 rows=4 width=233) (actual time=0.306..0.306 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 886
268. 0.259 0.259 ↓ 0.0 0 1

Seq Scan on _hyper_9_93_chunk (cost=0.00..40.53 rows=5 width=233) (actual time=0.259..0.259 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 902
269. 0.143 0.143 ↓ 0.0 0 1

Seq Scan on _hyper_9_94_chunk (cost=0.00..24.12 rows=3 width=233) (actual time=0.143..0.143 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 541
270. 0.329 0.329 ↓ 0.0 0 1

Seq Scan on _hyper_9_95_chunk (cost=0.00..40.53 rows=5 width=233) (actual time=0.328..0.329 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 902
271. 0.349 0.349 ↓ 0.0 0 1

Seq Scan on _hyper_9_96_chunk (cost=0.00..40.50 rows=4 width=234) (actual time=0.349..0.349 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 900
272. 0.246 0.246 ↓ 0.0 0 1

Seq Scan on _hyper_9_97_chunk (cost=0.00..32.80 rows=4 width=234) (actual time=0.246..0.246 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 720
273. 0.346 0.346 ↓ 0.0 0 1

Seq Scan on _hyper_9_98_chunk (cost=0.00..40.50 rows=4 width=233) (actual time=0.346..0.346 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 900
274. 0.233 0.233 ↓ 0.0 0 1

Seq Scan on _hyper_9_99_chunk (cost=0.00..32.80 rows=4 width=234) (actual time=0.232..0.233 rows=0 loops=1)

  • Filter: (date(date) = $1)
  • Rows Removed by Filter: 720