Server Version#: Version 1.19.5.3112 Player Version#: PlexWeb Version 4.34.3 First, I want to know if I should be worried. [ Databases]$ pwd /var/lib/plexmediaserver/Library/Application Support/Plex Media Server/Plug-in Support/Databases [ Databases]$ ls -l total 8215848 -rw-rw-r--. 1 plex plex …

[image] Volts: It’s possible that I was experiencing something more like what @philipsw mentioned Yeah, it was really odd. Whenever I remove media from my library (and sometimes just 'cause) I perform a manual database optimization. It normally takes seconds to complete (small libraries), b…

As I read the various comments I still have one nagging question - what exactly is being tracked by this table? How are the statistics ‘manifest’ or ‘viewed’ in Plex? Is it really just watch history by client? What I’ve collected so far is: It gets written to often if any client is open It is u…

[image] danielg1976: It gets written to often if any client is open My experience is that, under normal circumstances, this table is only written to when media is played, not just by virtue of having a client open. It tracks the type of media played, the account that played it, a count, and …

[image] danielg1976: It gets written to often if any client is open That’s statistics_bandwidth. An open client checks in frequently, which causes a little bit of bandwidth usage. The statistics_* tables are definitely used to populate the Bandwidth and Play History graphs on Status → Dashb…

I keep pondering this. Okay, so if it is watch history, how come 99.9% of the entries are all written with a timestamp of the first day of the month, at midnight? In fact, I can’t find an entry that isn’t written with a midnight timestamp. Wouldn’t they have much more random timestamps, like when…

The excessive number of entries is a bug. [image] danielg1976: like a playlist of everything I have listened to within the last 30 days Precisely. Or the opposite, to avoid hearing the same tracks too often. See [HowTo] Create Playlists

Wait, I think i realize that since these are STATS they are being compiled by plex server? Not necessarily being written right when something happens? So in that case the exact timestamp may be when data was compiled or less important…

[image] danielg1976: Okay, so if it is watch history, how come 99.9% of the entries are all written with a timestamp of the first day of the month, at midnight? The lowest time duration of the filters in those tables in the dashboard is seven days so it doesn’t need to track the actual time p…

These could very well be caused by a server bug, yes

[image] danielg1976: how come 99.9% of the entries are all written with a timestamp of the first day of the month, at midnight I’m not convinced these are “play history” at all. I think they’re truly statistics. Rolled up into daily/weekly/monthly, periodically, so that the database doesn’t …

Plex Database sqlite file has more than doubled in 10 days

Plex Media Server

OttoKerner August 22, 2020, 8:44pm 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

Topic		Replies	Views
Slow library performance due to increasingly growing database Plex Media Server server-linux	77	2999	May 23, 2022
Library.db size more than doubled in latest version Plex Media Server server-windows , server-linux	432	14954	March 6, 2026
DB locks and wait times Plex Media Server server-linux , server-docker	56	1006	March 13, 2022
Slow Query time - unable to scan or play media Plex Media Server server-linux	65	1781	February 22, 2022
Calling all users with MASSIVE libraries Plex Media Server server-linux	24	476	May 12, 2022

Plex Database sqlite file has more than doubled in 10 days

Related topics