28 GB com.plexapp.plugins.library.db file - is this normal? Seemingly causing unresponsiveness

[pshanew]

Have a look at the statistics_media table in your database and see if there are many relatively recent writes with a null account_id column. If so, you may be able to mitigate the issue by deleting those entries. See this thread for (much) more detail:

Plex Database sqlite file has more than doubled in 10 days

I experienced this issue several months ago. I noticed it because database optimization on my system went from completing in 4 - 5 seconds to several minutes. This prompted me to check my database size and it had ballooned by an order of magnitude. I used sqldiff to compare the current DB with a normal-sized backup and found that the table statistics_media was being written to constantly, even with no server usage. Examining the database further, I found that these “rogue” additions were bei…

This tool may be useful:
https://sqlitebrowser.org

Make sure to stop Plex Media Server before making any modifications to your database. And be sure to make a copy first.