{"action":"created","issue":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/28315","repository_url":"https://api.github.com/repos/cockroachdb/cockroach","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/28315/labels{/name}","comments_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/28315/comments","events_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/28315/events","html_url":"https://github.com/cockroachdb/cockroach/pull/28315","id":348108085,"node_id":"MDExOlB1bGxSZXF1ZXN0MjA2NTM3MDkx","number":28315,"title":"opt: update stats calculation for Select and Join","user":{"login":"rytaft","id":3288732,"node_id":"MDQ6VXNlcjMyODg3MzI=","avatar_url":"https://avatars2.githubusercontent.com/u/3288732?v=4","gravatar_id":"","url":"https://api.github.com/users/rytaft","html_url":"https://github.com/rytaft","followers_url":"https://api.github.com/users/rytaft/followers","following_url":"https://api.github.com/users/rytaft/following{/other_user}","gists_url":"https://api.github.com/users/rytaft/gists{/gist_id}","starred_url":"https://api.github.com/users/rytaft/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rytaft/subscriptions","organizations_url":"https://api.github.com/users/rytaft/orgs","repos_url":"https://api.github.com/users/rytaft/repos","events_url":"https://api.github.com/users/rytaft/events{/privacy}","received_events_url":"https://api.github.com/users/rytaft/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-08-06T22:52:24Z","updated_at":"2018-08-06T22:52:31Z","closed_at":null,"author_association":"CONTRIBUTOR","pull_request":{"url":"https://api.github.com/repos/cockroachdb/cockroach/pulls/28315","html_url":"https://github.com/cockroachdb/cockroach/pull/28315","diff_url":"https://github.com/cockroachdb/cockroach/pull/28315.diff","patch_url":"https://github.com/cockroachdb/cockroach/pull/28315.patch"},"body":"This PR consists of 4 commits which improve the stats calculation for Selects and Joins:\r\n1. Set the estimated distinct count for boolean columns to 2 when no stats are available\r\n2. Clean up and refactor the Select and Scan stats calculation\r\n3. Make the stats calculation for Select aware of equivalent columns\r\n4. Add stats calculation for Joins using the actual ON conditions\r\n\r\nSee the individual commit messages for details."},"comment":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/comments/410877756","html_url":"https://github.com/cockroachdb/cockroach/pull/28315#issuecomment-410877756","issue_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/28315","id":410877756,"node_id":"MDEyOklzc3VlQ29tbWVudDQxMDg3Nzc1Ng==","user":{"login":"cockroach-teamcity","id":20559710,"node_id":"MDQ6VXNlcjIwNTU5NzEw","avatar_url":"https://avatars0.githubusercontent.com/u/20559710?v=4","gravatar_id":"","url":"https://api.github.com/users/cockroach-teamcity","html_url":"https://github.com/cockroach-teamcity","followers_url":"https://api.github.com/users/cockroach-teamcity/followers","following_url":"https://api.github.com/users/cockroach-teamcity/following{/other_user}","gists_url":"https://api.github.com/users/cockroach-teamcity/gists{/gist_id}","starred_url":"https://api.github.com/users/cockroach-teamcity/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cockroach-teamcity/subscriptions","organizations_url":"https://api.github.com/users/cockroach-teamcity/orgs","repos_url":"https://api.github.com/users/cockroach-teamcity/repos","events_url":"https://api.github.com/users/cockroach-teamcity/events{/privacy}","received_events_url":"https://api.github.com/users/cockroach-teamcity/received_events","type":"User","site_admin":false},"created_at":"2018-08-06T22:52:31Z","updated_at":"2018-08-06T22:52:31Z","author_association":"MEMBER","body":"\n\n<!-- Reviewable:start -->\nThis change is [<img src=\"https://reviewable.io/review_button.png\" height=\"34\" align=\"absmiddle\" alt=\"Reviewable\"/>](https://reviewable.io/reviews/cockroachdb/cockroach/28315)\n<!-- Reviewable:end -->\n"}}
{"actor":{"display_login":"cockroach-teamcity"}}