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"