{"action":"created","issue":{"url":"https://api.github.com/repos/calebmer/postgraphql/issues/265","repository_url":"https://api.github.com/repos/calebmer/postgraphql","labels_url":"https://api.github.com/repos/calebmer/postgraphql/issues/265/labels{/name}","comments_url":"https://api.github.com/repos/calebmer/postgraphql/issues/265/comments","events_url":"https://api.github.com/repos/calebmer/postgraphql/issues/265/events","html_url":"https://github.com/calebmer/postgraphql/issues/265","id":193809765,"number":265,"title":"Performance of computed columns in connections","user":{"login":"ferdinandsalis","id":340520,"avatar_url":"https://avatars.githubusercontent.com/u/340520?v=3","gravatar_id":"","url":"https://api.github.com/users/ferdinandsalis","html_url":"https://github.com/ferdinandsalis","followers_url":"https://api.github.com/users/ferdinandsalis/followers","following_url":"https://api.github.com/users/ferdinandsalis/following{/other_user}","gists_url":"https://api.github.com/users/ferdinandsalis/gists{/gist_id}","starred_url":"https://api.github.com/users/ferdinandsalis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ferdinandsalis/subscriptions","organizations_url":"https://api.github.com/users/ferdinandsalis/orgs","repos_url":"https://api.github.com/users/ferdinandsalis/repos","events_url":"https://api.github.com/users/ferdinandsalis/events{/privacy}","received_events_url":"https://api.github.com/users/ferdinandsalis/received_events","type":"User","site_admin":false},"labels":[{"id":388983813,"url":"https://api.github.com/repos/calebmer/postgraphql/labels/enhancement","name":"enhancement","color":"c5def5","default":true},{"id":495751979,"url":"https://api.github.com/repos/calebmer/postgraphql/labels/performance","name":"performance","color":"0e8a16","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":5,"created_at":"2016-12-06T15:57:30Z","updated_at":"2016-12-08T13:20:34Z","closed_at":null,"body":"I am lacking the proper terminology to express the problem correctly but here you go.\r\n\r\nFor every row in a table the computed column procedure is executed, hence every other row contributes significantly to the execution time of the query. I am just guessing here but could we maybe use `with` queries to 'inline' the queries 🙈\r\n\r\nYou can find a 'test case' here https://github.com/ferdinandsalis/computed-columns-perf\r\n\r\n@calebmer please let me know if you were expecting something else for the issue and the test case."},"comment":{"url":"https://api.github.com/repos/calebmer/postgraphql/issues/comments/265738011","html_url":"https://github.com/calebmer/postgraphql/issues/265#issuecomment-265738011","issue_url":"https://api.github.com/repos/calebmer/postgraphql/issues/265","id":265738011,"user":{"login":"ferdinandsalis","id":340520,"avatar_url":"https://avatars.githubusercontent.com/u/340520?v=3","gravatar_id":"","url":"https://api.github.com/users/ferdinandsalis","html_url":"https://github.com/ferdinandsalis","followers_url":"https://api.github.com/users/ferdinandsalis/followers","following_url":"https://api.github.com/users/ferdinandsalis/following{/other_user}","gists_url":"https://api.github.com/users/ferdinandsalis/gists{/gist_id}","starred_url":"https://api.github.com/users/ferdinandsalis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ferdinandsalis/subscriptions","organizations_url":"https://api.github.com/users/ferdinandsalis/orgs","repos_url":"https://api.github.com/users/ferdinandsalis/repos","events_url":"https://api.github.com/users/ferdinandsalis/events{/privacy}","received_events_url":"https://api.github.com/users/ferdinandsalis/received_events","type":"User","site_admin":false},"created_at":"2016-12-08T13:20:34Z","updated_at":"2016-12-08T13:20:34Z","body":"@benjie thanks for sharing you learnings! This is very helpful to me."}}
{"actor":{"display_login":"ferdinandsalis"}}