{"action":"created","issue":{"url":"https://api.github.com/repos/fabric8-services/fabric8-auth/issues/388","repository_url":"https://api.github.com/repos/fabric8-services/fabric8-auth","labels_url":"https://api.github.com/repos/fabric8-services/fabric8-auth/issues/388/labels{/name}","comments_url":"https://api.github.com/repos/fabric8-services/fabric8-auth/issues/388/comments","events_url":"https://api.github.com/repos/fabric8-services/fabric8-auth/issues/388/events","html_url":"https://github.com/fabric8-services/fabric8-auth/issues/388","id":306111647,"number":388,"title":"Investigate possible seq_scan/index issues in Auth DB","user":{"login":"alexeykazakov","id":620087,"avatar_url":"https://avatars3.githubusercontent.com/u/620087?v=4","gravatar_id":"","url":"https://api.github.com/users/alexeykazakov","html_url":"https://github.com/alexeykazakov","followers_url":"https://api.github.com/users/alexeykazakov/followers","following_url":"https://api.github.com/users/alexeykazakov/following{/other_user}","gists_url":"https://api.github.com/users/alexeykazakov/gists{/gist_id}","starred_url":"https://api.github.com/users/alexeykazakov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alexeykazakov/subscriptions","organizations_url":"https://api.github.com/users/alexeykazakov/orgs","repos_url":"https://api.github.com/users/alexeykazakov/repos","events_url":"https://api.github.com/users/alexeykazakov/events{/privacy}","received_events_url":"https://api.github.com/users/alexeykazakov/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"sbryzak","id":165507,"avatar_url":"https://avatars0.githubusercontent.com/u/165507?v=4","gravatar_id":"","url":"https://api.github.com/users/sbryzak","html_url":"https://github.com/sbryzak","followers_url":"https://api.github.com/users/sbryzak/followers","following_url":"https://api.github.com/users/sbryzak/following{/other_user}","gists_url":"https://api.github.com/users/sbryzak/gists{/gist_id}","starred_url":"https://api.github.com/users/sbryzak/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sbryzak/subscriptions","organizations_url":"https://api.github.com/users/sbryzak/orgs","repos_url":"https://api.github.com/users/sbryzak/repos","events_url":"https://api.github.com/users/sbryzak/events{/privacy}","received_events_url":"https://api.github.com/users/sbryzak/received_events","type":"User","site_admin":false},"assignees":[{"login":"sbryzak","id":165507,"avatar_url":"https://avatars0.githubusercontent.com/u/165507?v=4","gravatar_id":"","url":"https://api.github.com/users/sbryzak","html_url":"https://github.com/sbryzak","followers_url":"https://api.github.com/users/sbryzak/followers","following_url":"https://api.github.com/users/sbryzak/following{/other_user}","gists_url":"https://api.github.com/users/sbryzak/gists{/gist_id}","starred_url":"https://api.github.com/users/sbryzak/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sbryzak/subscriptions","organizations_url":"https://api.github.com/users/sbryzak/orgs","repos_url":"https://api.github.com/users/sbryzak/repos","events_url":"https://api.github.com/users/sbryzak/events{/privacy}","received_events_url":"https://api.github.com/users/sbryzak/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/fabric8-services/fabric8-auth/milestones/39","html_url":"https://github.com/fabric8-services/fabric8-auth/milestone/39","labels_url":"https://api.github.com/repos/fabric8-services/fabric8-auth/milestones/39/labels","id":3201687,"number":39,"title":"Sprint 147-3","description":"","creator":{"login":"alexeykazakov","id":620087,"avatar_url":"https://avatars3.githubusercontent.com/u/620087?v=4","gravatar_id":"","url":"https://api.github.com/users/alexeykazakov","html_url":"https://github.com/alexeykazakov","followers_url":"https://api.github.com/users/alexeykazakov/followers","following_url":"https://api.github.com/users/alexeykazakov/following{/other_user}","gists_url":"https://api.github.com/users/alexeykazakov/gists{/gist_id}","starred_url":"https://api.github.com/users/alexeykazakov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alexeykazakov/subscriptions","organizations_url":"https://api.github.com/users/alexeykazakov/orgs","repos_url":"https://api.github.com/users/alexeykazakov/repos","events_url":"https://api.github.com/users/alexeykazakov/events{/privacy}","received_events_url":"https://api.github.com/users/alexeykazakov/received_events","type":"User","site_admin":false},"open_issues":8,"closed_issues":1,"state":"open","created_at":"2018-03-20T03:42:16Z","updated_at":"2018-04-10T20:23:08Z","due_on":"2018-04-16T07:00:00Z","closed_at":null},"comments":0,"created_at":"2018-03-17T00:23:32Z","updated_at":"2018-04-11T04:44:26Z","closed_at":null,"author_association":"OWNER","body":"We might have some index misses in identites, users, oauth_state_reference, space_resource tables.\r\nWe need to investigate it.\r\n\r\n![index](https://user-images.githubusercontent.com/620087/37549601-08bf9226-293f-11e8-887d-72644652fe6f.png)\r\n"},"comment":{"url":"https://api.github.com/repos/fabric8-services/fabric8-auth/issues/comments/380325490","html_url":"https://github.com/fabric8-services/fabric8-auth/issues/388#issuecomment-380325490","issue_url":"https://api.github.com/repos/fabric8-services/fabric8-auth/issues/388","id":380325490,"user":{"login":"alexeykazakov","id":620087,"avatar_url":"https://avatars3.githubusercontent.com/u/620087?v=4","gravatar_id":"","url":"https://api.github.com/users/alexeykazakov","html_url":"https://github.com/alexeykazakov","followers_url":"https://api.github.com/users/alexeykazakov/followers","following_url":"https://api.github.com/users/alexeykazakov/following{/other_user}","gists_url":"https://api.github.com/users/alexeykazakov/gists{/gist_id}","starred_url":"https://api.github.com/users/alexeykazakov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/alexeykazakov/subscriptions","organizations_url":"https://api.github.com/users/alexeykazakov/orgs","repos_url":"https://api.github.com/users/alexeykazakov/repos","events_url":"https://api.github.com/users/alexeykazakov/events{/privacy}","received_events_url":"https://api.github.com/users/alexeykazakov/received_events","type":"User","site_admin":false},"created_at":"2018-04-11T04:44:26Z","updated_at":"2018-04-11T04:44:26Z","author_association":"OWNER","body":"Our search API misses user and identity indexes:\r\n\r\n![search](https://user-images.githubusercontent.com/620087/38596744-16d7c4fa-3d08-11e8-86cb-fbb0f6cfa6bd.png)\r\n"}}
{"actor":{"display_login":"alexeykazakov"}}