[JIRA DC] Slow Query issue (v8.22.1)

[Yong Xin Choon]

Dear Community,

We found there are some slow query issue in our JIRA DataCenter version:

just like : 

SELECT ID, groupid, FIELDTYPE, FIELD, OLDVALUE, OLDSTRING, NEWVALUE, NEWSTRING FROM changeitem; 

there is no 'where' condition which will cause full table scanning.

So, is there any way to avoid this?

Thx/Br

[Radek Dostál]

Jira uses WHERE clauses in general, otherwise you'd be waiting 30-120 seconds on every page. None of what you're showing here is taken from native Jira webUI.

What is this about again? What is causing these queries, how are they impacting you?