Plex Database sqlite file has more than doubled in 10 days

Plex Media Server Desktops & Laptops
28

The excessive number of entries is a bug.

Precisely. Or the opposite, to avoid hearing the same tracks too often.
See [HowTo] Create Playlists