• Eulyeon Ko's avatar
    Index issues on project_id, state_id, created, id · 49aed743
    Eulyeon Ko authored
    The following existing index
    'idx_issues_on_project_id_and_created_at_and_id_and_state_id'
    has `state_id` as the last column.
    
    Because GitLab's domain logic usually requires querying
    issues in a particular state and the primary key comes before
    state_id, the above existing index could prevent a range scan.
    
    The newly added index modifies the order of the columns.
    (project_id, state_id, created_at, id).
    
    We will add the new index and collect data on the old and new
    indices before disabling/eventually retiring one of them.
    
    Changelog: added
    49aed743
20210802112233 64 Bytes