my db file grew to 31GB. Attempting to follow the suggestions here, 3+ hours later there was still no measurable progress.
Here is what actually worked: (~15min to finish for me)
(changing the journal_mode from wal to delete, running the delete, vacuuming, then changing it back.)
"C:\Program Files\Plex\Plex Media Server\Plex SQLite.exe" "%LOCALAPPDATA%\Plex Media Server\Plug-in Support\Databases\com.plexapp.plugins.library.db"
pragma journal_mode=delete;
DELETE FROM statistics_bandwidth WHERE account_id is NULL;
VACUUM;
pragma journal_mode=wal;
.quit
