Large amount of unknown records in sys_choice table

[Jonas23]

While troubleshooting performance complaints when opening a specific catalog item on the Service Portal, I noticed our sys_choice table contained more than 400,000 records.
After looking closer, there are more than 300,000 records which all contain a variation of "sys_hub_action_output" or "sys_hub_action_input".

These were all created by system on the same weekend we upgraded from quebec patch 7h2 to rome patch2.
Where are these records coming from? They are causing a noticable performance impact on a few of our requests on our portal

[Jonas23]

I've created a case for Hi, I will update this post with any updates should other people also run into this issue

[eumak]

Hey Jonas,
Looking forward to know the main reason.


Cheers..!
Happy Learning:)
Tushar

[Jonas23 · Accepted solution]

The case was resolved, it seems as if these records are indeed valid choices in integration hub spokes, and they were not the root cause of the slow performing service catalog.