JQL execution time

AbrahamA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 25, 2013

Hi

Is there a way we can know how long a particular JQL query took to complete.

I have a situation where I have 20,000 + issues, I have 2 options:

1. Get all issues and loop through to get stats I want..

2. Make 4-5 JQL queries and get stats

Not sure which one is faster..

Any suggestions please let me know?

Thanks

Abe

1 answer

0 votes
Aseem Parikh
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 25, 2013

You can enable profiling in the Logging & Profiling admin screen to determine how long it takes to run any particular query. You might need to set the logging for the com.atlassian.jira.jql package to DEBUG, but I'm not 100% sure on that.

Suggest an answer

Log in or Sign up to answer