My home-assistant_v2.db was gigantic and it was my fault
As a Home Assistant noob, there's some things that I'm just destined not to learn until I experience them and one such thing is that I should disable things I don't use on devices I use. I have a bunch of presence sensors in my house and they were essentially spamming my logs with the motion state, something I never need as I only ever need to know whether a room is occupied or not.
Anyway, I didn't think anything of the log spam until I did a backup, in two weeks my backup went from 5mb to 0.5gb I was like WTF? I digress... a quick search said it was safe to delete and it would be recreated automatically, so I did and now it's back to 5mb and obviously I disabled all of the extraneous logging elements disabled. Since disabling wasn't enough.
Just sharing what I learned.