mindersec / minder

Software Supply Chain Security Platform
https://minder-docs.stacklok.dev/
Apache License 2.0
295 stars 43 forks source link

Investigate high latency calls to ListEvaluationResults #4511

Open eleftherias opened 2 months ago

eleftherias commented 2 months ago

We've been getting alerts that ListEvaluationResults has had high latency. It's possible there's a user with several evaluation results, which causes this endpoint to be slow.

Let's find the maximum number of evaluation results for our current users, and recreate a profile with a similar number of alerts. We should time that and see if it is fast enough or how we can improve it.

Example alert https://stacklok.slack.com/archives/C073VMA1PB2/p1726583917065719

jhrozek commented 2 months ago

@blkt didn't you fix this with adding the indexes?