{"action":"closed","number":13,"pull_request":{"url":"https://api.github.com/repos/starburstdata/presto/pulls/13","id":169631350,"html_url":"https://github.com/starburstdata/presto/pull/13","diff_url":"https://github.com/starburstdata/presto/pull/13.diff","patch_url":"https://github.com/starburstdata/presto/pull/13.patch","issue_url":"https://api.github.com/repos/starburstdata/presto/issues/13","number":13,"state":"closed","locked":false,"title":"Cache stats for equivalent joins for ReorderJoins","user":{"login":"kokosing","id":7569403,"avatar_url":"https://avatars2.githubusercontent.com/u/7569403?v=4","gravatar_id":"","url":"https://api.github.com/users/kokosing","html_url":"https://github.com/kokosing","followers_url":"https://api.github.com/users/kokosing/followers","following_url":"https://api.github.com/users/kokosing/following{/other_user}","gists_url":"https://api.github.com/users/kokosing/gists{/gist_id}","starred_url":"https://api.github.com/users/kokosing/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kokosing/subscriptions","organizations_url":"https://api.github.com/users/kokosing/orgs","repos_url":"https://api.github.com/users/kokosing/repos","events_url":"https://api.github.com/users/kokosing/events{/privacy}","received_events_url":"https://api.github.com/users/kokosing/received_events","type":"User","site_admin":false},"body":"Cache stats for equivalent joins for ReorderJoins\r\n\r\nI haven't run a lot of benchmarks, below is the result for join reordering with 6 nodes.\r\nBefore:\r\n```\r\nBenchmark                                                  Mode  Cnt   Score   Error  Units\r\nBenchmarkReorderJoinsConnectedGraph.benchmarkReorderJoins  avgt   30  65.014 ± 1.838  ms/op\r\n```\r\nAfter:\r\n```\r\nBenchmark                                                  Mode  Cnt   Score   Error  Units\r\nBenchmarkReorderJoinsConnectedGraph.benchmarkReorderJoins  avgt   30  37.639 ± 1.340  ms/op\r\n```\r\n","created_at":"2018-02-16T14:02:46Z","updated_at":"2018-02-20T06:17:31Z","closed_at":"2018-02-20T06:17:31Z","merged_at":null,"merge_commit_sha":"12378661a6380acde261f63edee8f975c167c159","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[],"milestone":null,"commits_url":"https://api.github.com/repos/starburstdata/presto/pulls/13/commits","review_comments_url":"https://api.github.com/repos/starburstdata/presto/pulls/13/comments","review_comment_url":"https://api.github.com/repos/starburstdata/presto/pulls/comments{/number}","comments_url":"https://api.github.com/repos/starburstdata/presto/issues/13/comments","statuses_url":"https://api.github.com/repos/starburstdata/presto/statuses/74ef9ec46a794426f51a45d240b5fbf58d4480f5","head":{"label":"kokosing:sd/epic/cbo/12-with-old-style-normalizers/speedup_cbo","ref":"sd/epic/cbo/12-with-old-style-normalizers/speedup_cbo","sha":"74ef9ec46a794426f51a45d240b5fbf58d4480f5","user":{"login":"kokosing","id":7569403,"avatar_url":"https://avatars2.githubusercontent.com/u/7569403?v=4","gravatar_id":"","url":"https://api.github.com/users/kokosing","html_url":"https://github.com/kokosing","followers_url":"https://api.github.com/users/kokosing/followers","following_url":"https://api.github.com/users/kokosing/following{/other_user}","gists_url":"https://api.github.com/users/kokosing/gists{/gist_id}","starred_url":"https://api.github.com/users/kokosing/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kokosing/subscriptions","organizations_url":"https://api.github.com/users/kokosing/orgs","repos_url":"https://api.github.com/users/kokosing/repos","events_url":"https://api.github.com/users/kokosing/events{/privacy}","received_events_url":"https://api.github.com/users/kokosing/received_events","type":"User","site_admin":false},"repo":{"id":55942614,"name":"presto","full_name":"kokosing/presto","owner":{"login":"kokosing","id":7569403,"avatar_url":"https://avatars2.githubusercontent.com/u/7569403?v=4","gravatar_id":"","url":"https://api.github.com/users/kokosing","html_url":"https://github.com/kokosing","followers_url":"https://api.github.com/users/kokosing/followers","following_url":"https://api.github.com/users/kokosing/following{/other_user}","gists_url":"https://api.github.com/users/kokosing/gists{/gist_id}","starred_url":"https://api.github.com/users/kokosing/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kokosing/subscriptions","organizations_url":"https://api.github.com/users/kokosing/orgs","repos_url":"https://api.github.com/users/kokosing/repos","events_url":"https://api.github.com/users/kokosing/events{/privacy}","received_events_url":"https://api.github.com/users/kokosing/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/kokosing/presto","description":"Distributed SQL query engine for big data","fork":true,"url":"https://api.github.com/repos/kokosing/presto","forks_url":"https://api.github.com/repos/kokosing/presto/forks","keys_url":"https://api.github.com/repos/kokosing/presto/keys{/key_id}","collaborators_url":"https://api.github.com/repos/kokosing/presto/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/kokosing/presto/teams","hooks_url":"https://api.github.com/repos/kokosing/presto/hooks","issue_events_url":"https://api.github.com/repos/kokosing/presto/issues/events{/number}","events_url":"https://api.github.com/repos/kokosing/presto/events","assignees_url":"https://api.github.com/repos/kokosing/presto/assignees{/user}","branches_url":"https://api.github.com/repos/kokosing/presto/branches{/branch}","tags_url":"https://api.github.com/repos/kokosing/presto/tags","blobs_url":"https://api.github.com/repos/kokosing/presto/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/kokosing/presto/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/kokosing/presto/git/refs{/sha}","trees_url":"https://api.github.com/repos/kokosing/presto/git/trees{/sha}","statuses_url":"https://api.github.com/repos/kokosing/presto/statuses/{sha}","languages_url":"https://api.github.com/repos/kokosing/presto/languages","stargazers_url":"https://api.github.com/repos/kokosing/presto/stargazers","contributors_url":"https://api.github.com/repos/kokosing/presto/contributors","subscribers_url":"https://api.github.com/repos/kokosing/presto/subscribers","subscription_url":"https://api.github.com/repos/kokosing/presto/subscription","commits_url":"https://api.github.com/repos/kokosing/presto/commits{/sha}","git_commits_url":"https://api.github.com/repos/kokosing/presto/git/commits{/sha}","comments_url":"https://api.github.com/repos/kokosing/presto/comments{/number}","issue_comment_url":"https://api.github.com/repos/kokosing/presto/issues/comments{/number}","contents_url":"https://api.github.com/repos/kokosing/presto/contents/{+path}","compare_url":"https://api.github.com/repos/kokosing/presto/compare/{base}...{head}","merges_url":"https://api.github.com/repos/kokosing/presto/merges","archive_url":"https://api.github.com/repos/kokosing/presto/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/kokosing/presto/downloads","issues_url":"https://api.github.com/repos/kokosing/presto/issues{/number}","pulls_url":"https://api.github.com/repos/kokosing/presto/pulls{/number}","milestones_url":"https://api.github.com/repos/kokosing/presto/milestones{/number}","notifications_url":"https://api.github.com/repos/kokosing/presto/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/kokosing/presto/labels{/name}","releases_url":"https://api.github.com/repos/kokosing/presto/releases{/id}","deployments_url":"https://api.github.com/repos/kokosing/presto/deployments","created_at":"2016-04-11T04:52:12Z","updated_at":"2016-04-11T04:52:24Z","pushed_at":"2018-02-20T06:16:17Z","git_url":"git://github.com/kokosing/presto.git","ssh_url":"git@github.com:kokosing/presto.git","clone_url":"https://github.com/kokosing/presto.git","svn_url":"https://github.com/kokosing/presto","homepage":"https://prestodb.io","size":91859,"stargazers_count":0,"watchers_count":0,"language":"Java","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":0,"license":null,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"starburstdata:epic/cbo/12-with-old-style-normalizers","ref":"epic/cbo/12-with-old-style-normalizers","sha":"2fbb372fe7e344038537743a14af6d810861f500","user":{"login":"starburstdata","id":33209422,"avatar_url":"https://avatars3.githubusercontent.com/u/33209422?v=4","gravatar_id":"","url":"https://api.github.com/users/starburstdata","html_url":"https://github.com/starburstdata","followers_url":"https://api.github.com/users/starburstdata/followers","following_url":"https://api.github.com/users/starburstdata/following{/other_user}","gists_url":"https://api.github.com/users/starburstdata/gists{/gist_id}","starred_url":"https://api.github.com/users/starburstdata/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/starburstdata/subscriptions","organizations_url":"https://api.github.com/users/starburstdata/orgs","repos_url":"https://api.github.com/users/starburstdata/repos","events_url":"https://api.github.com/users/starburstdata/events{/privacy}","received_events_url":"https://api.github.com/users/starburstdata/received_events","type":"Organization","site_admin":false},"repo":{"id":108882128,"name":"presto","full_name":"starburstdata/presto","owner":{"login":"starburstdata","id":33209422,"avatar_url":"https://avatars3.githubusercontent.com/u/33209422?v=4","gravatar_id":"","url":"https://api.github.com/users/starburstdata","html_url":"https://github.com/starburstdata","followers_url":"https://api.github.com/users/starburstdata/followers","following_url":"https://api.github.com/users/starburstdata/following{/other_user}","gists_url":"https://api.github.com/users/starburstdata/gists{/gist_id}","starred_url":"https://api.github.com/users/starburstdata/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/starburstdata/subscriptions","organizations_url":"https://api.github.com/users/starburstdata/orgs","repos_url":"https://api.github.com/users/starburstdata/repos","events_url":"https://api.github.com/users/starburstdata/events{/privacy}","received_events_url":"https://api.github.com/users/starburstdata/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/starburstdata/presto","description":"Starburst Enterprise Distribution of Presto","fork":true,"url":"https://api.github.com/repos/starburstdata/presto","forks_url":"https://api.github.com/repos/starburstdata/presto/forks","keys_url":"https://api.github.com/repos/starburstdata/presto/keys{/key_id}","collaborators_url":"https://api.github.com/repos/starburstdata/presto/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/starburstdata/presto/teams","hooks_url":"https://api.github.com/repos/starburstdata/presto/hooks","issue_events_url":"https://api.github.com/repos/starburstdata/presto/issues/events{/number}","events_url":"https://api.github.com/repos/starburstdata/presto/events","assignees_url":"https://api.github.com/repos/starburstdata/presto/assignees{/user}","branches_url":"https://api.github.com/repos/starburstdata/presto/branches{/branch}","tags_url":"https://api.github.com/repos/starburstdata/presto/tags","blobs_url":"https://api.github.com/repos/starburstdata/presto/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/starburstdata/presto/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/starburstdata/presto/git/refs{/sha}","trees_url":"https://api.github.com/repos/starburstdata/presto/git/trees{/sha}","statuses_url":"https://api.github.com/repos/starburstdata/presto/statuses/{sha}","languages_url":"https://api.github.com/repos/starburstdata/presto/languages","stargazers_url":"https://api.github.com/repos/starburstdata/presto/stargazers","contributors_url":"https://api.github.com/repos/starburstdata/presto/contributors","subscribers_url":"https://api.github.com/repos/starburstdata/presto/subscribers","subscription_url":"https://api.github.com/repos/starburstdata/presto/subscription","commits_url":"https://api.github.com/repos/starburstdata/presto/commits{/sha}","git_commits_url":"https://api.github.com/repos/starburstdata/presto/git/commits{/sha}","comments_url":"https://api.github.com/repos/starburstdata/presto/comments{/number}","issue_comment_url":"https://api.github.com/repos/starburstdata/presto/issues/comments{/number}","contents_url":"https://api.github.com/repos/starburstdata/presto/contents/{+path}","compare_url":"https://api.github.com/repos/starburstdata/presto/compare/{base}...{head}","merges_url":"https://api.github.com/repos/starburstdata/presto/merges","archive_url":"https://api.github.com/repos/starburstdata/presto/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/starburstdata/presto/downloads","issues_url":"https://api.github.com/repos/starburstdata/presto/issues{/number}","pulls_url":"https://api.github.com/repos/starburstdata/presto/pulls{/number}","milestones_url":"https://api.github.com/repos/starburstdata/presto/milestones{/number}","notifications_url":"https://api.github.com/repos/starburstdata/presto/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/starburstdata/presto/labels{/name}","releases_url":"https://api.github.com/repos/starburstdata/presto/releases{/id}","deployments_url":"https://api.github.com/repos/starburstdata/presto/deployments","created_at":"2017-10-30T17:05:09Z","updated_at":"2018-01-30T11:23:08Z","pushed_at":"2018-02-20T06:16:23Z","git_url":"git://github.com/starburstdata/presto.git","ssh_url":"git@github.com:starburstdata/presto.git","clone_url":"https://github.com/starburstdata/presto.git","svn_url":"https://github.com/starburstdata/presto","homepage":"https://www.starburstdata.com","size":92772,"stargazers_count":12,"watchers_count":12,"language":"Java","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"archived":false,"open_issues_count":7,"license":null,"forks":0,"open_issues":7,"watchers":12,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/starburstdata/presto/pulls/13"},"html":{"href":"https://github.com/starburstdata/presto/pull/13"},"issue":{"href":"https://api.github.com/repos/starburstdata/presto/issues/13"},"comments":{"href":"https://api.github.com/repos/starburstdata/presto/issues/13/comments"},"review_comments":{"href":"https://api.github.com/repos/starburstdata/presto/pulls/13/comments"},"review_comment":{"href":"https://api.github.com/repos/starburstdata/presto/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/starburstdata/presto/pulls/13/commits"},"statuses":{"href":"https://api.github.com/repos/starburstdata/presto/statuses/74ef9ec46a794426f51a45d240b5fbf58d4480f5"}},"author_association":"MEMBER","merged":false,"mergeable":true,"rebaseable":true,"mergeable_state":"unstable","merged_by":null,"comments":2,"review_comments":13,"maintainer_can_modify":false,"commits":5,"additions":487,"deletions":151,"changed_files":30}}
{"actor":{"display_login":"kokosing"}}