QUERY PLAN ------------------------------------------------------------------------------------------------------------------------------------------------------------------------ HashAggregate (cost=106677438.41..106677438.43 rows=1 width=40) (actual time=1163574.453..1163574.631 rows=167 loops=1) Group Key: time_bucket('1 day'::interval, _hyper_8_11555_chunk."time") Batches: 1 Memory Usage: 56kB Buffers: shared hit=11447379 read=3970500 -> Result (cost=1.03..74887932.89 rows=4238600737 width=8) (actual time=3706.579..793701.922 rows=4238528003 loops=1) Buffers: shared hit=11447379 read=3970500 -> Append (cost=1.03..21905423.67 rows=4238600737 width=8) (actual time=3706.575..486360.868 rows=4238528003 loops=1) Buffers: shared hit=11447379 read=3970500 -> Custom Scan (DecompressChunk) on _hyper_8_11555_chunk (cost=1.03..707.56 rows=685000 width=8) (actual time=3706.574..3745.371 rows=685121 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Rows Removed by Filter: 278 Buffers: shared hit=2076 read=1034 -> Seq Scan on compress_hyper_9_11623_chunk (cost=0.00..707.56 rows=685 width=56) (actual time=3705.785..3705.937 rows=686 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Rows Removed by Filter: 28959 Buffers: shared hit=1 read=336 -> Custom Scan (DecompressChunk) on _hyper_8_11556_chunk (cost=0.02..638.34 rows=26747000 width=8) (actual time=0.754..1583.870 rows=26746616 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=79940 read=27381 -> Seq Scan on compress_hyper_9_11624_chunk (cost=0.00..638.34 rows=26747 width=56) (actual time=0.138..6.799 rows=26747 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=1 read=303 -> Custom Scan (DecompressChunk) on _hyper_8_11557_chunk (cost=0.02..671.65 rows=28132000 width=8) (actual time=0.728..1622.456 rows=28131704 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=84109 read=28768 -> Seq Scan on compress_hyper_9_11625_chunk (cost=0.00..671.65 rows=28132 width=56) (actual time=0.135..6.753 rows=28132 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=320 -> Custom Scan (DecompressChunk) on _hyper_8_11558_chunk (cost=0.02..673.21 rows=28177000 width=8) (actual time=0.735..1575.471 rows=28176330 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=84317 read=28741 -> Seq Scan on compress_hyper_9_11626_chunk (cost=0.00..673.21 rows=28177 width=56) (actual time=0.131..6.495 rows=28177 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=321 -> Custom Scan (DecompressChunk) on _hyper_8_11559_chunk (cost=0.02..717.36 rows=30029000 width=8) (actual time=0.744..1629.872 rows=30028993 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=89820 read=30667 -> Seq Scan on compress_hyper_9_11627_chunk (cost=0.00..717.36 rows=30029 width=56) (actual time=0.128..6.358 rows=30029 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=342 -> Custom Scan (DecompressChunk) on _hyper_8_11560_chunk (cost=0.02..632.08 rows=26486000 width=8) (actual time=0.937..1413.991 rows=26485919 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=79269 read=27005 -> Seq Scan on compress_hyper_9_11628_chunk (cost=0.00..632.08 rows=26486 width=56) (actual time=0.132..5.645 rows=26486 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=301 -> Custom Scan (DecompressChunk) on _hyper_8_11561_chunk (cost=0.02..680.40 rows=28512000 width=8) (actual time=0.727..1540.831 rows=28511323 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=85186 read=29215 -> Seq Scan on compress_hyper_9_11629_chunk (cost=0.00..680.40 rows=28512 width=56) (actual time=0.132..6.162 rows=28512 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=324 -> Custom Scan (DecompressChunk) on _hyper_8_11562_chunk (cost=0.02..652.11 rows=27289000 width=8) (actual time=0.755..1524.042 rows=27288977 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=81606 read=27890 -> Seq Scan on compress_hyper_9_11630_chunk (cost=0.00..652.11 rows=27289 width=56) (actual time=0.161..6.291 rows=27289 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=311 -> Custom Scan (DecompressChunk) on _hyper_8_11563_chunk (cost=0.02..646.19 rows=27055000 width=8) (actual time=0.702..1479.554 rows=27054300 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=80892 read=27665 -> Seq Scan on compress_hyper_9_11631_chunk (cost=0.00..646.19 rows=27055 width=56) (actual time=0.122..6.054 rows=27055 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=308 -> Custom Scan (DecompressChunk) on _hyper_8_11564_chunk (cost=0.02..656.36 rows=27469000 width=8) (actual time=0.729..1505.182 rows=27468434 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=82129 read=28089 -> Seq Scan on compress_hyper_9_11632_chunk (cost=0.00..656.36 rows=27469 width=56) (actual time=0.135..6.227 rows=27469 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=313 -> Custom Scan (DecompressChunk) on _hyper_8_11565_chunk (cost=0.02..633.49 rows=26519000 width=8) (actual time=0.723..1438.106 rows=26518472 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=79342 read=27065 -> Seq Scan on compress_hyper_9_11633_chunk (cost=0.00..633.49 rows=26519 width=56) (actual time=0.123..6.161 rows=26519 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=302 -> Custom Scan (DecompressChunk) on _hyper_8_11566_chunk (cost=0.02..656.95 rows=27516000 width=8) (actual time=0.689..1557.393 rows=27515876 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=82298 read=28108 -> Seq Scan on compress_hyper_9_11634_chunk (cost=0.00..656.95 rows=27516 width=56) (actual time=0.130..6.559 rows=27516 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=313 -> Custom Scan (DecompressChunk) on _hyper_8_11567_chunk (cost=0.02..652.28 rows=27302000 width=8) (actual time=0.739..1481.211 rows=27301750 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=81583 read=27965 -> Seq Scan on compress_hyper_9_11635_chunk (cost=0.00..652.28 rows=27302 width=56) (actual time=0.134..6.222 rows=27302 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=311 -> Custom Scan (DecompressChunk) on _hyper_8_11568_chunk (cost=0.02..627.88 rows=26310000 width=8) (actual time=0.757..1476.142 rows=26309402 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=78655 read=26913 -> Seq Scan on compress_hyper_9_11636_chunk (cost=0.00..627.88 rows=26310 width=56) (actual time=0.137..5.917 rows=26310 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=299 -> Custom Scan (DecompressChunk) on _hyper_8_11569_chunk (cost=0.02..617.31 rows=25865000 width=8) (actual time=0.731..1424.347 rows=25864750 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=77339 read=26444 -> Seq Scan on compress_hyper_9_11637_chunk (cost=0.00..617.31 rows=25865 width=56) (actual time=0.130..6.029 rows=25865 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=294 -> Custom Scan (DecompressChunk) on _hyper_8_11570_chunk (cost=0.02..644.34 rows=26987000 width=8) (actual time=0.731..1507.288 rows=26986963 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=80670 read=27614 -> Seq Scan on compress_hyper_9_11638_chunk (cost=0.00..644.34 rows=26987 width=56) (actual time=0.136..6.593 rows=26987 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=307 -> Custom Scan (DecompressChunk) on _hyper_8_11571_chunk (cost=0.02..629.79 rows=26383000 width=8) (actual time=0.692..1458.143 rows=26382617 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=78881 read=26980 -> Seq Scan on compress_hyper_9_11639_chunk (cost=0.00..629.79 rows=26383 width=56) (actual time=0.124..6.223 rows=26383 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=300 -> Custom Scan (DecompressChunk) on _hyper_8_11572_chunk (cost=0.02..596.14 rows=24971000 width=8) (actual time=0.602..1364.408 rows=24970968 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=49712 read=25515 -> Seq Scan on compress_hyper_9_11640_chunk (cost=0.00..596.14 rows=24971 width=56) (actual time=0.128..5.245 rows=24971 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=284 -> Custom Scan (DecompressChunk) on _hyper_8_11573_chunk (cost=0.02..648.79 rows=27183000 width=8) (actual time=0.734..1513.191 rows=27182270 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=81285 read=27785 -> Seq Scan on compress_hyper_9_11641_chunk (cost=0.00..648.79 rows=27183 width=56) (actual time=0.119..6.127 rows=27183 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=309 -> Custom Scan (DecompressChunk) on _hyper_8_11574_chunk (cost=0.02..585.33 rows=24506000 width=8) (actual time=0.773..1505.902 rows=24505952 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=48739 read=25088 -> Seq Scan on compress_hyper_9_11642_chunk (cost=0.00..585.33 rows=24506 width=56) (actual time=0.133..5.892 rows=24506 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=279 -> Custom Scan (DecompressChunk) on _hyper_8_11575_chunk (cost=0.02..591.46 rows=24757000 width=8) (actual time=0.650..1343.154 rows=24756307 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=49217 read=25365 -> Seq Scan on compress_hyper_9_11643_chunk (cost=0.00..591.46 rows=24757 width=56) (actual time=0.137..5.529 rows=24757 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=282 -> Custom Scan (DecompressChunk) on _hyper_8_11576_chunk (cost=0.02..633.94 rows=26555000 width=8) (actual time=0.713..1412.378 rows=26554006 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=79340 read=27207 -> Seq Scan on compress_hyper_9_11644_chunk (cost=0.00..633.94 rows=26555 width=56) (actual time=0.115..5.394 rows=26555 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=302 -> Custom Scan (DecompressChunk) on _hyper_8_11577_chunk (cost=0.02..702.90 rows=29432000 width=8) (actual time=0.689..1603.280 rows=29431525 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=87998 read=30094 -> Seq Scan on compress_hyper_9_11645_chunk (cost=0.00..702.90 rows=29432 width=56) (actual time=0.120..6.244 rows=29432 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=335 -> Custom Scan (DecompressChunk) on _hyper_8_11578_chunk (cost=0.02..642.12 rows=26890000 width=8) (actual time=0.695..1483.326 rows=26889710 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=80422 read=27473 -> Seq Scan on compress_hyper_9_11646_chunk (cost=0.00..642.12 rows=26890 width=56) (actual time=0.113..5.722 rows=26890 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=306 -> Custom Scan (DecompressChunk) on _hyper_8_11579_chunk (cost=0.02..608.19 rows=25455000 width=8) (actual time=0.624..1500.460 rows=25454010 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=50684 read=25997 -> Seq Scan on compress_hyper_9_11647_chunk (cost=0.00..608.19 rows=25455 width=56) (actual time=0.144..5.286 rows=25455 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=290 -> Custom Scan (DecompressChunk) on _hyper_8_11580_chunk (cost=0.02..589.84 rows=24707000 width=8) (actual time=0.522..1350.833 rows=24706813 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=49269 read=25162 -> Seq Scan on compress_hyper_9_11648_chunk (cost=0.00..589.84 rows=24707 width=56) (actual time=0.132..5.289 rows=24707 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=281 -> Custom Scan (DecompressChunk) on _hyper_8_11581_chunk (cost=0.02..589.69 rows=24695000 width=8) (actual time=0.648..1330.255 rows=24694860 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=49193 read=25202 -> Seq Scan on compress_hyper_9_11649_chunk (cost=0.00..589.69 rows=24695 width=56) (actual time=0.136..5.377 rows=24695 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=281 -> Custom Scan (DecompressChunk) on _hyper_8_11582_chunk (cost=0.02..623.61 rows=26129000 width=8) (actual time=0.746..1382.090 rows=26128012 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=78135 read=26704 -> Seq Scan on compress_hyper_9_11650_chunk (cost=0.00..623.61 rows=26129 width=56) (actual time=0.140..5.376 rows=26129 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=297 -> Custom Scan (DecompressChunk) on _hyper_8_11583_chunk (cost=0.02..680.09 rows=28487000 width=8) (actual time=0.702..1514.346 rows=28486433 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=85192 read=29110 -> Seq Scan on compress_hyper_9_11651_chunk (cost=0.00..680.09 rows=28487 width=56) (actual time=0.115..6.169 rows=28487 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=324 -> Custom Scan (DecompressChunk) on _hyper_8_11584_chunk (cost=0.02..605.75 rows=25340000 width=8) (actual time=0.619..1331.637 rows=25339186 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=50415 read=25920 -> Seq Scan on compress_hyper_9_11652_chunk (cost=0.00..605.75 rows=25340 width=56) (actual time=0.130..5.393 rows=25340 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=289 -> Custom Scan (DecompressChunk) on _hyper_8_11585_chunk (cost=0.02..634.14 rows=26571000 width=8) (actual time=0.719..1560.508 rows=26570472 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=79417 read=27198 -> Seq Scan on compress_hyper_9_11653_chunk (cost=0.00..634.14 rows=26571 width=56) (actual time=0.128..5.873 rows=26571 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=302 -> Custom Scan (DecompressChunk) on _hyper_8_11586_chunk (cost=0.02..590.00 rows=24720000 width=8) (actual time=0.621..1360.815 rows=24719841 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=49198 read=25272 -> Seq Scan on compress_hyper_9_11654_chunk (cost=0.00..590.00 rows=24720 width=56) (actual time=0.153..5.471 rows=24720 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=281 -> Custom Scan (DecompressChunk) on _hyper_8_11587_chunk (cost=0.02..620.56 rows=25965000 width=8) (actual time=0.703..1399.751 rows=25964117 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=77679 read=26502 -> Seq Scan on compress_hyper_9_11655_chunk (cost=0.00..620.56 rows=25965 width=56) (actual time=0.130..5.509 rows=25965 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=296 -> Custom Scan (DecompressChunk) on _hyper_8_11588_chunk (cost=0.02..608.99 rows=25519000 width=8) (actual time=0.602..1378.634 rows=25518640 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=50795 read=26081 -> Seq Scan on compress_hyper_9_11656_chunk (cost=0.00..608.99 rows=25519 width=56) (actual time=0.129..5.390 rows=25519 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=290 -> Custom Scan (DecompressChunk) on _hyper_8_11589_chunk (cost=0.02..570.71 rows=23897000 width=8) (actual time=0.604..1320.379 rows=23896980 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=47511 read=24482 -> Seq Scan on compress_hyper_9_11657_chunk (cost=0.00..570.71 rows=23897 width=56) (actual time=0.134..4.973 rows=23897 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=272 -> Custom Scan (DecompressChunk) on _hyper_8_11590_chunk (cost=0.02..602.23 rows=25218000 width=8) (actual time=0.589..1357.262 rows=25217513 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=50164 read=25807 -> Seq Scan on compress_hyper_9_11658_chunk (cost=0.00..602.23 rows=25218 width=56) (actual time=0.119..5.324 rows=25218 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=287 -> Custom Scan (DecompressChunk) on _hyper_8_11591_chunk (cost=0.02..597.71 rows=25017000 width=8) (actual time=0.618..1361.954 rows=25016977 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=49755 read=25613 -> Seq Scan on compress_hyper_9_11659_chunk (cost=0.00..597.71 rows=25017 width=56) (actual time=0.136..5.353 rows=25017 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=285 -> Custom Scan (DecompressChunk) on _hyper_8_11592_chunk (cost=0.02..637.94 rows=26715000 width=8) (actual time=0.744..1477.163 rows=26714610 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=79871 read=27322 -> Seq Scan on compress_hyper_9_11660_chunk (cost=0.00..637.94 rows=26715 width=56) (actual time=0.135..5.907 rows=26715 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=304 -> Custom Scan (DecompressChunk) on _hyper_8_11593_chunk (cost=0.02..602.59 rows=25247000 width=8) (actual time=0.584..1388.475 rows=25246195 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=50244 read=25815 -> Seq Scan on compress_hyper_9_11661_chunk (cost=0.00..602.59 rows=25247 width=56) (actual time=0.124..5.688 rows=25247 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=287 -> Custom Scan (DecompressChunk) on _hyper_8_11594_chunk (cost=0.02..629.84 rows=26387000 width=8) (actual time=0.659..1443.614 rows=26386741 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=78861 read=27016 -> Seq Scan on compress_hyper_9_11662_chunk (cost=0.00..629.84 rows=26387 width=56) (actual time=0.118..5.685 rows=26387 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=300 -> Custom Scan (DecompressChunk) on _hyper_8_11595_chunk (cost=0.02..625.80 rows=26224000 width=8) (actual time=0.687..1418.563 rows=26223574 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=78380 read=26843 -> Seq Scan on compress_hyper_9_11663_chunk (cost=0.00..625.80 rows=26224 width=56) (actual time=0.130..5.549 rows=26224 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=298 -> Custom Scan (DecompressChunk) on _hyper_8_11596_chunk (cost=0.02..615.25 rows=25780000 width=8) (actual time=0.723..1638.132 rows=25779690 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=77055 read=26387 -> Seq Scan on compress_hyper_9_11664_chunk (cost=0.00..615.25 rows=25780 width=56) (actual time=0.140..5.421 rows=25780 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=293 -> Custom Scan (DecompressChunk) on _hyper_8_11597_chunk (cost=0.02..620.70 rows=25976000 width=8) (actual time=0.750..1387.443 rows=25975900 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=77646 read=26583 -> Seq Scan on compress_hyper_9_11665_chunk (cost=0.00..620.70 rows=25976 width=56) (actual time=0.132..5.702 rows=25976 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=296 -> Custom Scan (DecompressChunk) on _hyper_8_11598_chunk (cost=0.02..615.14 rows=25771000 width=8) (actual time=0.729..1404.939 rows=25770306 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=77038 read=26368 -> Seq Scan on compress_hyper_9_11666_chunk (cost=0.00..615.14 rows=25771 width=56) (actual time=0.133..5.458 rows=25771 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=293 -> Custom Scan (DecompressChunk) on _hyper_8_11599_chunk (cost=0.02..699.04 rows=29283000 width=8) (actual time=0.699..1599.576 rows=29282292 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=87533 read=29961 -> Seq Scan on compress_hyper_9_11667_chunk (cost=0.00..699.04 rows=29283 width=56) (actual time=0.132..5.851 rows=29283 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=333 -> Custom Scan (DecompressChunk) on _hyper_8_11600_chunk (cost=0.02..572.23 rows=23938000 width=8) (actual time=0.691..1314.642 rows=23937435 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=47625 read=24491 -> Seq Scan on compress_hyper_9_11668_chunk (cost=0.00..572.23 rows=23938 width=56) (actual time=0.116..5.276 rows=23938 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=273 -> Custom Scan (DecompressChunk) on _hyper_8_11601_chunk (cost=0.02..669.65 rows=28052000 width=8) (actual time=0.762..1506.364 rows=28051035 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=83874 read=28678 -> Seq Scan on compress_hyper_9_11669_chunk (cost=0.00..669.65 rows=28052 width=56) (actual time=0.137..6.114 rows=28052 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=319 -> Custom Scan (DecompressChunk) on _hyper_8_11602_chunk (cost=0.02..646.03 rows=27042000 width=8) (actual time=0.853..1499.821 rows=27041829 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=84628 read=23877 -> Seq Scan on compress_hyper_9_11671_chunk (cost=0.00..646.03 rows=27042 width=56) (actual time=0.147..5.645 rows=27042 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=308 -> Custom Scan (DecompressChunk) on _hyper_8_11670_chunk (cost=0.02..663.45 rows=27796000 width=8) (actual time=0.749..1531.818 rows=27795396 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=87541 read=23988 -> Seq Scan on compress_hyper_9_11677_chunk (cost=0.00..663.45 rows=27796 width=56) (actual time=0.125..5.054 rows=27796 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=316 -> Custom Scan (DecompressChunk) on _hyper_8_11673_chunk (cost=0.02..652.91 rows=27353000 width=8) (actual time=0.713..1503.841 rows=27352483 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=85955 read=23797 -> Seq Scan on compress_hyper_9_11678_chunk (cost=0.00..652.91 rows=27353 width=56) (actual time=0.132..5.405 rows=27353 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=311 -> Custom Scan (DecompressChunk) on _hyper_8_11674_chunk (cost=0.02..627.23 rows=26258000 width=8) (actual time=0.743..1434.136 rows=26257260 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=82219 read=23141 -> Seq Scan on compress_hyper_9_11679_chunk (cost=0.00..627.23 rows=26258 width=56) (actual time=0.126..5.093 rows=26258 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=299 -> Custom Scan (DecompressChunk) on _hyper_8_11675_chunk (cost=0.02..633.81 rows=26545000 width=8) (actual time=0.733..1569.601 rows=26544181 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=83312 read=23199 -> Seq Scan on compress_hyper_9_11687_chunk (cost=0.00..633.81 rows=26545 width=56) (actual time=0.127..5.375 rows=26545 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=302 -> Custom Scan (DecompressChunk) on _hyper_8_11680_chunk (cost=0.02..599.74 rows=25099000 width=8) (actual time=0.885..1445.633 rows=25098349 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=53869 read=21743 -> Seq Scan on compress_hyper_9_11688_chunk (cost=0.00..599.74 rows=25099 width=56) (actual time=0.179..5.584 rows=25099 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=286 -> Custom Scan (DecompressChunk) on _hyper_8_11683_chunk (cost=0.02..644.06 rows=26965000 width=8) (actual time=0.751..1547.854 rows=26964471 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=86533 read=21663 -> Seq Scan on compress_hyper_9_11689_chunk (cost=0.00..644.06 rows=26965 width=56) (actual time=0.137..5.813 rows=26965 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=307 -> Custom Scan (DecompressChunk) on _hyper_8_11684_chunk (cost=0.02..584.94 rows=24475000 width=8) (actual time=0.667..1346.115 rows=24474810 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=52212 read=21521 -> Seq Scan on compress_hyper_9_11690_chunk (cost=0.00..584.94 rows=24475 width=56) (actual time=0.144..5.086 rows=24475 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=279 -> Custom Scan (DecompressChunk) on _hyper_8_11685_chunk (cost=0.02..600.25 rows=25140000 width=8) (actual time=0.627..1404.261 rows=25139860 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=53942 read=21793 -> Seq Scan on compress_hyper_9_11691_chunk (cost=0.00..600.25 rows=25140 width=56) (actual time=0.115..5.883 rows=25140 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=286 -> Custom Scan (DecompressChunk) on _hyper_8_11686_chunk (cost=0.02..606.76 rows=25421000 width=8) (actual time=0.719..1454.506 rows=25420196 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=55365 read=21216 -> Seq Scan on compress_hyper_9_11700_chunk (cost=0.00..606.76 rows=25421 width=56) (actual time=0.138..5.208 rows=25421 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=289 -> Custom Scan (DecompressChunk) on _hyper_8_11693_chunk (cost=0.02..593.75 rows=24860000 width=8) (actual time=0.623..1393.856 rows=24859372 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=53737 read=21155 -> Seq Scan on compress_hyper_9_11703_chunk (cost=0.00..593.75 rows=24860 width=56) (actual time=0.131..5.774 rows=24860 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=283 -> Custom Scan (DecompressChunk) on _hyper_8_11694_chunk (cost=0.02..589.58 rows=24686000 width=8) (actual time=0.678..1383.207 rows=24685962 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=53507 read=20861 -> Seq Scan on compress_hyper_9_11704_chunk (cost=0.00..589.58 rows=24686 width=56) (actual time=0.132..5.341 rows=24686 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=281 -> Custom Scan (DecompressChunk) on _hyper_8_11695_chunk (cost=0.02..568.89 rows=23831000 width=8) (actual time=0.579..1314.238 rows=23830860 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=51299 read=20494 -> Seq Scan on compress_hyper_9_11705_chunk (cost=0.00..568.89 rows=23831 width=56) (actual time=0.115..5.184 rows=23831 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=271 -> Custom Scan (DecompressChunk) on _hyper_8_11696_chunk (cost=0.02..686.04 rows=28723000 width=8) (actual time=0.756..1656.073 rows=28722976 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=90049 read=25199 -> Seq Scan on compress_hyper_9_11706_chunk (cost=0.00..686.04 rows=28723 width=56) (actual time=0.142..6.667 rows=28723 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=327 -> Custom Scan (DecompressChunk) on _hyper_8_11697_chunk (cost=0.02..568.91 rows=23833000 width=8) (actual time=0.587..1314.352 rows=23832415 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=50892 read=20907 -> Seq Scan on compress_hyper_9_11707_chunk (cost=0.00..568.91 rows=23833 width=56) (actual time=0.128..5.341 rows=23833 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=271 -> Custom Scan (DecompressChunk) on _hyper_8_11698_chunk (cost=0.02..557.78 rows=23342000 width=8) (actual time=0.696..1310.063 rows=23341028 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=50429 read=19889 -> Seq Scan on compress_hyper_9_11708_chunk (cost=0.00..557.78 rows=23342 width=56) (actual time=0.128..5.077 rows=23342 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=266 -> Custom Scan (DecompressChunk) on _hyper_8_11699_chunk (cost=0.02..559.74 rows=23419000 width=8) (actual time=0.613..1325.734 rows=23418969 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=50620 read=19933 -> Seq Scan on compress_hyper_9_11709_chunk (cost=0.00..559.74 rows=23419 width=56) (actual time=0.131..5.018 rows=23419 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=267 -> Custom Scan (DecompressChunk) on _hyper_8_11701_chunk (cost=0.02..535.34 rows=22427000 width=8) (actual time=0.731..1266.519 rows=22426589 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=48786 read=18779 -> Seq Scan on compress_hyper_9_11710_chunk (cost=0.00..535.34 rows=22427 width=56) (actual time=0.128..4.843 rows=22427 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=255 -> Custom Scan (DecompressChunk) on _hyper_8_11702_chunk (cost=0.02..566.23 rows=23698000 width=8) (actual time=0.625..1330.563 rows=23697356 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=51806 read=19587 -> Seq Scan on compress_hyper_9_11718_chunk (cost=0.00..566.23 rows=23698 width=56) (actual time=0.123..5.372 rows=23698 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=270 -> Custom Scan (DecompressChunk) on _hyper_8_11712_chunk (cost=0.02..515.56 rows=21565000 width=8) (actual time=0.620..1330.891 rows=21564216 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=46809 read=18162 -> Seq Scan on compress_hyper_9_11719_chunk (cost=0.00..515.56 rows=21565 width=56) (actual time=0.139..4.879 rows=21565 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=246 -> Custom Scan (DecompressChunk) on _hyper_8_11713_chunk (cost=0.02..593.73 rows=24858000 width=8) (actual time=0.476..1380.161 rows=24857450 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=54320 read=20566 -> Seq Scan on compress_hyper_9_11720_chunk (cost=0.00..593.73 rows=24858 width=56) (actual time=0.121..5.166 rows=24858 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=283 -> Custom Scan (DecompressChunk) on _hyper_8_11714_chunk (cost=0.02..577.25 rows=24180000 width=8) (actual time=0.456..1387.517 rows=24179307 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=52482 read=20362 -> Seq Scan on compress_hyper_9_11721_chunk (cost=0.00..577.25 rows=24180 width=56) (actual time=0.126..5.614 rows=24180 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=275 -> Custom Scan (DecompressChunk) on _hyper_8_11715_chunk (cost=0.02..583.39 rows=24431000 width=8) (actual time=0.630..1338.669 rows=24430620 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=52778 read=20822 -> Seq Scan on compress_hyper_9_11733_chunk (cost=0.00..583.39 rows=24431 width=56) (actual time=0.130..5.158 rows=24431 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=278 -> Custom Scan (DecompressChunk) on _hyper_8_11716_chunk (cost=0.02..614.99 rows=25759000 width=8) (actual time=0.741..1439.161 rows=25758106 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=81563 read=21792 -> Seq Scan on compress_hyper_9_11734_chunk (cost=0.00..614.99 rows=25759 width=56) (actual time=0.131..5.615 rows=25759 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=293 -> Custom Scan (DecompressChunk) on _hyper_8_11717_chunk (cost=0.02..652.14 rows=27291000 width=8) (actual time=0.726..1515.639 rows=27290221 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=87269 read=22237 -> Seq Scan on compress_hyper_9_11735_chunk (cost=0.00..652.14 rows=27291 width=56) (actual time=0.127..5.787 rows=27291 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=311 -> Custom Scan (DecompressChunk) on _hyper_8_11725_chunk (cost=0.02..629.36 rows=26349000 width=8) (actual time=0.891..1541.245 rows=26348765 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=84005 read=21720 -> Seq Scan on compress_hyper_9_11736_chunk (cost=0.00..629.36 rows=26349 width=56) (actual time=0.125..5.064 rows=26349 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=300 -> Custom Scan (DecompressChunk) on _hyper_8_11726_chunk (cost=0.02..511.59 rows=21407000 width=8) (actual time=0.787..1197.912 rows=21406561 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=46278 read=18216 -> Seq Scan on compress_hyper_9_11737_chunk (cost=0.00..511.59 rows=21407 width=56) (actual time=0.203..4.566 rows=21407 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=244 -> Custom Scan (DecompressChunk) on _hyper_8_11727_chunk (cost=0.02..610.03 rows=25522000 width=8) (actual time=0.758..1536.286 rows=25521390 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=81318 read=21090 -> Seq Scan on compress_hyper_9_11738_chunk (cost=0.00..610.03 rows=25522 width=56) (actual time=0.131..5.407 rows=25522 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=291 -> Custom Scan (DecompressChunk) on _hyper_8_11728_chunk (cost=0.02..602.36 rows=25229000 width=8) (actual time=0.610..1381.933 rows=25228324 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=55310 read=20693 -> Seq Scan on compress_hyper_9_11739_chunk (cost=0.00..602.36 rows=25229 width=56) (actual time=0.127..5.223 rows=25229 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=287 -> Custom Scan (DecompressChunk) on _hyper_8_11729_chunk (cost=0.02..585.74 rows=24539000 width=8) (actual time=0.594..1342.417 rows=24538749 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=53360 read=20565 -> Seq Scan on compress_hyper_9_11740_chunk (cost=0.00..585.74 rows=24539 width=56) (actual time=0.117..5.034 rows=24539 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=279 -> Custom Scan (DecompressChunk) on _hyper_8_11730_chunk (cost=0.02..636.05 rows=26644000 width=8) (actual time=0.752..1501.744 rows=26643865 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=84344 read=22565 -> Seq Scan on compress_hyper_9_11741_chunk (cost=0.00..636.05 rows=26644 width=56) (actual time=0.142..5.305 rows=26644 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=303 -> Custom Scan (DecompressChunk) on _hyper_8_11731_chunk (cost=0.02..612.14 rows=25611000 width=8) (actual time=0.753..1465.056 rows=25610201 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=81585 read=21180 -> Seq Scan on compress_hyper_9_11780_chunk (cost=0.00..612.14 rows=25611 width=56) (actual time=0.133..5.479 rows=25611 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=292 -> Custom Scan (DecompressChunk) on _hyper_8_11732_chunk (cost=0.02..655.00 rows=27440000 width=8) (actual time=0.712..1569.048 rows=27439423 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=87865 read=22237 -> Seq Scan on compress_hyper_9_11781_chunk (cost=0.00..655.00 rows=27440 width=56) (actual time=0.125..5.494 rows=27440 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=312 -> Custom Scan (DecompressChunk) on _hyper_8_11744_chunk (cost=0.02..83.86 rows=3509000 width=8) (actual time=0.609..189.120 rows=3508259 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=7557 read=3039 -> Seq Scan on compress_hyper_9_11782_chunk (cost=0.00..83.86 rows=3509 width=56) (actual time=0.118..0.849 rows=3509 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=40 -> Custom Scan (DecompressChunk) on _hyper_8_11745_chunk (cost=0.02..614.66 rows=25733000 width=8) (actual time=0.686..1501.136 rows=25732792 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=81825 read=21429 -> Seq Scan on compress_hyper_9_11783_chunk (cost=0.00..614.66 rows=25733 width=56) (actual time=0.128..4.568 rows=25733 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=293 -> Custom Scan (DecompressChunk) on _hyper_8_11746_chunk (cost=0.02..635.58 rows=26606000 width=8) (actual time=0.712..1550.960 rows=26605602 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=84248 read=22508 -> Seq Scan on compress_hyper_9_11784_chunk (cost=0.00..635.58 rows=26606 width=56) (actual time=0.132..5.604 rows=26606 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=303 -> Custom Scan (DecompressChunk) on _hyper_8_11747_chunk (cost=0.02..633.59 rows=26527000 width=8) (actual time=0.715..1569.241 rows=26526592 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=83816 read=22623 -> Seq Scan on compress_hyper_9_11785_chunk (cost=0.00..633.59 rows=26527 width=56) (actual time=0.126..5.668 rows=26527 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=302 -> Custom Scan (DecompressChunk) on _hyper_8_11748_chunk (cost=0.02..635.65 rows=26612000 width=8) (actual time=0.888..1458.269 rows=26611807 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=83776 read=23004 -> Seq Scan on compress_hyper_9_11786_chunk (cost=0.00..635.65 rows=26612 width=56) (actual time=0.145..5.344 rows=26612 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=303 -> Custom Scan (DecompressChunk) on _hyper_8_11749_chunk (cost=0.02..626.92 rows=26234000 width=8) (actual time=0.701..1471.810 rows=26233118 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=83258 read=22004 -> Seq Scan on compress_hyper_9_11787_chunk (cost=0.00..626.92 rows=26234 width=56) (actual time=0.142..5.077 rows=26234 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=299 -> Custom Scan (DecompressChunk) on _hyper_8_11750_chunk (cost=0.02..629.40 rows=26352000 width=8) (actual time=0.729..1462.010 rows=26351947 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=83940 read=21797 -> Seq Scan on compress_hyper_9_11788_chunk (cost=0.00..629.40 rows=26352 width=56) (actual time=0.118..5.348 rows=26352 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=300 -> Custom Scan (DecompressChunk) on _hyper_8_11751_chunk (cost=0.02..550.01 rows=23041000 width=8) (actual time=0.594..1281.178 rows=23040009 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=50266 read=19145 -> Seq Scan on compress_hyper_9_11789_chunk (cost=0.00..550.01 rows=23041 width=56) (actual time=0.129..4.855 rows=23041 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=262 -> Custom Scan (DecompressChunk) on _hyper_8_11752_chunk (cost=0.02..585.58 rows=24526000 width=8) (actual time=0.602..1379.709 rows=24525819 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=53761 read=20125 -> Seq Scan on compress_hyper_9_11790_chunk (cost=0.00..585.58 rows=24526 width=56) (actual time=0.133..4.745 rows=24526 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=279 -> Custom Scan (DecompressChunk) on _hyper_8_11753_chunk (cost=0.02..536.75 rows=22460000 width=8) (actual time=0.620..1286.562 rows=22459921 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=48300 read=19365 -> Seq Scan on compress_hyper_9_11791_chunk (cost=0.00..536.75 rows=22460 width=56) (actual time=0.134..4.336 rows=22460 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=256 -> Custom Scan (DecompressChunk) on _hyper_8_11754_chunk (cost=0.02..577.35 rows=24188000 width=8) (actual time=0.579..1366.382 rows=24187967 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=52613 read=20255 -> Seq Scan on compress_hyper_9_11792_chunk (cost=0.00..577.35 rows=24188 width=56) (actual time=0.129..4.767 rows=24188 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=275 -> Custom Scan (DecompressChunk) on _hyper_8_11755_chunk (cost=0.02..639.96 rows=26797000 width=8) (actual time=0.801..1540.973 rows=26796038 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=85218 read=22300 -> Seq Scan on compress_hyper_9_11793_chunk (cost=0.00..639.96 rows=26797 width=56) (actual time=0.216..5.486 rows=26797 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=305 -> Custom Scan (DecompressChunk) on _hyper_8_11756_chunk (cost=0.02..595.70 rows=24936000 width=8) (actual time=0.874..1416.833 rows=24935207 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=54407 read=20714 -> Seq Scan on compress_hyper_9_11794_chunk (cost=0.00..595.70 rows=24936 width=56) (actual time=0.141..5.053 rows=24936 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=284 -> Custom Scan (DecompressChunk) on _hyper_8_11757_chunk (cost=0.02..620.66 rows=25973000 width=8) (actual time=0.991..1418.960 rows=25972019 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=82122 read=22091 -> Seq Scan on compress_hyper_9_11795_chunk (cost=0.00..620.66 rows=25973 width=56) (actual time=0.117..5.208 rows=25973 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=296 -> Custom Scan (DecompressChunk) on _hyper_8_11758_chunk (cost=0.02..636.14 rows=26651000 width=8) (actual time=0.733..1520.519 rows=26650747 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=84053 read=22883 -> Seq Scan on compress_hyper_9_11796_chunk (cost=0.00..636.14 rows=26651 width=56) (actual time=0.138..5.452 rows=26651 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=303 -> Custom Scan (DecompressChunk) on _hyper_8_11759_chunk (cost=0.02..674.01 rows=28241000 width=8) (actual time=0.716..1557.628 rows=28240051 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=88487 read=24823 -> Seq Scan on compress_hyper_9_11797_chunk (cost=0.00..674.01 rows=28241 width=56) (actual time=0.136..5.940 rows=28241 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=321 -> Custom Scan (DecompressChunk) on _hyper_8_11760_chunk (cost=0.02..750.71 rows=31417000 width=8) (actual time=0.717..1705.970 rows=31416555 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=98297 read=27758 -> Seq Scan on compress_hyper_9_11798_chunk (cost=0.00..750.71 rows=31417 width=56) (actual time=0.132..6.316 rows=31417 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=358 -> Custom Scan (DecompressChunk) on _hyper_8_11761_chunk (cost=0.02..707.35 rows=29628000 width=8) (actual time=0.711..1647.093 rows=29627304 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=93228 read=25650 -> Seq Scan on compress_hyper_9_11799_chunk (cost=0.00..707.35 rows=29628 width=56) (actual time=0.136..6.479 rows=29628 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=337 -> Custom Scan (DecompressChunk) on _hyper_8_11762_chunk (cost=0.02..706.90 rows=29592000 width=8) (actual time=0.704..1649.411 rows=29591780 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=92174 read=26560 -> Seq Scan on compress_hyper_9_11800_chunk (cost=0.00..706.90 rows=29592 width=56) (actual time=0.127..5.918 rows=29592 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=337 -> Custom Scan (DecompressChunk) on _hyper_8_11763_chunk (cost=0.02..681.62 rows=28530000 width=8) (actual time=0.726..1647.752 rows=28529206 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=90698 read=23777 -> Seq Scan on compress_hyper_9_11801_chunk (cost=0.00..681.62 rows=28530 width=56) (actual time=0.133..5.773 rows=28530 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=325 -> Custom Scan (DecompressChunk) on _hyper_8_11764_chunk (cost=0.02..677.98 rows=28398000 width=8) (actual time=0.735..1587.671 rows=28397566 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=90056 read=23888 -> Seq Scan on compress_hyper_9_11802_chunk (cost=0.00..677.98 rows=28398 width=56) (actual time=0.127..5.619 rows=28398 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=323 -> Custom Scan (DecompressChunk) on _hyper_8_11765_chunk (cost=0.02..613.01 rows=25681000 width=8) (actual time=0.611..1415.807 rows=25680654 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=56003 read=21362 -> Seq Scan on compress_hyper_9_11803_chunk (cost=0.00..613.01 rows=25681 width=56) (actual time=0.116..5.220 rows=25681 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=292 -> Custom Scan (DecompressChunk) on _hyper_8_11766_chunk (cost=0.02..675.20 rows=28256000 width=8) (actual time=0.626..1585.045 rows=28255710 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=90434 read=22941 -> Seq Scan on compress_hyper_9_11804_chunk (cost=0.00..675.20 rows=28256 width=56) (actual time=0.130..5.707 rows=28256 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=322 -> Custom Scan (DecompressChunk) on _hyper_8_11767_chunk (cost=0.02..648.39 rows=27151000 width=8) (actual time=0.688..1479.474 rows=27150378 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=86391 read=22551 -> Seq Scan on compress_hyper_9_11805_chunk (cost=0.00..648.39 rows=27151 width=56) (actual time=0.115..5.519 rows=27151 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=309 -> Custom Scan (DecompressChunk) on _hyper_8_11768_chunk (cost=0.02..618.44 rows=25875000 width=8) (actual time=0.707..1441.090 rows=25874626 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=81699 read=22125 -> Seq Scan on compress_hyper_9_11806_chunk (cost=0.00..618.44 rows=25875 width=56) (actual time=0.126..5.355 rows=25875 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=295 -> Custom Scan (DecompressChunk) on _hyper_8_11769_chunk (cost=0.02..658.88 rows=27590000 width=8) (actual time=0.749..1667.638 rows=27589396 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=87105 read=23598 -> Seq Scan on compress_hyper_9_11807_chunk (cost=0.00..658.88 rows=27590 width=56) (actual time=0.132..5.335 rows=27590 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=314 -> Custom Scan (DecompressChunk) on _hyper_8_11770_chunk (cost=0.02..677.71 rows=28377000 width=8) (actual time=0.726..1593.226 rows=28376024 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=89887 read=23969 -> Seq Scan on compress_hyper_9_11808_chunk (cost=0.00..677.71 rows=28377 width=56) (actual time=0.127..6.341 rows=28377 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=323 -> Custom Scan (DecompressChunk) on _hyper_8_11771_chunk (cost=0.02..685.71 rows=28697000 width=8) (actual time=0.754..1646.269 rows=28696544 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=91383 read=23761 -> Seq Scan on compress_hyper_9_11809_chunk (cost=0.00..685.71 rows=28697 width=56) (actual time=0.137..6.332 rows=28697 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=327 -> Custom Scan (DecompressChunk) on _hyper_8_11772_chunk (cost=0.02..583.19 rows=24415000 width=8) (actual time=0.592..1323.396 rows=24414320 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=52699 read=20853 -> Seq Scan on compress_hyper_9_11810_chunk (cost=0.00..583.19 rows=24415 width=56) (actual time=0.125..4.650 rows=24415 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=278 -> Custom Scan (DecompressChunk) on _hyper_8_11773_chunk (cost=0.02..635.40 rows=26592000 width=8) (actual time=0.744..1590.747 rows=26591237 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=84403 read=22298 -> Seq Scan on compress_hyper_9_11811_chunk (cost=0.00..635.40 rows=26592 width=56) (actual time=0.143..5.659 rows=26592 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=303 -> Custom Scan (DecompressChunk) on _hyper_8_11774_chunk (cost=0.02..589.04 rows=24643000 width=8) (actual time=0.165..1306.909 rows=24642524 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=52919 read=21320 -> Seq Scan on compress_hyper_9_11812_chunk (cost=0.00..589.04 rows=24643 width=56) (actual time=0.034..4.581 rows=24643 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=281 -> Custom Scan (DecompressChunk) on _hyper_8_11775_chunk (cost=0.02..663.14 rows=27771000 width=8) (actual time=1.007..1589.354 rows=27770511 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=88216 read=23213 -> Seq Scan on compress_hyper_9_11813_chunk (cost=0.00..663.14 rows=27771 width=56) (actual time=0.127..5.844 rows=27771 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=316 -> Custom Scan (DecompressChunk) on _hyper_8_11776_chunk (cost=0.02..589.35 rows=24668000 width=8) (actual time=0.625..1365.391 rows=24667895 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=53363 read=20951 -> Seq Scan on compress_hyper_9_11814_chunk (cost=0.00..589.35 rows=24668 width=56) (actual time=0.146..5.268 rows=24668 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=281 -> Custom Scan (DecompressChunk) on _hyper_8_11777_chunk (cost=0.02..608.98 rows=25518000 width=8) (actual time=0.816..1392.924 rows=25517945 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=55334 read=21539 -> Seq Scan on compress_hyper_9_11827_chunk (cost=0.00..608.98 rows=25518 width=56) (actual time=0.130..4.965 rows=25518 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=290 -> Custom Scan (DecompressChunk) on _hyper_8_11778_chunk (cost=0.02..665.66 rows=27893000 width=8) (actual time=0.755..1587.945 rows=27892797 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=89073 read=22845 -> Seq Scan on compress_hyper_9_11828_chunk (cost=0.00..665.66 rows=27893 width=56) (actual time=0.128..5.298 rows=27893 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=317 -> Custom Scan (DecompressChunk) on _hyper_8_11817_chunk (cost=0.02..606.59 rows=25407000 width=8) (actual time=0.624..1426.528 rows=25406076 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=55425 read=21111 -> Seq Scan on compress_hyper_9_11829_chunk (cost=0.00..606.59 rows=25407 width=56) (actual time=0.144..4.940 rows=25407 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=289 -> Custom Scan (DecompressChunk) on _hyper_8_11818_chunk (cost=0.02..686.70 rows=28776000 width=8) (actual time=0.717..1740.566 rows=28775894 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=92162 read=23298 -> Seq Scan on compress_hyper_9_11830_chunk (cost=0.00..686.70 rows=28776 width=56) (actual time=0.128..5.534 rows=28776 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=327 -> Custom Scan (DecompressChunk) on _hyper_8_11819_chunk (cost=0.02..639.54 rows=26763000 width=8) (actual time=0.684..1463.203 rows=26762105 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=84933 read=22449 -> Seq Scan on compress_hyper_9_11831_chunk (cost=0.00..639.54 rows=26763 width=56) (actual time=0.131..5.243 rows=26763 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=305 -> Custom Scan (DecompressChunk) on _hyper_8_11820_chunk (cost=0.02..646.34 rows=27067000 width=8) (actual time=0.810..1484.148 rows=27066254 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=85731 read=22874 -> Seq Scan on compress_hyper_9_11832_chunk (cost=0.00..646.34 rows=27067 width=56) (actual time=0.142..5.562 rows=27067 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=308 -> Custom Scan (DecompressChunk) on _hyper_8_11821_chunk (cost=0.02..643.65 rows=26932000 width=8) (actual time=0.734..1538.560 rows=26931776 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=85926 read=22140 -> Seq Scan on compress_hyper_9_11833_chunk (cost=0.00..643.65 rows=26932 width=56) (actual time=0.117..5.605 rows=26932 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=307 -> Custom Scan (DecompressChunk) on _hyper_8_11822_chunk (cost=0.02..652.03 rows=27282000 width=8) (actual time=0.751..1527.491 rows=27281366 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=86918 read=22550 -> Seq Scan on compress_hyper_9_11834_chunk (cost=0.00..652.03 rows=27282 width=56) (actual time=0.122..5.680 rows=27282 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=311 -> Custom Scan (DecompressChunk) on _hyper_8_11823_chunk (cost=0.02..645.96 rows=27037000 width=8) (actual time=0.741..1484.770 rows=27036252 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=86425 read=22060 -> Seq Scan on compress_hyper_9_11835_chunk (cost=0.00..645.96 rows=27037 width=56) (actual time=0.119..5.225 rows=27037 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=308 -> Custom Scan (DecompressChunk) on _hyper_8_11824_chunk (cost=0.02..606.66 rows=25413000 width=8) (actual time=0.592..1444.189 rows=25412721 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=55437 read=21120 -> Seq Scan on compress_hyper_9_11836_chunk (cost=0.00..606.66 rows=25413 width=56) (actual time=0.125..5.094 rows=25413 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=289 -> Custom Scan (DecompressChunk) on _hyper_8_11825_chunk (cost=0.02..679.42 rows=28434000 width=8) (actual time=0.740..1578.883 rows=28433840 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=90863 read=23226 -> Seq Scan on compress_hyper_9_11837_chunk (cost=0.00..679.42 rows=28434 width=56) (actual time=0.127..5.708 rows=28434 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=324 -> Custom Scan (DecompressChunk) on _hyper_8_11826_chunk (cost=0.02..656.96 rows=27517000 width=8) (actual time=0.936..1579.464 rows=27516590 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=87490 read=22920 -> Seq Scan on compress_hyper_9_11855_chunk (cost=0.00..656.96 rows=27517 width=56) (actual time=0.151..5.848 rows=27517 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=313 -> Custom Scan (DecompressChunk) on _hyper_8_11838_chunk (cost=0.02..596.03 rows=24962000 width=8) (actual time=0.645..1462.195 rows=24961674 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=54141 read=21058 -> Seq Scan on compress_hyper_9_11856_chunk (cost=0.00..596.03 rows=24962 width=56) (actual time=0.129..5.096 rows=24962 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=284 -> Custom Scan (DecompressChunk) on _hyper_8_11841_chunk (cost=0.02..625.33 rows=26186000 width=8) (actual time=0.917..1609.252 rows=26185903 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=82675 read=22396 -> Seq Scan on compress_hyper_9_11857_chunk (cost=0.00..625.33 rows=26186 width=56) (actual time=0.131..5.451 rows=26186 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=298 -> Custom Scan (DecompressChunk) on _hyper_8_11842_chunk (cost=0.02..661.46 rows=27717000 width=8) (actual time=0.755..1694.561 rows=27716499 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=87931 read=23281 -> Seq Scan on compress_hyper_9_11858_chunk (cost=0.00..661.46 rows=27717 width=56) (actual time=0.133..5.807 rows=27717 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=315 -> Custom Scan (DecompressChunk) on _hyper_8_11843_chunk (cost=0.02..633.21 rows=26497000 width=8) (actual time=0.763..1467.381 rows=26496028 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=84661 read=21654 -> Seq Scan on compress_hyper_9_11859_chunk (cost=0.00..633.21 rows=26497 width=56) (actual time=0.133..5.405 rows=26497 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=302 -> Custom Scan (DecompressChunk) on _hyper_8_11844_chunk (cost=0.02..605.85 rows=25348000 width=8) (actual time=0.714..1506.930 rows=25347717 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=54938 read=21425 -> Seq Scan on compress_hyper_9_11860_chunk (cost=0.00..605.85 rows=25348 width=56) (actual time=0.133..5.150 rows=25348 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=289 -> Custom Scan (DecompressChunk) on _hyper_8_11845_chunk (cost=0.02..671.80 rows=28144000 width=8) (actual time=0.725..1554.183 rows=28143947 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=89592 read=23333 -> Seq Scan on compress_hyper_9_11861_chunk (cost=0.00..671.80 rows=28144 width=56) (actual time=0.138..5.620 rows=28144 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=320 -> Custom Scan (DecompressChunk) on _hyper_8_11846_chunk (cost=0.02..652.54 rows=27323000 width=8) (actual time=0.760..1500.688 rows=27322175 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=86244 read=23384 -> Seq Scan on compress_hyper_9_11862_chunk (cost=0.00..652.54 rows=27323 width=56) (actual time=0.131..5.159 rows=27323 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=311 -> Custom Scan (DecompressChunk) on _hyper_8_11847_chunk (cost=0.02..645.81 rows=27025000 width=8) (actual time=0.614..1479.887 rows=27024869 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=85127 read=23310 -> Seq Scan on compress_hyper_9_11863_chunk (cost=0.00..645.81 rows=27025 width=56) (actual time=0.130..5.481 rows=27025 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=308 -> Custom Scan (DecompressChunk) on _hyper_8_11848_chunk (cost=0.02..661.40 rows=27712000 width=8) (actual time=0.696..1560.485 rows=27711673 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=87279 read=23913 -> Seq Scan on compress_hyper_9_11864_chunk (cost=0.00..661.40 rows=27712 width=56) (actual time=0.114..5.479 rows=27712 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=315 -> Custom Scan (DecompressChunk) on _hyper_8_11849_chunk (cost=0.02..616.83 rows=25826000 width=8) (actual time=0.865..1475.306 rows=25825694 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=81280 read=22347 -> Seq Scan on compress_hyper_9_11865_chunk (cost=0.00..616.83 rows=25826 width=56) (actual time=0.128..5.452 rows=25826 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=294 -> Custom Scan (DecompressChunk) on _hyper_8_11850_chunk (cost=0.02..650.21 rows=27217000 width=8) (actual time=0.708..1498.401 rows=27216834 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=86670 read=22537 -> Seq Scan on compress_hyper_9_11866_chunk (cost=0.00..650.21 rows=27217 width=56) (actual time=0.137..5.388 rows=27217 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=310 -> Custom Scan (DecompressChunk) on _hyper_8_11851_chunk (cost=0.02..568.67 rows=23814000 width=8) (actual time=0.750..1290.253 rows=23813870 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=51598 read=20144 -> Seq Scan on compress_hyper_9_11867_chunk (cost=0.00..568.67 rows=23814 width=56) (actual time=0.114..4.470 rows=23814 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=271 -> Custom Scan (DecompressChunk) on _hyper_8_11852_chunk (cost=0.02..614.46 rows=25717000 width=8) (actual time=0.735..1413.079 rows=25716523 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=81951 read=21241 -> Seq Scan on compress_hyper_9_11868_chunk (cost=0.00..614.46 rows=25717 width=56) (actual time=0.129..5.126 rows=25717 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=293 -> Custom Scan (DecompressChunk) on _hyper_8_11853_chunk (cost=0.02..627.26 rows=26261000 width=8) (actual time=0.811..1435.754 rows=26260800 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=83525 read=21848 -> Seq Scan on compress_hyper_9_11873_chunk (cost=0.00..627.26 rows=26261 width=56) (actual time=0.118..5.297 rows=26261 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=299 -> Custom Scan (DecompressChunk) on _hyper_8_11854_chunk (cost=0.02..599.85 rows=25108000 width=8) (actual time=0.649..1348.831 rows=25107497 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=53595 read=22044 -> Seq Scan on compress_hyper_9_11874_chunk (cost=0.00..599.85 rows=25108 width=56) (actual time=0.126..5.196 rows=25108 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=286 -> Custom Scan (DecompressChunk) on _hyper_8_11871_chunk (cost=0.02..636.12 rows=26650000 width=8) (actual time=0.896..1486.070 rows=26649721 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=84101 read=22831 -> Seq Scan on compress_hyper_9_11875_chunk (cost=0.00..636.12 rows=26650 width=56) (actual time=0.126..5.399 rows=26650 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=303 -> Custom Scan (DecompressChunk) on _hyper_8_11872_chunk (cost=0.02..664.80 rows=27824000 width=8) (actual time=0.813..1548.223 rows=27823946 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=87079 read=24563 -> Seq Scan on compress_hyper_9_11896_chunk (cost=0.00..664.80 rows=27824 width=56) (actual time=0.126..5.934 rows=27824 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=317 -> Custom Scan (DecompressChunk) on _hyper_8_11877_chunk (cost=0.02..645.96 rows=27037000 width=8) (actual time=0.808..1612.137 rows=27036026 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=85521 read=22960 -> Seq Scan on compress_hyper_9_11897_chunk (cost=0.00..645.96 rows=27037 width=56) (actual time=0.120..5.516 rows=27037 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=308 -> Custom Scan (DecompressChunk) on _hyper_8_11878_chunk (cost=0.02..573.12 rows=24010000 width=8) (actual time=0.750..1328.329 rows=24009342 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=51429 read=20903 -> Seq Scan on compress_hyper_9_11898_chunk (cost=0.00..573.12 rows=24010 width=56) (actual time=0.141..4.805 rows=24010 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=273 -> Custom Scan (DecompressChunk) on _hyper_8_11879_chunk (cost=0.02..591.95 rows=24796000 width=8) (actual time=0.612..1478.667 rows=24795112 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=54273 read=20423 -> Seq Scan on compress_hyper_9_11899_chunk (cost=0.00..591.95 rows=24796 width=56) (actual time=0.139..5.000 rows=24796 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=282 -> Custom Scan (DecompressChunk) on _hyper_8_11880_chunk (cost=0.02..626.89 rows=26231000 width=8) (actual time=0.791..1463.400 rows=26230711 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=83628 read=21624 -> Seq Scan on compress_hyper_9_11900_chunk (cost=0.00..626.89 rows=26231 width=56) (actual time=0.125..5.330 rows=26231 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=299 -> Custom Scan (DecompressChunk) on _hyper_8_11881_chunk (cost=0.02..575.24 rows=24099000 width=8) (actual time=0.483..1334.271 rows=24098365 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=52347 read=20253 -> Seq Scan on compress_hyper_9_11901_chunk (cost=0.00..575.24 rows=24099 width=56) (actual time=0.128..4.771 rows=24099 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=274 -> Custom Scan (DecompressChunk) on _hyper_8_11882_chunk (cost=0.02..606.41 rows=25393000 width=8) (actual time=0.689..1399.218 rows=25392581 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=55124 read=21374 -> Seq Scan on compress_hyper_9_11902_chunk (cost=0.00..606.41 rows=25393 width=56) (actual time=0.147..5.137 rows=25393 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=289 -> Custom Scan (DecompressChunk) on _hyper_8_11883_chunk (cost=0.02..607.96 rows=25437000 width=8) (actual time=0.617..1481.717 rows=25436011 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=55028 read=21599 -> Seq Scan on compress_hyper_9_11903_chunk (cost=0.00..607.96 rows=25437 width=56) (actual time=0.118..5.298 rows=25437 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=290 -> Custom Scan (DecompressChunk) on _hyper_8_11884_chunk (cost=0.02..614.84 rows=25747000 width=8) (actual time=0.831..1465.179 rows=25746814 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=82096 read=21214 -> Seq Scan on compress_hyper_9_11904_chunk (cost=0.00..614.84 rows=25747 width=56) (actual time=0.127..5.101 rows=25747 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=293 -> Custom Scan (DecompressChunk) on _hyper_8_11885_chunk (cost=0.02..560.67 rows=23494000 width=8) (actual time=0.603..1308.173 rows=23493862 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=51473 read=19305 -> Seq Scan on compress_hyper_9_11905_chunk (cost=0.00..560.67 rows=23494 width=56) (actual time=0.127..4.726 rows=23494 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=267 -> Custom Scan (DecompressChunk) on _hyper_8_11886_chunk (cost=0.02..566.84 rows=23747000 width=8) (actual time=0.627..1317.064 rows=23746286 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=51657 read=19883 -> Seq Scan on compress_hyper_9_11906_chunk (cost=0.00..566.84 rows=23747 width=56) (actual time=0.134..4.957 rows=23747 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=270 -> Custom Scan (DecompressChunk) on _hyper_8_11887_chunk (cost=0.02..531.21 rows=22257000 width=8) (actual time=0.633..1217.303 rows=22256442 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=47939 read=19114 -> Seq Scan on compress_hyper_9_11907_chunk (cost=0.00..531.21 rows=22257 width=56) (actual time=0.133..4.356 rows=22257 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=253 -> Custom Scan (DecompressChunk) on _hyper_8_11888_chunk (cost=0.02..526.36 rows=22029000 width=8) (actual time=0.646..1187.062 rows=22028006 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=47097 read=19268 -> Seq Scan on compress_hyper_9_11908_chunk (cost=0.00..526.36 rows=22029 width=56) (actual time=0.116..4.577 rows=22029 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=251 -> Custom Scan (DecompressChunk) on _hyper_8_11889_chunk (cost=0.02..501.56 rows=21005000 width=8) (actual time=0.715..1154.190 rows=21004204 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=44713 read=18568 -> Seq Scan on compress_hyper_9_11909_chunk (cost=0.00..501.56 rows=21005 width=56) (actual time=0.139..4.146 rows=21005 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=239 -> Custom Scan (DecompressChunk) on _hyper_8_11890_chunk (cost=0.02..503.59 rows=21087000 width=8) (actual time=0.736..1301.231 rows=21086269 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=45044 read=18488 -> Seq Scan on compress_hyper_9_11910_chunk (cost=0.00..503.59 rows=21087 width=56) (actual time=0.128..4.077 rows=21087 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=240 -> Custom Scan (DecompressChunk) on _hyper_8_11891_chunk (cost=0.02..516.42 rows=21634000 width=8) (actual time=0.644..1249.751 rows=21633399 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=46843 read=18335 -> Seq Scan on compress_hyper_9_11911_chunk (cost=0.00..516.42 rows=21634 width=56) (actual time=0.127..5.022 rows=21634 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=246 -> Custom Scan (DecompressChunk) on _hyper_8_11892_chunk (cost=0.02..454.71 rows=19017000 width=8) (actual time=0.593..1043.533 rows=19016445 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=41067 read=16241 -> Seq Scan on compress_hyper_9_11912_chunk (cost=0.00..454.71 rows=19017 width=56) (actual time=0.133..3.890 rows=19017 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=217 -> Custom Scan (DecompressChunk) on _hyper_8_11893_chunk (cost=0.02..560.24 rows=23459000 width=8) (actual time=0.580..1280.136 rows=23458196 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=50287 read=20383 -> Seq Scan on compress_hyper_9_11913_chunk (cost=0.00..560.24 rows=23459 width=56) (actual time=0.117..5.481 rows=23459 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=267 -> Custom Scan (DecompressChunk) on _hyper_8_11894_chunk (cost=0.02..528.64 rows=22131000 width=8) (actual time=0.921..1309.385 rows=22130852 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=47337 read=19338 -> Seq Scan on compress_hyper_9_11914_chunk (cost=0.00..528.64 rows=22131 width=56) (actual time=0.130..5.882 rows=22131 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=252 -> Custom Scan (DecompressChunk) on _hyper_8_11895_chunk (cost=0.02..510.10 rows=21368000 width=8) (actual time=0.667..1143.957 rows=21367592 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=45151 read=19229 -> Seq Scan on compress_hyper_9_11918_chunk (cost=0.00..510.10 rows=21368 width=56) (actual time=0.130..5.051 rows=21368 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=243 -> Custom Scan (DecompressChunk) on _hyper_8_11916_chunk (cost=0.02..459.64 rows=19251000 width=8) (actual time=0.630..1044.895 rows=19250680 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=40475 read=17527 -> Seq Scan on compress_hyper_9_11919_chunk (cost=0.00..459.64 rows=19251 width=56) (actual time=0.113..4.228 rows=19251 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=219 -> Custom Scan (DecompressChunk) on _hyper_8_11917_chunk (cost=0.02..488.41 rows=20433000 width=8) (actual time=0.612..1126.086 rows=20432410 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=43295 read=18268 -> Seq Scan on compress_hyper_9_11921_chunk (cost=0.00..488.41 rows=20433 width=56) (actual time=0.131..4.274 rows=20433 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=233 -> Custom Scan (DecompressChunk) on _hyper_8_11920_chunk (cost=0.02..568.15 rows=23772000 width=8) (actual time=0.782..1360.341 rows=23771799 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=51007 read=20612 -> Seq Scan on compress_hyper_9_11986_chunk (cost=0.00..568.15 rows=23772 width=56) (actual time=0.139..5.471 rows=23772 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=271 -> Custom Scan (DecompressChunk) on _hyper_8_11984_chunk (cost=0.02..482.54 rows=20203000 width=8) (actual time=0.775..1108.413 rows=20202850 loops=1) Vectorized Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared hit=43496 read=17372 -> Seq Scan on compress_hyper_9_11987_chunk (cost=0.00..482.54 rows=20203 width=56) (actual time=0.053..3.980 rows=20203 loops=1) Filter: (_ts_meta_max_1 > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=230 -> Seq Scan on _hyper_8_11985_chunk (cost=0.00..388733.90 rows=21196792 width=8) (actual time=0.148..1604.602 rows=21198610 loops=1) Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=123774 -> Seq Scan on _hyper_8_11989_chunk (cost=0.00..222564.31 rows=12141945 width=8) (actual time=0.134..941.409 rows=12144551 loops=1) Filter: ("time" > '2023-06-01 00:00:00+01'::timestamp with time zone) Buffers: shared read=70790 Planning: Buffers: shared hit=27098 read=1297 Planning Time: 131.328 ms JIT: Functions: 509 Options: Inlining true, Optimization true, Expressions true, Deforming true Timing: Generation 18.001 ms, Inlining 47.929 ms, Optimization 2102.202 ms, Emission 1548.723 ms, Total 3716.854 ms Execution Time: 1163607.695 ms (1014 rows)