Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

Exceeded slow_query limit (0.5 > 0.5) in mysql: ``` #61169

Open vorpal-buildbot opened 1 year ago

vorpal-buildbot commented 1 year ago

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 44.201.149.140 Cf-Ray: 7c84ba234985177b-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cf-Connecting-Ip: 44.201.149.140 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 23.22.159.28 Cf-Ray: 7c8cec15dfea393d-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cf-Connecting-Ip: 23.22.159.28 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 52.91.55.245 Cf-Ray: 7c952959ed9c2054-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cf-Connecting-Ip: 52.91.55.245 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 54.243.20.45 Cf-Ray: 7c9d68e778b582e7-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cf-Connecting-Ip: 54.243.20.45 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 3.83.146.222 Cf-Ray: 7cade4342e893b1d-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cf-Connecting-Ip: 3.83.146.222 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 3.83.146.222 Cf-Ray: 7cb621930bf58018-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cf-Connecting-Ip: 3.83.146.222 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 44.202.120.24 Cf-Ray: 7cbe62b1a82c07bb-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cf-Connecting-Ip: 44.202.120.24 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 44.202.120.24 Cf-Ray: 7cc6c5964ac381e1-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cf-Connecting-Ip: 44.202.120.24 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 54.91.97.70 Cf-Ray: 7cced9654a139c85-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cf-Connecting-Ip: 54.91.97.70 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 3.87.219.150 Cf-Ray: 7cd71aef98b2059c-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cf-Connecting-Ip: 3.87.219.150 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 3.87.219.150 Cf-Ray: 7cdf53a358d21ef9-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cf-Connecting-Ip: 3.87.219.150 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 3.87.219.150 Cf-Ray: 7ce7aa3008fd8199-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cf-Connecting-Ip: 3.87.219.150 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 3.87.219.150 Cf-Ray: 7cefd20d090107b9-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cf-Connecting-Ip: 3.87.219.150 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 3.87.219.150 Cf-Ray: 7cf80e4e7a1e82ff-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cf-Connecting-Ip: 3.87.219.150 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 3.87.219.150 Cf-Ray: 7d004e04fd7b9c24-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cf-Connecting-Ip: 3.87.219.150 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 52.90.222.47 Cf-Ray: 7d08b13ca8d0826c-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cdn-Loop: cloudflare Cf-Connecting-Ip: 52.90.222.47 Cf-Ipcountry: US ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 54.80.255.212 Cf-Ray: 7d10c5591c692028-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cf-Connecting-Ip: 54.80.255.212 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 54.80.255.212 Cf-Ray: 7d213eb99b50388b-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cdn-Loop: cloudflare Cf-Connecting-Ip: 54.80.255.212 Cf-Ipcountry: US ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 54.80.255.212 Cf-Ray: 7d297b7779fb6fb6-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cdn-Loop: cloudflare Cf-Connecting-Ip: 54.80.255.212 Cf-Ipcountry: US ```

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (TRUE) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        num_reviewed = num_decks
    ORDER BY
        c.start_date DESC,
        c.name
    LIMIT 50
```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 1c036b7b35691d0cc14485eb33308b26eb16ee79

Request Data

``` Request Method: GET Path: /api/competitions? Cookies: ImmutableMultiDict([]) Endpoint: competitions_api View Args: {} Person: logged_out Referrer: None Request Data: {} Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 54.80.255.212 Cf-Ray: 7d39f70458f682ed-IAD X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Accept: */* User-Agent: Ruby Cdn-Loop: cloudflare Cf-Connecting-Ip: 54.80.255.212 Cf-Ipcountry: US ```

Labels: decksite