You will be needing either the SQLite tools (command line)
or you use any other GUI SQLite editor. I use sqlitebrowser.org
You must stop Plex server from running before doing any manipulations on the database.
(on Windows, ‘Exit’ Plex server using the tray bar icon. Closing the web browser window is not enough!)
Make a backup copy of the DB file before you do anything.
It can’t hurt to perform the ‘DB check’ steps from the ‘repair database’ procedure before doing anything else. https://support.plex.tv/articles/201100678-repair-a-corrupt-database/
Statistics are in 4 tables inside the main database file
The statistics_* tables - are used for all the graphs
The metadata_item_views - used for all the ‘top’ playbacks etc.
Don’t erase the tables. Only empty them out.
SQL command is DELETE FROM table_name
General advise is to not nuke things from the metadata_item_views tables (given it is the server playback history) but it should be ok to do so.
But don’t make a habit of it.
