QUERY PLAN ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Limit (cost=26118169.87..26118172.38 rows=1001 width=670) (actual time=634272.267..634345.383 rows=1001 loops=1) -> Sort (cost=26118169.87..26122620.69 rows=1780327 width=670) (actual time=631443.239..631515.378 rows=1001 loops=1) Sort Key: a_29.auditid DESC Sort Method: quicksort Memory: 1502kB -> Gather (cost=93571.10..26020543.63 rows=1780327 width=670) (actual time=6.291..631461.417 rows=1487 loops=1) Workers Planned: 4 Workers Launched: 0 -> Parallel Append (cost=92571.10..25841510.93 rows=455082 width=671) (actual time=0.068..631448.134 rows=1487 loops=1) -> Custom Scan (DecompressChunk) on _hyper_16_6903_chunk a_29 (cost=96806.88..96806.88 rows=1000 width=1026) (actual time=2067.697..2069.048 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7033_chunk (cost=0.00..96806.88 rows=1 width=357) (actual time=2066.234..2066.865 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 814902 -> Custom Scan (DecompressChunk) on _hyper_16_6909_chunk a_25 (cost=93156.24..93156.24 rows=1000 width=1026) (actual time=1776.915..1778.273 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7039_chunk (cost=0.00..93156.24 rows=1 width=357) (actual time=1776.045..1776.636 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 796332 -> Custom Scan (DecompressChunk) on _hyper_16_6905_chunk a_28 (cost=92902.76..92902.76 rows=1000 width=1026) (actual time=1823.113..1823.691 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7035_chunk (cost=0.00..92902.76 rows=1 width=357) (actual time=1821.275..1821.275 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 768735 -> Custom Scan (DecompressChunk) on _hyper_16_6894_chunk a_36 (cost=92571.10..92571.10 rows=1000 width=1026) (actual time=1828.497..1829.757 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7024_chunk (cost=0.00..92571.10 rows=1 width=357) (actual time=1827.104..1827.104 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 785627 -> Custom Scan (DecompressChunk) on _hyper_16_6886_chunk a_39 (cost=91763.00..91763.00 rows=1000 width=1026) (actual time=1892.264..1894.172 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7016_chunk (cost=0.00..91763.00 rows=1 width=357) (actual time=1891.351..1891.351 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 768799 -> Custom Scan (DecompressChunk) on _hyper_16_6896_chunk a_35 (cost=91013.72..91013.72 rows=1000 width=1026) (actual time=1854.701..1855.149 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7026_chunk (cost=0.00..91013.72 rows=1 width=357) (actual time=1853.186..1853.186 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 771392 -> Custom Scan (DecompressChunk) on _hyper_16_6889_chunk a_38 (cost=90423.71..90423.71 rows=1000 width=1026) (actual time=1975.508..1976.008 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7019_chunk (cost=0.00..90423.71 rows=1 width=357) (actual time=1974.447..1974.447 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 767922 -> Custom Scan (DecompressChunk) on _hyper_16_6892_chunk a_37 (cost=90338.13..90338.13 rows=1000 width=1026) (actual time=1665.442..1666.238 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7022_chunk (cost=0.00..90338.13 rows=1 width=357) (actual time=1664.521..1664.521 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 768568 -> Custom Scan (DecompressChunk) on _hyper_16_6890_chunk a_31 (cost=90035.41..90035.41 rows=1000 width=1026) (actual time=1670.194..1670.359 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7020_chunk (cost=0.00..90035.41 rows=1 width=357) (actual time=1669.038..1669.038 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 757177 -> Custom Scan (DecompressChunk) on _hyper_16_6897_chunk a_34 (cost=89137.10..89137.10 rows=1000 width=1026) (actual time=1727.421..1727.927 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7027_chunk (cost=0.00..89137.10 rows=1 width=357) (actual time=1727.410..1727.410 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 759226 -> Custom Scan (DecompressChunk) on _hyper_16_6902_chunk a_30 (cost=89133.67..89133.67 rows=1000 width=1026) (actual time=1516.389..1517.447 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7032_chunk (cost=0.00..89133.67 rows=1 width=357) (actual time=1515.554..1515.555 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 754578 -> Custom Scan (DecompressChunk) on _hyper_16_6904_chunk a_24 (cost=89044.83..89044.83 rows=1000 width=1026) (actual time=1559.562..1560.325 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7034_chunk (cost=0.00..89044.83 rows=1 width=357) (actual time=1558.879..1558.879 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 746887 -> Custom Scan (DecompressChunk) on _hyper_16_6907_chunk a_27 (cost=88879.05..88879.05 rows=1000 width=1026) (actual time=1619.118..1619.916 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7037_chunk (cost=0.00..88879.05 rows=1 width=357) (actual time=1617.892..1617.892 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 710947 -> Custom Scan (DecompressChunk) on _hyper_16_6908_chunk a_26 (cost=86715.17..86715.17 rows=1000 width=1026) (actual time=1753.010..1753.670 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7038_chunk (cost=0.00..86715.17 rows=1 width=357) (actual time=1752.065..1752.066 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 697378 -> Custom Scan (DecompressChunk) on _hyper_16_6884_chunk a_9 (cost=74016.28..74016.28 rows=1000 width=1026) (actual time=1369.276..1369.280 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7014_chunk (cost=0.00..74016.28 rows=1 width=357) (actual time=1368.543..1368.543 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 615809 -> Custom Scan (DecompressChunk) on _hyper_16_6906_chunk a_23 (cost=64438.46..128876.91 rows=2000 width=1026) (actual time=2497.893..2497.896 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7036_chunk (cost=0.00..128876.91 rows=2 width=357) (actual time=2496.201..2496.201 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 1063976 -> Custom Scan (DecompressChunk) on _hyper_16_6914_chunk a_18 (cost=62740.29..125480.57 rows=2000 width=1026) (actual time=2220.429..2220.432 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7044_chunk (cost=0.00..125480.57 rows=2 width=357) (actual time=2219.426..2219.426 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 1060686 -> Custom Scan (DecompressChunk) on _hyper_16_6878_chunk a_10 (cost=61827.23..123654.46 rows=2000 width=1026) (actual time=2246.579..2247.924 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7008_chunk (cost=0.00..123654.46 rows=2 width=357) (actual time=2245.980..2246.614 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 1046790 -> Custom Scan (DecompressChunk) on _hyper_16_6916_chunk a_59 (cost=61395.17..613951.71 rows=10000 width=1026) (actual time=11309.959..11310.449 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7046_chunk (cost=0.00..613951.71 rows=10 width=357) (actual time=11308.503..11308.503 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 4858396 -> Custom Scan (DecompressChunk) on _hyper_16_6911_chunk a_21 (cost=59847.96..119695.93 rows=2000 width=1026) (actual time=2277.549..2279.094 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7041_chunk (cost=0.00..119695.93 rows=2 width=357) (actual time=2275.816..2276.385 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 1017847 -> Custom Scan (DecompressChunk) on _hyper_16_6877_chunk a_11 (cost=58446.69..116893.38 rows=2000 width=1026) (actual time=2366.018..2366.184 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7007_chunk (cost=0.00..116893.38 rows=2 width=357) (actual time=2364.576..2364.576 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 988634 -> Custom Scan (DecompressChunk) on _hyper_16_6875_chunk a_12 (cost=58148.63..116297.26 rows=2000 width=1026) (actual time=2022.104..2023.223 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7005_chunk (cost=0.00..116297.26 rows=2 width=357) (actual time=2019.377..2019.377 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 981935 -> Custom Scan (DecompressChunk) on _hyper_16_6919_chunk a_50 (cost=58100.05..1162000.95 rows=20000 width=1026) (actual time=21050.887..21051.422 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7050_chunk (cost=0.00..1162000.95 rows=20 width=357) (actual time=21049.956..21049.956 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 9165781 -> Custom Scan (DecompressChunk) on _hyper_16_6910_chunk a_22 (cost=57386.79..114773.58 rows=2000 width=1026) (actual time=2130.835..2131.655 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7040_chunk (cost=0.00..114773.58 rows=2 width=357) (actual time=2129.282..2129.282 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 959355 -> Custom Scan (DecompressChunk) on _hyper_16_6915_chunk a_17 (cost=57307.14..114614.28 rows=2000 width=1026) (actual time=2214.361..2215.177 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7045_chunk (cost=0.00..114614.28 rows=2 width=357) (actual time=2212.771..2212.772 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 964608 -> Custom Scan (DecompressChunk) on _hyper_16_6882_chunk a_51 (cost=57176.53..1143530.53 rows=20000 width=1026) (actual time=20219.366..20220.364 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7012_chunk (cost=0.00..1143530.53 rows=20 width=357) (actual time=20218.466..20218.466 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 9006918 -> Custom Scan (DecompressChunk) on _hyper_16_6917_chunk a_54 (cost=57107.02..1142140.50 rows=20000 width=1026) (actual time=19807.831..19808.630 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7048_chunk (cost=0.00..1142140.50 rows=20 width=357) (actual time=19806.765..19806.766 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 9021585 -> Custom Scan (DecompressChunk) on _hyper_16_6869_chunk a_15 (cost=56957.12..113914.24 rows=2000 width=1026) (actual time=2341.000..2341.267 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_6999_chunk (cost=0.00..113914.24 rows=2 width=357) (actual time=2340.509..2340.509 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 960863 -> Custom Scan (DecompressChunk) on _hyper_16_6913_chunk a_19 (cost=56807.95..113615.90 rows=2000 width=1026) (actual time=2141.600..2142.110 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7043_chunk (cost=0.00..113615.90 rows=2 width=357) (actual time=2140.652..2140.652 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 960772 -> Custom Scan (DecompressChunk) on _hyper_16_6868_chunk a_16 (cost=56806.47..113612.93 rows=2000 width=1026) (actual time=3000.807..3001.945 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_6998_chunk (cost=0.00..113612.93 rows=2 width=357) (actual time=2999.568..3000.229 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 959716 -> Custom Scan (DecompressChunk) on _hyper_16_6923_chunk a_49 (cost=56733.12..1191395.48 rows=21000 width=1026) (actual time=20711.111..20711.603 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7054_chunk (cost=0.00..1191395.48 rows=21 width=357) (actual time=20707.840..20707.840 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 9308002 -> Custom Scan (DecompressChunk) on _hyper_16_6871_chunk a_53 (cost=56690.91..1133818.18 rows=20000 width=1026) (actual time=20458.814..20459.381 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7001_chunk (cost=0.00..1133818.18 rows=20 width=358) (actual time=20458.288..20458.288 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 8941521 -> Custom Scan (DecompressChunk) on _hyper_16_6922_chunk a_52 (cost=56464.95..1129299.00 rows=20000 width=1026) (actual time=19580.006..19580.414 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7053_chunk (cost=0.00..1129299.00 rows=20 width=357) (actual time=19572.264..19572.264 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 8898215 -> Custom Scan (DecompressChunk) on _hyper_16_6881_chunk a_48 (cost=55955.91..1175074.19 rows=21000 width=1026) (actual time=21679.745..21679.980 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7011_chunk (cost=0.00..1175074.19 rows=21 width=357) (actual time=21678.745..21678.979 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 9310700 -> Custom Scan (DecompressChunk) on _hyper_16_6918_chunk a_56 (cost=55806.72..1116134.47 rows=20000 width=1026) (actual time=19790.963..19791.639 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7049_chunk (cost=0.00..1116134.47 rows=20 width=357) (actual time=19789.462..19789.462 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 8818098 -> Custom Scan (DecompressChunk) on _hyper_16_6883_chunk a_58 (cost=55744.99..1114899.71 rows=20000 width=1026) (actual time=18816.419..18816.962 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7013_chunk (cost=0.00..1114899.71 rows=20 width=357) (actual time=18815.045..18815.046 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 8816082 -> Custom Scan (DecompressChunk) on _hyper_16_6870_chunk a_57 (cost=55593.86..1111877.27 rows=20000 width=1026) (actual time=20240.890..20241.617 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7000_chunk (cost=0.00..1111877.27 rows=20 width=357) (actual time=20239.539..20239.540 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 8790177 -> Custom Scan (DecompressChunk) on _hyper_16_6912_chunk a_20 (cost=55510.42..111020.83 rows=2000 width=1026) (actual time=230.458..230.608 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7042_chunk (cost=0.00..111020.83 rows=2 width=357) (actual time=228.858..228.858 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 939955 -> Custom Scan (DecompressChunk) on _hyper_16_6921_chunk a_55 (cost=55401.92..1108038.40 rows=20000 width=1026) (actual time=4888.918..4889.497 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7052_chunk (cost=0.00..1108038.40 rows=20 width=357) (actual time=4887.863..4887.864 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 8750668 -> Custom Scan (DecompressChunk) on _hyper_16_6876_chunk a_43 (cost=55304.02..1271992.39 rows=23000 width=1026) (actual time=19967.944..19976.090 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7006_chunk (cost=0.00..1271992.39 rows=23 width=357) (actual time=19966.882..19966.882 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 9996101 -> Custom Scan (DecompressChunk) on _hyper_16_6872_chunk a_47 (cost=55283.32..1160949.73 rows=21000 width=1026) (actual time=18456.253..18456.493 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7002_chunk (cost=0.00..1160949.73 rows=21 width=357) (actual time=18455.464..18455.464 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 9203907 -> Custom Scan (DecompressChunk) on _hyper_16_6899_chunk a_45 (cost=55192.70..1159046.74 rows=21000 width=1026) (actual time=14750.455..14750.940 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7029_chunk (cost=0.00..1159046.74 rows=21 width=357) (actual time=14749.552..14749.552 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 9150598 -> Custom Scan (DecompressChunk) on _hyper_16_6885_chunk a_40 (cost=55168.23..662018.81 rows=12000 width=1026) (actual time=15588.932..15589.162 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7015_chunk (cost=0.00..662018.81 rows=12 width=357) (actual time=15588.921..15588.921 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 5274082 -> Custom Scan (DecompressChunk) on _hyper_16_6887_chunk a_44 (cost=55150.06..1268451.42 rows=23000 width=1026) (actual time=97303.148..97303.628 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7017_chunk (cost=0.00..1268451.42 rows=23 width=357) (actual time=97303.143..97303.144 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 9966141 -> Custom Scan (DecompressChunk) on _hyper_16_6900_chunk a_46 (cost=54979.67..1154573.03 rows=21000 width=1026) (actual time=113224.318..113224.971 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7030_chunk (cost=0.00..1154573.03 rows=21 width=357) (actual time=113224.308..113224.308 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 9127791 -> Custom Scan (DecompressChunk) on _hyper_16_6920_chunk a_42 (cost=54824.54..1315788.98 rows=24000 width=1026) (actual time=29219.579..29221.370 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7051_chunk (cost=0.00..1315788.98 rows=24 width=357) (actual time=29219.576..29219.580 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 10397612 -> Custom Scan (DecompressChunk) on _hyper_16_6924_chunk a_41 (cost=54601.42..1310434.14 rows=24000 width=1026) (actual time=32643.235..32643.945 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7065_chunk (cost=0.00..1310434.14 rows=24 width=357) (actual time=32643.232..32643.232 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 10354983 -> Custom Scan (DecompressChunk) on _hyper_16_6874_chunk a_13 (cost=54174.38..108348.76 rows=2000 width=1026) (actual time=3476.783..3477.951 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7004_chunk (cost=0.00..108348.76 rows=2 width=357) (actual time=3476.781..3476.981 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 913003 -> Custom Scan (DecompressChunk) on _hyper_16_6873_chunk a_14 (cost=51032.10..102064.20 rows=2000 width=1026) (actual time=3758.099..3758.808 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7003_chunk (cost=0.00..102064.20 rows=2 width=357) (actual time=3758.096..3758.096 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 861921 -> Custom Scan (DecompressChunk) on _hyper_16_6901_chunk a_32 (cost=47744.53..95489.05 rows=2000 width=1026) (actual time=3116.652..3119.559 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7031_chunk (cost=0.00..95489.05 rows=2 width=357) (actual time=3116.651..3117.347 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 806147 -> Custom Scan (DecompressChunk) on _hyper_16_6898_chunk a_33 (cost=47627.06..95254.11 rows=2000 width=1026) (actual time=3269.655..3270.318 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7028_chunk (cost=0.00..95254.11 rows=2 width=357) (actual time=3269.653..3269.653 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 790430 -> Custom Scan (DecompressChunk) on _hyper_16_6880_chunk a_4 (cost=35363.26..35363.26 rows=1000 width=1026) (actual time=907.876..909.081 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7010_chunk (cost=0.00..35363.26 rows=1 width=357) (actual time=907.874..907.874 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 262736 -> Custom Scan (DecompressChunk) on _hyper_16_6879_chunk a_7 (cost=34365.16..34365.16 rows=1000 width=1026) (actual time=866.594..867.585 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7009_chunk (cost=0.00..34365.16 rows=1 width=357) (actual time=866.592..866.592 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 249110 -> Custom Scan (DecompressChunk) on _hyper_16_6888_chunk a_8 (cost=33822.71..33822.71 rows=1000 width=1026) (actual time=918.622..920.316 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7018_chunk (cost=0.00..33822.71 rows=1 width=357) (actual time=918.619..918.621 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 246589 -> Custom Scan (DecompressChunk) on _hyper_16_6891_chunk a_6 (cost=33375.42..33375.42 rows=1000 width=1026) (actual time=926.223..927.616 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7021_chunk (cost=0.00..33375.42 rows=1 width=357) (actual time=926.221..926.221 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 245446 -> Custom Scan (DecompressChunk) on _hyper_16_6975_chunk a_2 (cost=33258.53..33258.53 rows=1000 width=628) (actual time=843.490..844.888 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_18_chunk (cost=0.00..33258.53 rows=1 width=357) (actual time=843.489..843.489 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 244674 -> Custom Scan (DecompressChunk) on _hyper_16_6895_chunk a_3 (cost=32193.56..32193.56 rows=1000 width=1026) (actual time=917.620..918.920 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7025_chunk (cost=0.00..32193.56 rows=1 width=357) (actual time=917.619..917.619 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 235883 -> Custom Scan (DecompressChunk) on _hyper_16_6893_chunk a_5 (cost=31861.24..31861.24 rows=1000 width=1026) (actual time=811.669..813.207 rows=0 loops=1) Vectorized Filter: ((clock >= 1735282290) AND (clock <= 1735285890)) -> Parallel Seq Scan on compress_hyper_18_7023_chunk (cost=0.00..31861.24 rows=1 width=357) (actual time=811.668..811.672 rows=0 loops=1) Filter: ((_ts_meta_max_1 >= 1735282290) AND (_ts_meta_min_1 <= 1735285890)) Rows Removed by Filter: 232596 -> Parallel Index Scan using _hyper_16_7105_chunk_auditlog_2 on _hyper_16_7105_chunk a_1 (cost=0.29..36.58 rows=192 width=609) (actual time=0.068..36.747 rows=1487 loops=1) Index Cond: ((clock >= 1735282290) AND (clock <= 1735285890)) Planning Time: 831.701 ms JIT: Functions: 121 Options: Inlining true, Optimization true, Expressions true, Deforming true Timing: Generation 15.904 ms, Inlining 59.697 ms, Optimization 1676.482 ms, Emission 1113.330 ms, Total 2865.413 ms Execution Time: 634504.801 ms (306 rows)