Find slow JQL query

[Luca Andreatta]

Hi,

I'm getting many slow JQL query info messages in my log and I want to find where this queries are saved, but I can't fint them.

the messages are something like:

2019-02-14 15:42:20,803 ajp-nio-8009-exec-224 INFO username 942x2132636x1 s22ja2 161.27.248.37 /secure/AjaxIssueAction.jspa [c.a.j.p.webhooks.matcher.JqlEventMatcher_SLOW] JQL query '{project = "Project ABC"} AND {key in ("XYZ-13020")}' produced lucene query and took '327' ms to run.

I tried to find that in the searchrequest, but I didn't find any evidence. From where this queries could come? How can I find them? Could I increase the threashold of the message?

Every message has a similar query that change only the issue key and the user tha is running it.

I suspect that this may come from a script in a workflow or something in a plugin. How can I find it?

[Willis Towers Watson Atlassian Team]

I believe those INFO lines are being thrown because of web-hooks.  We've been trying to figure out how to change the threshold or silence those entries without any luck.  But someone did it with the help of Script Runner.  We are all waiting to hear exactly how this is to be done.

[Tuncay Senturk]

Oh sorry, I don't know if there is such a details tracing feature.

[Tuncay Senturk]

Hello Luca,

Under JIRA_HOME/log/ folder there should be a file named atlassian-jira-slow-queries.log

This file displays slow queries

[Luca Andreatta]

Thanks, but it is not what I asked for.

In there I find only what I have already found in catalina.out.

My problem is to understand what s executing that query and why. I'm searching for a particular query that is executed many times a day and has a similar structure, as I have already explained.