search

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

Exceeded slow_query limit (98.8 > 60.0) in mysql: ``` #63713

Open vorpal-buildbot opened 1 month ago

vorpal-buildbot commented 1 month ago 
    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 98.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (95.1 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 95.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (92.5 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 92.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (100.5 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 100.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (371.1 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 371.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (66.9 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 66.9, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (112.2 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 112.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (71.3 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 71.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (60.7 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 60.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (89.0 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 89.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (72.7 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 72.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (70.8 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 70.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (65.2 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 65.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (71.5 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 71.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 month ago

Exceeded slow_query limit (71.2 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 71.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 3 weeks ago

Exceeded slow_query limit (78.0 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 78.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 3 weeks ago

Exceeded slow_query limit (62.1 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 62.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 3 weeks ago

Exceeded slow_query limit (77.1 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 77.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 3 weeks ago

Exceeded slow_query limit (78.0 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 78.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 2 weeks ago

Exceeded slow_query limit (77.2 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 77.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 2 weeks ago

Exceeded slow_query limit (77.0 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 77.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 2 weeks ago

Exceeded slow_query limit (71.0 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 71.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 2 weeks ago

Exceeded slow_query limit (61.7 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 61.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 2 weeks ago

Exceeded slow_query limit (65.6 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 65.6, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 2 weeks ago

Exceeded slow_query limit (72.7 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 72.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 2 weeks ago

Exceeded slow_query limit (64.8 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 64.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 week ago

Exceeded slow_query limit (89.6 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 89.6, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 week ago

Exceeded slow_query limit (91.0 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 91.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 week ago

Exceeded slow_query limit (90.5 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 90.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 week ago

Exceeded slow_query limit (91.8 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 91.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 week ago

Exceeded slow_query limit (69.3 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 69.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 week ago

Exceeded slow_query limit (86.7 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 86.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 week ago

Exceeded slow_query limit (84.6 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 84.6, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 week ago

Exceeded slow_query limit (83.8 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 83.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 week ago

Exceeded slow_query limit (83.2 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 83.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 week ago

Exceeded slow_query limit (78.9 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 78.9, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 week ago

Exceeded slow_query limit (84.2 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 84.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite

vorpal-buildbot commented 1 week ago

Exceeded slow_query limit (94.3 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 94.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 31f00e4756717c2be0eb46f02f1d3305ae26fb06

Labels: decksite