# Can I reset all statistics? **URL:** \ **Category:** General Discussions\ **Created:** [May 8, 2019, 11:28am UTC](https://forums.plex.tv/t/can-i-reset-all-statistics/409381 "2019-05-08T11:28:42Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![VarHyid](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/varhyid/32/132192_2.png) [@VarHyid](https://forums.plex.tv/u/VarHyid)\ **Post date:** [May 8, 2019, 11:28am UTC](https://forums.plex.tv/t/can-i-reset-all-statistics/409381/1 "2019-05-08T11:28:42Z")
I’ve been testing Plex in the last few days, partially playing stuff and now I want to start using it “for real” and reset all the stats gathered during the tests - is this possible? Note - I’m mainly talking about the view statistics in the Dashboard, I know that I can mark any movie I started as “unwatched” to reset its progress, but I can’t find any “delete user stats” option. BTW, I wouldn’t want to delete the user and create a new one because… the user is me, I’m the admin and don’t want to wait a month before I can recreate the account (which I also paid for, though that’s not the main issue as I’m planning to cancel the subscription anyway and get the lifetime pass 🙂). ---
**Author:** ![OttoKerner](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ottokerner/32/10079_2.png) [@OttoKerner](https://forums.plex.tv/u/OttoKerner)\ **Post date:** [May 8, 2019, 11:50am UTC](https://forums.plex.tv/t/can-i-reset-all-statistics/409381/2 "2019-05-08T11:50:08Z")
There is no need to cancel the subscription or erase the account if you want to go from monthly to lifetime. [https://plex.tv/subscription](https://plex.tv/subscription) The only way to erase the statistics is to edit the database directly (i.e. from outside of the Plex user interface). I am waiting for detailed info in that. ---
**Author:** ![VarHyid](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/varhyid/32/132192_2.png) [@VarHyid](https://forums.plex.tv/u/VarHyid)\ **Post date:** [May 8, 2019, 12:11pm UTC](https://forums.plex.tv/t/can-i-reset-all-statistics/409381/3 "2019-05-08T12:11:14Z")
I paid via PayPal so I was referring to just canceling the monthly payment authorization there and of course I do NOT want to delete the account - that’s the whole point. I know I could probably wipe the stats by deleting the account which I don’t wanna do. Anyway, let me know once you have the details, I’m guessing it’ll be somewhere in C:\Users\username\AppData\Local\Somethingsomething…? ---
**Author:** ![OttoKerner](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ottokerner/32/10079_2.png) [@OttoKerner](https://forums.plex.tv/u/OttoKerner)\ **Post date:** [May 8, 2019, 1:10pm UTC](https://forums.plex.tv/t/can-i-reset-all-statistics/409381/4 "2019-05-08T13:10:28Z")
You will be needing either the SQLite tools (command line) or you use any other GUI SQLite editor. I use [sqlitebrowser.org](http://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/](https://support.plex.tv/articles/201100678-repair-a-corrupt-database/) Statistics are in 4 tables inside the [main database file](https://support.plex.tv/articles/201100678-repair-a-corrupt-database/) 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. ---
**Author:** ![system](https://global.discourse-cdn.com/plex/original/3X/2/a/2acb9765406f63293d357b4ec509ec39aa28f2ad.png) [@system](https://forums.plex.tv/u/system)\ **Post date:** [August 6, 2019, 1:10pm UTC](https://forums.plex.tv/t/can-i-reset-all-statistics/409381/5 "2019-08-06T13:10:30Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed. ---
**Author:** ![OttoKerner](https://sea1.discourse-cdn.com/plex/user_avatar/forums.plex.tv/ottokerner/32/10079_2.png) [@OttoKerner](https://forums.plex.tv/u/OttoKerner)\ **Post date:** [December 13, 2019, 11:23am UTC](https://forums.plex.tv/t/can-i-reset-all-statistics/409381/6 "2019-12-13T11:23:05Z")
I want to add that deleting the user account or cancelling the monthly Plex Pass payment will **not** erase the playback history from your server’s database.