haha, OK, final conclusion. It ran pretty quickly, and it did clear my logbook, but… it didn’t have an effect on the database size. Still 1.5GB. (and yes, Repack was checked)
I dug a little deeper and installed the SQLite web add-on as well - via this thread: How to keep your recorder database size under control - Community Guides - Home Assistant Community (home-assistant.io) - I ran the query to find the size of all tables, and they were all under 1MB at most. Strange.
One more Google for how to make SQLite compact itself, and I found the “VACUUM” query. So I simply ran the query:
VACUUM;
And voila, instantly:
Great success. 