flowd_aggregate.py high CPU usage

[neillans]

I've been noticing that flowd_aggregate.py script is pushing my opnsense hard of late.
I've tried a reset of the data but it reoccurs after a few days.

Any reasons to this? It's not consistent, nor does there appear to be any real pattern to it.
Didn't appear pre 19.1.4.

Hardware is a PC Engines apu4c4:
4GB RAM
AMD GX-412TC SOC (1Ghz)

[rantwolf]

Hi.
Good question.
After update from 19.1.3 to 19.1.4 my database was killed.
When I reset the data the script needs a lot of cpu load but only for one hour.

My OPNsense machines are on Celeron J3455 and Core i5 5300U.
The AMD SOC is not the fastest and needs a bit more of time.