{"action":"closed","issue":{"url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/5781","repository_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports","labels_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/5781/labels{/name}","comments_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/5781/comments","events_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/5781/events","html_url":"https://github.com/PennyDreadfulMTG/perf-reports/issues/5781","id":285972822,"node_id":"MDU6SXNzdWUyODU5NzI4MjI=","number":5781,"title":"Exceeded slow_query limit (16.1 > 5) 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":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-01-04T12:34:35Z","updated_at":"2018-07-13T15:41:36Z","closed_at":"2018-07-13T15:41:36Z","author_association":"NONE","body":"        SELECT\n            card AS name,\n            \n        SUM(CASE WHEN TRUE THEN 1 ELSE 0 END) AS `all_num_decks`,\n        SUM(CASE WHEN TRUE THEN wins ELSE 0 END) AS `all_wins`,\n        SUM(CASE WHEN TRUE THEN losses ELSE 0 END) AS `all_losses`,\n        SUM(CASE WHEN TRUE THEN draws ELSE 0 END) AS `all_draws`,\n        IFNULL(ROUND((SUM(CASE WHEN TRUE THEN wins ELSE 0 END) / NULLIF(SUM(CASE WHEN TRUE THEN wins + losses ELSE 0 END), 0)) * 100, 1), '') AS `all_win_percent`\n    ,\n            \n        SUM(CASE WHEN dsum.created_date >= 1506668400 THEN 1 ELSE 0 END) AS `season_num_decks`,\n        SUM(CASE WHEN dsum.created_date >= 1506668400 THEN wins ELSE 0 END) AS `season_wins`,\n        SUM(CASE WHEN dsum.created_date >= 1506668400 THEN losses ELSE 0 END) AS `season_losses`,\n        SUM(CASE WHEN dsum.created_date >= 1506668400 THEN draws ELSE 0 END) AS `season_draws`,\n        IFNULL(ROUND((SUM(CASE WHEN dsum.created_date >= 1506668400 THEN wins ELSE 0 END) / NULLIF(SUM(CASE WHEN dsum.created_date >= 1506668400 THEN wins + losses ELSE 0 END), 0)) * 100, 1), '') AS `season_win_percent`\n    ,\n            \n        SUM(CASE WHEN dsum.created_date >= UNIX_TIMESTAMP(NOW() - INTERVAL 1 WEEK) THEN 1 ELSE 0 END) AS `week_num_decks`,\n        SUM(CASE WHEN dsum.created_date >= UNIX_TIMESTAMP(NOW() - INTERVAL 1 WEEK) THEN wins ELSE 0 END) AS `week_wins`,\n        SUM(CASE WHEN dsum.created_date >= UNIX_TIMESTAMP(NOW() - INTERVAL 1 WEEK) THEN losses ELSE 0 END) AS `week_losses`,\n        SUM(CASE WHEN dsum.created_date >= UNIX_TIMESTAMP(NOW() - INTERVAL 1 WEEK) THEN draws ELSE 0 END) AS `week_draws`,\n        IFNULL(ROUND((SUM(CASE WHEN dsum.created_date >= UNIX_TIMESTAMP(NOW() - INTERVAL 1 WEEK) THEN wins ELSE 0 END) / NULLIF(SUM(CASE WHEN dsum.created_date >= UNIX_TIMESTAMP(NOW() - INTERVAL 1 WEEK) THEN wins + losses ELSE 0 END), 0)) * 100, 1), '') AS `week_win_percent`\n    \n        FROM\n            deck_card AS dc\n        INNER JOIN\n            deck AS d ON dc.deck_id = d.id\n        \n        LEFT JOIN\n            (\n                SELECT\n                    d.id,\n                    d.created_date,\n                    SUM(CASE WHEN dm.games > IFNULL(odm.games, 0) THEN 1 ELSE 0 END) AS wins, -- IFNULL so we still count byes as wins.\n                    SUM(CASE WHEN dm.games < odm.games THEN 1 ELSE 0 END) AS losses,\n                    SUM(CASE WHEN dm.games = odm.games THEN 1 ELSE 0 END) AS draws\n                FROM\n                    deck_match AS dm\n                INNER JOIN\n                    deck_match AS odm ON dm.match_id = odm.match_id AND dm.deck_id <> odm.deck_id\n                INNER JOIN\n                    deck AS d ON d.id = dm.deck_id\n                GROUP BY\n                    d.id\n            ) AS dsum ON d.id = dsum.id\n    \n        WHERE\n            1 = 1\n        GROUP BY\n            dc.card\n        ORDER BY\n            season_num_decks DESC,\n            SUM(CASE WHEN dsum.created_date >= %s THEN dsum.wins - dsum.losses ELSE 0 END) DESC,\n            name\n    ; [1506668400] (slow_query, 16.1, mysql)\n\nReported on mysql by perf\n--------------------------------------------------------------------------------\nRequest Method: GET\nPath: /?\nCookies: {}\nEndpoint: home\nView Args: {}\nPerson: logged_out\nUser-Agent: Mozilla/5.0+(compatible; UptimeRobot/2.0; http://www.uptimerobot.com/)\nReferrer: https://pennydreadfulmagic.com\n"}}
{"actor":{"display_login":"stale"}}