Any tool to analyze JQL performance?

[LaBulle22]

Hi all,

Does Jira offer any tool to help an end user (i.e., not an admin) fine-tune their JQL? Let's suppose a complex JQL query composed of a mix of filters, sub-filters, issue functions, AND/OR clauses, etc., that runs a bit too slowly from my point of view. I'd like Jira to show me how it processes my request, providing the processing time for each step so that I can try to optimize the slowest ones.

Regards,
Bruno

[Marc - Devoteam · Accepted solution]

Hi @LaBulle22 

This is not possible in Cloud as there is not access to logging or the DB.

You will need to structurally dismantle your complex JQL in parts and find the slow part.

jql-optimization-recommendations 

[LaBulle22]

Hi Marc,

Thank you for your answer event if that's the one I was afraid of getting!

[LaBulle22 · Accepted solution]

Hi @Marc - Devoteam

I was wrong, when I said we are using Jira Cloud. Actually, we are using Jira Data Center that is no longer is our premises hence my confusion.

Would that change your answer? Please remind my question was from a standard user (like me) point of view, not an admin one.

[Marc - Devoteam]

Hi @LaBulle22 

There should be a slow queries log file on the server running Jira.

Here you can find slow running JQL queries.

[LaBulle22]

Hi @Marc - Devoteam 

Thanks.