The spy_oms_transition_log table takes up too much space

Edit on GitHub

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.

Manipulating tables

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.

	created_at < CURRENT_DATE - interval '90' day;