The spy_oms_transition_log table takes up too much space

The 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.

Cause

By default, nothing limits the table size or deletes old records.

Solution

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;