nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Any tool to analyze JQL performance?

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

Accepted answers

Marc -Devoteam-

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

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.

All comments

Marc -Devoteam-

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

Hi Marc,

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

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-

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

Here you can find slow running JQL queries.

Hi @Marc -Devoteam-

Thanks.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

jql

performance