Skip to content

Doing queries that use archieved and state_id at the same time is slow on patchwork 3.1 #581

Open
@mchehab

Description

This is a low hanging fruit. Just creating this index solved the issue:

CREATE INDEX idx_patch_state_id_archived on patchwork_patch (state_id, archived);

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions