Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Query Profile option in advanced JQL for Jira data center

Sagar Mahajan Community Leader May 06, 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.

2 comments

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

Like # people like this
Sagar Mahajan Community Leader May 06, 2021

Thanks @Ravina Mahajan I will check this.

Like # people like this

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! 

Like # people like this
Sagar Mahajan Community Leader May 10, 2021

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

Like # people like this

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Confluence Cloud

🏠 Say hello to the new Confluence Home!

Hi Atlassian Community, My name is DJ Chung, and I’m a Product Manager on the Confluence Cloud team. Today, I’m excited to share a new and improved version of Home. The new Home helps you ...

26,754 views 21 101
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you