Query Profile option in advanced JQL for Jira data center

[Sagar Mahajan]

Does anyone seen this at advanced jql search - Query Profile

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.

[Ravina Mahajan]

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

[Sagar Mahajan]

Thanks @Ravina Mahajan I will check this.

[Benz Kek _Adaptavist_]

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: 

• Query Profiler

Hope the above helps! 

[Sagar Mahajan]

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