{"action":"created","issue":{"url":"https://api.github.com/repos/Zocdoc/ZocBuild.Database/issues/9","repository_url":"https://api.github.com/repos/Zocdoc/ZocBuild.Database","labels_url":"https://api.github.com/repos/Zocdoc/ZocBuild.Database/issues/9/labels{/name}","comments_url":"https://api.github.com/repos/Zocdoc/ZocBuild.Database/issues/9/comments","events_url":"https://api.github.com/repos/Zocdoc/ZocBuild.Database/issues/9/events","html_url":"https://github.com/Zocdoc/ZocBuild.Database/pull/9","id":146393643,"number":9,"title":"Boosting this timeout so we don't have more issues. Should probably f…","user":{"login":"colin-hanson-zocdoc","id":4604503,"avatar_url":"https://avatars.githubusercontent.com/u/4604503?v=3","gravatar_id":"","url":"https://api.github.com/users/colin-hanson-zocdoc","html_url":"https://github.com/colin-hanson-zocdoc","followers_url":"https://api.github.com/users/colin-hanson-zocdoc/followers","following_url":"https://api.github.com/users/colin-hanson-zocdoc/following{/other_user}","gists_url":"https://api.github.com/users/colin-hanson-zocdoc/gists{/gist_id}","starred_url":"https://api.github.com/users/colin-hanson-zocdoc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/colin-hanson-zocdoc/subscriptions","organizations_url":"https://api.github.com/users/colin-hanson-zocdoc/orgs","repos_url":"https://api.github.com/users/colin-hanson-zocdoc/repos","events_url":"https://api.github.com/users/colin-hanson-zocdoc/events{/privacy}","received_events_url":"https://api.github.com/users/colin-hanson-zocdoc/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-04-06T18:14:41Z","updated_at":"2016-04-06T18:59:39Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/Zocdoc/ZocBuild.Database/pulls/9","html_url":"https://github.com/Zocdoc/ZocBuild.Database/pull/9","diff_url":"https://github.com/Zocdoc/ZocBuild.Database/pull/9.diff","patch_url":"https://github.com/Zocdoc/ZocBuild.Database/pull/9.patch"},"body":"…urther optimize this query\r\n\r\n@Lal-kottu-zocdoc @chris-smith-zocdoc \r\n\r\nThis query timed out on three consecutive main ci runs this morning.  While boosting the timeout is definitely not the best solution it should help prevent this from happening again in the future."},"comment":{"url":"https://api.github.com/repos/Zocdoc/ZocBuild.Database/issues/comments/206514049","html_url":"https://github.com/Zocdoc/ZocBuild.Database/pull/9#issuecomment-206514049","issue_url":"https://api.github.com/repos/Zocdoc/ZocBuild.Database/issues/9","id":206514049,"user":{"login":"Lal-kottu-zocdoc","id":6463909,"avatar_url":"https://avatars.githubusercontent.com/u/6463909?v=3","gravatar_id":"","url":"https://api.github.com/users/Lal-kottu-zocdoc","html_url":"https://github.com/Lal-kottu-zocdoc","followers_url":"https://api.github.com/users/Lal-kottu-zocdoc/followers","following_url":"https://api.github.com/users/Lal-kottu-zocdoc/following{/other_user}","gists_url":"https://api.github.com/users/Lal-kottu-zocdoc/gists{/gist_id}","starred_url":"https://api.github.com/users/Lal-kottu-zocdoc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Lal-kottu-zocdoc/subscriptions","organizations_url":"https://api.github.com/users/Lal-kottu-zocdoc/orgs","repos_url":"https://api.github.com/users/Lal-kottu-zocdoc/repos","events_url":"https://api.github.com/users/Lal-kottu-zocdoc/events{/privacy}","received_events_url":"https://api.github.com/users/Lal-kottu-zocdoc/received_events","type":"User","site_admin":false},"created_at":"2016-04-06T18:59:39Z","updated_at":"2016-04-06T18:59:39Z","body":"Just ran this on metrics_datawarehouse in production/repl-db.\r\n\r\nIt runs as part of the metrics deploy - took 70 seconds :hankey: \r\n\r\ni'll look into getting this to behave but if you boys have ideas lmk"}}