Gavin
09/27/2021, 4:59 PMTomas Touceda
09/27/2021, 5:01 PMGavin
09/27/2021, 5:03 PMpolicies/manage
Tomas Touceda
09/27/2021, 5:03 PMGavin
09/27/2021, 5:03 PMTomas Touceda
09/27/2021, 5:04 PMselect count(*) from policy_membership_history
?Gavin
09/27/2021, 5:04 PMTomas Touceda
09/27/2021, 5:05 PMGavin
09/27/2021, 5:05 PMTomas Touceda
09/27/2021, 5:07 PMGavin
09/27/2021, 5:07 PMTomas Touceda
09/27/2021, 5:07 PMGavin
09/27/2021, 5:08 PMTomas Touceda
09/27/2021, 5:09 PMGavin
09/27/2021, 5:11 PMTomas Touceda
09/27/2021, 5:13 PMdelete from policies
should do the trick, and you can also clear the history with:
delete from policy_membership_history
Gavin
09/27/2021, 5:13 PMTomas Touceda
09/27/2021, 5:27 PMGavin
09/27/2021, 5:52 PMselect count(*) from policy_membership_history
may have an exceptionally high number of results in it as it’s currently hung until timeout.SELECT table_rows
-> FROM information_schema.tables
-> WHERE table_name='policy_membership_history';
+------------+
| table_rows |
+------------+
| 36844359 |
+------------+
1 row in set (0.04 sec)
Tomas Touceda
09/27/2021, 5:57 PM