Implement a "Fix All" button in "Developer Tools > Statistics" to remove orphaned IDs #12644
Replies: 24 comments 2 replies
-
|
Would be great to have this. I disabled a lot of entities which produced many thousand rows in the database (including statistics and statistics_short_term tables) which I want to remove now. Note that I disabled them, they are not deleted. Overview of current situation (scenarios and options) and other related feature requests: |
Beta Was this translation helpful? Give feedback.
-
|
This is some pretty low hanging fruit as far as I can see - something that with a small amount of work reaps great rewards |
Beta Was this translation helpful? Give feedback.
-
|
...nevertheless unfortunately nobody seems to be willing or able to do that small amout of work. |
Beta Was this translation helpful? Give feedback.
-
|
Ping & Push |
Beta Was this translation helpful? Give feedback.
-
|
I also ran into this Issue with one of my statistics, would be a great feature! |
Beta Was this translation helpful? Give feedback.
-
|
Home Assistant have terrible stuff going on under the hood. This is an example of amateurism. Home automation is to save time but now all the users have to delete 1 by 1 thousands of leftovers. This is terrible. |
Beta Was this translation helpful? Give feedback.
-
|
would be great to have this feature. |
Beta Was this translation helpful? Give feedback.
-
|
+1 in need it ! |
Beta Was this translation helpful? Give feedback.
-
|
+1 love it! |
Beta Was this translation helpful? Give feedback.
-
|
please.... |
Beta Was this translation helpful? Give feedback.
-
|
Would be a great help.. thanks in advance |
Beta Was this translation helpful? Give feedback.
-
|
+1 please |
Beta Was this translation helpful? Give feedback.
-
|
+1 I am using autoclicker for an hour now :D |
Beta Was this translation helpful? Give feedback.
-
|
Same her, would be more than happy if someone could implement a "purge all orphaned statistics" button. Thanks in advance. |
Beta Was this translation helpful? Give feedback.
-
|
Seems this community guide mentioned in the original post no longer exists or has been made private |
Beta Was this translation helpful? Give feedback.
-
Here's a snapshot: https://web.archive.org/web/20230401222744/https://community.home-assistant.io/t/statistics-fix-issue-large-amount-of-data/419728 |
Beta Was this translation helpful? Give feedback.
-
|
I vote for this as well. I got over 1500 entries that need to be done. FIX ALL would be nice. |
Beta Was this translation helpful? Give feedback.
-
|
In 2024.10 you can mass delete statistics in developer-tools. |
Beta Was this translation helpful? Give feedback.
and others
-
Could it be possible in a future release to implement a “Fix All” button in the “Developer Tools > Statistics” to clean up all orphaned IDs?
If we face a lot of statistic issues to be fixed (in my case about 7000), and we don’t want to bother by clicking thousands of times the “Fix Issue” button, and clicking the “Remove” button in the dialog then a “Fix All” button could useful.
I was able to clean it manually and wrote a little how-to in community guides, however a “Fix All” button might be safer than going to modify it directly within the database.
Beta Was this translation helpful? Give feedback.
All reactions