{"action":"closed","issue":{"url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/37850","repository_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports","labels_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/37850/labels{/name}","comments_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/37850/comments","events_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/37850/events","html_url":"https://github.com/PennyDreadfulMTG/perf-reports/issues/37850","id":360514277,"node_id":"MDU6SXNzdWUzNjA1MTQyNzc=","number":37850,"title":"Exceeded slow_query limit (4.1 > 3.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-15T06:51:37Z","updated_at":"2018-11-21T07:51:51Z","closed_at":"2018-11-21T07:51:51Z","author_association":"NONE","body":"        SELECT\n            name,\n            SUM(num_decks) AS all_num_decks,\n            SUM(wins) AS all_wins,\n            SUM(losses) AS all_losses,\n            SUM(draws) AS all_draws,\n            SUM(wins - losses) AS record,\n            SUM(perfect_runs) AS all_perfect_runs,\n            SUM(tournament_wins) AS all_tournament_wins,\n            SUM(tournament_top8s) AS all_tournament_top8s,\n            IFNULL(ROUND((SUM(wins) / NULLIF(SUM(wins + losses), 0)) * 100, 1), '') AS all_win_percent,\n            SUM(CASE WHEN `day` > 1531465200 THEN num_decks ELSE 0 END) AS season_num_decks,\n            SUM(CASE WHEN `day` > 1531465200 THEN wins ELSE 0 END) AS season_wins,\n            SUM(CASE WHEN `day` > 1531465200 THEN losses ELSE 0 END) AS season_losses,\n            SUM(CASE WHEN `day` > 1531465200 THEN draws ELSE 0 END) AS season_draws,\n            SUM(CASE WHEN `day` > 1531465200 THEN perfect_runs ELSE 0 END) AS season_perfect_runs,\n            SUM(CASE WHEN `day` > 1531465200 THEN tournament_wins ELSE 0 END) AS season_tournament_wins,\n            SUM(CASE WHEN `day` > 1531465200 THEN tournament_top8s ELSE 0 END) AS season_tournament_top8s,\n            IFNULL(ROUND((SUM(CASE WHEN `day` > 1531465200 THEN wins ELSE 0 END) / NULLIF(SUM(CASE WHEN `day` > 1531465200 THEN wins + losses ELSE 0 END), 0)) * 100, 1), '') AS `season_win_percent`,\n            SUM(CASE WHEN `day` > UNIX_TIMESTAMP(NOW() - INTERVAL 1 WEEK) THEN num_decks ELSE 0 END) AS week_num_decks,\n            SUM(CASE WHEN `day` > UNIX_TIMESTAMP(NOW() - INTERVAL 1 WEEK) THEN wins ELSE 0 END) AS week_wins,\n            SUM(CASE WHEN `day` > UNIX_TIMESTAMP(NOW() - INTERVAL 1 WEEK) THEN losses ELSE 0 END) AS week_losses,\n            SUM(CASE WHEN `day` > UNIX_TIMESTAMP(NOW() - INTERVAL 1 WEEK) THEN draws ELSE 0 END) AS week_draws,\n            SUM(CASE WHEN `day` > UNIX_TIMESTAMP(NOW() - INTERVAL 1 WEEK) THEN perfect_runs ELSE 0 END) AS week_perfect_runs,\n            SUM(CASE WHEN `day` > UNIX_TIMESTAMP(NOW() - INTERVAL 1 WEEK) THEN tournament_wins ELSE 0 END) AS week_tournament_wins,\n            SUM(CASE WHEN `day` > UNIX_TIMESTAMP(NOW() - INTERVAL 1 WEEK) THEN tournament_top8s ELSE 0 END) AS week_tournament_top8s,\n            IFNULL(ROUND((SUM(CASE WHEN `day` > UNIX_TIMESTAMP(NOW() - INTERVAL 1 WEEK) THEN wins ELSE 0 END) / NULLIF(SUM(CASE WHEN `day` > UNIX_TIMESTAMP(NOW() - INTERVAL 1 WEEK) THEN wins + losses ELSE 0 END), 0)) * 100, 1), '') AS `week_win_percent`\n        FROM\n            _card_person_stats AS cs\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 <= cs.day AND (season.end_date IS NULL OR season.end_date > cs.day)\n        WHERE\n            season.id = 6 AND person_id = 2082\n        GROUP BY\n            name, person_id\n        ORDER BY\n            all_num_decks DESC,\n            record,\n            name\n    ```\n\n```[]``` (slow_query, 4.1, mysql)\n\nReported on decksite by mysql-perf```\n            --------------------------------------------------------------------------------\n            Request Method: GET\n            Path: /seasons/6/people/2082/?locale=sv\n            Cookies: {}\n            Endpoint: seasons.person\n            View Args: {'person_id': '2082'}\n            Person: logged_out\n            Referrer: None\n            Request Data: {}\nHost: pennydreadfulmagic.com\nAccept-Encoding: gzip\nCf-Ipcountry: US\nX-Forwarded-For: 207.46.13.209, 162.158.106.242\nCf-Ray: 45a92a539c197a05-SEA\nX-Forwarded-Proto: https\nCf-Visitor: {\"scheme\":\"https\"}\nCache-Control: no-cache\nPragma: no-cache\nAccept: */*\nFrom: bingbot(at)microsoft.com\nUser-Agent: Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)\nCf-Connecting-Ip: 207.46.13.209\nX-Forwarded-Host: pennydreadfulmagic.com\nX-Forwarded-Server: pennydreadfulmagic.com\nConnection: Keep-Alive\n```\n"}}
{"actor":{"display_login":"stale"}}