{"action":"closed","issue":{"url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/38302","repository_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports","labels_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/38302/labels{/name}","comments_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/38302/comments","events_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/38302/events","html_url":"https://github.com/PennyDreadfulMTG/perf-reports/issues/38302","id":363400707,"node_id":"MDU6SXNzdWUzNjM0MDA3MDc=","number":38302,"title":"Exceeded slow_query limit (10.5 > 5.0) in mysql: ```","user":{"login":"vorpal-buildbot","id":23072004,"node_id":"MDQ6VXNlcjIzMDcyMDA0","avatar_url":"https://avatars2.githubusercontent.com/u/23072004?v=4","gravatar_id":"","url":"https://api.github.com/users/vorpal-buildbot","html_url":"https://github.com/vorpal-buildbot","followers_url":"https://api.github.com/users/vorpal-buildbot/followers","following_url":"https://api.github.com/users/vorpal-buildbot/following{/other_user}","gists_url":"https://api.github.com/users/vorpal-buildbot/gists{/gist_id}","starred_url":"https://api.github.com/users/vorpal-buildbot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vorpal-buildbot/subscriptions","organizations_url":"https://api.github.com/users/vorpal-buildbot/orgs","repos_url":"https://api.github.com/users/vorpal-buildbot/repos","events_url":"https://api.github.com/users/vorpal-buildbot/events{/privacy}","received_events_url":"https://api.github.com/users/vorpal-buildbot/received_events","type":"User","site_admin":false},"labels":[{"id":958792189,"node_id":"MDU6TGFiZWw5NTg3OTIxODk=","url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/labels/decksite","name":"decksite","color":"bfd4f2","default":false},{"id":763867617,"node_id":"MDU6TGFiZWw3NjM4Njc2MTc=","url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/labels/wontfix","name":"wontfix","color":"ffffff","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-09-25T03:56:30Z","updated_at":"2018-12-01T11:54:20Z","closed_at":"2018-12-01T11:54:20Z","author_association":"NONE","body":"        SELECT\n            archetype_id,\n            a.name AS archetype_name,\n            opponent_archetype_id AS id,\n            oa.name AS name,\n            SUM(wins) AS all_wins,\n            SUM(losses) AS all_losses,\n            SUM(draws) AS all_draws,\n            IFNULL(ROUND((SUM(wins) / NULLIF(SUM(wins + losses), 0)) * 100, 1), '') AS all_win_percent\n        FROM\n            _matchup_stats AS ms\n        INNER JOIN\n            archetype AS a ON archetype_id = a.id\n        INNER JOIN\n            archetype AS oa ON opponent_archetype_id = oa.id\n        LEFT JOIN\n            (\n        SELECT\n            `start`.id,\n            `start`.code,\n            `start`.start_date AS start_date,\n            `end`.start_date AS end_date\n        FROM\n            season AS `start`\n        LEFT JOIN\n            season AS `end` ON `end`.id = `start`.id + 1\n    ) AS season ON season.start_date <= ms.day AND (season.end_date IS NULL OR season.end_date > ms.day)\n        WHERE\n            (TRUE) AND (TRUE)\n        GROUP BY\n            archetype_id,\n            opponent_archetype_id\n        ORDER BY\n            all_wins DESC,\n            oa.name\n    ```\n\n```[]``` (slow_query, 10.5, mysql)\n\nReported on decksite by mysql-perf```\n            --------------------------------------------------------------------------------\n            Request Method: GET\n            Path: /seasons/all/archetypes/?\n            Cookies: {'__cfduid': 'dd5c08a1e0dfb8d3456571b51b83d2c621537331867', '_ga': 'GA1.2.548140330.1537331866', '_gid': 'GA1.2.1540201213.1537845454', 'hide_intro': 'True', '_gat_gtag_UA_109131120_1': '1'}\n            Endpoint: seasons.archetypes\n            View Args: {}\n            Person: logged_out\n            Referrer: https://pennydreadfulmagic.com/seasons/7/archetypes/\n            Request Data: {}\nHost: pennydreadfulmagic.com\nAccept-Encoding: gzip\nCf-Ipcountry: US\nX-Forwarded-For: 108.51.184.53, 162.158.78.12\nCf-Ray: 45fa8f6b4a59c1cc-IAD\nX-Forwarded-Proto: https\nCf-Visitor: {\"scheme\":\"https\"}\nUpgrade-Insecure-Requests: 1\nDnt: 1\nUser-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Silk/68.4.9 like Chrome/68.0.3440.85 Safari/537.36\nAccept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8\nReferer: https://pennydreadfulmagic.com/seasons/7/archetypes/\nAccept-Language: en-US,en;q=0.9\nCookie: __cfduid=dd5c08a1e0dfb8d3456571b51b83d2c621537331867; _ga=GA1.2.548140330.1537331866; _gid=GA1.2.1540201213.1537845454; hide_intro=True; _gat_gtag_UA_109131120_1=1\nCf-Connecting-Ip: 108.51.184.53\nX-Forwarded-Host: pennydreadfulmagic.com\nX-Forwarded-Server: pennydreadfulmagic.com\nConnection: Keep-Alive\n```\n"}}
{"actor":{"display_login":"stale"}}