The spy_oms_transition_log table takes up too much spaceEdit on GitHub
spy_oms_transition_log table stores the history of order management system transitions. The logs are kept for debugging reasons. If you don’t need them or you have backed them up, you can remove them.
Table manipulations can affect a shop greatly. It is not safe to do so, and we recommend double-checking all the details before you proceed. The instructions below can help you solve a storage space issue. Make sure to follow them exactly.
By default, nothing limits the table size or deletes old records.
Schedule the following SQL query to delete all the logs older than 90 days. You can adjust the time interval per your requirements.
DELETE FROM spy_oms_transition_log WHERE created_at < CURRENT_DATE - interval '90' day;
For submitting the form