Actual Results:

There is a performance degradation in the Queue display, when using the clause: ORDER BY "Time to resolution"

In a large Service Desk, with more than 30000 requests, a Queue with 300 requests is taking a huge delay of 40s to return the JQL result when using ORDER BY "Time to resolution".

Steps to reproduce:

1. Create a Service Desk
2. Populate it with 30k requests
3. Set up a queue that will take more than 300 requests and add ORDER BY "Time to resolution" to the JQL of the Queue.
4. Load the queue.

Expected Results:

JIRA Service Desk loads the Queue without major delays.

Workaround:

Remove the clause from the JQL, when removing the ORDER BY "Time to resolution" the Queue displays immediately.