Server Version#: plexmediaserver_1.24.4.5081-e362dc1ee_amd64 Player Version#: various DB re-created in June around 3k movies/TV episodes 1 regular user that plays <5 items per week DB is 40GB 1 211 708 001 entries in the STATISTICS_MEDIA table Half a million records for each media item. I see …

Running a database optimize should fix this if it’s related to the previously mentioned bug. Settings → Troubleshooting → Optimize Database

Hi. Plex team will not fix it and will not answer. I just removed statistics table from DB ~ year ago and forgot about this issue (sometimes I can see warnings in log - “statistics table does not exist, bla bla bla …”).

The above linked issue was a side effect of a client in the local network which was not signed into the plex account. But a fix for this should already be in your server release. Do you let your server perform its maintenance routine during the night? If not, do it.

Very interesting, I thought I want to try deleting the records that have no account_id (NULL) via command line sqlite that comes with plex. That took forever for just 100 records, so I transferred it onto my desktop machine and used the sqlite browser to do the same. Deleting 1m records takes around…

1.2 billion records in STATISTICS_MEDIA

Plex Media Server

dane22 October 26, 2021, 11:56am 3

Maybe: Plex Database sqlite file has more than doubled in 10 days

Topic		Replies	Views
Database size is 12GB and there are 140 millions rows in statistics_media table Plex Media Server server-synology	7	486	January 5, 2021
Plex Database sqlite file has more than doubled in 10 days Plex Media Server server-linux	94	2752	October 1, 2021
Plex optimization causes indefinite loss of access Plex Media Server server-windows	3	185	August 27, 2025
[SOLVED] Database Size Suddenly 13 GIG Plex Media Server server-linux , server-synology , plex-web	5	281	August 26, 2025
Plugin library 78gb Plex Media Server server-mac	2	142	July 14, 2022

1.2 billion records in STATISTICS_MEDIA

Related topics