Cannot load history anywhere in HA - "loading state history..."

same on my System. Raspberry Pi 3B+ 32bit running on 0.82.1)
sometimes i see the history graph, but then i can not scroll down on the page and the browser window freeze, or the graph is not not loading.
In both cases i have to restart the browser (Chrome latests Version).
Home screen is loading normal, also all other functions are working, only the history is dead.

my history have atm 4gigs

Same problem here

same here, when I try to open history system, is going to crash
my db is 825MB

I am also having same issues with HA which is causing my HA to hang.
I have a raspberry Pi 3b+ with HASSIO running HassOS 1.13 (64 bit) and home assistant 84.6 when i select the history tab the processor temperature increases towards 60 degrees with an increase in processor load and the whole thing hangs and I have to unplug the pi and plug it back in.
When i plug it in it shows the increase in temperature and processor load then the return to reasonable level. If i ping the IP i get significant delays in response from typical 3.5ms increasing to thousands of ms. i cannot SSH in when it gets in this state.
There are no entries in the log to show any problems, but it seems to get in a state where the processor is unable to cope with the demands.

Any ideas gratefully received.

Switching to an external database rather than sqlite helps, if you haven’t done it already.

Still have this problem… Also my db is read only. Is this connected?