{"action":"reopened","issue":{"url":"https://api.github.com/repos/glitch-soc/mastodon/issues/397","repository_url":"https://api.github.com/repos/glitch-soc/mastodon","labels_url":"https://api.github.com/repos/glitch-soc/mastodon/issues/397/labels{/name}","comments_url":"https://api.github.com/repos/glitch-soc/mastodon/issues/397/comments","events_url":"https://api.github.com/repos/glitch-soc/mastodon/issues/397/events","html_url":"https://github.com/glitch-soc/mastodon/issues/397","id":307487449,"node_id":"MDU6SXNzdWUzMDc0ODc0NDk=","number":397,"title":"DM timeline loads (/api/v1/timelines/direct) are unusually slow","user":{"login":"rtucker","id":97437,"node_id":"MDQ6VXNlcjk3NDM3","avatar_url":"https://avatars1.githubusercontent.com/u/97437?v=4","gravatar_id":"","url":"https://api.github.com/users/rtucker","html_url":"https://github.com/rtucker","followers_url":"https://api.github.com/users/rtucker/followers","following_url":"https://api.github.com/users/rtucker/following{/other_user}","gists_url":"https://api.github.com/users/rtucker/gists{/gist_id}","starred_url":"https://api.github.com/users/rtucker/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rtucker/subscriptions","organizations_url":"https://api.github.com/users/rtucker/orgs","repos_url":"https://api.github.com/users/rtucker/repos","events_url":"https://api.github.com/users/rtucker/events{/privacy}","received_events_url":"https://api.github.com/users/rtucker/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":3,"created_at":"2018-03-22T02:50:22Z","updated_at":"2018-06-03T08:21:53Z","closed_at":null,"author_association":"NONE","body":"I'm noticing that loading the contents of the direct message column is unusually slow for me, like on the order of 15+ seconds.  It looks to be mostly database delay, which suggests that an index might be missing:\r\n\r\nweb_1 | [fe97475a-b47d-4bf4-b73a-f1cacbbecf86] method=GET path=/api/v1/timelines/direct format=html controller=Api::V1::Timelines::DirectController action=show status=200 duration=15092.58 view=1619.73 db=13042.11\r\n\r\nHaven't investigated much yet, just wanted to get this written down so I can forget about it ^^\r\n\r\nvulpineclub issue: https://github.com/vulpineclub/mastodon/issues/4\r\n\r\n* * * *\r\n\r\n- [X] I searched or browsed the repo’s other issues to ensure this is not a duplicate.\r\n- [ ] This bug happens on a [tagged release](https://github.com/tootsuite/mastodon/releases) and not on `master` (If you're a user, don't worry about this).\r\n"}}
{"actor":{"display_login":"yipdw"}}