#	exclusive	inclusive	rows x	rows	loops	node
1.	0.002	9,805.035	↓ 0.0	0	1	→ Limit (cost=42.09..353.32 rows=1,000 width=16) (actual time=9,805.009..9,805.035 rows=0 loops=1) Buffers: shared hit=5,095,843
2.	282.363	9,805.033	↓ 0.0	0	1	→ Merge Join (cost=42.09..4,358,075.15 rows=14,002,909 width=16) (actual time=9,805.008..9,805.033 rows=0 loops=1) Merge Cond: ((_hyper_214910_3361319_chunk.id_time_series = _hyper_198643_2485035_chunk.id_time_series) AND (_hyper_214910_3361319_chunk.value_date = _hyper_198643_2485035_chunk.value_date)) Buffers: shared hit=5,095,843
3.	18.108	212.832	↓ 2.0	221,526	1	→ Merge Append (cost=3.80..393,861.52 rows=110,069 width=16) (actual time=20.836..212.832 rows=221,526 loops=1) Sort Key: _hyper_214910_3361319_chunk.id_time_series, _hyper_214910_3361319_chunk.value_date Buffers: shared hit=98,349
4.	4.269	4.269	↓ 2.6	10,136 - 1,448	1	→ Index Scan using "3361319_161_data_quality_alert_pkey" on _hyper_214910_3361319_chunk (cost=0.42..9,927.91 rows=3,955 width=16) (actual time=0.121..4.269 rows=10,136 loops=1) Index Cond: (rule_id = 5) Filter: ((last_updated < '2025-01-22 07:14:08.779384+00'::timestamp with time zone) AND (status = 1)) Rows Removed by Filter: 1,448 Buffers: shared hit=3,456
5.	0.032	0.032	↓ 0.0	0	1	→ Index Scan using "3369312_163_data_quality_alert_pkey" on _hyper_214910_3369312_chunk (cost=0.28..40.07 rows=1 width=16) (actual time=0.032..0.032 rows=0 loops=1) Index Cond: (rule_id = 5) Filter: ((last_updated < '2025-01-22 07:14:08.779384+00'::timestamp with time zone) AND (status = 1)) Buffers: shared hit=15
6.	8.443	8.443	↓ 2.6	20,648 - 3,360	1	→ Index Scan using "3699068_169_data_quality_alert_pkey" on _hyper_214910_3699068_chunk (cost=0.42..18,083.12 rows=7,820 width=16) (actual time=0.104..8.443 rows=20,648 loops=1) Index Cond: (rule_id = 5) Filter: ((last_updated < '2025-01-22 07:14:08.779384+00'::timestamp with time zone) AND (status = 1)) Rows Removed by Filter: 3,360 Buffers: shared hit=7,153
7.	14.099	14.099	↓ 7.0	19,216 - 18,672	1	→ Index Scan using "4120816_245_data_quality_alert_pkey" on _hyper_214910_4120816_chunk (cost=0.42..39,319.40 rows=2,755 width=16) (actual time=0.201..14.099 rows=19,216 loops=1) Index Cond: (rule_id = 5) Filter: ((last_updated < '2025-01-22 07:14:08.779384+00'::timestamp with time zone) AND (status = 1)) Rows Removed by Filter: 18,672 Buffers: shared hit=7,407
8.	55.334	55.334	↓ 1.9	28,889 - 245,656	1	→ Index Scan using "4878553_280_data_quality_alert_pkey" on _hyper_214910_4878553_chunk (cost=0.42..83,800.32 rows=14,946 width=16) (actual time=8.959..55.334 rows=28,889 loops=1) Index Cond: (rule_id = 5) Filter: ((last_updated < '2025-01-22 07:14:08.779384+00'::timestamp with time zone) AND (status = 1)) Rows Removed by Filter: 245,656 Buffers: shared hit=19,749
9.	31.895	31.895	↓ 3.7	42,520 - 75,148	1	→ Index Scan using "5013804_288_data_quality_alert_pkey" on _hyper_214910_5013804_chunk (cost=0.42..84,102.95 rows=11,421 width=16) (actual time=4.561..31.895 rows=42,520 loops=1) Index Cond: (rule_id = 5) Filter: ((last_updated < '2025-01-22 07:14:08.779384+00'::timestamp with time zone) AND (status = 1)) Rows Removed by Filter: 75,148 Buffers: shared hit=13,167
10.	22.667	22.667	↓ 2.9	34,848 - 30,320	1	→ Index Scan using "5206473_294_data_quality_alert_pkey" on _hyper_214910_5206473_chunk (cost=0.42..51,647.13 rows=12,019 width=16) (actual time=6.598..22.667 rows=34,848 loops=1) Index Cond: (rule_id = 5) Filter: ((last_updated < '2025-01-22 07:14:08.779384+00'::timestamp with time zone) AND (status = 1)) Rows Removed by Filter: 30,320 Buffers: shared hit=11,723
11.	44.714	44.714	↑ 1.2	46,341 - 106,897	1	→ Index Scan using "5348084_3778_data_quality_alert_pkey" on _hyper_214910_5348084_chunk (cost=0.42..100,834.74 rows=57,151 width=16) (actual time=0.248..44.714 rows=46,341 loops=1) Index Cond: (rule_id = 5) Filter: ((last_updated < '2025-01-22 07:14:08.779384+00'::timestamp with time zone) AND (status = 1)) Rows Removed by Filter: 106,897 Buffers: shared hit=22,546
12.	13.271	13.271	↓ 18,928.0	18,928 - 16,452	1	→ Index Scan using "5597355_4674_data_quality_alert_pkey" on _hyper_214910_5597355_chunk (cost=0.42..3,810.83 rows=1 width=16) (actual time=0.007..13.271 rows=18,928 loops=1) Index Cond: (rule_id = 5) Filter: ((last_updated < '2025-01-22 07:14:08.779384+00'::timestamp with time zone) AND (status = 1)) Rows Removed by Filter: 16,452 Buffers: shared hit=13,133
13.	453.009	9,309.838	↓ 1.1	5,737,656	1	→ Merge Append (cost=38.30..3,798,190.33 rows=5,088,775 width=16) (actual time=5,077.406..9,309.838 rows=5,737,656 loops=1) Sort Key: _hyper_198643_2485035_chunk.id_time_series, _hyper_198643_2485035_chunk.value_date Buffers: shared hit=4,997,494
14.	143.013	143.013	↓ 3,046.0	3,046 - 1,475,602	1	→ Index Scan using "2485035_2_realized_activepower_unversioned_pkey" on _hyper_198643_2485035_chunk (cost=0.43..65,003.31 rows=1 width=16) (actual time=91.451..143.013 rows=3,046 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,475,602 Buffers: shared hit=69,878
15.	133.692	133.692	↓ 3,890.0	3,890 - 1,454,841	1	→ Index Scan using "2485036_4_realized_activepower_unversioned_pkey" on _hyper_198643_2485036_chunk (cost=0.43..63,744.15 rows=1 width=16) (actual time=84.499..133.692 rows=3,890 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,454,841 Buffers: shared hit=53,281
16.	57.417	57.417	↓ 0.0	0 - 561,591	1	→ Index Scan using "2485037_6_realized_activepower_unversioned_pkey" on _hyper_198643_2485037_chunk (cost=0.42..25,086.23 rows=1 width=16) (actual time=57.417..57.417 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 561,591 Buffers: shared hit=31,889
17.	49.414	49.414	↓ 0.0	0 - 514,363	1	→ Index Scan using "2485038_8_realized_activepower_unversioned_pkey" on _hyper_198643_2485038_chunk (cost=0.42..22,831.89 rows=1 width=16) (actual time=49.414..49.414 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 514,363 Buffers: shared hit=19,176
18.	45.502	45.502	↓ 0.0	0 - 511,011	1	→ Index Scan using "2485039_10_realized_activepower_unversioned_pkey" on _hyper_198643_2485039_chunk (cost=0.42..22,510.52 rows=1 width=16) (actual time=45.502..45.502 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 511,011 Buffers: shared hit=11,687
19.	49.174	49.174	↓ 0.0	0 - 553,131	1	→ Index Scan using "2485040_12_realized_activepower_unversioned_pkey" on _hyper_198643_2485040_chunk (cost=0.42..24,179.59 rows=1 width=16) (actual time=49.174..49.174 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 553,131 Buffers: shared hit=11,388
20.	51.025	51.025	↓ 0.0	0 - 581,642	1	→ Index Scan using "2485041_14_realized_activepower_unversioned_pkey" on _hyper_198643_2485041_chunk (cost=0.42..25,507.92 rows=1 width=16) (actual time=51.025..51.025 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 581,642 Buffers: shared hit=11,709
21.	50.672	50.672	↓ 0.0	0 - 571,503	1	→ Index Scan using "2485042_16_realized_activepower_unversioned_pkey" on _hyper_198643_2485042_chunk (cost=0.42..25,038.55 rows=1 width=16) (actual time=50.672..50.672 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 571,503 Buffers: shared hit=11,983
22.	48.424	48.424	↓ 0.0	0 - 516,225	1	→ Index Scan using "2485043_18_realized_activepower_unversioned_pkey" on _hyper_198643_2485043_chunk (cost=0.42..22,612.71 rows=1 width=16) (actual time=48.424..48.424 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 516,225 Buffers: shared hit=11,343
23.	45.254	45.254	↓ 0.0	0 - 505,782	1	→ Index Scan using "2485044_20_realized_activepower_unversioned_pkey" on _hyper_198643_2485044_chunk (cost=0.42..22,151.53 rows=1 width=16) (actual time=45.254..45.254 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 505,782 Buffers: shared hit=10,864
24.	44.918	44.918	↓ 0.0	0 - 504,210	1	→ Index Scan using "2485045_22_realized_activepower_unversioned_pkey" on _hyper_198643_2485045_chunk (cost=0.42..22,154.86 rows=1 width=16) (actual time=44.918..44.918 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 504,210 Buffers: shared hit=11,018
25.	138.854	138.854	↓ 3,400.0	3,400 - 1,469,536	1	→ Index Scan using "2485046_24_realized_activepower_unversioned_pkey" on _hyper_198643_2485046_chunk (cost=0.43..65,176.29 rows=1 width=16) (actual time=86.672..138.854 rows=3,400 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,469,536 Buffers: shared hit=79,732
26.	145.276	145.276	↓ 3,978.0	3,978 - 1,497,890	1	→ Index Scan using "2485047_26_realized_activepower_unversioned_pkey" on _hyper_198643_2485047_chunk (cost=0.43..66,913.44 rows=1 width=16) (actual time=90.442..145.276 rows=3,978 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,497,890 Buffers: shared hit=86,867
27.	153.659	153.659	↓ 3,726.0	3,726 - 1,523,093	1	→ Index Scan using "2485048_28_realized_activepower_unversioned_pkey" on _hyper_198643_2485048_chunk (cost=0.43..68,048.58 rows=1 width=16) (actual time=96.419..153.659 rows=3,726 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,523,093 Buffers: shared hit=108,348
28.	162.517	162.517	↓ 3,587.0	3,587 - 1,543,496	1	→ Index Scan using "2485049_30_realized_activepower_unversioned_pkey" on _hyper_198643_2485049_chunk (cost=0.43..69,068.97 rows=1 width=16) (actual time=104.231..162.517 rows=3,587 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,543,496 Buffers: shared hit=114,499
29.	143.490	143.490	↓ 3,649.0	3,649 - 1,581,083	1	→ Index Scan using "2485050_32_realized_activepower_unversioned_pkey" on _hyper_198643_2485050_chunk (cost=0.43..69,620.29 rows=1 width=16) (actual time=88.886..143.490 rows=3,649 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,581,083 Buffers: shared hit=48,579
30.	150.148	150.148	↓ 3,468.0	3,468 - 1,603,488	1	→ Index Scan using "2485051_34_realized_activepower_unversioned_pkey" on _hyper_198643_2485051_chunk (cost=0.43..69,934.66 rows=1 width=16) (actual time=94.862..150.148 rows=3,468 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,603,488 Buffers: shared hit=53,928
31.	146.578	146.578	↓ 3,222.0	3,222 - 1,605,738	1	→ Index Scan using "2485052_36_realized_activepower_unversioned_pkey" on _hyper_198643_2485052_chunk (cost=0.43..70,017.86 rows=1 width=16) (actual time=91.354..146.578 rows=3,222 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,605,738 Buffers: shared hit=61,240
32.	133.923	133.923	↓ 2,681.0	2,681 - 1,460,487	1	→ Index Scan using "2485053_38_realized_activepower_unversioned_pkey" on _hyper_198643_2485053_chunk (cost=0.43..63,835.14 rows=1 width=16) (actual time=83.206..133.923 rows=2,681 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,460,487 Buffers: shared hit=59,872
33.	130.849	130.849	↓ 2,937.0	2,937 - 1,409,407	1	→ Index Scan using "2485054_40_realized_activepower_unversioned_pkey" on _hyper_198643_2485054_chunk (cost=0.43..61,650.05 rows=1 width=16) (actual time=81.174..130.849 rows=2,937 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,409,407 Buffers: shared hit=50,506
34.	129.513	129.513	↓ 3,095.0	3,095 - 1,427,703	1	→ Index Scan using "2485055_42_realized_activepower_unversioned_pkey" on _hyper_198643_2485055_chunk (cost=0.43..62,197.02 rows=1 width=16) (actual time=82.368..129.513 rows=3,095 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,427,703 Buffers: shared hit=51,562
35.	127.196	127.196	↓ 4,195.0	4,195 - 1,355,465	1	→ Index Scan using "2485056_44_realized_activepower_unversioned_pkey" on _hyper_198643_2485056_chunk (cost=0.43..59,312.73 rows=1 width=16) (actual time=79.429..127.196 rows=4,195 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,355,465 Buffers: shared hit=50,347
36.	126.082	126.082	↓ 3,357.0	3,357 - 1,330,048	1	→ Index Scan using "2485057_46_realized_activepower_unversioned_pkey" on _hyper_198643_2485057_chunk (cost=0.43..58,610.05 rows=1 width=16) (actual time=78.475..126.082 rows=3,357 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,330,048 Buffers: shared hit=63,438
37.	121.048	121.048	↓ 3,801.0	3,801 - 1,343,457	1	→ Index Scan using "2485058_48_realized_activepower_unversioned_pkey" on _hyper_198643_2485058_chunk (cost=0.43..58,827.55 rows=1 width=16) (actual time=75.810..121.048 rows=3,801 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,343,457 Buffers: shared hit=38,854
38.	117.450	117.450	↓ 3,912.0	3,912 - 1,328,332	1	→ Index Scan using "2485059_50_realized_activepower_unversioned_pkey" on _hyper_198643_2485059_chunk (cost=0.43..57,970.42 rows=1 width=16) (actual time=72.276..117.450 rows=3,912 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,328,332 Buffers: shared hit=27,817
39.	117.149	117.149	↓ 3,422.0	3,422 - 1,321,722	1	→ Index Scan using "2485060_52_realized_activepower_unversioned_pkey" on _hyper_198643_2485060_chunk (cost=0.43..57,643.92 rows=1 width=16) (actual time=72.540..117.149 rows=3,422 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,321,722 Buffers: shared hit=29,224
40.	120.153	120.153	↓ 3,930.0	3,930 - 1,356,336	1	→ Index Scan using "2485061_54_realized_activepower_unversioned_pkey" on _hyper_198643_2485061_chunk (cost=0.43..59,063.60 rows=1 width=16) (actual time=72.444..120.153 rows=3,930 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,356,336 Buffers: shared hit=30,244
41.	122.047	122.047	↓ 3,562.0	3,562 - 1,381,810	1	→ Index Scan using "2485062_56_realized_activepower_unversioned_pkey" on _hyper_198643_2485062_chunk (cost=0.43..59,912.58 rows=1 width=16) (actual time=71.486..122.047 rows=3,562 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,381,810 Buffers: shared hit=35,272
42.	131.154	131.154	↓ 3,734.0	3,734 - 1,399,634	1	→ Index Scan using "2485063_58_realized_activepower_unversioned_pkey" on _hyper_198643_2485063_chunk (cost=0.43..60,495.52 rows=1 width=16) (actual time=72.864..131.154 rows=3,734 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,399,634 Buffers: shared hit=33,179
43.	127.672	127.672	↓ 3,226.0	3,226 - 1,401,194	1	→ Index Scan using "2485064_60_realized_activepower_unversioned_pkey" on _hyper_198643_2485064_chunk (cost=0.43..60,459.92 rows=1 width=16) (actual time=73.681..127.672 rows=3,226 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,401,194 Buffers: shared hit=43,976
44.	187.811	187.811	↓ 3,114.0	3,114 - 1,388,038	1	→ Index Scan using "2485065_62_realized_activepower_unversioned_pkey" on _hyper_198643_2485065_chunk (cost=0.43..60,684.92 rows=1 width=16) (actual time=110.856..187.811 rows=3,114 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,388,038 Buffers: shared hit=502,763
45.	152.769	152.769	↓ 4,232.0	4,232 - 1,400,704	1	→ Index Scan using "2485066_64_realized_activepower_unversioned_pkey" on _hyper_198643_2485066_chunk (cost=0.43..60,702.41 rows=1 width=16) (actual time=88.548..152.769 rows=4,232 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,400,704 Buffers: shared hit=235,905
46.	130.332	130.332	↓ 3,672.0	3,672 - 1,424,935	1	→ Index Scan using "2485067_66_realized_activepower_unversioned_pkey" on _hyper_198643_2485067_chunk (cost=0.43..61,839.55 rows=1 width=16) (actual time=75.854..130.332 rows=3,672 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,424,935 Buffers: shared hit=30,545
47.	126.929	126.929	↓ 4,599.0	4,599 - 1,427,006	1	→ Index Scan using "2485068_68_realized_activepower_unversioned_pkey" on _hyper_198643_2485068_chunk (cost=0.43..62,113.18 rows=1 width=16) (actual time=61.533..126.929 rows=4,599 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,427,006 Buffers: shared hit=30,841
48.	52.472	52.472	↓ 0.0	0 - 585,382	1	→ Index Scan using "2485069_70_realized_activepower_unversioned_pkey" on _hyper_198643_2485069_chunk (cost=0.42..25,691.80 rows=1 width=16) (actual time=52.472..52.472 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 585,382 Buffers: shared hit=13,710
49.	54.209	54.209	↓ 0.0	0 - 596,140	1	→ Index Scan using "2485070_72_realized_activepower_unversioned_pkey" on _hyper_198643_2485070_chunk (cost=0.42..26,278.55 rows=1 width=16) (actual time=54.209..54.209 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 596,140 Buffers: shared hit=15,985
50.	52.374	52.374	↓ 0.0	0 - 589,705	1	→ Index Scan using "2485071_74_realized_activepower_unversioned_pkey" on _hyper_198643_2485071_chunk (cost=0.42..25,924.27 rows=1 width=16) (actual time=52.374..52.374 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 589,705 Buffers: shared hit=14,232
51.	23.619	23.619	↓ 0.0	0 - 260,641	1	→ Index Scan using "2485072_76_realized_activepower_unversioned_pkey" on _hyper_198643_2485072_chunk (cost=0.42..11,491.30 rows=1 width=16) (actual time=23.619..23.619 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 260,641 Buffers: shared hit=7,548
52.	65.800	65.800	↓ 0.0	0 - 668,498	1	→ Index Scan using "2485073_78_realized_activepower_unversioned_pkey" on _hyper_198643_2485073_chunk (cost=0.42..29,792.81 rows=1 width=16) (actual time=65.800..65.800 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 668,498 Buffers: shared hit=28,637
53.	66.963	66.963	↓ 0.0	0 - 660,205	1	→ Index Scan using "2485074_80_realized_activepower_unversioned_pkey" on _hyper_198643_2485074_chunk (cost=0.42..29,410.22 rows=1 width=16) (actual time=66.963..66.963 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 660,205 Buffers: shared hit=27,298
54.	66.502	66.502	↓ 0.0	0 - 655,907	1	→ Index Scan using "2485075_82_realized_activepower_unversioned_pkey" on _hyper_198643_2485075_chunk (cost=0.42..29,275.68 rows=1 width=16) (actual time=66.502..66.502 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 655,907 Buffers: shared hit=29,903
55.	64.907	64.907	↓ 0.0	0 - 663,787	1	→ Index Scan using "2485076_84_realized_activepower_unversioned_pkey" on _hyper_198643_2485076_chunk (cost=0.42..29,742.81 rows=1 width=16) (actual time=64.907..64.907 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 663,787 Buffers: shared hit=31,094
56.	65.238	65.238	↓ 0.0	0 - 651,568	1	→ Index Scan using "2485077_86_realized_activepower_unversioned_pkey" on _hyper_198643_2485077_chunk (cost=0.42..29,166.57 rows=1 width=16) (actual time=65.238..65.238 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 651,568 Buffers: shared hit=37,023
57.	64.534	64.534	↓ 0.0	0 - 675,158	1	→ Index Scan using "2485078_88_realized_activepower_unversioned_pkey" on _hyper_198643_2485078_chunk (cost=0.42..30,321.36 rows=1 width=16) (actual time=64.534..64.534 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 675,158 Buffers: shared hit=32,731
58.	64.168	64.168	↓ 0.0	0 - 665,004	1	→ Index Scan using "2485079_90_realized_activepower_unversioned_pkey" on _hyper_198643_2485079_chunk (cost=0.42..29,845.83 rows=1 width=16) (actual time=64.168..64.168 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 665,004 Buffers: shared hit=31,619
59.	66.046	66.046	↓ 0.0	0 - 687,463	1	→ Index Scan using "2485080_92_realized_activepower_unversioned_pkey" on _hyper_198643_2485080_chunk (cost=0.42..30,764.16 rows=1 width=16) (actual time=66.046..66.046 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 687,463 Buffers: shared hit=35,882
60.	71.379	71.379	↓ 1,124.0	1,124 - 723,880	1	→ Index Scan using "2485081_94_realized_activepower_unversioned_pkey" on _hyper_198643_2485081_chunk (cost=0.42..32,404.26 rows=1 width=16) (actual time=64.803..71.379 rows=1,124 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 723,880 Buffers: shared hit=37,426
61.	78.047	78.047	↓ 3,916.0	3,916 - 753,684	1	→ Index Scan using "2485082_96_realized_activepower_unversioned_pkey" on _hyper_198643_2485082_chunk (cost=0.42..33,844.43 rows=1 width=16) (actual time=67.330..78.047 rows=3,916 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 753,684 Buffers: shared hit=48,923
62.	65.112	65.112	↓ 0.0	0 - 645,592	1	→ Index Scan using "2485083_98_realized_activepower_unversioned_pkey" on _hyper_198643_2485083_chunk (cost=0.42..28,842.94 rows=1 width=16) (actual time=65.112..65.112 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 645,592 Buffers: shared hit=40,715
63.	69.514	69.514	↓ 0.0	0 - 644,544	1	→ Index Scan using "2485084_100_realized_activepower_unversioned_pkey" on _hyper_198643_2485084_chunk (cost=0.42..29,057.81 rows=1 width=16) (actual time=69.514..69.514 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 644,544 Buffers: shared hit=53,115
64.	130.804	130.804	↓ 6,199.0	6,199 - 1,416,377	1	→ Index Scan using "2485085_102_realized_activepower_unversioned_pkey" on _hyper_198643_2485085_chunk (cost=0.43..61,099.67 rows=1 width=16) (actual time=60.472..130.804 rows=6,199 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,416,377 Buffers: shared hit=32,910
65.	128.819	128.819	↓ 6,230.0	6,230 - 1,414,774	1	→ Index Scan using "2485086_104_realized_activepower_unversioned_pkey" on _hyper_198643_2485086_chunk (cost=0.43..61,249.80 rows=1 width=16) (actual time=60.324..128.819 rows=6,230 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,414,774 Buffers: shared hit=32,853
66.	126.637	126.637	↓ 6,045.0	6,045 - 1,362,041	1	→ Index Scan using "2485087_106_realized_activepower_unversioned_pkey" on _hyper_198643_2485087_chunk (cost=0.43..55,553.81 rows=1 width=16) (actual time=62.066..126.637 rows=6,045 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,362,041 Buffers: shared hit=33,924
67.	158.597	158.597	↓ 3,687.0	3,687 - 1,512,039	1	→ Index Scan using "2485088_108_realized_activepower_unversioned_pkey" on _hyper_198643_2485088_chunk (cost=0.43..67,253.31 rows=1 width=16) (actual time=99.304..158.597 rows=3,687 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,512,039 Buffers: shared hit=167,434
68.	137.408	137.408	↓ 3,536.0	3,536 - 1,344,926	1	→ Index Scan using "2485089_110_realized_activepower_unversioned_pkey" on _hyper_198643_2485089_chunk (cost=0.43..60,118.71 rows=1 width=16) (actual time=91.585..137.408 rows=3,536 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,344,926 Buffers: shared hit=99,151
69.	132.616	132.616	↓ 3,419.0	3,419 - 1,311,679	1	→ Index Scan using "2485090_112_realized_activepower_unversioned_pkey" on _hyper_198643_2485090_chunk (cost=0.43..58,422.65 rows=1 width=16) (actual time=90.517..132.616 rows=3,419 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,311,679 Buffers: shared hit=98,782
70.	129.936	129.936	↓ 3,218.0	3,218 - 1,323,464	1	→ Index Scan using "2485091_114_realized_activepower_unversioned_pkey" on _hyper_198643_2485091_chunk (cost=0.43..58,797.68 rows=1 width=16) (actual time=87.423..129.936 rows=3,218 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,323,464 Buffers: shared hit=88,131
71.	141.959	141.959	↓ 3,117.0	3,117 - 1,445,384	1	→ Index Scan using "2485092_116_realized_activepower_unversioned_pkey" on _hyper_198643_2485092_chunk (cost=0.43..64,226.88 rows=1 width=16) (actual time=95.184..141.959 rows=3,117 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,445,384 Buffers: shared hit=82,532
72.	152.015	152.015	↓ 3,026.0	3,026 - 1,458,253	1	→ Index Scan using "2485093_118_realized_activepower_unversioned_pkey" on _hyper_198643_2485093_chunk (cost=0.43..65,091.74 rows=1 width=16) (actual time=99.409..152.015 rows=3,026 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,458,253 Buffers: shared hit=102,318
73.	116.608	116.608	↓ 3,873.0	3,873 - 1,175,922	1	→ Index Scan using "2485094_120_realized_activepower_unversioned_pkey" on _hyper_198643_2485094_chunk (cost=0.43..52,266.63 rows=1 width=16) (actual time=78.545..116.608 rows=3,873 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,175,922 Buffers: shared hit=71,244
74.	123.990	123.990	↓ 3,541.0	3,541 - 1,204,848	1	→ Index Scan using "2485095_122_realized_activepower_unversioned_pkey" on _hyper_198643_2485095_chunk (cost=0.43..53,601.77 rows=1 width=16) (actual time=85.456..123.990 rows=3,541 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,204,848 Buffers: shared hit=75,289
75.	116.437	116.437	↓ 3,620.0	3,620 - 1,148,470	1	→ Index Scan using "2485096_124_realized_activepower_unversioned_pkey" on _hyper_198643_2485096_chunk (cost=0.43..51,026.86 rows=1 width=16) (actual time=80.689..116.437 rows=3,620 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,148,470 Buffers: shared hit=68,299
76.	121.378	121.378	↓ 3,746.0	3,746 - 1,235,331	1	→ Index Scan using "2485097_126_realized_activepower_unversioned_pkey" on _hyper_198643_2485097_chunk (cost=0.43..54,683.82 rows=1 width=16) (actual time=81.810..121.378 rows=3,746 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,235,331 Buffers: shared hit=76,023
77.	123.748	123.748	↓ 4,168.0	4,168 - 1,239,533	1	→ Index Scan using "2485098_128_realized_activepower_unversioned_pkey" on _hyper_198643_2485098_chunk (cost=0.43..55,217.51 rows=1 width=16) (actual time=84.183..123.748 rows=4,168 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,239,533 Buffers: shared hit=79,424
78.	128.405	128.405	↓ 3,080.0	3,080 - 1,248,087	1	→ Index Scan using "2485099_130_realized_activepower_unversioned_pkey" on _hyper_198643_2485099_chunk (cost=0.43..55,715.82 rows=1 width=16) (actual time=87.184..128.405 rows=3,080 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,248,087 Buffers: shared hit=98,165
79.	0.159	0.159	↓ 0.0	0 - 1,633	1	→ Index Scan using "2485100_132_realized_activepower_unversioned_pkey" on _hyper_198643_2485100_chunk (cost=0.28..77.03 rows=1 width=16) (actual time=0.159..0.159 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,633 Buffers: shared hit=65
80.	0.217	0.217	↓ 0.0	0 - 2,355	1	→ Index Scan using "2485101_134_realized_activepower_unversioned_pkey" on _hyper_198643_2485101_chunk (cost=0.28..107.06 rows=1 width=16) (actual time=0.217..0.217 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 2,355 Buffers: shared hit=107
81.	0.236	0.236	↓ 0.0	0 - 2,544	1	→ Index Scan using "2485102_136_realized_activepower_unversioned_pkey" on _hyper_198643_2485102_chunk (cost=0.28..115.88 rows=1 width=16) (actual time=0.236..0.236 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 2,544 Buffers: shared hit=111
82.	0.240	0.240	↓ 0.0	0 - 2,366	1	→ Index Scan using "2485103_138_realized_activepower_unversioned_pkey" on _hyper_198643_2485103_chunk (cost=0.28..106.61 rows=1 width=16) (actual time=0.239..0.240 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 2,366 Buffers: shared hit=101
83.	0.231	0.231	↓ 0.0	0 - 2,519	1	→ Index Scan using "2485104_140_realized_activepower_unversioned_pkey" on _hyper_198643_2485104_chunk (cost=0.28..113.58 rows=1 width=16) (actual time=0.231..0.231 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 2,519 Buffers: shared hit=107
84.	0.231	0.231	↓ 0.0	0 - 2,527	1	→ Index Scan using "2485105_142_realized_activepower_unversioned_pkey" on _hyper_198643_2485105_chunk (cost=0.28..112.88 rows=1 width=16) (actual time=0.231..0.231 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 2,527 Buffers: shared hit=80
85.	0.228	0.228	↓ 0.0	0 - 2,477	1	→ Index Scan using "2485106_144_realized_activepower_unversioned_pkey" on _hyper_198643_2485106_chunk (cost=0.28..111.14 rows=1 width=16) (actual time=0.227..0.228 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 2,477 Buffers: shared hit=92
86.	0.239	0.239	↓ 0.0	0 - 2,396	1	→ Index Scan using "2485107_146_realized_activepower_unversioned_pkey" on _hyper_198643_2485107_chunk (cost=0.28..108.21 rows=1 width=16) (actual time=0.239..0.239 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 2,396 Buffers: shared hit=73
87.	0.226	0.226	↓ 0.0	0 - 2,496	1	→ Index Scan using "2485108_148_realized_activepower_unversioned_pkey" on _hyper_198643_2485108_chunk (cost=0.28..112.50 rows=1 width=16) (actual time=0.226..0.226 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 2,496 Buffers: shared hit=66
88.	0.245	0.245	↓ 0.0	0 - 2,722	1	→ Index Scan using "2485109_150_realized_activepower_unversioned_pkey" on _hyper_198643_2485109_chunk (cost=0.28..124.45 rows=1 width=16) (actual time=0.245..0.245 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 2,722 Buffers: shared hit=75
89.	0.214	0.214	↓ 0.0	0 - 2,408	1	→ Index Scan using "2485110_152_realized_activepower_unversioned_pkey" on _hyper_198643_2485110_chunk (cost=0.28..111.23 rows=1 width=16) (actual time=0.213..0.214 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 2,408 Buffers: shared hit=46
90.	0.239	0.239	↓ 0.0	0 - 2,778	1	→ Index Scan using "2485111_154_realized_activepower_unversioned_pkey" on _hyper_198643_2485111_chunk (cost=0.28..126.41 rows=1 width=16) (actual time=0.239..0.239 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 2,778 Buffers: shared hit=45
91.	134.790	134.790	↓ 1.8	8,853 - 1,335,759	1	→ Index Scan using "2609291_156_realized_activepower_unversioned_pkey" on _hyper_198643_2609291_chunk (cost=0.43..45,277.85 rows=4,865 width=16) (actual time=69.491..134.790 rows=8,853 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,335,759 Buffers: shared hit=49,737
92.	134.305	134.305	↑ 1.0	12,855 - 1,374,658	1	→ Index Scan using "2996229_158_realized_activepower_unversioned_pkey" on _hyper_198643_2996229_chunk (cost=0.43..46,980.98 rows=13,376 width=16) (actual time=64.961..134.305 rows=12,855 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,374,658 Buffers: shared hit=45,067
93.	141.326	141.326	↑ 1.0	13,435 - 1,408,785	1	→ Index Scan using "3294025_160_realized_activepower_unversioned_pkey" on _hyper_198643_3294025_chunk (cost=0.43..47,487.14 rows=13,494 width=16) (actual time=64.256..141.326 rows=13,435 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,408,785 Buffers: shared hit=35,337
94.	0.005	0.005	↓ 0.0	0	1	→ Index Scan using "3450540_166_realized_activepower_unversioned_pkey" on _hyper_198643_3450540_chunk (cost=0.12..2.34 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Buffers: shared hit=1
95.	138.656	138.656	↓ 3,558.0	14,232 - 1,427,664	1	→ Index Scan using "3699067_168_realized_activepower_unversioned_pkey" on _hyper_198643_3699067_chunk (cost=0.43..48,220.15 rows=4 width=16) (actual time=63.511..138.656 rows=14,232 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,427,664 Buffers: shared hit=37,665
96.	154.414	154.414	↓ 18,120.0	18,120 - 1,461,572	1	→ Index Scan using "4120815_244_realized_activepower_unversioned_pkey" on _hyper_198643_4120815_chunk (cost=0.43..50,019.92 rows=1 width=16) (actual time=69.302..154.414 rows=18,120 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,461,572 Buffers: shared hit=102,266
97.	205.786	205.786	↓ 1.2	287,880 - 1,239,066	1	→ Index Scan using "4865080_279_realized_activepower_unversioned_pkey" on _hyper_198643_4865080_chunk (cost=0.43..52,752.60 rows=242,298 width=16) (actual time=1.950..205.786 rows=287,880 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,239,066 Buffers: shared hit=211,863
98.	282.956	282.956	↓ 1.0	1,079,491 - 507,909	1	→ Index Scan using "5013803_287_realized_activepower_unversioned_pkey" on _hyper_198643_5013803_chunk (cost=0.43..56,061.73 rows=1,077,618 width=16) (actual time=0.178..282.956 rows=1,079,491 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 507,909 Buffers: shared hit=221,790
99.	357.411	357.411	↑ 1.0	1,756,603 - 5,762	1	→ Index Scan using "5206472_293_realized_activepower_unversioned_pkey" on _hyper_198643_5206472_chunk (cost=0.43..68,842.71 rows=1,757,263 width=16) (actual time=0.006..357.411 rows=1,756,603 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 5,762 Buffers: shared hit=240,835
100.	393.812	393.812	↑ 1.0	1,903,143 - 1,724	1	→ Index Scan using "5332356_3773_realized_activepower_unversioned_pkey" on _hyper_198643_5332356_chunk (cost=0.43..68,380.68 rows=1,912,087 width=16) (actual time=0.009..393.812 rows=1,903,143 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Rows Removed by Filter: 1,724 Buffers: shared hit=213,903
101.	89.318	89.318	↓ 7.2	488,066	1	→ Index Scan using "5597354_4673_realized_activepower_unversioned_pkey" on _hyper_198643_5597354_chunk (cost=0.42..11,936.20 rows=67,691 width=16) (actual time=0.008..89.318 rows=488,066 loops=1) Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone) Buffers: shared hit=23,988

Custom settings:
effective_cache_size ?	190GB
effective_io_concurrency ?	256
enable_partitionwise_aggregate ?	on
enable_partitionwise_join ?	on
maintenance_io_concurrency ?	400
max_parallel_workers ?	4
max_parallel_workers_per_gather ?	4
plan_cache_mode ?	force_custom_plan
random_page_cost ?	1.1
work_mem ?	32MB

Limit  (cost=42.09..353.32 rows=1000 width=16) (actual time=9805.009..9805.035 rows=0 loops=1)
          Buffers: shared hit=5095843
          ->  Merge Join  (cost=42.09..4358075.15 rows=14002909 width=16) (actual time=9805.008..9805.033 rows=0 loops=1)
                Merge Cond: ((_hyper_214910_3361319_chunk.id_time_series = _hyper_198643_2485035_chunk.id_time_series) AND (_hyper_214910_3361319_chunk.value_date = _hyper_198643_2485035_chunk.value_date))
                Buffers: shared hit=5095843
                ->  Merge Append  (cost=3.80..393861.52 rows=110069 width=16) (actual time=20.836..212.832 rows=221526 loops=1)
                      Sort Key: _hyper_214910_3361319_chunk.id_time_series, _hyper_214910_3361319_chunk.value_date
                      Buffers: shared hit=98349
                      ->  Index Scan using "3361319_161_data_quality_alert_pkey" on _hyper_214910_3361319_chunk  (cost=0.42..9927.91 rows=3955 width=16) (actual time=0.121..4.269 rows=10136 loops=1)
                            Index Cond: (rule_id = 5)
                            Filter: ((last_updated < '2025-01-22 07:14:08.779384+00'::timestamp with time zone) AND (status = 1))
                            Rows Removed by Filter: 1448
                            Buffers: shared hit=3456
                      ->  Index Scan using "3369312_163_data_quality_alert_pkey" on _hyper_214910_3369312_chunk  (cost=0.28..40.07 rows=1 width=16) (actual time=0.032..0.032 rows=0 loops=1)
                            Index Cond: (rule_id = 5)
                            Filter: ((last_updated < '2025-01-22 07:14:08.779384+00'::timestamp with time zone) AND (status = 1))
                            Buffers: shared hit=15
                      ->  Index Scan using "3699068_169_data_quality_alert_pkey" on _hyper_214910_3699068_chunk  (cost=0.42..18083.12 rows=7820 width=16) (actual time=0.104..8.443 rows=20648 loops=1)
                            Index Cond: (rule_id = 5)
                            Filter: ((last_updated < '2025-01-22 07:14:08.779384+00'::timestamp with time zone) AND (status = 1))
                            Rows Removed by Filter: 3360
                            Buffers: shared hit=7153
                      ->  Index Scan using "4120816_245_data_quality_alert_pkey" on _hyper_214910_4120816_chunk  (cost=0.42..39319.40 rows=2755 width=16) (actual time=0.201..14.099 rows=19216 loops=1)
                            Index Cond: (rule_id = 5)
                            Filter: ((last_updated < '2025-01-22 07:14:08.779384+00'::timestamp with time zone) AND (status = 1))
                            Rows Removed by Filter: 18672
                            Buffers: shared hit=7407
                      ->  Index Scan using "4878553_280_data_quality_alert_pkey" on _hyper_214910_4878553_chunk  (cost=0.42..83800.32 rows=14946 width=16) (actual time=8.959..55.334 rows=28889 loops=1)
                            Index Cond: (rule_id = 5)
                            Filter: ((last_updated < '2025-01-22 07:14:08.779384+00'::timestamp with time zone) AND (status = 1))
                            Rows Removed by Filter: 245656
                            Buffers: shared hit=19749
                      ->  Index Scan using "5013804_288_data_quality_alert_pkey" on _hyper_214910_5013804_chunk  (cost=0.42..84102.95 rows=11421 width=16) (actual time=4.561..31.895 rows=42520 loops=1)
                            Index Cond: (rule_id = 5)
                            Filter: ((last_updated < '2025-01-22 07:14:08.779384+00'::timestamp with time zone) AND (status = 1))
                            Rows Removed by Filter: 75148
                            Buffers: shared hit=13167
                      ->  Index Scan using "5206473_294_data_quality_alert_pkey" on _hyper_214910_5206473_chunk  (cost=0.42..51647.13 rows=12019 width=16) (actual time=6.598..22.667 rows=34848 loops=1)
                            Index Cond: (rule_id = 5)
                            Filter: ((last_updated < '2025-01-22 07:14:08.779384+00'::timestamp with time zone) AND (status = 1))
                            Rows Removed by Filter: 30320
                            Buffers: shared hit=11723
                      ->  Index Scan using "5348084_3778_data_quality_alert_pkey" on _hyper_214910_5348084_chunk  (cost=0.42..100834.74 rows=57151 width=16) (actual time=0.248..44.714 rows=46341 loops=1)
                            Index Cond: (rule_id = 5)
                            Filter: ((last_updated < '2025-01-22 07:14:08.779384+00'::timestamp with time zone) AND (status = 1))
                            Rows Removed by Filter: 106897
                            Buffers: shared hit=22546
                      ->  Index Scan using "5597355_4674_data_quality_alert_pkey" on _hyper_214910_5597355_chunk  (cost=0.42..3810.83 rows=1 width=16) (actual time=0.007..13.271 rows=18928 loops=1)
                            Index Cond: (rule_id = 5)
                            Filter: ((last_updated < '2025-01-22 07:14:08.779384+00'::timestamp with time zone) AND (status = 1))
                            Rows Removed by Filter: 16452
                            Buffers: shared hit=13133
                ->  Merge Append  (cost=38.30..3798190.33 rows=5088775 width=16) (actual time=5077.406..9309.838 rows=5737656 loops=1)
                      Sort Key: _hyper_198643_2485035_chunk.id_time_series, _hyper_198643_2485035_chunk.value_date
                      Buffers: shared hit=4997494
                      ->  Index Scan using "2485035_2_realized_activepower_unversioned_pkey" on _hyper_198643_2485035_chunk  (cost=0.43..65003.31 rows=1 width=16) (actual time=91.451..143.013 rows=3046 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1475602
                            Buffers: shared hit=69878
                      ->  Index Scan using "2485036_4_realized_activepower_unversioned_pkey" on _hyper_198643_2485036_chunk  (cost=0.43..63744.15 rows=1 width=16) (actual time=84.499..133.692 rows=3890 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1454841
                            Buffers: shared hit=53281
                      ->  Index Scan using "2485037_6_realized_activepower_unversioned_pkey" on _hyper_198643_2485037_chunk  (cost=0.42..25086.23 rows=1 width=16) (actual time=57.417..57.417 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 561591
                            Buffers: shared hit=31889
                      ->  Index Scan using "2485038_8_realized_activepower_unversioned_pkey" on _hyper_198643_2485038_chunk  (cost=0.42..22831.89 rows=1 width=16) (actual time=49.414..49.414 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 514363
                            Buffers: shared hit=19176
                      ->  Index Scan using "2485039_10_realized_activepower_unversioned_pkey" on _hyper_198643_2485039_chunk  (cost=0.42..22510.52 rows=1 width=16) (actual time=45.502..45.502 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 511011
                            Buffers: shared hit=11687
                      ->  Index Scan using "2485040_12_realized_activepower_unversioned_pkey" on _hyper_198643_2485040_chunk  (cost=0.42..24179.59 rows=1 width=16) (actual time=49.174..49.174 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 553131
                            Buffers: shared hit=11388
                      ->  Index Scan using "2485041_14_realized_activepower_unversioned_pkey" on _hyper_198643_2485041_chunk  (cost=0.42..25507.92 rows=1 width=16) (actual time=51.025..51.025 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 581642
                            Buffers: shared hit=11709
                      ->  Index Scan using "2485042_16_realized_activepower_unversioned_pkey" on _hyper_198643_2485042_chunk  (cost=0.42..25038.55 rows=1 width=16) (actual time=50.672..50.672 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 571503
                            Buffers: shared hit=11983
                      ->  Index Scan using "2485043_18_realized_activepower_unversioned_pkey" on _hyper_198643_2485043_chunk  (cost=0.42..22612.71 rows=1 width=16) (actual time=48.424..48.424 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 516225
                            Buffers: shared hit=11343
                      ->  Index Scan using "2485044_20_realized_activepower_unversioned_pkey" on _hyper_198643_2485044_chunk  (cost=0.42..22151.53 rows=1 width=16) (actual time=45.254..45.254 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 505782
                            Buffers: shared hit=10864
                      ->  Index Scan using "2485045_22_realized_activepower_unversioned_pkey" on _hyper_198643_2485045_chunk  (cost=0.42..22154.86 rows=1 width=16) (actual time=44.918..44.918 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 504210
                            Buffers: shared hit=11018
                      ->  Index Scan using "2485046_24_realized_activepower_unversioned_pkey" on _hyper_198643_2485046_chunk  (cost=0.43..65176.29 rows=1 width=16) (actual time=86.672..138.854 rows=3400 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1469536
                            Buffers: shared hit=79732
                      ->  Index Scan using "2485047_26_realized_activepower_unversioned_pkey" on _hyper_198643_2485047_chunk  (cost=0.43..66913.44 rows=1 width=16) (actual time=90.442..145.276 rows=3978 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1497890
                            Buffers: shared hit=86867
                      ->  Index Scan using "2485048_28_realized_activepower_unversioned_pkey" on _hyper_198643_2485048_chunk  (cost=0.43..68048.58 rows=1 width=16) (actual time=96.419..153.659 rows=3726 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1523093
                            Buffers: shared hit=108348
                      ->  Index Scan using "2485049_30_realized_activepower_unversioned_pkey" on _hyper_198643_2485049_chunk  (cost=0.43..69068.97 rows=1 width=16) (actual time=104.231..162.517 rows=3587 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1543496
                            Buffers: shared hit=114499
                      ->  Index Scan using "2485050_32_realized_activepower_unversioned_pkey" on _hyper_198643_2485050_chunk  (cost=0.43..69620.29 rows=1 width=16) (actual time=88.886..143.490 rows=3649 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1581083
                            Buffers: shared hit=48579
                      ->  Index Scan using "2485051_34_realized_activepower_unversioned_pkey" on _hyper_198643_2485051_chunk  (cost=0.43..69934.66 rows=1 width=16) (actual time=94.862..150.148 rows=3468 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1603488
                            Buffers: shared hit=53928
                      ->  Index Scan using "2485052_36_realized_activepower_unversioned_pkey" on _hyper_198643_2485052_chunk  (cost=0.43..70017.86 rows=1 width=16) (actual time=91.354..146.578 rows=3222 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1605738
                            Buffers: shared hit=61240
                      ->  Index Scan using "2485053_38_realized_activepower_unversioned_pkey" on _hyper_198643_2485053_chunk  (cost=0.43..63835.14 rows=1 width=16) (actual time=83.206..133.923 rows=2681 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1460487
                            Buffers: shared hit=59872
                      ->  Index Scan using "2485054_40_realized_activepower_unversioned_pkey" on _hyper_198643_2485054_chunk  (cost=0.43..61650.05 rows=1 width=16) (actual time=81.174..130.849 rows=2937 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1409407
                            Buffers: shared hit=50506
                      ->  Index Scan using "2485055_42_realized_activepower_unversioned_pkey" on _hyper_198643_2485055_chunk  (cost=0.43..62197.02 rows=1 width=16) (actual time=82.368..129.513 rows=3095 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1427703
                            Buffers: shared hit=51562
                      ->  Index Scan using "2485056_44_realized_activepower_unversioned_pkey" on _hyper_198643_2485056_chunk  (cost=0.43..59312.73 rows=1 width=16) (actual time=79.429..127.196 rows=4195 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1355465
                            Buffers: shared hit=50347
                      ->  Index Scan using "2485057_46_realized_activepower_unversioned_pkey" on _hyper_198643_2485057_chunk  (cost=0.43..58610.05 rows=1 width=16) (actual time=78.475..126.082 rows=3357 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1330048
                            Buffers: shared hit=63438
                      ->  Index Scan using "2485058_48_realized_activepower_unversioned_pkey" on _hyper_198643_2485058_chunk  (cost=0.43..58827.55 rows=1 width=16) (actual time=75.810..121.048 rows=3801 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1343457
                            Buffers: shared hit=38854
                      ->  Index Scan using "2485059_50_realized_activepower_unversioned_pkey" on _hyper_198643_2485059_chunk  (cost=0.43..57970.42 rows=1 width=16) (actual time=72.276..117.450 rows=3912 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1328332
                            Buffers: shared hit=27817
                      ->  Index Scan using "2485060_52_realized_activepower_unversioned_pkey" on _hyper_198643_2485060_chunk  (cost=0.43..57643.92 rows=1 width=16) (actual time=72.540..117.149 rows=3422 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1321722
                            Buffers: shared hit=29224
                      ->  Index Scan using "2485061_54_realized_activepower_unversioned_pkey" on _hyper_198643_2485061_chunk  (cost=0.43..59063.60 rows=1 width=16) (actual time=72.444..120.153 rows=3930 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1356336
                            Buffers: shared hit=30244
                      ->  Index Scan using "2485062_56_realized_activepower_unversioned_pkey" on _hyper_198643_2485062_chunk  (cost=0.43..59912.58 rows=1 width=16) (actual time=71.486..122.047 rows=3562 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1381810
                            Buffers: shared hit=35272
                      ->  Index Scan using "2485063_58_realized_activepower_unversioned_pkey" on _hyper_198643_2485063_chunk  (cost=0.43..60495.52 rows=1 width=16) (actual time=72.864..131.154 rows=3734 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1399634
                            Buffers: shared hit=33179
                      ->  Index Scan using "2485064_60_realized_activepower_unversioned_pkey" on _hyper_198643_2485064_chunk  (cost=0.43..60459.92 rows=1 width=16) (actual time=73.681..127.672 rows=3226 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1401194
                            Buffers: shared hit=43976
                      ->  Index Scan using "2485065_62_realized_activepower_unversioned_pkey" on _hyper_198643_2485065_chunk  (cost=0.43..60684.92 rows=1 width=16) (actual time=110.856..187.811 rows=3114 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1388038
                            Buffers: shared hit=502763
                      ->  Index Scan using "2485066_64_realized_activepower_unversioned_pkey" on _hyper_198643_2485066_chunk  (cost=0.43..60702.41 rows=1 width=16) (actual time=88.548..152.769 rows=4232 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1400704
                            Buffers: shared hit=235905
                      ->  Index Scan using "2485067_66_realized_activepower_unversioned_pkey" on _hyper_198643_2485067_chunk  (cost=0.43..61839.55 rows=1 width=16) (actual time=75.854..130.332 rows=3672 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1424935
                            Buffers: shared hit=30545
                      ->  Index Scan using "2485068_68_realized_activepower_unversioned_pkey" on _hyper_198643_2485068_chunk  (cost=0.43..62113.18 rows=1 width=16) (actual time=61.533..126.929 rows=4599 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1427006
                            Buffers: shared hit=30841
                      ->  Index Scan using "2485069_70_realized_activepower_unversioned_pkey" on _hyper_198643_2485069_chunk  (cost=0.42..25691.80 rows=1 width=16) (actual time=52.472..52.472 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 585382
                            Buffers: shared hit=13710
                      ->  Index Scan using "2485070_72_realized_activepower_unversioned_pkey" on _hyper_198643_2485070_chunk  (cost=0.42..26278.55 rows=1 width=16) (actual time=54.209..54.209 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 596140
                            Buffers: shared hit=15985
                      ->  Index Scan using "2485071_74_realized_activepower_unversioned_pkey" on _hyper_198643_2485071_chunk  (cost=0.42..25924.27 rows=1 width=16) (actual time=52.374..52.374 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 589705
                            Buffers: shared hit=14232                            
                      ->  Index Scan using "2485072_76_realized_activepower_unversioned_pkey" on _hyper_198643_2485072_chunk  (cost=0.42..11491.30 rows=1 width=16) (actual time=23.619..23.619 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 260641
                            Buffers: shared hit=7548
                      ->  Index Scan using "2485073_78_realized_activepower_unversioned_pkey" on _hyper_198643_2485073_chunk  (cost=0.42..29792.81 rows=1 width=16) (actual time=65.800..65.800 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 668498
                            Buffers: shared hit=28637
                      ->  Index Scan using "2485074_80_realized_activepower_unversioned_pkey" on _hyper_198643_2485074_chunk  (cost=0.42..29410.22 rows=1 width=16) (actual time=66.963..66.963 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 660205
                            Buffers: shared hit=27298
                      ->  Index Scan using "2485075_82_realized_activepower_unversioned_pkey" on _hyper_198643_2485075_chunk  (cost=0.42..29275.68 rows=1 width=16) (actual time=66.502..66.502 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 655907
                            Buffers: shared hit=29903
                      ->  Index Scan using "2485076_84_realized_activepower_unversioned_pkey" on _hyper_198643_2485076_chunk  (cost=0.42..29742.81 rows=1 width=16) (actual time=64.907..64.907 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 663787
                            Buffers: shared hit=31094
                      ->  Index Scan using "2485077_86_realized_activepower_unversioned_pkey" on _hyper_198643_2485077_chunk  (cost=0.42..29166.57 rows=1 width=16) (actual time=65.238..65.238 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 651568
                            Buffers: shared hit=37023
                      ->  Index Scan using "2485078_88_realized_activepower_unversioned_pkey" on _hyper_198643_2485078_chunk  (cost=0.42..30321.36 rows=1 width=16) (actual time=64.534..64.534 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 675158
                            Buffers: shared hit=32731
                      ->  Index Scan using "2485079_90_realized_activepower_unversioned_pkey" on _hyper_198643_2485079_chunk  (cost=0.42..29845.83 rows=1 width=16) (actual time=64.168..64.168 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 665004
                            Buffers: shared hit=31619
                      ->  Index Scan using "2485080_92_realized_activepower_unversioned_pkey" on _hyper_198643_2485080_chunk  (cost=0.42..30764.16 rows=1 width=16) (actual time=66.046..66.046 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 687463
                            Buffers: shared hit=35882
                      ->  Index Scan using "2485081_94_realized_activepower_unversioned_pkey" on _hyper_198643_2485081_chunk  (cost=0.42..32404.26 rows=1 width=16) (actual time=64.803..71.379 rows=1124 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 723880
                            Buffers: shared hit=37426
                      ->  Index Scan using "2485082_96_realized_activepower_unversioned_pkey" on _hyper_198643_2485082_chunk  (cost=0.42..33844.43 rows=1 width=16) (actual time=67.330..78.047 rows=3916 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 753684
                            Buffers: shared hit=48923
                      ->  Index Scan using "2485083_98_realized_activepower_unversioned_pkey" on _hyper_198643_2485083_chunk  (cost=0.42..28842.94 rows=1 width=16) (actual time=65.112..65.112 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 645592
                            Buffers: shared hit=40715
                      ->  Index Scan using "2485084_100_realized_activepower_unversioned_pkey" on _hyper_198643_2485084_chunk  (cost=0.42..29057.81 rows=1 width=16) (actual time=69.514..69.514 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 644544
                            Buffers: shared hit=53115
                      ->  Index Scan using "2485085_102_realized_activepower_unversioned_pkey" on _hyper_198643_2485085_chunk  (cost=0.43..61099.67 rows=1 width=16) (actual time=60.472..130.804 rows=6199 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1416377
                            Buffers: shared hit=32910
                      ->  Index Scan using "2485086_104_realized_activepower_unversioned_pkey" on _hyper_198643_2485086_chunk  (cost=0.43..61249.80 rows=1 width=16) (actual time=60.324..128.819 rows=6230 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1414774
                            Buffers: shared hit=32853
                      ->  Index Scan using "2485087_106_realized_activepower_unversioned_pkey" on _hyper_198643_2485087_chunk  (cost=0.43..55553.81 rows=1 width=16) (actual time=62.066..126.637 rows=6045 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1362041
                            Buffers: shared hit=33924
                      ->  Index Scan using "2485088_108_realized_activepower_unversioned_pkey" on _hyper_198643_2485088_chunk  (cost=0.43..67253.31 rows=1 width=16) (actual time=99.304..158.597 rows=3687 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1512039
                            Buffers: shared hit=167434
                      ->  Index Scan using "2485089_110_realized_activepower_unversioned_pkey" on _hyper_198643_2485089_chunk  (cost=0.43..60118.71 rows=1 width=16) (actual time=91.585..137.408 rows=3536 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1344926
                            Buffers: shared hit=99151
                      ->  Index Scan using "2485090_112_realized_activepower_unversioned_pkey" on _hyper_198643_2485090_chunk  (cost=0.43..58422.65 rows=1 width=16) (actual time=90.517..132.616 rows=3419 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1311679
                            Buffers: shared hit=98782
                      ->  Index Scan using "2485091_114_realized_activepower_unversioned_pkey" on _hyper_198643_2485091_chunk  (cost=0.43..58797.68 rows=1 width=16) (actual time=87.423..129.936 rows=3218 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1323464
                            Buffers: shared hit=88131
                      ->  Index Scan using "2485092_116_realized_activepower_unversioned_pkey" on _hyper_198643_2485092_chunk  (cost=0.43..64226.88 rows=1 width=16) (actual time=95.184..141.959 rows=3117 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1445384
                            Buffers: shared hit=82532
                      ->  Index Scan using "2485093_118_realized_activepower_unversioned_pkey" on _hyper_198643_2485093_chunk  (cost=0.43..65091.74 rows=1 width=16) (actual time=99.409..152.015 rows=3026 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1458253
                            Buffers: shared hit=102318
                      ->  Index Scan using "2485094_120_realized_activepower_unversioned_pkey" on _hyper_198643_2485094_chunk  (cost=0.43..52266.63 rows=1 width=16) (actual time=78.545..116.608 rows=3873 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1175922
                            Buffers: shared hit=71244
                      ->  Index Scan using "2485095_122_realized_activepower_unversioned_pkey" on _hyper_198643_2485095_chunk  (cost=0.43..53601.77 rows=1 width=16) (actual time=85.456..123.990 rows=3541 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1204848
                            Buffers: shared hit=75289
                      ->  Index Scan using "2485096_124_realized_activepower_unversioned_pkey" on _hyper_198643_2485096_chunk  (cost=0.43..51026.86 rows=1 width=16) (actual time=80.689..116.437 rows=3620 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1148470
                            Buffers: shared hit=68299                            
                      ->  Index Scan using "2485097_126_realized_activepower_unversioned_pkey" on _hyper_198643_2485097_chunk  (cost=0.43..54683.82 rows=1 width=16) (actual time=81.810..121.378 rows=3746 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1235331
                            Buffers: shared hit=76023
                      ->  Index Scan using "2485098_128_realized_activepower_unversioned_pkey" on _hyper_198643_2485098_chunk  (cost=0.43..55217.51 rows=1 width=16) (actual time=84.183..123.748 rows=4168 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1239533
                            Buffers: shared hit=79424
                      ->  Index Scan using "2485099_130_realized_activepower_unversioned_pkey" on _hyper_198643_2485099_chunk  (cost=0.43..55715.82 rows=1 width=16) (actual time=87.184..128.405 rows=3080 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1248087
                            Buffers: shared hit=98165
                      ->  Index Scan using "2485100_132_realized_activepower_unversioned_pkey" on _hyper_198643_2485100_chunk  (cost=0.28..77.03 rows=1 width=16) (actual time=0.159..0.159 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1633
                            Buffers: shared hit=65
                      ->  Index Scan using "2485101_134_realized_activepower_unversioned_pkey" on _hyper_198643_2485101_chunk  (cost=0.28..107.06 rows=1 width=16) (actual time=0.217..0.217 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 2355
                            Buffers: shared hit=107
                      ->  Index Scan using "2485102_136_realized_activepower_unversioned_pkey" on _hyper_198643_2485102_chunk  (cost=0.28..115.88 rows=1 width=16) (actual time=0.236..0.236 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 2544
                            Buffers: shared hit=111
                      ->  Index Scan using "2485103_138_realized_activepower_unversioned_pkey" on _hyper_198643_2485103_chunk  (cost=0.28..106.61 rows=1 width=16) (actual time=0.239..0.240 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 2366
                            Buffers: shared hit=101
                      ->  Index Scan using "2485104_140_realized_activepower_unversioned_pkey" on _hyper_198643_2485104_chunk  (cost=0.28..113.58 rows=1 width=16) (actual time=0.231..0.231 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 2519
                            Buffers: shared hit=107
                      ->  Index Scan using "2485105_142_realized_activepower_unversioned_pkey" on _hyper_198643_2485105_chunk  (cost=0.28..112.88 rows=1 width=16) (actual time=0.231..0.231 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 2527
                            Buffers: shared hit=80
                      ->  Index Scan using "2485106_144_realized_activepower_unversioned_pkey" on _hyper_198643_2485106_chunk  (cost=0.28..111.14 rows=1 width=16) (actual time=0.227..0.228 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 2477
                            Buffers: shared hit=92
                      ->  Index Scan using "2485107_146_realized_activepower_unversioned_pkey" on _hyper_198643_2485107_chunk  (cost=0.28..108.21 rows=1 width=16) (actual time=0.239..0.239 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 2396
                            Buffers: shared hit=73
                      ->  Index Scan using "2485108_148_realized_activepower_unversioned_pkey" on _hyper_198643_2485108_chunk  (cost=0.28..112.50 rows=1 width=16) (actual time=0.226..0.226 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 2496
                            Buffers: shared hit=66
                      ->  Index Scan using "2485109_150_realized_activepower_unversioned_pkey" on _hyper_198643_2485109_chunk  (cost=0.28..124.45 rows=1 width=16) (actual time=0.245..0.245 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 2722
                            Buffers: shared hit=75
                      ->  Index Scan using "2485110_152_realized_activepower_unversioned_pkey" on _hyper_198643_2485110_chunk  (cost=0.28..111.23 rows=1 width=16) (actual time=0.213..0.214 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 2408
                            Buffers: shared hit=46
                      ->  Index Scan using "2485111_154_realized_activepower_unversioned_pkey" on _hyper_198643_2485111_chunk  (cost=0.28..126.41 rows=1 width=16) (actual time=0.239..0.239 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 2778
                            Buffers: shared hit=45
                      ->  Index Scan using "2609291_156_realized_activepower_unversioned_pkey" on _hyper_198643_2609291_chunk  (cost=0.43..45277.85 rows=4865 width=16) (actual time=69.491..134.790 rows=8853 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1335759
                            Buffers: shared hit=49737
                      ->  Index Scan using "2996229_158_realized_activepower_unversioned_pkey" on _hyper_198643_2996229_chunk  (cost=0.43..46980.98 rows=13376 width=16) (actual time=64.961..134.305 rows=12855 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1374658
                            Buffers: shared hit=45067
                      ->  Index Scan using "3294025_160_realized_activepower_unversioned_pkey" on _hyper_198643_3294025_chunk  (cost=0.43..47487.14 rows=13494 width=16) (actual time=64.256..141.326 rows=13435 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1408785
                            Buffers: shared hit=35337
                      ->  Index Scan using "3450540_166_realized_activepower_unversioned_pkey" on _hyper_198643_3450540_chunk  (cost=0.12..2.34 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Buffers: shared hit=1
                      ->  Index Scan using "3699067_168_realized_activepower_unversioned_pkey" on _hyper_198643_3699067_chunk  (cost=0.43..48220.15 rows=4 width=16) (actual time=63.511..138.656 rows=14232 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1427664
                            Buffers: shared hit=37665
                      ->  Index Scan using "4120815_244_realized_activepower_unversioned_pkey" on _hyper_198643_4120815_chunk  (cost=0.43..50019.92 rows=1 width=16) (actual time=69.302..154.414 rows=18120 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1461572
                            Buffers: shared hit=102266
                      ->  Index Scan using "4865080_279_realized_activepower_unversioned_pkey" on _hyper_198643_4865080_chunk  (cost=0.43..52752.60 rows=242298 width=16) (actual time=1.950..205.786 rows=287880 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1239066
                            Buffers: shared hit=211863
                      ->  Index Scan using "5013803_287_realized_activepower_unversioned_pkey" on _hyper_198643_5013803_chunk  (cost=0.43..56061.73 rows=1077618 width=16) (actual time=0.178..282.956 rows=1079491 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 507909
                            Buffers: shared hit=221790
                      ->  Index Scan using "5206472_293_realized_activepower_unversioned_pkey" on _hyper_198643_5206472_chunk  (cost=0.43..68842.71 rows=1757263 width=16) (actual time=0.006..357.411 rows=1756603 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 5762
                            Buffers: shared hit=240835
                      ->  Index Scan using "5332356_3773_realized_activepower_unversioned_pkey" on _hyper_198643_5332356_chunk  (cost=0.43..68380.68 rows=1912087 width=16) (actual time=0.009..393.812 rows=1903143 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Rows Removed by Filter: 1724
                            Buffers: shared hit=213903
                      ->  Index Scan using "5597354_4673_realized_activepower_unversioned_pkey" on _hyper_198643_5597354_chunk  (cost=0.42..11936.20 rows=67691 width=16) (actual time=0.008..89.318 rows=488066 loops=1)
                            Filter: (insertion_date >= '2024-11-03 07:00:46+00'::timestamp with time zone)
                            Buffers: shared hit=23988
        Settings: effective_cache_size = '190GB', effective_io_concurrency = '256', enable_partitionwise_aggregate = 'on', enable_partitionwise_join = 'on', maintenance_io_concurrency = '400', max_parallel_workers = '4', max_parallel_workers_per_gather = '4', plan_cache_mode = 'force_custom_plan', random_page_cost = '1.1', work_mem = '32MB'

I/O stats

Per node type stats

node type	count	sum of times	% of query
Index Scan	97	9,051.553 ms	92.3 %
Limit	1	0.002 ms	0.0 %
Merge Append	2	471.117 ms	4.8 %
Merge Join	1	282.363 ms	2.9 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
_hyper_198643_2485035_chunk	1	143.013 ms	1.5 %
Index Scan	1	143.013 ms	100.0 %
_hyper_198643_2485036_chunk	1	133.692 ms	1.4 %
Index Scan	1	133.692 ms	100.0 %
_hyper_198643_2485037_chunk	1	57.417 ms	0.6 %
Index Scan	1	57.417 ms	100.0 %
_hyper_198643_2485038_chunk	1	49.414 ms	0.5 %
Index Scan	1	49.414 ms	100.0 %
_hyper_198643_2485039_chunk	1	45.502 ms	0.5 %
Index Scan	1	45.502 ms	100.0 %
_hyper_198643_2485040_chunk	1	49.174 ms	0.5 %
Index Scan	1	49.174 ms	100.0 %
_hyper_198643_2485041_chunk	1	51.025 ms	0.5 %
Index Scan	1	51.025 ms	100.0 %
_hyper_198643_2485042_chunk	1	50.672 ms	0.5 %
Index Scan	1	50.672 ms	100.0 %
_hyper_198643_2485043_chunk	1	48.424 ms	0.5 %
Index Scan	1	48.424 ms	100.0 %
_hyper_198643_2485044_chunk	1	45.254 ms	0.5 %
Index Scan	1	45.254 ms	100.0 %
_hyper_198643_2485045_chunk	1	44.918 ms	0.5 %
Index Scan	1	44.918 ms	100.0 %
_hyper_198643_2485046_chunk	1	138.854 ms	1.4 %
Index Scan	1	138.854 ms	100.0 %
_hyper_198643_2485047_chunk	1	145.276 ms	1.5 %
Index Scan	1	145.276 ms	100.0 %
_hyper_198643_2485048_chunk	1	153.659 ms	1.6 %
Index Scan	1	153.659 ms	100.0 %
_hyper_198643_2485049_chunk	1	162.517 ms	1.7 %
Index Scan	1	162.517 ms	100.0 %
_hyper_198643_2485050_chunk	1	143.490 ms	1.5 %
Index Scan	1	143.490 ms	100.0 %
_hyper_198643_2485051_chunk	1	150.148 ms	1.5 %
Index Scan	1	150.148 ms	100.0 %
_hyper_198643_2485052_chunk	1	146.578 ms	1.5 %
Index Scan	1	146.578 ms	100.0 %
_hyper_198643_2485053_chunk	1	133.923 ms	1.4 %
Index Scan	1	133.923 ms	100.0 %
_hyper_198643_2485054_chunk	1	130.849 ms	1.3 %
Index Scan	1	130.849 ms	100.0 %
_hyper_198643_2485055_chunk	1	129.513 ms	1.3 %
Index Scan	1	129.513 ms	100.0 %
_hyper_198643_2485056_chunk	1	127.196 ms	1.3 %
Index Scan	1	127.196 ms	100.0 %
_hyper_198643_2485057_chunk	1	126.082 ms	1.3 %
Index Scan	1	126.082 ms	100.0 %
_hyper_198643_2485058_chunk	1	121.048 ms	1.2 %
Index Scan	1	121.048 ms	100.0 %
_hyper_198643_2485059_chunk	1	117.450 ms	1.2 %
Index Scan	1	117.450 ms	100.0 %
_hyper_198643_2485060_chunk	1	117.149 ms	1.2 %
Index Scan	1	117.149 ms	100.0 %
_hyper_198643_2485061_chunk	1	120.153 ms	1.2 %
Index Scan	1	120.153 ms	100.0 %
_hyper_198643_2485062_chunk	1	122.047 ms	1.2 %
Index Scan	1	122.047 ms	100.0 %
_hyper_198643_2485063_chunk	1	131.154 ms	1.3 %
Index Scan	1	131.154 ms	100.0 %
_hyper_198643_2485064_chunk	1	127.672 ms	1.3 %
Index Scan	1	127.672 ms	100.0 %
_hyper_198643_2485065_chunk	1	187.811 ms	1.9 %
Index Scan	1	187.811 ms	100.0 %
_hyper_198643_2485066_chunk	1	152.769 ms	1.6 %
Index Scan	1	152.769 ms	100.0 %
_hyper_198643_2485067_chunk	1	130.332 ms	1.3 %
Index Scan	1	130.332 ms	100.0 %
_hyper_198643_2485068_chunk	1	126.929 ms	1.3 %
Index Scan	1	126.929 ms	100.0 %
_hyper_198643_2485069_chunk	1	52.472 ms	0.5 %
Index Scan	1	52.472 ms	100.0 %
_hyper_198643_2485070_chunk	1	54.209 ms	0.6 %
Index Scan	1	54.209 ms	100.0 %
_hyper_198643_2485071_chunk	1	52.374 ms	0.5 %
Index Scan	1	52.374 ms	100.0 %
_hyper_198643_2485072_chunk	1	23.619 ms	0.2 %
Index Scan	1	23.619 ms	100.0 %
_hyper_198643_2485073_chunk	1	65.800 ms	0.7 %
Index Scan	1	65.800 ms	100.0 %
_hyper_198643_2485074_chunk	1	66.963 ms	0.7 %
Index Scan	1	66.963 ms	100.0 %
_hyper_198643_2485075_chunk	1	66.502 ms	0.7 %
Index Scan	1	66.502 ms	100.0 %
_hyper_198643_2485076_chunk	1	64.907 ms	0.7 %
Index Scan	1	64.907 ms	100.0 %
_hyper_198643_2485077_chunk	1	65.238 ms	0.7 %
Index Scan	1	65.238 ms	100.0 %
_hyper_198643_2485078_chunk	1	64.534 ms	0.7 %
Index Scan	1	64.534 ms	100.0 %
_hyper_198643_2485079_chunk	1	64.168 ms	0.7 %
Index Scan	1	64.168 ms	100.0 %
_hyper_198643_2485080_chunk	1	66.046 ms	0.7 %
Index Scan	1	66.046 ms	100.0 %
_hyper_198643_2485081_chunk	1	71.379 ms	0.7 %
Index Scan	1	71.379 ms	100.0 %
_hyper_198643_2485082_chunk	1	78.047 ms	0.8 %
Index Scan	1	78.047 ms	100.0 %
_hyper_198643_2485083_chunk	1	65.112 ms	0.7 %
Index Scan	1	65.112 ms	100.0 %
_hyper_198643_2485084_chunk	1	69.514 ms	0.7 %
Index Scan	1	69.514 ms	100.0 %
_hyper_198643_2485085_chunk	1	130.804 ms	1.3 %
Index Scan	1	130.804 ms	100.0 %
_hyper_198643_2485086_chunk	1	128.819 ms	1.3 %
Index Scan	1	128.819 ms	100.0 %
_hyper_198643_2485087_chunk	1	126.637 ms	1.3 %
Index Scan	1	126.637 ms	100.0 %
_hyper_198643_2485088_chunk	1	158.597 ms	1.6 %
Index Scan	1	158.597 ms	100.0 %
_hyper_198643_2485089_chunk	1	137.408 ms	1.4 %
Index Scan	1	137.408 ms	100.0 %
_hyper_198643_2485090_chunk	1	132.616 ms	1.4 %
Index Scan	1	132.616 ms	100.0 %
_hyper_198643_2485091_chunk	1	129.936 ms	1.3 %
Index Scan	1	129.936 ms	100.0 %
_hyper_198643_2485092_chunk	1	141.959 ms	1.4 %
Index Scan	1	141.959 ms	100.0 %
_hyper_198643_2485093_chunk	1	152.015 ms	1.6 %
Index Scan	1	152.015 ms	100.0 %
_hyper_198643_2485094_chunk	1	116.608 ms	1.2 %
Index Scan	1	116.608 ms	100.0 %
_hyper_198643_2485095_chunk	1	123.990 ms	1.3 %
Index Scan	1	123.990 ms	100.0 %
_hyper_198643_2485096_chunk	1	116.437 ms	1.2 %
Index Scan	1	116.437 ms	100.0 %
_hyper_198643_2485097_chunk	1	121.378 ms	1.2 %
Index Scan	1	121.378 ms	100.0 %
_hyper_198643_2485098_chunk	1	123.748 ms	1.3 %
Index Scan	1	123.748 ms	100.0 %
_hyper_198643_2485099_chunk	1	128.405 ms	1.3 %
Index Scan	1	128.405 ms	100.0 %
_hyper_198643_2485100_chunk	1	0.159 ms	0.0 %
Index Scan	1	0.159 ms	100.0 %
_hyper_198643_2485101_chunk	1	0.217 ms	0.0 %
Index Scan	1	0.217 ms	100.0 %
_hyper_198643_2485102_chunk	1	0.236 ms	0.0 %
Index Scan	1	0.236 ms	100.0 %
_hyper_198643_2485103_chunk	1	0.240 ms	0.0 %
Index Scan	1	0.240 ms	100.0 %
_hyper_198643_2485104_chunk	1	0.231 ms	0.0 %
Index Scan	1	0.231 ms	100.0 %
_hyper_198643_2485105_chunk	1	0.231 ms	0.0 %
Index Scan	1	0.231 ms	100.0 %
_hyper_198643_2485106_chunk	1	0.228 ms	0.0 %
Index Scan	1	0.228 ms	100.0 %
_hyper_198643_2485107_chunk	1	0.239 ms	0.0 %
Index Scan	1	0.239 ms	100.0 %
_hyper_198643_2485108_chunk	1	0.226 ms	0.0 %
Index Scan	1	0.226 ms	100.0 %
_hyper_198643_2485109_chunk	1	0.245 ms	0.0 %
Index Scan	1	0.245 ms	100.0 %
_hyper_198643_2485110_chunk	1	0.214 ms	0.0 %
Index Scan	1	0.214 ms	100.0 %
_hyper_198643_2485111_chunk	1	0.239 ms	0.0 %
Index Scan	1	0.239 ms	100.0 %
_hyper_198643_2609291_chunk	1	134.790 ms	1.4 %
Index Scan	1	134.790 ms	100.0 %
_hyper_198643_2996229_chunk	1	134.305 ms	1.4 %
Index Scan	1	134.305 ms	100.0 %
_hyper_198643_3294025_chunk	1	141.326 ms	1.4 %
Index Scan	1	141.326 ms	100.0 %
_hyper_198643_3450540_chunk	1	0.005 ms	0.0 %
Index Scan	1	0.005 ms	100.0 %
_hyper_198643_3699067_chunk	1	138.656 ms	1.4 %
Index Scan	1	138.656 ms	100.0 %
_hyper_198643_4120815_chunk	1	154.414 ms	1.6 %
Index Scan	1	154.414 ms	100.0 %
_hyper_198643_4865080_chunk	1	205.786 ms	2.1 %
Index Scan	1	205.786 ms	100.0 %
_hyper_198643_5013803_chunk	1	282.956 ms	2.9 %
Index Scan	1	282.956 ms	100.0 %
_hyper_198643_5206472_chunk	1	357.411 ms	3.6 %
Index Scan	1	357.411 ms	100.0 %
_hyper_198643_5332356_chunk	1	393.812 ms	4.0 %
Index Scan	1	393.812 ms	100.0 %
_hyper_198643_5597354_chunk	1	89.318 ms	0.9 %
Index Scan	1	89.318 ms	100.0 %
_hyper_214910_3361319_chunk	1	4.269 ms	0.0 %
Index Scan	1	4.269 ms	100.0 %
_hyper_214910_3369312_chunk	1	0.032 ms	0.0 %
Index Scan	1	0.032 ms	100.0 %
_hyper_214910_3699068_chunk	1	8.443 ms	0.1 %
Index Scan	1	8.443 ms	100.0 %
_hyper_214910_4120816_chunk	1	14.099 ms	0.1 %
Index Scan	1	14.099 ms	100.0 %
_hyper_214910_4878553_chunk	1	55.334 ms	0.6 %
Index Scan	1	55.334 ms	100.0 %
_hyper_214910_5013804_chunk	1	31.895 ms	0.3 %
Index Scan	1	31.895 ms	100.0 %
_hyper_214910_5206473_chunk	1	22.667 ms	0.2 %
Index Scan	1	22.667 ms	100.0 %
_hyper_214910_5348084_chunk	1	44.714 ms	0.5 %
Index Scan	1	44.714 ms	100.0 %
_hyper_214910_5597355_chunk	1	13.271 ms	0.1 %
Index Scan	1	13.271 ms	100.0 %

explain.anayrat.info

PostgreSQL's explain analyze made readable

Result: ge

Color mode:

Visible columns:

I/O stats

Per node type stats

Per table stats