It’s normal for the current month to grow significantly and then essentially be condensed every 30 days? So I’d expect it to grow over 30 days and then on a rolling basis its condensed? I didn’t delete all the data. I only deleted May data and January data.
The “problem” as I see it, I was not on the Beta update so I shouldn’t have received 1.41.7.9784. I only turned it on to received the 1.41.7.9795 update. My DB went from 248Mb to 11 GB
@Yaracuy you can just group by a date/time (or 30 days previous) and delete.
DELETE FROM statistics_bandwidth
WHERE strftime('%Y-%m', datetime(at, 'unixepoch')) = '2025-05';
It seems like deleting these statistics will caused usage stats to incorrectly reported for users.
Edit: Despite not selecting the beta channel I absolutely have a crash report for 1.41.7.9784 so that definitely is the culprit. I’m just wondering if the currently growing May (ok last 30 days) will actually shrink. The DB doubled from watching 2 hours and as shown above, that last 2 hours was responsible for 76% of rows in the table.
