Skip to content

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

@mchehab

Description

@mchehab

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

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions