Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-74397

Issue search may cause a high CPU utilization in the database

XMLWordPrintable

      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.

            Unassigned Unassigned
            ayanar Alp
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: