{"action":"created","issue":{"url":"https://api.github.com/repos/scala-exercises/scala-exercises/issues/464","repository_url":"https://api.github.com/repos/scala-exercises/scala-exercises","labels_url":"https://api.github.com/repos/scala-exercises/scala-exercises/issues/464/labels{/name}","comments_url":"https://api.github.com/repos/scala-exercises/scala-exercises/issues/464/comments","events_url":"https://api.github.com/repos/scala-exercises/scala-exercises/issues/464/events","html_url":"https://github.com/scala-exercises/scala-exercises/issues/464","id":162343373,"number":464,"title":"Database indexes","user":{"login":"raulraja","id":456796,"avatar_url":"https://avatars.githubusercontent.com/u/456796?v=3","gravatar_id":"","url":"https://api.github.com/users/raulraja","html_url":"https://github.com/raulraja","followers_url":"https://api.github.com/users/raulraja/followers","following_url":"https://api.github.com/users/raulraja/following{/other_user}","gists_url":"https://api.github.com/users/raulraja/gists{/gist_id}","starred_url":"https://api.github.com/users/raulraja/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/raulraja/subscriptions","organizations_url":"https://api.github.com/users/raulraja/orgs","repos_url":"https://api.github.com/users/raulraja/repos","events_url":"https://api.github.com/users/raulraja/events{/privacy}","received_events_url":"https://api.github.com/users/raulraja/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/scala-exercises/scala-exercises/labels/backend","name":"backend","color":"4183D7"},{"url":"https://api.github.com/repos/scala-exercises/scala-exercises/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-06-26T19:37:27Z","updated_at":"2016-06-28T14:37:32Z","closed_at":null,"body":"We need to do a pass to the most used queries and create proper indexes for those."},"comment":{"url":"https://api.github.com/repos/scala-exercises/scala-exercises/issues/comments/229068959","html_url":"https://github.com/scala-exercises/scala-exercises/issues/464#issuecomment-229068959","issue_url":"https://api.github.com/repos/scala-exercises/scala-exercises/issues/464","id":229068959,"user":{"login":"raulraja","id":456796,"avatar_url":"https://avatars.githubusercontent.com/u/456796?v=3","gravatar_id":"","url":"https://api.github.com/users/raulraja","html_url":"https://github.com/raulraja","followers_url":"https://api.github.com/users/raulraja/followers","following_url":"https://api.github.com/users/raulraja/following{/other_user}","gists_url":"https://api.github.com/users/raulraja/gists{/gist_id}","starred_url":"https://api.github.com/users/raulraja/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/raulraja/subscriptions","organizations_url":"https://api.github.com/users/raulraja/orgs","repos_url":"https://api.github.com/users/raulraja/repos","events_url":"https://api.github.com/users/raulraja/events{/privacy}","received_events_url":"https://api.github.com/users/raulraja/received_events","type":"User","site_admin":false},"created_at":"2016-06-28T14:37:31Z","updated_at":"2016-06-28T14:37:31Z","body":"Ran a `pg:diagnose` and looks like we are in the green even after the load tests so holding back on creating extra indexes for now.\r\n```\r\n △ ~ heroku pg:diagnose --app scala-exercises HEROKU_POSTGRESQL_ORANGE\r\nReport a7620071-20b0-49b5-96d7-087d8cac33bc for scala-exercises::HEROKU_POSTGRESQL_ORANGE_URL\r\navailable for one month after creation on 2016-06-28T14:34:24.760778+00:00\r\n\r\nGREEN: Connection Count\r\nGREEN: Long Queries\r\nGREEN: Idle in Transaction\r\nGREEN: Indexes\r\nGREEN: Bloat\r\nGREEN: Hit Rate\r\nGREEN: Blocking Queries\r\nGREEN: Sequences\r\nGREEN: Load\r\n```"}}
{"actor":{"display_login":"raulraja"}}