Before the update from 6.4.15 to 7.0.0, housekeeper took about 5 seconds, after the update about 2 hours. Database version postgresql14-14.12, timescaledb-2-postgresql-14-2.10.3. Setting for housekeeper are not changed.

I have identified a potential misconfiguration in the Zabbix housekeeper settings. It appears that the housekeeper frequency value is being used as the limit in a SELECT query. This behavior seems incorrect. 

The issue seems to be in file housekeeper_server.c:

Definition of function housekeeping_events(int now, int config_max_hk_delete) <<< second param is MaxHousekeeperDelete

Calling housekeeping_events(now, housekeeper_args_in->config_housekeeping_frequency); <<< second param is HousekeepingFrequency

Tested by changing values in zabbix server configuration:

• Default values: HousekeepingFrequency=1 and MaxHousekeeperDelete=5000

  select eventid from events where clock<1720007049 and events.source=3 and events.object=0 and not exists(select null from problem where events.eventid=problem.eventid) and not exists(select null from problem where events.eventid=problem.r_eventid) order by eventid limit 1

   

• Changed values: HousekeepingFrequency=2 and MaxHousekeeperDelete=10000

  select eventid from events where clock<1720442002 and events.source=3 and events.object=0 and not exists(select null from problem where events.eventid=problem.eventid) and not exists(select null from problem where events.eventid=problem.r_eventid) order by eventid limit 2

i have the same issue sinse upgrading to 7

Same issue for me. I upgraded from Zabbix 6 to 7 in Docker.

housekeeper-6.2.1.txthousekeeper-7.2.5.txt

The same problem after upgrading from 6.2.1 to 7.2.5

The difference  is 
for 6.2.1 "deleted 4794734 hist/trends... in 599.316635 sec"
for 7.2.5 "deleted 8327100 hist/trends... in 7135.690522 sec"

Hello.
So in the last example you are deleting almost 2x values than on 6.2.1...
Is the DB tuned?
Overall, based upon the amount of values deleted, you are collecting overall around 2k NVPS values every second.
For such environments partitioning is required.