Loading...

XML

Word

Printable

Type: Bug
Resolution: Unresolved
Priority: Low
Fix Version/s: None
Affects Version/s: 8.13.22
Component/s: Data Center - Archiving, Project - Issues
Labels:
- database-index
- pse-request

Introduced in Version:
8.13
Support reference count:
4
Symptom Severity:
Severity 3 - Minor
UIS:
0

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.

relates to

JRASERVER-71567 Archived Issues page automatically performs a count from all active projects

Closed

Assignee:: Unassigned
Reporter:: Alp (Inactive)
Votes:: 1 Vote for this issue
Watchers:: 3 Start watching this issue

Created:: 13/Oct/2022 3:42 PM
Updated:: 21/Dec/2024 4:11 AM