# Can I reset all statistics?

**URL:** <https://forums.plex.tv/t/can-i-reset-all-statistics/409381>\
**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:** 1\
**Showing post:** 4

<div class="post-metadata">

**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")

</div>

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.

---

_[View the full topic](https://forums.plex.tv/t/can-i-reset-all-statistics/409381)._