Issue search may cause a high CPU utilization in the database

Issue Summary

A manual search of all issues in active projects can sometimes causes a high CPU utilization in the database.

Details

The query below seems to be the most active and expensive one in the database:

SELECT COUNT(I.ID) FROM public.jiraissue I WHERE I.PROJECT=$1

Workaround

A workaround will be added when it's available.