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

As a Jira Admin, I would like to add an index by ISSUE_ID column on the table moved_issue_key

XMLWordPrintable

    • 3
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Summary

      1) When moving an issue between projects or bulk moving multiples issues, we can observe that the query below consumes much of the active connection pool and db cpu.

      • Report from DB:

        "SELECT OLD_ISSUE_KEY FROM moved_issue_key WHERE ISSUE_ID=:1 ORDER BY ID"

        Id Operation Name Rows Bytes Cost (%CPU) Time
        0 SELECT STATEMENT       84 (100)  
        1 SORT ORDER BY   1 21 84 (3) 00:00:01
        2 TABLE ACCESS FULL MOVED_ISSUE_KEY 1 21 83 (2) 00:00:01
      • Query is doing full table scans
      • moved_issue_key table structure: 
                   Table "public.moved_issue_key"
    Column     |          Type          | Modifiers
---------------+------------------------+-----------
 id            | numeric(18,0)          | not null
 old_issue_key | character varying(255) |
 issue_id      | numeric(18,0)          |
Indexes:
    "pk_moved_issue_key" PRIMARY KEY, btree (id)
    "idx_old_issue_key" UNIQUE, btree (old_issue_key)

      2) Customers facing issue JSWSERVER-20612 Dev.Status can get stuck paging over issue updates from Bitbucket Server, Bamboo or Fecru and cause excessive load on database can minimize the DB impact by adding this index:

      CREATE INDEX idx_issue_id ON moved_issue_key (issue_id);

      Suggested Solution

      Add an index on the issue_id column for the table moved_issue_key

      Workaround

      Add index manually

      CREATE INDEX CONCURRENTLY idx_issue_id ON moved_issue_key (issue_id);

            [JRASERVER-70678] As a Jira Admin, I would like to add an index by ISSUE_ID column on the table moved_issue_key

            SET Analytics Bot made changes -
            UIS Original: 2 New: 3
            Conny Postma made changes -
            Remote Link Original: This issue links to "Page (Atlassian Documentation)" [ 494111 ]
            SET Analytics Bot made changes -
            UIS Original: 5 New: 2
            SET Analytics Bot made changes -
            UIS Original: 7 New: 5
            SET Analytics Bot made changes -
            UIS Original: 6 New: 7
            Cathy S made changes -
            Remote Link New: This issue links to "Page (Confluence)" [ 893453 ]
            SET Analytics Bot made changes -
            UIS Original: 11 New: 6
            SET Analytics Bot made changes -
            UIS Original: 3 New: 11
            SET Analytics Bot made changes -
            UIS Original: 8 New: 3
            SET Analytics Bot made changes -
            UIS Original: 6 New: 8

              Unassigned Unassigned
              imurakami@atlassian.com Murakami
              Votes:
              14 Vote for this issue
              Watchers:
              16 Start watching this issue

                Created:
                Updated: