Query Profile option in advanced JQL for Jira data center

Sagar
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 6, 2021

Does anyone seen this at advanced jql search - Query Profile

Capture 2021-05-06 at 15.01.55.png

Capture 2021-05-06 at 15.02.48.png

Profile :

[70ms] - JQL query profile, thread: http-nio-8080-exec-84 url: /rest/scriptrunner-jira/latest/jqlfunctions/profile; user: username

 Lucene :

*:*

Resources :

OpSnapshot{name='issue.index.reads', invocationCount=1, elapsedTotal=70210799, elapsedMin=70210799, elapsedMax=70210799, resultSetSize=0, cpuTotal=0, cpuMin=0, cpuMax=0}
OpSnapshot{name='db.conns', invocationCount=1, elapsedTotal=70216260, elapsedMin=70216260, elapsedMax=70216260, resultSetSize=0, cpuTotal=0, cpuMin=0, cpuMax=0}
OpSnapshot{name='db.reads', invocationCount=1, elapsedTotal=70217438, elapsedMin=70217438, elapsedMax=70217438, resultSetSize=0, cpuTotal=0, cpuMin=0, cpuMax=0}

Something from scriptrunner related to indexes but not sure what actually it is.

4 answers

3 votes
Benz Kek _Adaptavist_
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.
May 10, 2021

Hi Sagar, that option is only available to administrators only, it is used to profile JQL to find poorly performing JQL queries. 

You may read more about it in our documentation here: 

Hope the above helps! 

2 votes
Sagar
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 10, 2021

Hi @Benz Kek _Adaptavist_ Thanks for the reply, that was helpful

2 votes
Sagar
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 6, 2021

Thanks @Ravina I will check this.

2 votes
Ravina
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 6, 2021

This looks like related to the indexing stats as you are on data center this must some internal index sync timings between the nodes.

You can check the index health of the node looks similar to it.

https://issues.redhat.com/rest/indexanalyzer/1/state?maxResults=100

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events