GetJobs query performance

[sgwozdz]

Hey I was looking into some metrics and I noticed this query could be much faster.

I did some tests, and I was able to get quite a performance boost by a simple change. If you're ok with it I can prepare a pull request with the change.
With my dataset it went down from ~4 seconds to ~500ms.

[azygis]

Sure, performance improvements are always welcome!

[chaitanya-swimlane]

hi @sgwozdz , could you share the updated query that improved the performance. We are running into a similar issue with getting Jobs, and this could help us.