Created
August 4, 2025 10:30
-
-
Save CamonZ/e0cbc5a84c2098487073a28450a4c534 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| trade_gym_dev=# explain analyze select count(*) from candles_1m; | |
| QUERY PLAN | |
| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | |
| Finalize Aggregate (cost=32033707.60..32033707.61 rows=1 width=8) (actual time=288.020..301.440 rows=1 loops=1) | |
| -> Gather (cost=33588.59..32033707.58 rows=9 width=8) (actual time=11.694..301.405 rows=312 loops=1) | |
| Workers Planned: 9 | |
| Workers Launched: 9 | |
| -> Parallel Append (cost=32588.59..32032706.68 rows=1 width=8) (actual time=25.130..176.618 rows=31 loops=10) | |
| -> Partial Aggregate (cost=32588.59..32588.60 rows=1 width=8) (actual time=34.150..34.150 rows=1 loops=10) | |
| -> Parallel Index Only Scan using _hyper_1_813_chunk_candles_1m_date_idx on _hyper_1_813_chunk (cost=0.43..30324.06 rows=905811 width=0) (actual time=0.112..21.506 rows=362278 loops=10) | |
| Heap Fetches: 0 | |
| -> Custom Scan (VectorAgg) (cost=166901.93..166901.94 rows=1 width=8) (actual time=12.131..12.133 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_404_chunk (cost=0.10..133794.43 rows=13243000 width=0) (actual time=0.000..0.001 rows=6241562 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_436_chunk (cost=0.00..1364.43 rows=13243 width=4) (actual time=0.017..7.197 rows=22513 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=183255.91..183255.92 rows=1 width=8) (actual time=13.778..13.779 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_338_chunk (cost=0.10..146903.41 rows=14541000 width=0) (actual time=0.000..0.001 rows=6430461 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_378_chunk (cost=0.00..1493.41 rows=14541 width=4) (actual time=0.015..8.042 rows=24719 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=189469.38..189469.39 rows=1 width=8) (actual time=13.692..13.693 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_770_chunk (cost=0.10..151874.38 rows=15038000 width=0) (actual time=0.000..0.000 rows=8464627 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_812_chunk (cost=0.00..1494.38 rows=15038 width=4) (actual time=0.016..8.186 rows=25564 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=104812.22..104812.23 rows=1 width=8) (actual time=5.296..5.297 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_399_chunk (cost=0.09..84007.22 rows=8322000 width=0) (actual time=0.000..0.001 rows=5319707 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_431_chunk (cost=0.00..787.22 rows=8322 width=4) (actual time=0.012..3.133 rows=14148 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=154768.39..154768.40 rows=1 width=8) (actual time=7.657..7.657 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_152_chunk (cost=0.09..124045.89 rows=12289000 width=0) (actual time=0.000..0.001 rows=6507231 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_185_chunk (cost=0.00..1155.89 rows=12289 width=4) (actual time=0.011..4.488 rows=20891 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=98005.33..98005.34 rows=1 width=8) (actual time=5.166..5.167 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_537_chunk (cost=0.09..78547.83 rows=7783000 width=0) (actual time=0.000..0.001 rows=5194054 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_674_chunk (cost=0.00..717.83 rows=7783 width=4) (actual time=0.017..3.063 rows=13231 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109616.06..109616.07 rows=1 width=8) (actual time=7.290..7.291 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_387_chunk (cost=0.09..87851.06 rows=8706000 width=0) (actual time=0.000..0.001 rows=6243947 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_419_chunk (cost=0.00..791.06 rows=8706 width=4) (actual time=0.018..4.329 rows=14801 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=119800.65..119800.66 rows=1 width=8) (actual time=7.789..7.790 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_326_chunk (cost=0.09..96013.15 rows=9515000 width=0) (actual time=0.000..0.001 rows=7966504 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_366_chunk (cost=0.00..863.15 rows=9515 width=4) (actual time=0.016..4.695 rows=16175 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=99856.81..99856.82 rows=1 width=8) (actual time=4.478..4.479 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_571_chunk (cost=0.09..80029.31 rows=7931000 width=0) (actual time=0.000..0.000 rows=5721031 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_705_chunk (cost=0.00..719.31 rows=7931 width=4) (actual time=0.006..2.543 rows=13483 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=99906.85..99906.86 rows=1 width=8) (actual time=4.945..4.946 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_513_chunk (cost=0.09..80069.35 rows=7935000 width=0) (actual time=0.000..0.001 rows=5369963 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_653_chunk (cost=0.00..719.35 rows=7935 width=4) (actual time=0.010..2.833 rows=13490 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=120013.32..120013.33 rows=1 width=8) (actual time=5.515..5.516 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_334_chunk (cost=0.09..96183.32 rows=9532000 width=0) (actual time=0.000..0.000 rows=7967561 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_374_chunk (cost=0.00..863.32 rows=9532 width=4) (actual time=0.005..3.130 rows=16204 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=120138.42..120138.43 rows=1 width=8) (actual time=8.215..8.216 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_321_chunk (cost=0.09..96283.42 rows=9542000 width=0) (actual time=0.000..0.000 rows=8069830 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_364_chunk (cost=0.00..863.42 rows=9542 width=4) (actual time=0.014..4.691 rows=16222 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=100282.15..100282.16 rows=1 width=8) (actual time=4.558..4.558 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_583_chunk (cost=0.09..80369.65 rows=7965000 width=0) (actual time=0.000..0.000 rows=5776067 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_713_chunk (cost=0.00..719.65 rows=7965 width=4) (actual time=0.006..2.520 rows=13541 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110366.66..110366.67 rows=1 width=8) (actual time=7.069..7.070 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_327_chunk (cost=0.09..88451.66 rows=8766000 width=0) (actual time=0.000..0.000 rows=6285792 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_367_chunk (cost=0.00..791.66 rows=8766 width=4) (actual time=0.012..4.054 rows=14902 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=151913.66..151913.67 rows=1 width=8) (actual time=7.281..7.282 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_79_chunk (cost=0.09..121748.66 rows=12066000 width=0) (actual time=0.000..0.001 rows=7581593 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_105_chunk (cost=0.00..1088.66 rows=12066 width=4) (actual time=0.008..4.081 rows=20512 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110491.76..110491.77 rows=1 width=8) (actual time=7.005..7.006 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_310_chunk (cost=0.09..88551.76 rows=8776000 width=0) (actual time=0.000..0.001 rows=6589022 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_354_chunk (cost=0.00..791.76 rows=8776 width=4) (actual time=0.013..4.109 rows=14920 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=100657.45..100657.46 rows=1 width=8) (actual time=6.415..6.416 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_568_chunk (cost=0.09..80669.95 rows=7995000 width=0) (actual time=0.000..0.001 rows=5831585 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_702_chunk (cost=0.00..719.95 rows=7995 width=4) (actual time=0.014..3.686 rows=13591 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=120889.02..120889.03 rows=1 width=8) (actual time=7.825..7.825 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_322_chunk (cost=0.09..96884.02 rows=9602000 width=0) (actual time=0.000..0.000 rows=8176824 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_365_chunk (cost=0.00..864.02 rows=9602 width=4) (actual time=0.012..4.516 rows=16324 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=121064.16..121064.17 rows=1 width=8) (actual time=5.323..5.324 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_319_chunk (cost=0.09..97024.16 rows=9616000 width=0) (actual time=0.000..0.000 rows=8224832 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_363_chunk (cost=0.00..864.16 rows=9616 width=4) (actual time=0.005..2.968 rows=16348 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110992.16..110992.17 rows=1 width=8) (actual time=4.915..4.916 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_315_chunk (cost=0.09..88952.16 rows=8816000 width=0) (actual time=0.000..0.001 rows=6527248 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_359_chunk (cost=0.00..792.16 rows=8816 width=4) (actual time=0.006..2.725 rows=14988 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=101095.30..101095.31 rows=1 width=8) (actual time=6.113..6.114 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_524_chunk (cost=0.09..81020.30 rows=8030000 width=0) (actual time=0.000..0.001 rows=5717966 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_662_chunk (cost=0.00..720.30 rows=8030 width=4) (actual time=0.008..3.500 rows=13651 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=101683.27..101683.28 rows=1 width=8) (actual time=6.335..6.337 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_186_chunk (cost=0.09..81490.77 rows=8077000 width=0) (actual time=0.000..0.001 rows=6006918 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_187_chunk (cost=0.00..720.77 rows=8077 width=4) (actual time=0.015..3.638 rows=13731 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=76315.62..76315.63 rows=1 width=8) (actual time=4.529..4.530 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_54_chunk (cost=0.09..61160.62 rows=6062000 width=0) (actual time=0.000..0.000 rows=3952518 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_80_chunk (cost=0.00..540.62 rows=6062 width=4) (actual time=0.007..2.526 rows=10306 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=122352.69..122352.70 rows=1 width=8) (actual time=5.556..5.557 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_328_chunk (cost=0.09..98055.19 rows=9719000 width=0) (actual time=0.000..0.000 rows=8324697 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_368_chunk (cost=0.00..865.19 rows=9719 width=4) (actual time=0.003..3.073 rows=16523 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=102271.24..102271.25 rows=1 width=8) (actual time=4.188..4.189 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_236_chunk (cost=0.09..81961.24 rows=8124000 width=0) (actual time=0.000..0.001 rows=6248140 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_281_chunk (cost=0.00..721.24 rows=8124 width=4) (actual time=0.005..2.296 rows=13810 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=112505.87..112505.88 rows=1 width=8) (actual time=4.663..4.664 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_333_chunk (cost=0.09..90163.37 rows=8937000 width=0) (actual time=0.000..0.000 rows=6561986 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_373_chunk (cost=0.00..793.37 rows=8937 width=4) (actual time=0.010..2.470 rows=15193 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=122765.52..122765.53 rows=1 width=8) (actual time=7.640..7.642 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_329_chunk (cost=0.09..98385.52 rows=9752000 width=0) (actual time=0.000..0.001 rows=8397057 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_369_chunk (cost=0.00..865.52 rows=9752 width=4) (actual time=0.012..4.402 rows=16579 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=102446.38..102446.39 rows=1 width=8) (actual time=6.314..6.315 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_548_chunk (cost=0.09..82101.38 rows=8138000 width=0) (actual time=0.000..0.001 rows=6189658 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_685_chunk (cost=0.00..721.38 rows=8138 width=4) (actual time=0.014..3.541 rows=13835 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=105756.51..105756.52 rows=1 width=8) (actual time=6.399..6.400 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_304_chunk (cost=0.09..84754.01 rows=8401000 width=0) (actual time=0.000..0.001 rows=6038715 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_351_chunk (cost=0.00..744.01 rows=8401 width=4) (actual time=0.010..3.559 rows=14281 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=102721.60..102721.61 rows=1 width=8) (actual time=4.215..4.216 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_247_chunk (cost=0.09..82321.60 rows=8160000 width=0) (actual time=0.000..0.001 rows=6091397 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_291_chunk (cost=0.00..721.60 rows=8160 width=4) (actual time=0.007..2.220 rows=13872 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=123315.96..123315.97 rows=1 width=8) (actual time=7.308..7.310 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_316_chunk (cost=0.09..98825.96 rows=9796000 width=0) (actual time=0.000..0.001 rows=8579610 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_360_chunk (cost=0.00..865.96 rows=9796 width=4) (actual time=0.009..4.154 rows=16654 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=123791.34..123791.35 rows=1 width=8) (actual time=5.563..5.564 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_317_chunk (cost=0.09..99206.34 rows=9834000 width=0) (actual time=0.000..0.000 rows=8657246 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_361_chunk (cost=0.00..866.34 rows=9834 width=4) (actual time=0.006..3.049 rows=16717 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=114007.07..114007.08 rows=1 width=8) (actual time=6.980..6.981 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_496_chunk (cost=0.09..91364.57 rows=9057000 width=0) (actual time=0.000..0.000 rows=7504106 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_636_chunk (cost=0.00..794.57 rows=9057 width=4) (actual time=0.014..3.954 rows=15397 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=114082.13..114082.14 rows=1 width=8) (actual time=4.852..4.852 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_336_chunk (cost=0.09..91424.63 rows=9063000 width=0) (actual time=0.000..0.000 rows=6892052 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_376_chunk (cost=0.00..794.63 rows=9063 width=4) (actual time=0.009..2.622 rows=15407 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=114207.23..114207.24 rows=1 width=8) (actual time=6.881..6.882 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_495_chunk (cost=0.09..91524.73 rows=9073000 width=0) (actual time=0.000..0.001 rows=7517137 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_635_chunk (cost=0.00..794.73 rows=9073 width=4) (actual time=0.009..3.860 rows=15424 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=103985.11..103985.12 rows=1 width=8) (actual time=6.399..6.400 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_501_chunk (cost=0.09..83332.61 rows=8261000 width=0) (actual time=0.000..0.000 rows=5873187 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_641_chunk (cost=0.00..722.61 rows=8261 width=4) (actual time=0.010..3.533 rows=14043 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=114407.39..114407.40 rows=1 width=8) (actual time=4.745..4.746 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_493_chunk (cost=0.09..91684.89 rows=9089000 width=0) (actual time=0.000..0.001 rows=7504535 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_633_chunk (cost=0.00..794.89 rows=9089 width=4) (actual time=0.006..2.535 rows=15452 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=117088.02..117088.03 rows=1 width=8) (actual time=4.752..4.753 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_379_chunk (cost=0.09..93833.02 rows=9302000 width=0) (actual time=0.000..0.000 rows=7535841 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_411_chunk (cost=0.00..813.02 rows=9302 width=4) (actual time=0.003..2.409 rows=15814 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=104122.72..104122.73 rows=1 width=8) (actual time=6.163..6.164 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_508_chunk (cost=0.09..83442.72 rows=8272000 width=0) (actual time=0.000..0.000 rows=6020271 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_648_chunk (cost=0.00..722.72 rows=8272 width=4) (actual time=0.012..3.448 rows=14063 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=125179.95..125179.96 rows=1 width=8) (actual time=5.323..5.324 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_330_chunk (cost=0.09..100317.45 rows=9945000 width=0) (actual time=0.000..0.000 rows=8876990 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_370_chunk (cost=0.00..867.45 rows=9945 width=4) (actual time=0.003..2.881 rows=16906 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=104673.16..104673.17 rows=1 width=8) (actual time=6.098..6.099 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_511_chunk (cost=0.09..83883.16 rows=8316000 width=0) (actual time=0.000..0.001 rows=6196183 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_651_chunk (cost=0.00..723.16 rows=8316 width=4) (actual time=0.011..3.449 rows=14138 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=116881.86..116881.87 rows=1 width=8) (actual time=6.801..6.801 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_381_chunk (cost=0.09..93666.86 rows=9286000 width=0) (actual time=0.000..0.000 rows=7390711 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_413_chunk (cost=0.00..806.86 rows=9286 width=4) (actual time=0.010..3.644 rows=15787 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=115408.19..115408.20 rows=1 width=8) (actual time=4.602..4.603 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_490_chunk (cost=0.09..92485.69 rows=9169000 width=0) (actual time=0.000..0.001 rows=7547171 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_630_chunk (cost=0.00..795.69 rows=9169 width=4) (actual time=0.004..2.422 rows=15588 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=115808.51..115808.52 rows=1 width=8) (actual time=6.696..6.697 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_298_chunk (cost=0.09..92806.01 rows=9201000 width=0) (actual time=0.000..0.001 rows=7899312 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_345_chunk (cost=0.00..796.01 rows=9201 width=4) (actual time=0.007..3.712 rows=15642 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=115821.02..115821.03 rows=1 width=8) (actual time=4.574..4.575 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_488_chunk (cost=0.09..92816.02 rows=9202000 width=0) (actual time=0.000..0.001 rows=7674449 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_628_chunk (cost=0.00..796.02 rows=9202 width=4) (actual time=0.007..2.392 rows=15644 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=105298.66..105298.67 rows=1 width=8) (actual time=6.285..6.286 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_767_chunk (cost=0.09..84383.66 rows=8366000 width=0) (actual time=0.000..0.000 rows=6084666 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_806_chunk (cost=0.00..723.66 rows=8366 width=4) (actual time=0.013..3.508 rows=14223 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=117494.85..117494.86 rows=1 width=8) (actual time=4.918..4.919 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_380_chunk (cost=0.09..94157.35 rows=9335000 width=0) (actual time=0.000..0.001 rows=7585912 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_412_chunk (cost=0.00..807.35 rows=9335 width=4) (actual time=0.005..2.517 rows=15870 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=116108.75..116108.76 rows=1 width=8) (actual time=6.487..6.488 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_282_chunk (cost=0.09..93046.25 rows=9225000 width=0) (actual time=0.000..0.000 rows=8064321 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_343_chunk (cost=0.00..796.25 rows=9225 width=4) (actual time=0.005..3.595 rows=15683 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=116108.75..116108.76 rows=1 width=8) (actual time=6.568..6.569 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_398_chunk (cost=0.09..93046.25 rows=9225000 width=0) (actual time=0.000..0.001 rows=7400029 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_430_chunk (cost=0.00..796.25 rows=9225 width=4) (actual time=0.010..3.603 rows=15682 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=105849.10..105849.11 rows=1 width=8) (actual time=4.160..4.161 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_570_chunk (cost=0.09..84824.10 rows=8410000 width=0) (actual time=0.000..0.001 rows=6863336 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_704_chunk (cost=0.00..724.10 rows=8410 width=4) (actual time=0.004..2.171 rows=14297 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=118586.22..118586.23 rows=1 width=8) (actual time=7.098..7.099 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_389_chunk (cost=0.09..95031.22 rows=9422000 width=0) (actual time=0.000..0.001 rows=7750555 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_421_chunk (cost=0.00..811.22 rows=9422 width=4) (actual time=0.012..3.888 rows=16017 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=105874.12..105874.13 rows=1 width=8) (actual time=4.094..4.095 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_403_chunk (cost=0.09..84844.12 rows=8412000 width=0) (actual time=0.000..0.001 rows=6007156 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_435_chunk (cost=0.00..724.12 rows=8412 width=4) (actual time=0.005..2.025 rows=14301 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=105924.16..105924.17 rows=1 width=8) (actual time=4.398..4.399 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_747_chunk (cost=0.09..84884.16 rows=8416000 width=0) (actual time=0.000..0.001 rows=6546441 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_786_chunk (cost=0.00..724.16 rows=8416 width=4) (actual time=0.004..2.331 rows=14307 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=117352.24..117352.25 rows=1 width=8) (actual time=6.861..6.862 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_386_chunk (cost=0.09..94042.24 rows=9324000 width=0) (actual time=0.000..0.000 rows=7523312 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_418_chunk (cost=0.00..802.24 rows=9324 width=4) (actual time=0.013..3.707 rows=15851 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=106161.85..106161.86 rows=1 width=8) (actual time=6.176..6.177 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_494_chunk (cost=0.09..85074.35 rows=8435000 width=0) (actual time=0.000..0.001 rows=6085436 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_634_chunk (cost=0.00..724.35 rows=8435 width=4) (actual time=0.008..3.274 rows=14339 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=116946.92..116946.93 rows=1 width=8) (actual time=4.609..4.610 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_385_chunk (cost=0.09..93716.92 rows=9292000 width=0) (actual time=0.000..0.000 rows=7482630 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_417_chunk (cost=0.00..796.92 rows=9292 width=4) (actual time=0.004..2.343 rows=15796 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=106449.58..106449.59 rows=1 width=8) (actual time=5.818..5.819 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_756_chunk (cost=0.09..85304.58 rows=8458000 width=0) (actual time=0.000..0.000 rows=6535142 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_795_chunk (cost=0.00..724.58 rows=8458 width=4) (actual time=0.005..3.166 rows=14379 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=117109.55..117109.56 rows=1 width=8) (actual time=4.589..4.590 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_305_chunk (cost=0.09..93847.05 rows=9305000 width=0) (actual time=0.000..0.000 rows=7905740 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_352_chunk (cost=0.00..797.05 rows=9305 width=4) (actual time=0.008..2.381 rows=15819 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=117159.59..117159.60 rows=1 width=8) (actual time=6.376..6.377 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_400_chunk (cost=0.09..93887.09 rows=9309000 width=0) (actual time=0.000..0.000 rows=7696827 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_432_chunk (cost=0.00..797.09 rows=9309 width=4) (actual time=0.003..3.419 rows=15825 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=119865.24..119865.25 rows=1 width=8) (actual time=4.924..4.925 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_383_chunk (cost=0.09..96055.24 rows=9524000 width=0) (actual time=0.000..0.000 rows=7933711 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_415_chunk (cost=0.00..815.24 rows=9524 width=4) (actual time=0.007..2.472 rows=16190 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=118380.06..118380.07 rows=1 width=8) (actual time=6.762..6.763 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_394_chunk (cost=0.09..94865.06 rows=9406000 width=0) (actual time=0.000..0.000 rows=7719048 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_426_chunk (cost=0.00..805.06 rows=9406 width=4) (actual time=0.006..3.605 rows=15990 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=107745.11..107745.12 rows=1 width=8) (actual time=4.232..4.233 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_489_chunk (cost=0.09..86342.61 rows=8561000 width=0) (actual time=0.000..0.001 rows=6261697 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_629_chunk (cost=0.00..732.61 rows=8561 width=4) (actual time=0.006..2.136 rows=14553 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=117347.24..117347.25 rows=1 width=8) (actual time=6.773..6.774 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_401_chunk (cost=0.09..94037.24 rows=9324000 width=0) (actual time=0.000..0.001 rows=7804696 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_433_chunk (cost=0.00..797.24 rows=9324 width=4) (actual time=0.013..3.654 rows=15850 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=106712.29..106712.30 rows=1 width=8) (actual time=4.119..4.120 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_761_chunk (cost=0.09..85514.79 rows=8479000 width=0) (actual time=0.000..0.001 rows=6533313 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_800_chunk (cost=0.00..724.79 rows=8479 width=4) (actual time=0.003..2.102 rows=14415 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=117384.77..117384.78 rows=1 width=8) (actual time=6.748..6.749 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_392_chunk (cost=0.09..94067.27 rows=9327000 width=0) (actual time=0.000..0.000 rows=7576917 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_424_chunk (cost=0.00..797.27 rows=9327 width=4) (actual time=0.008..3.624 rows=15856 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=117572.42..117572.43 rows=1 width=8) (actual time=6.336..6.337 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_296_chunk (cost=0.09..94217.42 rows=9342000 width=0) (actual time=0.000..0.001 rows=8238970 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_344_chunk (cost=0.00..797.42 rows=9342 width=4) (actual time=0.010..3.455 rows=15881 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=117735.05..117735.06 rows=1 width=8) (actual time=4.805..4.805 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_402_chunk (cost=0.09..94347.55 rows=9355000 width=0) (actual time=0.000..0.000 rows=7967582 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_434_chunk (cost=0.00..797.55 rows=9355 width=4) (actual time=0.006..2.489 rows=15903 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=117785.09..117785.10 rows=1 width=8) (actual time=6.223..6.224 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_299_chunk (cost=0.09..94387.59 rows=9359000 width=0) (actual time=0.000..0.001 rows=8147188 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_346_chunk (cost=0.00..797.59 rows=9359 width=4) (actual time=0.011..3.381 rows=15910 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=117935.21..117935.22 rows=1 width=8) (actual time=4.589..4.590 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_302_chunk (cost=0.09..94507.71 rows=9371000 width=0) (actual time=0.000..0.001 rows=8153824 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_349_chunk (cost=0.00..797.71 rows=9371 width=4) (actual time=0.007..2.391 rows=15931 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=118035.29..118035.30 rows=1 width=8) (actual time=4.486..4.487 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_388_chunk (cost=0.09..94587.79 rows=9379000 width=0) (actual time=0.000..0.001 rows=7709444 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_420_chunk (cost=0.00..797.79 rows=9379 width=4) (actual time=0.007..2.210 rows=15944 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=120073.91..120073.92 rows=1 width=8) (actual time=6.792..6.793 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_391_chunk (cost=0.09..96221.41 rows=9541000 width=0) (actual time=0.000..0.000 rows=7976109 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_423_chunk (cost=0.00..811.41 rows=9541 width=4) (actual time=0.014..3.603 rows=16219 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=107841.19..107841.20 rows=1 width=8) (actual time=6.149..6.150 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_300_chunk (cost=0.09..86418.69 rows=8569000 width=0) (actual time=0.000..0.000 rows=6352793 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_347_chunk (cost=0.00..728.69 rows=8569 width=4) (actual time=0.010..3.220 rows=14568 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=118915.99..118916.00 rows=1 width=8) (actual time=4.787..4.788 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_313_chunk (cost=0.09..95293.49 rows=9449000 width=0) (actual time=0.000..0.000 rows=7973150 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_357_chunk (cost=0.00..803.49 rows=9449 width=4) (actual time=0.005..2.390 rows=16064 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=107425.36..107425.37 rows=1 width=8) (actual time=5.735..5.736 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_582_chunk (cost=0.08..86085.36 rows=8536000 width=0) (actual time=0.000..0.000 rows=7064729 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_712_chunk (cost=0.00..725.36 rows=8536 width=4) (actual time=0.005..3.026 rows=14511 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=100100.54..100100.55 rows=1 width=8) (actual time=5.790..5.791 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_565_chunk (cost=0.08..80215.54 rows=7954000 width=0) (actual time=0.000..0.001 rows=5885607 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_699_chunk (cost=0.00..675.54 rows=7954 width=4) (actual time=0.012..3.131 rows=13522 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=120928.59..120928.60 rows=1 width=8) (actual time=4.630..4.631 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_390_chunk (cost=0.08..96906.09 rows=9609000 width=0) (actual time=0.000..0.000 rows=8138818 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_422_chunk (cost=0.00..816.09 rows=9609 width=4) (actual time=0.003..2.296 rows=16336 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=100615.45..100615.46 rows=1 width=8) (actual time=3.805..3.806 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_597_chunk (cost=0.08..80627.95 rows=7995000 width=0) (actual time=0.000..0.001 rows=5744914 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_736_chunk (cost=0.00..677.95 rows=7995 width=4) (actual time=0.005..1.900 rows=13591 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=119328.82..119328.83 rows=1 width=8) (actual time=6.420..6.420 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_382_chunk (cost=0.08..95623.82 rows=9482000 width=0) (actual time=0.000..0.001 rows=7848956 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_414_chunk (cost=0.00..803.82 rows=9482 width=4) (actual time=0.011..3.380 rows=16119 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=107738.11..107738.12 rows=1 width=8) (actual time=6.068..6.069 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_523_chunk (cost=0.08..86335.61 rows=8561000 width=0) (actual time=0.000..0.001 rows=6933081 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_661_chunk (cost=0.00..725.61 rows=8561 width=4) (actual time=0.014..3.234 rows=14554 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=118523.18..118523.19 rows=1 width=8) (actual time=4.722..4.723 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_395_chunk (cost=0.08..94978.18 rows=9418000 width=0) (actual time=0.000..0.001 rows=7796867 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_427_chunk (cost=0.00..798.18 rows=9418 width=4) (actual time=0.007..2.375 rows=16011 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=118573.22..118573.23 rows=1 width=8) (actual time=4.431..4.432 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_309_chunk (cost=0.08..95018.22 rows=9422000 width=0) (actual time=0.000..0.000 rows=8078652 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_353_chunk (cost=0.00..798.22 rows=9422 width=4) (actual time=0.003..2.256 rows=16018 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=118698.32..118698.33 rows=1 width=8) (actual time=4.482..4.483 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_396_chunk (cost=0.08..95118.32 rows=9432000 width=0) (actual time=0.000..0.000 rows=7898375 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_428_chunk (cost=0.00..798.32 rows=9432 width=4) (actual time=0.003..2.216 rows=16035 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=108088.39..108088.40 rows=1 width=8) (actual time=5.968..5.968 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_580_chunk (cost=0.08..86615.89 rows=8589000 width=0) (actual time=0.000..0.001 rows=7169488 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_711_chunk (cost=0.00..725.89 rows=8589 width=4) (actual time=0.011..3.208 rows=14602 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=118910.99..118911.00 rows=1 width=8) (actual time=6.460..6.461 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_393_chunk (cost=0.08..95288.49 rows=9449000 width=0) (actual time=0.000..0.000 rows=7789044 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_425_chunk (cost=0.00..798.49 rows=9449 width=4) (actual time=0.007..3.438 rows=16064 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=120962.12..120962.13 rows=1 width=8) (actual time=6.790..6.791 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_337_chunk (cost=0.08..96932.12 rows=9612000 width=0) (actual time=0.000..0.000 rows=8222226 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_377_chunk (cost=0.00..812.12 rows=9612 width=4) (actual time=0.009..3.574 rows=16340 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=111107.79..111107.80 rows=1 width=8) (actual time=5.727..5.728 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_253_chunk (cost=0.08..89035.29 rows=8829000 width=0) (actual time=0.000..0.000 rows=7309848 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_297_chunk (cost=0.00..745.29 rows=8829 width=4) (actual time=0.007..3.026 rows=15010 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=119161.19..119161.20 rows=1 width=8) (actual time=4.445..4.446 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_384_chunk (cost=0.08..95488.69 rows=9469000 width=0) (actual time=0.000..0.001 rows=7829161 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_416_chunk (cost=0.00..798.69 rows=9469 width=4) (actual time=0.006..2.183 rows=16097 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=119261.27..119261.28 rows=1 width=8) (actual time=4.164..4.165 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_303_chunk (cost=0.08..95568.77 rows=9477000 width=0) (actual time=0.000..0.000 rows=8343487 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_350_chunk (cost=0.00..798.77 rows=9477 width=4) (actual time=0.004..2.060 rows=16111 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=108451.18..108451.19 rows=1 width=8) (actual time=3.965..3.966 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_527_chunk (cost=0.08..86906.18 rows=8618000 width=0) (actual time=0.000..0.000 rows=7046709 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_664_chunk (cost=0.00..726.18 rows=8618 width=4) (actual time=0.006..1.963 rows=14650 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=108501.22..108501.23 rows=1 width=8) (actual time=5.953..5.955 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_579_chunk (cost=0.08..86946.22 rows=8622000 width=0) (actual time=0.000..0.001 rows=7274252 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_710_chunk (cost=0.00..726.22 rows=8622 width=4) (actual time=0.011..3.184 rows=14658 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=108551.26..108551.27 rows=1 width=8) (actual time=5.966..5.967 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_563_chunk (cost=0.08..86986.26 rows=8626000 width=0) (actual time=0.000..0.001 rows=7266789 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_698_chunk (cost=0.00..726.26 rows=8626 width=4) (actual time=0.005..3.153 rows=14664 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=108576.28..108576.29 rows=1 width=8) (actual time=5.676..5.677 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_228_chunk (cost=0.08..87006.28 rows=8628000 width=0) (actual time=0.000..0.000 rows=7576924 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_275_chunk (cost=0.00..726.28 rows=8628 width=4) (actual time=0.009..3.016 rows=14668 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=108663.85..108663.86 rows=1 width=8) (actual time=6.034..6.035 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_530_chunk (cost=0.08..87076.35 rows=8635000 width=0) (actual time=0.000..0.000 rows=7124053 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_667_chunk (cost=0.00..726.35 rows=8635 width=4) (actual time=0.007..3.203 rows=14680 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=121763.76..121763.77 rows=1 width=8) (actual time=4.547..4.548 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_312_chunk (cost=0.08..97573.76 rows=9676000 width=0) (actual time=0.000..0.000 rows=8426026 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_356_chunk (cost=0.00..813.76 rows=9676 width=4) (actual time=0.005..2.279 rows=16450 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=108713.89..108713.90 rows=1 width=8) (actual time=3.946..3.947 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_560_chunk (cost=0.08..87116.39 rows=8639000 width=0) (actual time=0.000..0.000 rows=7366319 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_697_chunk (cost=0.00..726.39 rows=8639 width=4) (actual time=0.004..1.970 rows=14686 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=108726.40..108726.41 rows=1 width=8) (actual time=4.441..4.442 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_526_chunk (cost=0.08..87126.40 rows=8640000 width=0) (actual time=0.000..0.000 rows=7068720 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_663_chunk (cost=0.00..726.40 rows=8640 width=4) (actual time=0.011..2.253 rows=14688 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=101263.97..101263.98 rows=1 width=8) (actual time=5.362..5.363 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_554_chunk (cost=0.08..81146.47 rows=8047000 width=0) (actual time=0.000..0.001 rows=6069402 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_691_chunk (cost=0.00..676.47 rows=8047 width=4) (actual time=0.006..2.815 rows=13680 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=108751.42..108751.43 rows=1 width=8) (actual time=5.984..5.985 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_528_chunk (cost=0.08..87146.42 rows=8642000 width=0) (actual time=0.000..0.000 rows=7133856 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_665_chunk (cost=0.00..726.42 rows=8642 width=4) (actual time=0.007..3.153 rows=14691 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=108788.95..108788.96 rows=1 width=8) (actual time=6.046..6.046 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_765_chunk (cost=0.08..87176.45 rows=8645000 width=0) (actual time=0.000..0.000 rows=6806360 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_804_chunk (cost=0.00..726.45 rows=8645 width=4) (actual time=0.003..3.126 rows=14697 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=119674.10..119674.11 rows=1 width=8) (actual time=4.454..4.455 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_301_chunk (cost=0.08..95899.10 rows=9510000 width=0) (actual time=0.000..0.001 rows=8433215 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_348_chunk (cost=0.00..799.10 rows=9510 width=4) (actual time=0.007..2.225 rows=16167 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=120240.05..120240.06 rows=1 width=8) (actual time=6.398..6.399 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_314_chunk (cost=0.08..96352.55 rows=9555000 width=0) (actual time=0.000..0.001 rows=8138118 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_358_chunk (cost=0.00..802.55 rows=9555 width=4) (actual time=0.005..3.330 rows=16244 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=108864.01..108864.02 rows=1 width=8) (actual time=4.045..4.046 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_567_chunk (cost=0.08..87236.51 rows=8651000 width=0) (actual time=0.000..0.000 rows=7267373 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_701_chunk (cost=0.00..726.51 rows=8651 width=4) (actual time=0.008..2.021 rows=14707 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=108876.52..108876.53 rows=1 width=8) (actual time=4.269..4.269 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_553_chunk (cost=0.08..87246.52 rows=8652000 width=0) (actual time=0.000..0.001 rows=7415920 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_690_chunk (cost=0.00..726.52 rows=8652 width=4) (actual time=0.006..2.162 rows=14709 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=111279.93..111279.94 rows=1 width=8) (actual time=6.185..6.186 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_503_chunk (cost=0.08..89172.43 rows=8843000 width=0) (actual time=0.000..0.000 rows=7255163 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_643_chunk (cost=0.00..742.43 rows=8843 width=4) (actual time=0.007..3.220 rows=15033 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=108914.05..108914.06 rows=1 width=8) (actual time=5.626..5.627 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_558_chunk (cost=0.08..87276.55 rows=8655000 width=0) (actual time=0.000..0.000 rows=7403716 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_695_chunk (cost=0.00..726.55 rows=8655 width=4) (actual time=0.006..2.960 rows=14714 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=108964.09..108964.10 rows=1 width=8) (actual time=3.898..3.898 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_559_chunk (cost=0.08..87316.59 rows=8659000 width=0) (actual time=0.000..0.001 rows=7420399 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_696_chunk (cost=0.00..726.59 rows=8659 width=4) (actual time=0.004..1.929 rows=14720 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=108964.09..108964.10 rows=1 width=8) (actual time=3.899..3.900 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_585_chunk (cost=0.08..87316.59 rows=8659000 width=0) (actual time=0.000..0.001 rows=7336664 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_724_chunk (cost=0.00..726.59 rows=8659 width=4) (actual time=0.005..1.907 rows=14720 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109076.68..109076.69 rows=1 width=8) (actual time=5.934..5.935 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_531_chunk (cost=0.08..87406.68 rows=8668000 width=0) (actual time=0.000..0.001 rows=7273119 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_668_chunk (cost=0.00..726.68 rows=8668 width=4) (actual time=0.005..3.123 rows=14735 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109126.72..109126.73 rows=1 width=8) (actual time=4.239..4.240 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_590_chunk (cost=0.08..87446.72 rows=8672000 width=0) (actual time=0.000..0.000 rows=7265613 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_729_chunk (cost=0.00..726.72 rows=8672 width=4) (actual time=0.006..2.164 rows=14743 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109164.25..109164.26 rows=1 width=8) (actual time=6.043..6.045 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_557_chunk (cost=0.08..87476.75 rows=8675000 width=0) (actual time=0.000..0.001 rows=7452103 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_694_chunk (cost=0.00..726.75 rows=8675 width=4) (actual time=0.012..3.220 rows=14748 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109239.31..109239.32 rows=1 width=8) (actual time=5.632..5.633 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_569_chunk (cost=0.08..87536.81 rows=8681000 width=0) (actual time=0.000..0.000 rows=7379785 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_703_chunk (cost=0.00..726.81 rows=8681 width=4) (actual time=0.007..2.945 rows=14758 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109326.88..109326.89 rows=1 width=8) (actual time=5.968..5.969 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_589_chunk (cost=0.08..87606.88 rows=8688000 width=0) (actual time=0.000..0.000 rows=7289582 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_728_chunk (cost=0.00..726.88 rows=8688 width=4) (actual time=0.007..3.144 rows=14769 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109376.92..109376.93 rows=1 width=8) (actual time=5.772..5.773 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_536_chunk (cost=0.08..87646.92 rows=8692000 width=0) (actual time=0.000..0.000 rows=7260095 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_673_chunk (cost=0.00..726.92 rows=8692 width=4) (actual time=0.008..3.047 rows=14777 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109414.45..109414.46 rows=1 width=8) (actual time=4.009..4.011 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_574_chunk (cost=0.08..87676.95 rows=8695000 width=0) (actual time=0.000..0.001 rows=7425580 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_707_chunk (cost=0.00..726.95 rows=8695 width=4) (actual time=0.003..2.007 rows=14781 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109439.47..109439.48 rows=1 width=8) (actual time=3.959..3.960 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_586_chunk (cost=0.08..87696.97 rows=8697000 width=0) (actual time=0.000..0.000 rows=7372432 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_725_chunk (cost=0.00..726.97 rows=8697 width=4) (actual time=0.004..1.958 rows=14785 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109502.02..109502.03 rows=1 width=8) (actual time=4.162..4.162 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_555_chunk (cost=0.08..87747.02 rows=8702000 width=0) (actual time=0.000..0.000 rows=7478779 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_692_chunk (cost=0.00..727.02 rows=8702 width=4) (actual time=0.004..2.042 rows=14793 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109564.57..109564.58 rows=1 width=8) (actual time=5.997..5.998 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_521_chunk (cost=0.08..87797.07 rows=8707000 width=0) (actual time=0.000..0.000 rows=7179881 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_660_chunk (cost=0.00..727.07 rows=8707 width=4) (actual time=0.005..3.097 rows=14802 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=120524.78..120524.79 rows=1 width=8) (actual time=6.718..6.719 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_397_chunk (cost=0.08..96579.78 rows=9578000 width=0) (actual time=0.000..0.000 rows=8131936 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_429_chunk (cost=0.00..799.78 rows=9578 width=4) (actual time=0.008..3.451 rows=16283 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109577.08..109577.09 rows=1 width=8) (actual time=5.591..5.592 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_239_chunk (cost=0.08..87807.08 rows=8708000 width=0) (actual time=0.000..0.000 rows=7443935 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_285_chunk (cost=0.00..727.08 rows=8708 width=4) (actual time=0.005..2.858 rows=14804 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109589.59..109589.60 rows=1 width=8) (actual time=5.133..5.134 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_566_chunk (cost=0.08..87817.09 rows=8709000 width=0) (actual time=0.000..0.000 rows=7416561 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_700_chunk (cost=0.00..727.09 rows=8709 width=4) (actual time=0.004..2.539 rows=14805 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109614.61..109614.62 rows=1 width=8) (actual time=4.967..4.969 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_543_chunk (cost=0.08..87837.11 rows=8711000 width=0) (actual time=0.000..0.001 rows=7455253 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_680_chunk (cost=0.00..727.11 rows=8711 width=4) (actual time=0.005..2.564 rows=14809 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109664.65..109664.66 rows=1 width=8) (actual time=6.103..6.104 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_591_chunk (cost=0.08..87877.15 rows=8715000 width=0) (actual time=0.000..0.001 rows=7340362 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_730_chunk (cost=0.00..727.15 rows=8715 width=4) (actual time=0.006..3.295 rows=14816 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=121870.35..121870.36 rows=1 width=8) (actual time=6.473..6.474 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_318_chunk (cost=0.08..97657.85 rows=9685000 width=0) (actual time=0.000..0.001 rows=8432861 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_362_chunk (cost=0.00..807.85 rows=9685 width=4) (actual time=0.012..3.412 rows=16464 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109952.38..109952.39 rows=1 width=8) (actual time=5.542..5.543 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_227_chunk (cost=0.08..88107.38 rows=8738000 width=0) (actual time=0.000..0.000 rows=7896106 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_274_chunk (cost=0.00..727.38 rows=8738 width=4) (actual time=0.009..2.901 rows=14855 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109964.89..109964.90 rows=1 width=8) (actual time=5.966..5.967 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_556_chunk (cost=0.08..88117.39 rows=8739000 width=0) (actual time=0.000..0.001 rows=7636493 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_693_chunk (cost=0.00..727.39 rows=8739 width=4) (actual time=0.008..3.097 rows=14856 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109989.91..109989.92 rows=1 width=8) (actual time=5.511..5.512 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_520_chunk (cost=0.08..88137.41 rows=8741000 width=0) (actual time=0.000..0.001 rows=7307461 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_659_chunk (cost=0.00..727.41 rows=8741 width=4) (actual time=0.006..2.715 rows=14860 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110002.42..110002.43 rows=1 width=8) (actual time=5.873..5.874 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_545_chunk (cost=0.08..88147.42 rows=8742000 width=0) (actual time=0.000..0.000 rows=7405385 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_682_chunk (cost=0.00..727.42 rows=8742 width=4) (actual time=0.008..2.999 rows=14862 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110052.46..110052.47 rows=1 width=8) (actual time=5.686..5.687 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_544_chunk (cost=0.08..88187.46 rows=8746000 width=0) (actual time=0.000..0.000 rows=7486314 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_681_chunk (cost=0.00..727.46 rows=8746 width=4) (actual time=0.009..2.989 rows=14868 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110089.99..110090.00 rows=1 width=8) (actual time=6.080..6.081 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_552_chunk (cost=0.08..88217.49 rows=8749000 width=0) (actual time=0.000..0.001 rows=7607854 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_689_chunk (cost=0.00..727.49 rows=8749 width=4) (actual time=0.004..3.171 rows=14873 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110102.50..110102.51 rows=1 width=8) (actual time=5.977..5.978 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_529_chunk (cost=0.08..88227.50 rows=8750000 width=0) (actual time=0.000..0.000 rows=7435474 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_666_chunk (cost=0.00..727.50 rows=8750 width=4) (actual time=0.007..3.079 rows=14875 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110127.52..110127.53 rows=1 width=8) (actual time=5.951..5.952 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_516_chunk (cost=0.08..88247.52 rows=8752000 width=0) (actual time=0.000..0.000 rows=7288660 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_656_chunk (cost=0.00..727.52 rows=8752 width=4) (actual time=0.010..3.110 rows=14879 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110165.05..110165.06 rows=1 width=8) (actual time=5.515..5.516 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_532_chunk (cost=0.08..88277.55 rows=8755000 width=0) (actual time=0.000..0.001 rows=7391220 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_669_chunk (cost=0.00..727.55 rows=8755 width=4) (actual time=0.006..2.771 rows=14884 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=112958.27..112958.28 rows=1 width=8) (actual time=5.979..5.980 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_499_chunk (cost=0.08..90515.77 rows=8977000 width=0) (actual time=0.000..0.001 rows=7543878 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_639_chunk (cost=0.00..745.77 rows=8977 width=4) (actual time=0.008..3.047 rows=15261 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110227.60..110227.61 rows=1 width=8) (actual time=5.582..5.583 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_533_chunk (cost=0.08..88327.60 rows=8760000 width=0) (actual time=0.000..0.001 rows=7387823 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_670_chunk (cost=0.00..727.60 rows=8760 width=4) (actual time=0.005..2.849 rows=14892 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=121312.91..121312.92 rows=1 width=8) (actual time=6.400..6.401 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_332_chunk (cost=0.08..97210.41 rows=9641000 width=0) (actual time=0.000..0.000 rows=8299608 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_372_chunk (cost=0.00..800.41 rows=9641 width=4) (actual time=0.005..3.223 rows=16390 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110377.72..110377.73 rows=1 width=8) (actual time=5.423..5.424 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_576_chunk (cost=0.08..88447.72 rows=8772000 width=0) (actual time=0.000..0.000 rows=7551408 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_708_chunk (cost=0.00..727.72 rows=8772 width=4) (actual time=0.008..2.782 rows=14913 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110377.72..110377.73 rows=1 width=8) (actual time=5.884..5.885 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_587_chunk (cost=0.08..88447.72 rows=8772000 width=0) (actual time=0.000..0.000 rows=7474019 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_726_chunk (cost=0.00..727.72 rows=8772 width=4) (actual time=0.007..3.018 rows=14912 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=122809.60..122809.61 rows=1 width=8) (actual time=6.624..6.625 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_335_chunk (cost=0.08..98409.60 rows=9760000 width=0) (actual time=0.000..0.001 rows=8474844 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_375_chunk (cost=0.00..809.60 rows=9760 width=4) (actual time=0.009..3.364 rows=16592 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110402.74..110402.75 rows=1 width=8) (actual time=5.631..5.632 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_237_chunk (cost=0.08..88467.74 rows=8774000 width=0) (actual time=0.000..0.000 rows=7682343 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_283_chunk (cost=0.00..727.74 rows=8774 width=4) (actual time=0.003..2.870 rows=14916 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110490.31..110490.32 rows=1 width=8) (actual time=5.847..5.848 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_539_chunk (cost=0.08..88537.81 rows=8781000 width=0) (actual time=0.000..0.000 rows=7538488 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_676_chunk (cost=0.00..727.81 rows=8781 width=4) (actual time=0.006..3.064 rows=14928 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110552.86..110552.87 rows=1 width=8) (actual time=5.501..5.502 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_242_chunk (cost=0.08..88587.86 rows=8786000 width=0) (actual time=0.000..0.001 rows=7500662 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_288_chunk (cost=0.00..727.86 rows=8786 width=4) (actual time=0.006..2.782 rows=14936 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=88469.81..88469.82 rows=1 width=8) (actual time=4.833..4.834 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_147_chunk (cost=0.08..70892.31 rows=7031000 width=0) (actual time=0.000..0.000 rows=5537444 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_180_chunk (cost=0.00..582.31 rows=7031 width=4) (actual time=0.011..2.510 rows=11953 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=101606.25..101606.26 rows=1 width=8) (actual time=5.174..5.175 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_229_chunk (cost=0.08..81418.75 rows=8075000 width=0) (actual time=0.000..0.001 rows=6295493 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_276_chunk (cost=0.00..668.75 rows=8075 width=4) (actual time=0.005..2.650 rows=13728 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=112339.28..112339.29 rows=1 width=8) (actual time=6.141..6.142 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_255_chunk (cost=0.08..90019.28 rows=8928000 width=0) (actual time=0.000..0.000 rows=7520516 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_341_chunk (cost=0.00..739.28 rows=8928 width=4) (actual time=0.009..3.127 rows=15178 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110715.49..110715.50 rows=1 width=8) (actual time=6.029..6.031 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_551_chunk (cost=0.08..88717.99 rows=8799000 width=0) (actual time=0.000..0.001 rows=7670798 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_688_chunk (cost=0.00..727.99 rows=8799 width=4) (actual time=0.004..3.061 rows=14959 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110740.51..110740.52 rows=1 width=8) (actual time=5.554..5.555 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_534_chunk (cost=0.08..88738.01 rows=8801000 width=0) (actual time=0.000..0.001 rows=7506055 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_671_chunk (cost=0.00..728.01 rows=8801 width=4) (actual time=0.005..2.825 rows=14961 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110753.02..110753.03 rows=1 width=8) (actual time=6.161..6.162 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_547_chunk (cost=0.08..88748.02 rows=8802000 width=0) (actual time=0.000..0.001 rows=7661368 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_684_chunk (cost=0.00..728.02 rows=8802 width=4) (actual time=0.006..3.236 rows=14964 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110753.02..110753.03 rows=1 width=8) (actual time=6.179..6.180 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_245_chunk (cost=0.08..88748.02 rows=8802000 width=0) (actual time=0.000..0.001 rows=7556711 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_290_chunk (cost=0.00..728.02 rows=8802 width=4) (actual time=0.012..3.182 rows=14963 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110753.02..110753.03 rows=1 width=8) (actual time=6.053..6.054 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_592_chunk (cost=0.08..88748.02 rows=8802000 width=0) (actual time=0.000..0.000 rows=7490170 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_731_chunk (cost=0.00..728.02 rows=8802 width=4) (actual time=0.010..3.130 rows=14963 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=114062.15..114062.16 rows=1 width=8) (actual time=5.754..5.755 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_269_chunk (cost=0.08..91399.65 rows=9065000 width=0) (actual time=0.000..0.001 rows=7794494 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_342_chunk (cost=0.00..749.65 rows=9065 width=4) (actual time=0.007..2.924 rows=15410 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110778.04..110778.05 rows=1 width=8) (actual time=5.509..5.510 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_230_chunk (cost=0.08..88768.04 rows=8804000 width=0) (actual time=0.000..0.001 rows=7909301 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_277_chunk (cost=0.00..728.04 rows=8804 width=4) (actual time=0.004..2.840 rows=14967 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110803.06..110803.07 rows=1 width=8) (actual time=5.827..5.828 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_240_chunk (cost=0.08..88788.06 rows=8806000 width=0) (actual time=0.000..0.001 rows=7590942 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_286_chunk (cost=0.00..728.06 rows=8806 width=4) (actual time=0.007..2.969 rows=14971 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=100938.22..100938.23 rows=1 width=8) (actual time=4.948..4.949 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_541_chunk (cost=0.08..80883.22 rows=8022000 width=0) (actual time=0.000..0.001 rows=5963176 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_678_chunk (cost=0.00..663.22 rows=8022 width=4) (actual time=0.006..2.461 rows=13637 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110815.57..110815.58 rows=1 width=8) (actual time=5.887..5.889 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_588_chunk (cost=0.08..88798.07 rows=8807000 width=0) (actual time=0.000..0.001 rows=7589583 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_727_chunk (cost=0.00..728.07 rows=8807 width=4) (actual time=0.006..3.050 rows=14972 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=113244.00..113244.01 rows=1 width=8) (actual time=6.025..6.026 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_500_chunk (cost=0.08..90744.00 rows=9000000 width=0) (actual time=0.000..0.001 rows=7566482 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_640_chunk (cost=0.00..744.00 rows=9000 width=4) (actual time=0.006..3.111 rows=15300 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110865.61..110865.62 rows=1 width=8) (actual time=5.873..5.874 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_506_chunk (cost=0.08..88838.11 rows=8811000 width=0) (actual time=0.000..0.000 rows=7348307 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_646_chunk (cost=0.00..728.11 rows=8811 width=4) (actual time=0.007..2.989 rows=14978 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110865.61..110865.62 rows=1 width=8) (actual time=5.800..5.801 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_546_chunk (cost=0.08..88838.11 rows=8811000 width=0) (actual time=0.000..0.000 rows=7632320 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_683_chunk (cost=0.00..728.11 rows=8811 width=4) (actual time=0.005..2.952 rows=14978 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110878.12..110878.13 rows=1 width=8) (actual time=6.052..6.054 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_549_chunk (cost=0.08..88848.12 rows=8812000 width=0) (actual time=0.000..0.000 rows=7645850 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_686_chunk (cost=0.00..728.12 rows=8812 width=4) (actual time=0.007..3.143 rows=14981 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110903.14..110903.15 rows=1 width=8) (actual time=6.123..6.124 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_535_chunk (cost=0.08..88868.14 rows=8814000 width=0) (actual time=0.000..0.000 rows=7526094 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_672_chunk (cost=0.00..728.14 rows=8814 width=4) (actual time=0.007..3.135 rows=14983 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110953.18..110953.19 rows=1 width=8) (actual time=6.154..6.155 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_241_chunk (cost=0.08..88908.18 rows=8818000 width=0) (actual time=0.000..0.001 rows=7567880 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_287_chunk (cost=0.00..728.18 rows=8818 width=4) (actual time=0.007..3.179 rows=14990 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110990.71..110990.72 rows=1 width=8) (actual time=6.001..6.002 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_514_chunk (cost=0.08..88938.21 rows=8821000 width=0) (actual time=0.000..0.001 rows=7407815 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_654_chunk (cost=0.00..728.21 rows=8821 width=4) (actual time=0.005..3.012 rows=14996 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=111003.22..111003.23 rows=1 width=8) (actual time=5.988..5.989 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_231_chunk (cost=0.08..88948.22 rows=8822000 width=0) (actual time=0.000..0.000 rows=7896401 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_278_chunk (cost=0.00..728.22 rows=8822 width=4) (actual time=0.004..3.045 rows=14997 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=111090.79..111090.80 rows=1 width=8) (actual time=6.179..6.180 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_243_chunk (cost=0.08..89018.29 rows=8829000 width=0) (actual time=0.000..0.001 rows=7603774 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_289_chunk (cost=0.00..728.29 rows=8829 width=4) (actual time=0.010..3.149 rows=15010 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=123282.98..123282.99 rows=1 width=8) (actual time=7.092..7.093 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_331_chunk (cost=0.08..98787.98 rows=9798000 width=0) (actual time=0.000..0.000 rows=8585030 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_371_chunk (cost=0.00..807.98 rows=9798 width=4) (actual time=0.007..3.606 rows=16657 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=111203.38..111203.39 rows=1 width=8) (actual time=6.417..6.418 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_518_chunk (cost=0.08..89108.38 rows=8838000 width=0) (actual time=0.000..0.000 rows=7512302 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_658_chunk (cost=0.00..728.38 rows=8838 width=4) (actual time=0.005..3.283 rows=15024 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=111920.45..111920.46 rows=1 width=8) (actual time=6.875..6.876 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_507_chunk (cost=0.08..89682.95 rows=8895000 width=0) (actual time=0.000..0.001 rows=7472507 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_647_chunk (cost=0.00..732.95 rows=8895 width=4) (actual time=0.012..3.537 rows=15122 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=113958.07..113958.08 rows=1 width=8) (actual time=6.924..6.925 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_250_chunk (cost=0.08..91315.57 rows=9057000 width=0) (actual time=0.000..0.000 rows=7913930 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_293_chunk (cost=0.00..745.57 rows=9057 width=4) (actual time=0.008..3.512 rows=15397 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=103098.94..103098.95 rows=1 width=8) (actual time=6.355..6.356 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_600_chunk (cost=0.08..82613.94 rows=8194000 width=0) (actual time=0.000..0.001 rows=6125786 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_739_chunk (cost=0.00..673.94 rows=8194 width=4) (actual time=0.014..3.329 rows=13929 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=111466.09..111466.10 rows=1 width=8) (actual time=6.352..6.353 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_512_chunk (cost=0.08..89318.59 rows=8859000 width=0) (actual time=0.000..0.000 rows=7515793 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_652_chunk (cost=0.00..728.59 rows=8859 width=4) (actual time=0.009..3.180 rows=15061 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=111553.66..111553.67 rows=1 width=8) (actual time=6.470..6.471 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_515_chunk (cost=0.08..89388.66 rows=8866000 width=0) (actual time=0.000..0.001 rows=7465918 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_655_chunk (cost=0.00..728.66 rows=8866 width=4) (actual time=0.014..3.312 rows=15073 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=111703.78..111703.79 rows=1 width=8) (actual time=6.365..6.366 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_538_chunk (cost=0.08..89508.78 rows=8878000 width=0) (actual time=0.000..0.001 rows=7751093 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_675_chunk (cost=0.00..728.78 rows=8878 width=4) (actual time=0.005..3.260 rows=15092 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=111716.29..111716.30 rows=1 width=8) (actual time=6.380..6.381 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_502_chunk (cost=0.08..89518.79 rows=8879000 width=0) (actual time=0.000..0.000 rows=7394064 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_642_chunk (cost=0.00..728.79 rows=8879 width=4) (actual time=0.005..3.207 rows=15094 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=111766.33..111766.34 rows=1 width=8) (actual time=6.511..6.511 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_234_chunk (cost=0.08..89558.83 rows=8883000 width=0) (actual time=0.000..0.000 rows=7993434 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_280_chunk (cost=0.00..728.83 rows=8883 width=4) (actual time=0.009..3.433 rows=15101 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=111878.92..111878.93 rows=1 width=8) (actual time=6.790..6.791 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_517_chunk (cost=0.08..89648.92 rows=8892000 width=0) (actual time=0.000..0.000 rows=7566117 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_657_chunk (cost=0.00..728.92 rows=8892 width=4) (actual time=0.016..3.455 rows=15117 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=111928.96..111928.97 rows=1 width=8) (actual time=6.661..6.663 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_233_chunk (cost=0.08..89688.96 rows=8896000 width=0) (actual time=0.000..0.001 rows=8079432 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_279_chunk (cost=0.00..728.96 rows=8896 width=4) (actual time=0.011..3.485 rows=15123 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=111966.49..111966.50 rows=1 width=8) (actual time=6.573..6.574 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_572_chunk (cost=0.08..89718.99 rows=8899000 width=0) (actual time=0.000..0.000 rows=7831919 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_706_chunk (cost=0.00..728.99 rows=8899 width=4) (actual time=0.005..3.388 rows=15129 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=112004.02..112004.03 rows=1 width=8) (actual time=6.429..6.430 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_505_chunk (cost=0.08..89749.02 rows=8902000 width=0) (actual time=0.000..0.000 rows=7546257 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_645_chunk (cost=0.00..729.02 rows=8902 width=4) (actual time=0.008..3.257 rows=15133 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=112984.80..112984.81 rows=1 width=8) (actual time=6.586..6.587 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_251_chunk (cost=0.08..90534.80 rows=8980000 width=0) (actual time=0.000..0.001 rows=7774842 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_294_chunk (cost=0.00..734.80 rows=8980 width=4) (actual time=0.006..3.325 rows=15266 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=112204.18..112204.19 rows=1 width=8) (actual time=6.282..6.283 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_238_chunk (cost=0.08..89909.18 rows=8918000 width=0) (actual time=0.000..0.000 rows=7913337 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_284_chunk (cost=0.00..729.18 rows=8918 width=4) (actual time=0.010..3.235 rows=15161 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=112254.22..112254.23 rows=1 width=8) (actual time=6.457..6.458 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_504_chunk (cost=0.08..89949.22 rows=8922000 width=0) (actual time=0.000..0.001 rows=7531882 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_644_chunk (cost=0.00..729.22 rows=8922 width=4) (actual time=0.007..3.266 rows=15168 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=115777.02..115777.03 rows=1 width=8) (actual time=6.716..6.716 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_491_chunk (cost=0.08..92772.02 rows=9202000 width=0) (actual time=0.000..0.000 rows=7723057 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_631_chunk (cost=0.00..752.02 rows=9202 width=4) (actual time=0.007..3.433 rows=15643 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=112366.81..112366.82 rows=1 width=8) (actual time=6.917..6.918 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_550_chunk (cost=0.08..90039.31 rows=8931000 width=0) (actual time=0.000..0.001 rows=7919143 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_687_chunk (cost=0.00..729.31 rows=8931 width=4) (actual time=0.011..3.558 rows=15182 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=112429.36..112429.37 rows=1 width=8) (actual time=6.887..6.888 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_510_chunk (cost=0.08..90089.36 rows=8936000 width=0) (actual time=0.000..0.000 rows=7546601 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_650_chunk (cost=0.00..729.36 rows=8936 width=4) (actual time=0.008..3.483 rows=15191 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=124255.76..124255.77 rows=1 width=8) (actual time=7.553..7.554 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_311_chunk (cost=0.08..99565.76 rows=9876000 width=0) (actual time=0.000..0.000 rows=8901665 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_355_chunk (cost=0.00..805.76 rows=9876 width=4) (actual time=0.013..3.904 rows=16789 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=112668.05..112668.06 rows=1 width=8) (actual time=6.466..6.467 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_249_chunk (cost=0.08..90280.55 rows=8955000 width=0) (actual time=0.000..0.000 rows=7801632 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_292_chunk (cost=0.00..730.55 rows=8955 width=4) (actual time=0.006..3.296 rows=15223 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=90008.54..90008.55 rows=1 width=8) (actual time=5.090..5.091 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_59_chunk (cost=0.08..72123.54 rows=7154000 width=0) (actual time=0.000..0.000 rows=6422386 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_85_chunk (cost=0.00..583.54 rows=7154 width=4) (actual time=0.006..2.661 rows=12162 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=115636.41..115636.42 rows=1 width=8) (actual time=6.637..6.638 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_498_chunk (cost=0.08..92658.91 rows=9191000 width=0) (actual time=0.000..0.000 rows=7920341 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_638_chunk (cost=0.00..748.91 rows=9191 width=4) (actual time=0.009..3.383 rows=15624 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=113156.94..113156.95 rows=1 width=8) (actual time=6.452..6.453 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_509_chunk (cost=0.08..90671.94 rows=8994000 width=0) (actual time=0.000..0.000 rows=7679132 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_649_chunk (cost=0.00..731.94 rows=8994 width=4) (actual time=0.007..3.207 rows=15289 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=101656.80..101656.81 rows=1 width=8) (actual time=5.803..5.803 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_542_chunk (cost=0.08..81456.80 rows=8080000 width=0) (actual time=0.000..0.001 rows=6124456 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_679_chunk (cost=0.00..656.80 rows=8080 width=4) (actual time=0.009..2.918 rows=13736 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=90383.84..90383.85 rows=1 width=8) (actual time=5.374..5.375 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_57_chunk (cost=0.08..72423.84 rows=7184000 width=0) (actual time=0.000..0.000 rows=6538316 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_83_chunk (cost=0.00..583.84 rows=7184 width=4) (actual time=0.006..2.780 rows=12213 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=113042.35..113042.36 rows=1 width=8) (actual time=6.776..6.777 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_595_chunk (cost=0.08..90579.85 rows=8985000 width=0) (actual time=0.000..0.000 rows=7970322 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_734_chunk (cost=0.00..729.85 rows=8985 width=4) (actual time=0.004..3.512 rows=15275 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=116615.19..116615.20 rows=1 width=8) (actual time=6.611..6.612 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_492_chunk (cost=0.08..93442.69 rows=9269000 width=0) (actual time=0.000..0.000 rows=7992984 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_632_chunk (cost=0.00..752.69 rows=9269 width=4) (actual time=0.009..3.341 rows=15757 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=113129.92..113129.93 rows=1 width=8) (actual time=6.363..6.364 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_540_chunk (cost=0.08..90649.92 rows=8992000 width=0) (actual time=0.000..0.000 rows=8101598 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_677_chunk (cost=0.00..729.92 rows=8992 width=4) (actual time=0.005..3.244 rows=15286 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=113330.08..113330.09 rows=1 width=8) (actual time=3.372..3.373 rows=1 loops=2) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_596_chunk (cost=0.08..90810.08 rows=9008000 width=0) (actual time=0.000..0.000 rows=3978537 loops=2) | |
| -> Parallel Seq Scan on compress_hyper_2_735_chunk (cost=0.00..730.08 rows=9008 width=4) (actual time=0.008..1.759 rows=7657 loops=2) | |
| -> Custom Scan (VectorAgg) (cost=113455.18..113455.19 rows=1 width=8) (actual time=3.231..3.231 rows=1 loops=2) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_593_chunk (cost=0.08..90910.18 rows=9018000 width=0) (actual time=0.000..0.000 rows=3967873 loops=2) | |
| -> Parallel Seq Scan on compress_hyper_2_732_chunk (cost=0.00..730.18 rows=9018 width=4) (actual time=0.007..1.704 rows=7665 loops=2) | |
| -> Custom Scan (VectorAgg) (cost=113505.22..113505.23 rows=1 width=8) (actual time=1.293..1.294 rows=1 loops=5) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_598_chunk (cost=0.08..90950.22 rows=9022000 width=0) (actual time=0.000..0.000 rows=1593842 loops=5) | |
| -> Parallel Seq Scan on compress_hyper_2_737_chunk (cost=0.00..730.22 rows=9022 width=4) (actual time=0.005..0.661 rows=3068 loops=5) | |
| -> Custom Scan (VectorAgg) (cost=83473.85..83473.86 rows=1 width=8) (actual time=2.426..2.427 rows=1 loops=2) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_60_chunk (cost=0.08..66886.35 rows=6635000 width=0) (actual time=0.000..0.000 rows=2579380 loops=2) | |
| -> Parallel Seq Scan on compress_hyper_2_86_chunk (cost=0.00..536.35 rows=6635 width=4) (actual time=0.007..1.230 rows=5640 loops=2) | |
| -> Custom Scan (VectorAgg) (cost=113969.09..113969.10 rows=1 width=8) (actual time=1.366..1.367 rows=1 loops=4) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_252_chunk (cost=0.08..91321.59 rows=9059000 width=0) (actual time=0.000..0.000 rows=1963581 loops=4) | |
| -> Parallel Seq Scan on compress_hyper_2_295_chunk (cost=0.00..731.59 rows=9059 width=4) (actual time=0.005..0.676 rows=3850 loops=4) | |
| -> Custom Scan (VectorAgg) (cost=113868.01..113868.02 rows=1 width=8) (actual time=1.789..1.790 rows=1 loops=2) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_752_chunk (cost=0.08..91240.51 rows=9051000 width=0) (actual time=0.000..0.000 rows=3941187 loops=2) | |
| -> Parallel Seq Scan on compress_hyper_2_791_chunk (cost=0.00..730.51 rows=9051 width=4) (actual time=0.006..0.779 rows=7694 loops=2) | |
| -> Custom Scan (VectorAgg) (cost=113868.01..113868.02 rows=1 width=8) (actual time=3.268..3.269 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_757_chunk (cost=0.08..91240.51 rows=9051000 width=0) (actual time=0.000..0.000 rows=7902273 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_796_chunk (cost=0.00..730.51 rows=9051 width=4) (actual time=0.002..1.347 rows=15387 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=83546.91..83546.92 rows=1 width=8) (actual time=2.446..2.447 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_56_chunk (cost=0.08..66944.41 rows=6641000 width=0) (actual time=0.000..0.000 rows=5233996 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_82_chunk (cost=0.00..534.41 rows=6641 width=4) (actual time=0.002..0.991 rows=11290 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=91647.35..91647.36 rows=1 width=8) (actual time=2.652..2.653 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_58_chunk (cost=0.08..73434.85 rows=7285000 width=0) (actual time=0.000..0.000 rows=6748708 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_84_chunk (cost=0.00..584.85 rows=7285 width=4) (actual time=0.002..1.080 rows=12384 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=114793.75..114793.76 rows=1 width=8) (actual time=3.321..3.322 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_577_chunk (cost=0.08..91981.25 rows=9125000 width=0) (actual time=0.000..0.000 rows=8224626 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_709_chunk (cost=0.00..731.25 rows=9125 width=4) (actual time=0.002..1.369 rows=15513 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=115183.56..115183.57 rows=1 width=8) (actual time=3.306..3.307 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_758_chunk (cost=0.08..92293.56 rows=9156000 width=0) (actual time=0.000..0.000 rows=8055889 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_797_chunk (cost=0.00..733.56 rows=9156 width=4) (actual time=0.002..1.357 rows=15566 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=104087.74..104087.75 rows=1 width=8) (actual time=2.941..2.942 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_601_chunk (cost=0.08..83402.74 rows=8274000 width=0) (actual time=0.000..0.001 rows=6510548 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_740_chunk (cost=0.00..662.74 rows=8274 width=4) (actual time=0.002..1.201 rows=14066 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=118290.53..118290.54 rows=1 width=8) (actual time=3.453..3.454 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_497_chunk (cost=0.08..94783.03 rows=9403000 width=0) (actual time=0.000..0.001 rows=8338829 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_637_chunk (cost=0.00..753.03 rows=9403 width=4) (actual time=0.002..1.411 rows=15985 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=105383.27..105383.28 rows=1 width=8) (actual time=3.116..3.117 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_743_chunk (cost=0.08..84440.77 rows=8377000 width=0) (actual time=0.000..0.000 rows=6576097 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_782_chunk (cost=0.00..670.77 rows=8377 width=4) (actual time=0.002..1.332 rows=14241 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=114906.34..114906.35 rows=1 width=8) (actual time=3.334..3.335 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_599_chunk (cost=0.08..92071.34 rows=9134000 width=0) (actual time=0.000..0.000 rows=8192386 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_738_chunk (cost=0.00..731.34 rows=9134 width=4) (actual time=0.002..1.386 rows=15528 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=115006.42..115006.43 rows=1 width=8) (actual time=3.427..3.428 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_744_chunk (cost=0.08..92151.42 rows=9142000 width=0) (actual time=0.000..0.001 rows=8175244 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_783_chunk (cost=0.00..731.42 rows=9142 width=4) (actual time=0.003..1.237 rows=15542 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=115031.44..115031.45 rows=1 width=8) (actual time=2.944..2.945 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_746_chunk (cost=0.08..92171.44 rows=9144000 width=0) (actual time=0.000..0.001 rows=8124927 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_785_chunk (cost=0.00..731.44 rows=9144 width=4) (actual time=0.002..1.197 rows=15545 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=115093.99..115094.00 rows=1 width=8) (actual time=2.953..2.954 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_594_chunk (cost=0.08..92221.49 rows=9149000 width=0) (actual time=0.000..0.001 rows=8271808 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_733_chunk (cost=0.00..731.49 rows=9149 width=4) (actual time=0.002..1.186 rows=15554 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=115419.25..115419.26 rows=1 width=8) (actual time=2.929..2.929 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_751_chunk (cost=0.08..92481.75 rows=9175000 width=0) (actual time=0.000..0.000 rows=8113082 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_790_chunk (cost=0.00..731.75 rows=9175 width=4) (actual time=0.002..1.186 rows=15597 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=115581.88..115581.89 rows=1 width=8) (actual time=2.940..2.941 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_753_chunk (cost=0.08..92611.88 rows=9188000 width=0) (actual time=0.000..0.000 rows=8139836 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_792_chunk (cost=0.00..731.88 rows=9188 width=4) (actual time=0.002..1.192 rows=15620 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=115782.04..115782.05 rows=1 width=8) (actual time=2.942..2.943 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_745_chunk (cost=0.08..92772.04 rows=9204000 width=0) (actual time=0.000..0.001 rows=8237611 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_784_chunk (cost=0.00..732.04 rows=9204 width=4) (actual time=0.002..1.190 rows=15646 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=115919.65..115919.66 rows=1 width=8) (actual time=3.002..3.003 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_760_chunk (cost=0.08..92882.15 rows=9215000 width=0) (actual time=0.000..0.001 rows=8119343 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_799_chunk (cost=0.00..732.15 rows=9215 width=4) (actual time=0.002..1.210 rows=15665 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=106220.44..106220.45 rows=1 width=8) (actual time=2.700..2.701 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_741_chunk (cost=0.08..85110.44 rows=8444000 width=0) (actual time=0.000..0.000 rows=6749856 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_780_chunk (cost=0.00..670.44 rows=8444 width=4) (actual time=0.002..1.096 rows=14354 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=118168.94..118168.95 rows=1 width=8) (actual time=3.027..3.028 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_759_chunk (cost=0.08..94683.94 rows=9394000 width=0) (actual time=0.000..0.001 rows=8473732 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_798_chunk (cost=0.00..743.94 rows=9394 width=4) (actual time=0.002..1.221 rows=15970 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=106193.42..106193.43 rows=1 width=8) (actual time=2.748..2.749 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_742_chunk (cost=0.08..85088.42 rows=8442000 width=0) (actual time=0.000..0.001 rows=6745630 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_781_chunk (cost=0.00..668.42 rows=8442 width=4) (actual time=0.002..1.108 rows=14352 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=117991.80..117991.81 rows=1 width=8) (actual time=3.001..3.002 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_764_chunk (cost=0.08..94541.80 rows=9380000 width=0) (actual time=0.000..0.001 rows=8379185 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_803_chunk (cost=0.00..741.80 rows=9380 width=4) (actual time=0.002..1.206 rows=15946 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=116745.31..116745.32 rows=1 width=8) (actual time=2.983..2.984 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_762_chunk (cost=0.08..93542.81 rows=9281000 width=0) (actual time=0.000..0.000 rows=8253370 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_801_chunk (cost=0.00..732.81 rows=9281 width=4) (actual time=0.002..1.199 rows=15778 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=117120.61..117120.62 rows=1 width=8) (actual time=2.979..2.980 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_748_chunk (cost=0.08..93843.11 rows=9311000 width=0) (actual time=0.000..0.000 rows=8433496 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_787_chunk (cost=0.00..733.11 rows=9311 width=4) (actual time=0.002..1.215 rows=15828 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=119169.74..119169.75 rows=1 width=8) (actual time=3.058..3.059 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_768_chunk (cost=0.08..95484.74 rows=9474000 width=0) (actual time=0.000..0.001 rows=8517347 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_807_chunk (cost=0.00..744.74 rows=9474 width=4) (actual time=0.002..1.236 rows=16106 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=117345.79..117345.80 rows=1 width=8) (actual time=2.981..2.982 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_755_chunk (cost=0.08..94023.29 rows=9329000 width=0) (actual time=0.000..0.001 rows=8458346 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_794_chunk (cost=0.00..733.29 rows=9329 width=4) (actual time=0.002..1.223 rows=15859 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=117495.91..117495.92 rows=1 width=8) (actual time=3.007..3.008 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_763_chunk (cost=0.08..94143.41 rows=9341000 width=0) (actual time=0.000..0.000 rows=8348181 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_802_chunk (cost=0.00..733.41 rows=9341 width=4) (actual time=0.002..1.214 rows=15880 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=94249.43..94249.44 rows=1 width=8) (actual time=2.387..2.388 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_140_chunk (cost=0.08..75516.93 rows=7493000 width=0) (actual time=0.000..0.001 rows=6823821 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_173_chunk (cost=0.00..586.93 rows=7493 width=4) (actual time=0.002..0.955 rows=12738 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=94449.59..94449.60 rows=1 width=8) (actual time=2.439..2.440 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_141_chunk (cost=0.08..75677.09 rows=7509000 width=0) (actual time=0.000..0.001 rows=6814038 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_174_chunk (cost=0.00..587.09 rows=7509 width=4) (actual time=0.002..0.965 rows=12766 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=94599.71..94599.72 rows=1 width=8) (actual time=2.439..2.440 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_129_chunk (cost=0.08..75797.21 rows=7521000 width=0) (actual time=0.000..0.001 rows=7117226 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_162_chunk (cost=0.00..587.21 rows=7521 width=4) (actual time=0.002..0.983 rows=12785 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=94699.79..94699.80 rows=1 width=8) (actual time=2.409..2.410 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_134_chunk (cost=0.08..75877.29 rows=7529000 width=0) (actual time=0.000..0.001 rows=7110264 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_167_chunk (cost=0.00..587.29 rows=7529 width=4) (actual time=0.002..0.983 rows=12799 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=94737.32..94737.33 rows=1 width=8) (actual time=2.404..2.405 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_128_chunk (cost=0.08..75907.32 rows=7532000 width=0) (actual time=0.000..0.000 rows=7172046 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_161_chunk (cost=0.00..587.32 rows=7532 width=4) (actual time=0.002..0.973 rows=12804 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=118584.28..118584.29 rows=1 width=8) (actual time=2.982..2.983 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_750_chunk (cost=0.08..95014.28 rows=9428000 width=0) (actual time=0.000..0.000 rows=8665894 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_789_chunk (cost=0.00..734.28 rows=9428 width=4) (actual time=0.002..1.211 rows=16028 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=118609.30..118609.31 rows=1 width=8) (actual time=2.989..2.990 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_749_chunk (cost=0.08..95034.30 rows=9430000 width=0) (actual time=0.000..0.000 rows=8655962 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_788_chunk (cost=0.00..734.30 rows=9430 width=4) (actual time=0.002..1.213 rows=16031 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=120105.99..120106.00 rows=1 width=8) (actual time=3.045..3.046 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_769_chunk (cost=0.08..96233.49 rows=9549000 width=0) (actual time=0.000..0.001 rows=8637828 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_808_chunk (cost=0.00..743.49 rows=9549 width=4) (actual time=0.002..1.234 rows=16233 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=95000.03..95000.04 rows=1 width=8) (actual time=2.398..2.399 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_136_chunk (cost=0.08..76117.53 rows=7553000 width=0) (actual time=0.000..0.001 rows=7145112 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_169_chunk (cost=0.00..587.53 rows=7553 width=4) (actual time=0.002..0.980 rows=12840 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=107036.10..107036.11 rows=1 width=8) (actual time=2.709..2.710 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_222_chunk (cost=0.08..85761.10 rows=8510000 width=0) (actual time=0.000..0.000 rows=7774573 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_268_chunk (cost=0.00..661.10 rows=8510 width=4) (actual time=0.002..1.091 rows=14467 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=95162.66..95162.67 rows=1 width=8) (actual time=2.422..2.423 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_142_chunk (cost=0.08..76247.66 rows=7566000 width=0) (actual time=0.000..0.001 rows=6968399 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_175_chunk (cost=0.00..587.66 rows=7566 width=4) (actual time=0.002..0.979 rows=12862 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=119172.25..119172.26 rows=1 width=8) (actual time=3.002..3.003 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_766_chunk (cost=0.08..95484.75 rows=9475000 width=0) (actual time=0.000..0.001 rows=8605822 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_805_chunk (cost=0.00..734.75 rows=9475 width=4) (actual time=0.002..1.217 rows=16107 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=99424.55..99424.56 rows=1 width=8) (actual time=2.516..2.517 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_221_chunk (cost=0.08..79662.05 rows=7905000 width=0) (actual time=0.000..0.000 rows=6457981 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_267_chunk (cost=0.00..612.05 rows=7905 width=4) (actual time=0.002..1.019 rows=13438 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=95512.94..95512.95 rows=1 width=8) (actual time=2.431..2.432 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_138_chunk (cost=0.08..76527.94 rows=7594000 width=0) (actual time=0.000..0.000 rows=7156011 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_171_chunk (cost=0.00..587.94 rows=7594 width=4) (actual time=0.002..0.983 rows=12909 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=95613.02..95613.03 rows=1 width=8) (actual time=2.452..2.453 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_139_chunk (cost=0.08..76608.02 rows=7602000 width=0) (actual time=0.000..0.001 rows=7126520 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_172_chunk (cost=0.00..588.02 rows=7602 width=4) (actual time=0.002..0.990 rows=12923 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=107674.11..107674.12 rows=1 width=8) (actual time=2.731..2.732 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_224_chunk (cost=0.08..86271.61 rows=8561000 width=0) (actual time=0.000..0.001 rows=7673039 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_271_chunk (cost=0.00..661.61 rows=8561 width=4) (actual time=0.002..1.118 rows=14554 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=111974.53..111974.54 rows=1 width=8) (actual time=2.874..2.875 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_226_chunk (cost=0.08..89717.03 rows=8903000 width=0) (actual time=0.000..0.001 rows=8270725 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_273_chunk (cost=0.00..687.03 rows=8903 width=4) (actual time=0.002..1.147 rows=15135 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=107886.78..107886.79 rows=1 width=8) (actual time=2.701..2.702 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_223_chunk (cost=0.08..86441.78 rows=8578000 width=0) (actual time=0.000..0.001 rows=7864411 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_270_chunk (cost=0.00..661.78 rows=8578 width=4) (actual time=0.002..1.096 rows=14582 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=87736.76..87736.77 rows=1 width=8) (actual time=2.261..2.262 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_126_chunk (cost=0.08..70296.76 rows=6976000 width=0) (actual time=0.000..0.001 rows=5891225 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_159_chunk (cost=0.00..536.76 rows=6976 width=4) (actual time=0.002..0.903 rows=11859 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=96276.05..96276.06 rows=1 width=8) (actual time=2.424..2.425 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_130_chunk (cost=0.08..77138.55 rows=7655000 width=0) (actual time=0.000..0.000 rows=7418138 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_163_chunk (cost=0.00..588.55 rows=7655 width=4) (actual time=0.002..0.981 rows=13014 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=96651.35..96651.36 rows=1 width=8) (actual time=2.442..2.443 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_143_chunk (cost=0.08..77438.85 rows=7685000 width=0) (actual time=0.000..0.001 rows=7140483 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_176_chunk (cost=0.00..588.85 rows=7685 width=4) (actual time=0.002..0.983 rows=13065 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=96701.39..96701.40 rows=1 width=8) (actual time=2.437..2.438 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_137_chunk (cost=0.08..77478.89 rows=7689000 width=0) (actual time=0.000..0.001 rows=7319049 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_170_chunk (cost=0.00..588.89 rows=7689 width=4) (actual time=0.002..0.990 rows=13072 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109038.70..109038.71 rows=1 width=8) (actual time=2.768..2.769 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_225_chunk (cost=0.08..87363.70 rows=8670000 width=0) (actual time=0.000..0.001 rows=7959123 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_272_chunk (cost=0.00..663.70 rows=8670 width=4) (actual time=0.002..1.122 rows=14739 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=96901.55..96901.56 rows=1 width=8) (actual time=2.482..2.483 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_131_chunk (cost=0.08..77639.05 rows=7705000 width=0) (actual time=0.000..0.001 rows=7478907 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_164_chunk (cost=0.00..589.05 rows=7705 width=4) (actual time=0.002..1.000 rows=13099 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=88851.15..88851.16 rows=1 width=8) (actual time=2.244..2.245 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_135_chunk (cost=0.08..71188.65 rows=7065000 width=0) (actual time=0.000..0.001 rows=5992380 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_168_chunk (cost=0.00..538.65 rows=7065 width=4) (actual time=0.002..0.900 rows=12011 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=97289.36..97289.37 rows=1 width=8) (actual time=2.499..2.500 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_78_chunk (cost=0.08..77949.36 rows=7736000 width=0) (actual time=0.000..0.000 rows=7650316 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_104_chunk (cost=0.00..589.36 rows=7736 width=4) (actual time=0.002..1.022 rows=13152 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=109638.18..109638.19 rows=1 width=8) (actual time=2.733..2.734 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_220_chunk (cost=0.08..87843.18 rows=8718000 width=0) (actual time=0.000..0.001 rows=8343724 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_266_chunk (cost=0.00..663.18 rows=8718 width=4) (actual time=0.002..1.129 rows=14821 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=97639.64..97639.65 rows=1 width=8) (actual time=2.467..2.468 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_145_chunk (cost=0.08..78229.64 rows=7764000 width=0) (actual time=0.000..0.001 rows=7315383 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_178_chunk (cost=0.00..589.64 rows=7764 width=4) (actual time=0.001..1.005 rows=13199 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=88320.73..88320.74 rows=1 width=8) (actual time=2.372..2.373 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_151_chunk (cost=0.08..70763.23 rows=7023000 width=0) (actual time=0.000..0.001 rows=5502689 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_184_chunk (cost=0.00..533.23 rows=7023 width=4) (actual time=0.002..0.956 rows=11939 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=90118.66..90118.67 rows=1 width=8) (actual time=2.583..2.585 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_55_chunk (cost=0.08..72203.66 rows=7166000 width=0) (actual time=0.000..0.001 rows=6529550 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_81_chunk (cost=0.00..543.66 rows=7166 width=4) (actual time=0.002..1.057 rows=12183 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110338.74..110338.75 rows=1 width=8) (actual time=3.058..3.059 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_219_chunk (cost=0.08..88403.74 rows=8774000 width=0) (actual time=0.000..0.000 rows=8475116 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_265_chunk (cost=0.00..663.74 rows=8774 width=4) (actual time=0.002..1.278 rows=14915 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=87132.79..87132.80 rows=1 width=8) (actual time=2.487..2.488 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_74_chunk (cost=0.08..69810.29 rows=6929000 width=0) (actual time=0.000..0.001 rows=5910390 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_100_chunk (cost=0.00..520.29 rows=6929 width=4) (actual time=0.002..1.016 rows=11780 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=99140.84..99140.85 rows=1 width=8) (actual time=2.789..2.790 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_144_chunk (cost=0.07..79430.84 rows=7884000 width=0) (actual time=0.000..0.001 rows=7528257 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_177_chunk (cost=0.00..590.84 rows=7884 width=4) (actual time=0.002..1.158 rows=13403 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=99478.61..99478.62 rows=1 width=8) (actual time=2.810..2.811 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_146_chunk (cost=0.07..79701.11 rows=7911000 width=0) (actual time=0.000..0.001 rows=7527902 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_179_chunk (cost=0.00..591.11 rows=7911 width=4) (actual time=0.003..1.156 rows=13448 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=93615.95..93615.96 rows=1 width=8) (actual time=2.629..2.630 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_132_chunk (cost=0.07..75003.45 rows=7445000 width=0) (actual time=0.000..0.001 rows=6962181 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_165_chunk (cost=0.00..553.45 rows=7445 width=4) (actual time=0.002..1.085 rows=12657 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=100229.21..100229.22 rows=1 width=8) (actual time=2.804..2.805 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_214_chunk (cost=0.07..80301.71 rows=7971000 width=0) (actual time=0.000..0.001 rows=7144143 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_260_chunk (cost=0.00..591.71 rows=7971 width=4) (actual time=0.002..1.166 rows=13550 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=87767.80..87767.81 rows=1 width=8) (actual time=2.517..2.518 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_68_chunk (cost=0.07..70317.80 rows=6980000 width=0) (actual time=0.000..0.001 rows=6090307 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_94_chunk (cost=0.00..517.80 rows=6980 width=4) (actual time=0.002..1.045 rows=11866 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=125539.84..125539.85 rows=1 width=8) (actual time=3.504..3.505 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_754_chunk (cost=0.07..100579.84 rows=9984000 width=0) (actual time=0.000..0.001 rows=9830250 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_793_chunk (cost=0.00..739.84 rows=9984 width=4) (actual time=0.002..1.470 rows=16972 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=93978.74..93978.75 rows=1 width=8) (actual time=2.713..2.714 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_133_chunk (cost=0.07..75293.74 rows=7474000 width=0) (actual time=0.000..0.001 rows=6960439 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_166_chunk (cost=0.00..553.74 rows=7474 width=4) (actual time=0.002..1.107 rows=12706 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=100779.65..100779.66 rows=1 width=8) (actual time=2.779..2.780 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_148_chunk (cost=0.07..80742.15 rows=8015000 width=0) (actual time=0.000..0.001 rows=7694575 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_181_chunk (cost=0.00..592.15 rows=8015 width=4) (actual time=0.002..1.159 rows=13625 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=101267.54..101267.55 rows=1 width=8) (actual time=2.884..2.885 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_149_chunk (cost=0.07..81132.54 rows=8054000 width=0) (actual time=0.000..0.001 rows=7769878 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_182_chunk (cost=0.00..592.54 rows=8054 width=4) (actual time=0.002..1.209 rows=13692 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=94964.03..94964.04 rows=1 width=8) (actual time=2.721..2.721 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_71_chunk (cost=0.07..76081.53 rows=7553000 width=0) (actual time=0.000..0.000 rows=7389899 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_97_chunk (cost=0.00..551.53 rows=7553 width=4) (actual time=0.002..1.119 rows=12840 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=93731.05..93731.06 rows=1 width=8) (actual time=2.652..2.653 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_61_chunk (cost=0.07..75093.55 rows=7455000 width=0) (actual time=0.000..0.001 rows=7152037 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_87_chunk (cost=0.00..543.55 rows=7455 width=4) (actual time=0.002..1.086 rows=12673 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=102856.31..102856.32 rows=1 width=8) (actual time=2.919..2.920 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_150_chunk (cost=0.07..82403.81 rows=8181000 width=0) (actual time=0.000..0.001 rows=7968138 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_183_chunk (cost=0.00..593.81 rows=8181 width=4) (actual time=0.002..1.213 rows=13907 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=96456.72..96456.73 rows=1 width=8) (actual time=2.675..2.676 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_210_chunk (cost=0.07..77276.72 rows=7672000 width=0) (actual time=0.000..0.000 rows=6730312 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_256_chunk (cost=0.00..556.72 rows=7672 width=4) (actual time=0.002..1.116 rows=13043 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=96506.76..96506.77 rows=1 width=8) (actual time=2.703..2.704 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_127_chunk (cost=0.07..77316.76 rows=7676000 width=0) (actual time=0.000..0.001 rows=7483282 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_160_chunk (cost=0.00..556.76 rows=7676 width=4) (actual time=0.002..1.115 rows=13050 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=96065.91..96065.92 rows=1 width=8) (actual time=2.729..2.730 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_73_chunk (cost=0.07..76963.41 rows=7641000 width=0) (actual time=0.000..0.001 rows=7513932 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_99_chunk (cost=0.00..553.41 rows=7641 width=4) (actual time=0.002..1.126 rows=12990 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=95826.22..95826.23 rows=1 width=8) (actual time=2.808..2.809 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_75_chunk (cost=0.07..76771.22 rows=7622000 width=0) (actual time=0.000..0.001 rows=7501603 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_101_chunk (cost=0.00..551.22 rows=7622 width=4) (actual time=0.002..1.127 rows=12957 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=95549.00..95549.01 rows=1 width=8) (actual time=2.752..2.753 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_70_chunk (cost=0.07..76549.00 rows=7600000 width=0) (actual time=0.000..0.001 rows=7472927 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_96_chunk (cost=0.00..549.00 rows=7600 width=4) (actual time=0.002..1.136 rows=12920 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=95748.16..95748.17 rows=1 width=8) (actual time=2.727..2.728 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_72_chunk (cost=0.07..76708.16 rows=7616000 width=0) (actual time=0.000..0.001 rows=7527049 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_98_chunk (cost=0.00..548.16 rows=7616 width=4) (actual time=0.002..1.126 rows=12948 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=95722.14..95722.15 rows=1 width=8) (actual time=2.664..2.665 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_67_chunk (cost=0.07..76687.14 rows=7614000 width=0) (actual time=0.000..0.001 rows=7535005 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_93_chunk (cost=0.00..547.14 rows=7614 width=4) (actual time=0.002..1.095 rows=12943 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=95193.72..95193.73 rows=1 width=8) (actual time=2.686..2.687 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_69_chunk (cost=0.07..76263.72 rows=7572000 width=0) (actual time=0.000..0.001 rows=7411801 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_95_chunk (cost=0.00..543.72 rows=7572 width=4) (actual time=0.002..1.111 rows=12872 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=104782.85..104782.86 rows=1 width=8) (actual time=2.906..2.907 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_209_chunk (cost=0.07..83945.35 rows=8335000 width=0) (actual time=0.000..0.001 rows=8214379 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_254_chunk (cost=0.00..595.35 rows=8335 width=4) (actual time=0.002..1.213 rows=14170 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110602.98..110602.99 rows=1 width=8) (actual time=3.110..3.111 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_218_chunk (cost=0.07..88607.98 rows=8798000 width=0) (actual time=0.000..0.000 rows=8570592 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_264_chunk (cost=0.00..627.98 rows=8798 width=4) (actual time=0.002..1.301 rows=14957 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=99170.39..99170.40 rows=1 width=8) (actual time=2.795..2.797 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_76_chunk (cost=0.07..79447.89 rows=7889000 width=0) (actual time=0.000..0.001 rows=8013299 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_102_chunk (cost=0.00..557.89 rows=7889 width=4) (actual time=0.002..1.159 rows=13412 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=96693.92..96693.93 rows=1 width=8) (actual time=2.543..2.544 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_66_chunk (cost=0.07..77463.92 rows=7692000 width=0) (actual time=0.000..0.001 rows=7784486 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_92_chunk (cost=0.00..543.92 rows=7692 width=4) (actual time=0.002..1.017 rows=13077 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=97999.96..97999.97 rows=1 width=8) (actual time=2.460..2.462 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_62_chunk (cost=0.07..78509.96 rows=7796000 width=0) (actual time=0.000..0.001 rows=7906105 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_88_chunk (cost=0.00..549.96 rows=7796 width=4) (actual time=0.002..1.002 rows=13253 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=99105.84..99105.85 rows=1 width=8) (actual time=2.597..2.598 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_77_chunk (cost=0.07..79395.84 rows=7884000 width=0) (actual time=0.000..0.001 rows=7974354 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_103_chunk (cost=0.00..555.84 rows=7884 width=4) (actual time=0.004..1.059 rows=13402 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=97203.83..97203.84 rows=1 width=8) (actual time=2.620..2.622 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_63_chunk (cost=0.07..77871.33 rows=7733000 width=0) (actual time=0.000..0.001 rows=7861476 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_89_chunk (cost=0.00..541.33 rows=7733 width=4) (actual time=0.003..1.076 rows=13146 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=108210.59..108210.60 rows=1 width=8) (actual time=2.803..2.804 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_211_chunk (cost=0.07..86688.09 rows=8609000 width=0) (actual time=0.000..0.001 rows=8680691 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_257_chunk (cost=0.00..598.09 rows=8609 width=4) (actual time=0.003..1.167 rows=14636 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=108923.66..108923.67 rows=1 width=8) (actual time=2.769..2.770 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_212_chunk (cost=0.07..87258.66 rows=8666000 width=0) (actual time=0.000..0.000 rows=8740820 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_258_chunk (cost=0.00..598.66 rows=8666 width=4) (actual time=0.002..1.144 rows=14733 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=113771.52..113771.53 rows=1 width=8) (actual time=2.865..2.866 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_217_chunk (cost=0.07..91141.52 rows=9052000 width=0) (actual time=0.000..0.001 rows=9259800 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_263_chunk (cost=0.00..621.52 rows=9052 width=4) (actual time=0.002..1.191 rows=15388 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=112083.18..112083.19 rows=1 width=8) (actual time=2.732..2.733 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_215_chunk (cost=0.07..89788.18 rows=8918000 width=0) (actual time=0.000..0.001 rows=9115481 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_261_chunk (cost=0.00..608.18 rows=8918 width=4) (actual time=0.001..1.103 rows=15160 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=110862.71..110862.72 rows=1 width=8) (actual time=2.075..2.076 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_213_chunk (cost=0.07..88810.21 rows=8821000 width=0) (actual time=0.000..0.001 rows=8920852 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_259_chunk (cost=0.00..600.21 rows=8821 width=4) (actual time=0.002..0.831 rows=14996 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=100216.74..100216.75 rows=1 width=8) (actual time=1.897..1.897 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_65_chunk (cost=0.07..80281.74 rows=7974000 width=0) (actual time=0.000..0.000 rows=8370001 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_91_chunk (cost=0.00..541.74 rows=7974 width=4) (actual time=0.002..0.729 rows=13556 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=112041.65..112041.66 rows=1 width=8) (actual time=2.200..2.201 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_216_chunk (cost=0.07..89754.15 rows=8915000 width=0) (actual time=0.000..0.001 rows=9048610 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_262_chunk (cost=0.00..604.15 rows=8915 width=4) (actual time=0.001..0.860 rows=15155 loops=1) | |
| -> Custom Scan (VectorAgg) (cost=99333.04..99333.05 rows=1 width=8) (actual time=1.945..1.946 rows=1 loops=1) | |
| -> Custom Scan (DecompressChunk) on _hyper_1_64_chunk (cost=0.07..79573.04 rows=7904000 width=0) (actual time=0.000..0.000 rows=8378805 loops=1) | |
| -> Parallel Seq Scan on compress_hyper_2_90_chunk (cost=0.00..533.04 rows=7904 width=4) (actual time=0.003..0.778 rows=13436 loops=1) | |
| Planning Time: 78.171 ms | |
| Execution Time: 304.850 ms | |
| (883 rows) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| trade_gym_dev=# select count(*) from candles_1m; | |
| count | |
| ------------ | |
| 2169557062 | |
| (1 row) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| trade_gym_dev=# \d candles_1m | |
| Table "public.candles_1m" | |
| Column | Type | Collation | Nullable | Default | |
| --------------+--------------------------------+-----------+----------+--------- | |
| timestamp | timestamp(0) without time zone | | not null | | |
| symbol | text | | not null | | |
| open | numeric | | | | |
| high | numeric | | | | |
| low | numeric | | | | |
| close | numeric | | | | |
| volume | integer | | | | |
| transactions | integer | | | | |
| Indexes: | |
| "candles_1m_pkey" PRIMARY KEY, btree ("timestamp", symbol) | |
| "candles_1m_date_idx" btree (("timestamp"::date)) | |
| "candles_1m_symbol_index" btree (symbol) | |
| "candles_1m_time_idx" btree (("timestamp"::time without time zone)) | |
| "candles_1m_timestamp_idx" btree ("timestamp" DESC) | |
| Triggers: | |
| log_candle_activity_trigger AFTER INSERT ON candles_1m FOR EACH ROW EXECUTE FUNCTION log_candle_activity() | |
| ts_cagg_invalidation_trigger AFTER INSERT OR DELETE OR UPDATE ON candles_1m FOR EACH ROW EXECUTE FUNCTION _timescaledb_functions.continuous_agg_invalidation_trigger('1') | |
| ts_insert_blocker BEFORE INSERT ON candles_1m FOR EACH ROW EXECUTE FUNCTION _timescaledb_functions.insert_blocker() | |
| Number of child tables: 292 (Use \d+ to list them.) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment