{"action":"closed","number":511,"pull_request":{"url":"https://api.github.com/repos/ubccr/xdmod/pulls/511","id":182246042,"html_url":"https://github.com/ubccr/xdmod/pull/511","diff_url":"https://github.com/ubccr/xdmod/pull/511.diff","patch_url":"https://github.com/ubccr/xdmod/pull/511.patch","issue_url":"https://api.github.com/repos/ubccr/xdmod/issues/511","number":511,"state":"closed","locked":false,"title":"Add Group by Job Wait Time","user":{"login":"treydock","id":739622,"avatar_url":"https://avatars1.githubusercontent.com/u/739622?v=4","gravatar_id":"","url":"https://api.github.com/users/treydock","html_url":"https://github.com/treydock","followers_url":"https://api.github.com/users/treydock/followers","following_url":"https://api.github.com/users/treydock/following{/other_user}","gists_url":"https://api.github.com/users/treydock/gists{/gist_id}","starred_url":"https://api.github.com/users/treydock/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/treydock/subscriptions","organizations_url":"https://api.github.com/users/treydock/orgs","repos_url":"https://api.github.com/users/treydock/repos","events_url":"https://api.github.com/users/treydock/events{/privacy}","received_events_url":"https://api.github.com/users/treydock/received_events","type":"User","site_admin":false},"body":"Add Group by Job Wait Time\r\nAdd job_wait_times table that has same buckets as job_times\r\n\r\n<!--- Provide a general summary of your changes in the Title above -->\r\n\r\n## Description\r\nThis adds a new grouping that is by wait time, modeled after the grouping by wall time.\r\n\r\n![screen shot 2018-04-17 at 1 50 04 pm](https://user-images.githubusercontent.com/739622/38887275-63d24d14-4246-11e8-86b1-81bc0849b43c.png)\r\n\r\n![screen shot 2018-04-17 at 1 50 20 pm](https://user-images.githubusercontent.com/739622/38887282-6779e79c-4246-11e8-974b-69cc1bc410b1.png)\r\n\r\n![screen shot 2018-04-17 at 1 50 40 pm](https://user-images.githubusercontent.com/739622/38887287-6a793bb4-4246-11e8-9830-cd2ce8603809.png)\r\n\r\n<!--- Describe your changes in detail -->\r\n<!--- Include screenshots for GUI changes if appropriate -->\r\n<!--- If any documentation outside of this repo needs to be added or updated,\r\n      please include links to the relevant docs and how they should be changed -->\r\n\r\n## Motivation and Context\r\nThis allows grouping statistics like jobs ended by wait time.  We find this useful in understanding job wait times over time by generating aggregate graphs of jobs ended that are grouped by wait times.\r\n\r\nThe new wait time bucket table allows wait time groupings to be different than the wall time groupings.\r\n\r\n<!--- Why is this change required? What problem does it solve? -->\r\n<!--- If it fixes an open issue, please link to the issue here. -->\r\n\r\n## Tests performed\r\nI have tested these changes on OSC's test XDMoD server using production data.\r\n<!--- Please describe in detail how you tested your changes. -->\r\n<!--- Include details of your testing environment, and the tests you ran to -->\r\n<!--- see how your change affects other areas of the code, etc. -->\r\n\r\n## Types of changes\r\n<!--- What types of changes does your code introduce? Put an `x` in all the boxes that apply: -->\r\n- [ ] Bug fix (non-breaking change which fixes an issue)\r\n- [x] New feature (non-breaking change which adds functionality)\r\n- [ ] Breaking change (fix or feature that would cause existing functionality to change)\r\n\r\n## Checklist:\r\n<!--- Go over all the following points, and put an `x` in all the boxes that apply. -->\r\n<!--- If you're unsure about any of these, don't hesitate to ask. We're here to help! -->\r\n- [x] My code follows the code style of this project as found in the **CONTRIBUTING** document.\r\n- [ ] I have added tests to cover my changes.\r\n- [ ] All new and existing tests passed.\r\n","created_at":"2018-04-17T17:52:38Z","updated_at":"2018-05-08T12:59:56Z","closed_at":"2018-05-08T12:59:56Z","merged_at":"2018-05-08T12:59:56Z","merge_commit_sha":"9ca164da05d71ad5b405f264967a47588dae833f","assignee":null,"assignees":[],"requested_reviewers":[],"requested_teams":[],"labels":[{"id":470896635,"url":"https://api.github.com/repos/ubccr/xdmod/labels/enhancement","name":"enhancement","color":"84b6eb","default":true}],"milestone":null,"commits_url":"https://api.github.com/repos/ubccr/xdmod/pulls/511/commits","review_comments_url":"https://api.github.com/repos/ubccr/xdmod/pulls/511/comments","review_comment_url":"https://api.github.com/repos/ubccr/xdmod/pulls/comments{/number}","comments_url":"https://api.github.com/repos/ubccr/xdmod/issues/511/comments","statuses_url":"https://api.github.com/repos/ubccr/xdmod/statuses/ced094ec08b597dfef54148c4762c2c602944613","head":{"label":"treydock:add-group-by-wait-time","ref":"add-group-by-wait-time","sha":"ced094ec08b597dfef54148c4762c2c602944613","user":{"login":"treydock","id":739622,"avatar_url":"https://avatars1.githubusercontent.com/u/739622?v=4","gravatar_id":"","url":"https://api.github.com/users/treydock","html_url":"https://github.com/treydock","followers_url":"https://api.github.com/users/treydock/followers","following_url":"https://api.github.com/users/treydock/following{/other_user}","gists_url":"https://api.github.com/users/treydock/gists{/gist_id}","starred_url":"https://api.github.com/users/treydock/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/treydock/subscriptions","organizations_url":"https://api.github.com/users/treydock/orgs","repos_url":"https://api.github.com/users/treydock/repos","events_url":"https://api.github.com/users/treydock/events{/privacy}","received_events_url":"https://api.github.com/users/treydock/received_events","type":"User","site_admin":false},"repo":{"id":123942244,"name":"xdmod","full_name":"treydock/xdmod","owner":{"login":"treydock","id":739622,"avatar_url":"https://avatars1.githubusercontent.com/u/739622?v=4","gravatar_id":"","url":"https://api.github.com/users/treydock","html_url":"https://github.com/treydock","followers_url":"https://api.github.com/users/treydock/followers","following_url":"https://api.github.com/users/treydock/following{/other_user}","gists_url":"https://api.github.com/users/treydock/gists{/gist_id}","starred_url":"https://api.github.com/users/treydock/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/treydock/subscriptions","organizations_url":"https://api.github.com/users/treydock/orgs","repos_url":"https://api.github.com/users/treydock/repos","events_url":"https://api.github.com/users/treydock/events{/privacy}","received_events_url":"https://api.github.com/users/treydock/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/treydock/xdmod","description":"An open framework for collecting and analyzing HPC metrics.","fork":true,"url":"https://api.github.com/repos/treydock/xdmod","forks_url":"https://api.github.com/repos/treydock/xdmod/forks","keys_url":"https://api.github.com/repos/treydock/xdmod/keys{/key_id}","collaborators_url":"https://api.github.com/repos/treydock/xdmod/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/treydock/xdmod/teams","hooks_url":"https://api.github.com/repos/treydock/xdmod/hooks","issue_events_url":"https://api.github.com/repos/treydock/xdmod/issues/events{/number}","events_url":"https://api.github.com/repos/treydock/xdmod/events","assignees_url":"https://api.github.com/repos/treydock/xdmod/assignees{/user}","branches_url":"https://api.github.com/repos/treydock/xdmod/branches{/branch}","tags_url":"https://api.github.com/repos/treydock/xdmod/tags","blobs_url":"https://api.github.com/repos/treydock/xdmod/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/treydock/xdmod/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/treydock/xdmod/git/refs{/sha}","trees_url":"https://api.github.com/repos/treydock/xdmod/git/trees{/sha}","statuses_url":"https://api.github.com/repos/treydock/xdmod/statuses/{sha}","languages_url":"https://api.github.com/repos/treydock/xdmod/languages","stargazers_url":"https://api.github.com/repos/treydock/xdmod/stargazers","contributors_url":"https://api.github.com/repos/treydock/xdmod/contributors","subscribers_url":"https://api.github.com/repos/treydock/xdmod/subscribers","subscription_url":"https://api.github.com/repos/treydock/xdmod/subscription","commits_url":"https://api.github.com/repos/treydock/xdmod/commits{/sha}","git_commits_url":"https://api.github.com/repos/treydock/xdmod/git/commits{/sha}","comments_url":"https://api.github.com/repos/treydock/xdmod/comments{/number}","issue_comment_url":"https://api.github.com/repos/treydock/xdmod/issues/comments{/number}","contents_url":"https://api.github.com/repos/treydock/xdmod/contents/{+path}","compare_url":"https://api.github.com/repos/treydock/xdmod/compare/{base}...{head}","merges_url":"https://api.github.com/repos/treydock/xdmod/merges","archive_url":"https://api.github.com/repos/treydock/xdmod/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/treydock/xdmod/downloads","issues_url":"https://api.github.com/repos/treydock/xdmod/issues{/number}","pulls_url":"https://api.github.com/repos/treydock/xdmod/pulls{/number}","milestones_url":"https://api.github.com/repos/treydock/xdmod/milestones{/number}","notifications_url":"https://api.github.com/repos/treydock/xdmod/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/treydock/xdmod/labels{/name}","releases_url":"https://api.github.com/repos/treydock/xdmod/releases{/id}","deployments_url":"https://api.github.com/repos/treydock/xdmod/deployments","created_at":"2018-03-05T15:50:10Z","updated_at":"2018-03-05T15:50:15Z","pushed_at":"2018-05-07T18:02:58Z","git_url":"git://github.com/treydock/xdmod.git","ssh_url":"git@github.com:treydock/xdmod.git","clone_url":"https://github.com/treydock/xdmod.git","svn_url":"https://github.com/treydock/xdmod","homepage":"http://open.xdmod.org","size":6625,"stargazers_count":0,"watchers_count":0,"language":"PHP","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":{"key":"lgpl-3.0","name":"GNU Lesser General Public License v3.0","spdx_id":"LGPL-3.0","url":"https://api.github.com/licenses/lgpl-3.0"},"forks":0,"open_issues":0,"watchers":0,"default_branch":"xdmod8.0"}},"base":{"label":"ubccr:xdmod8.0","ref":"xdmod8.0","sha":"5591ededf45071c11ebb742a2f6a4b01e3fed343","user":{"login":"ubccr","id":2301947,"avatar_url":"https://avatars2.githubusercontent.com/u/2301947?v=4","gravatar_id":"","url":"https://api.github.com/users/ubccr","html_url":"https://github.com/ubccr","followers_url":"https://api.github.com/users/ubccr/followers","following_url":"https://api.github.com/users/ubccr/following{/other_user}","gists_url":"https://api.github.com/users/ubccr/gists{/gist_id}","starred_url":"https://api.github.com/users/ubccr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ubccr/subscriptions","organizations_url":"https://api.github.com/users/ubccr/orgs","repos_url":"https://api.github.com/users/ubccr/repos","events_url":"https://api.github.com/users/ubccr/events{/privacy}","received_events_url":"https://api.github.com/users/ubccr/received_events","type":"Organization","site_admin":false},"repo":{"id":72233032,"name":"xdmod","full_name":"ubccr/xdmod","owner":{"login":"ubccr","id":2301947,"avatar_url":"https://avatars2.githubusercontent.com/u/2301947?v=4","gravatar_id":"","url":"https://api.github.com/users/ubccr","html_url":"https://github.com/ubccr","followers_url":"https://api.github.com/users/ubccr/followers","following_url":"https://api.github.com/users/ubccr/following{/other_user}","gists_url":"https://api.github.com/users/ubccr/gists{/gist_id}","starred_url":"https://api.github.com/users/ubccr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ubccr/subscriptions","organizations_url":"https://api.github.com/users/ubccr/orgs","repos_url":"https://api.github.com/users/ubccr/repos","events_url":"https://api.github.com/users/ubccr/events{/privacy}","received_events_url":"https://api.github.com/users/ubccr/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/ubccr/xdmod","description":"An open framework for collecting and analyzing HPC metrics.","fork":false,"url":"https://api.github.com/repos/ubccr/xdmod","forks_url":"https://api.github.com/repos/ubccr/xdmod/forks","keys_url":"https://api.github.com/repos/ubccr/xdmod/keys{/key_id}","collaborators_url":"https://api.github.com/repos/ubccr/xdmod/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/ubccr/xdmod/teams","hooks_url":"https://api.github.com/repos/ubccr/xdmod/hooks","issue_events_url":"https://api.github.com/repos/ubccr/xdmod/issues/events{/number}","events_url":"https://api.github.com/repos/ubccr/xdmod/events","assignees_url":"https://api.github.com/repos/ubccr/xdmod/assignees{/user}","branches_url":"https://api.github.com/repos/ubccr/xdmod/branches{/branch}","tags_url":"https://api.github.com/repos/ubccr/xdmod/tags","blobs_url":"https://api.github.com/repos/ubccr/xdmod/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/ubccr/xdmod/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/ubccr/xdmod/git/refs{/sha}","trees_url":"https://api.github.com/repos/ubccr/xdmod/git/trees{/sha}","statuses_url":"https://api.github.com/repos/ubccr/xdmod/statuses/{sha}","languages_url":"https://api.github.com/repos/ubccr/xdmod/languages","stargazers_url":"https://api.github.com/repos/ubccr/xdmod/stargazers","contributors_url":"https://api.github.com/repos/ubccr/xdmod/contributors","subscribers_url":"https://api.github.com/repos/ubccr/xdmod/subscribers","subscription_url":"https://api.github.com/repos/ubccr/xdmod/subscription","commits_url":"https://api.github.com/repos/ubccr/xdmod/commits{/sha}","git_commits_url":"https://api.github.com/repos/ubccr/xdmod/git/commits{/sha}","comments_url":"https://api.github.com/repos/ubccr/xdmod/comments{/number}","issue_comment_url":"https://api.github.com/repos/ubccr/xdmod/issues/comments{/number}","contents_url":"https://api.github.com/repos/ubccr/xdmod/contents/{+path}","compare_url":"https://api.github.com/repos/ubccr/xdmod/compare/{base}...{head}","merges_url":"https://api.github.com/repos/ubccr/xdmod/merges","archive_url":"https://api.github.com/repos/ubccr/xdmod/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/ubccr/xdmod/downloads","issues_url":"https://api.github.com/repos/ubccr/xdmod/issues{/number}","pulls_url":"https://api.github.com/repos/ubccr/xdmod/pulls{/number}","milestones_url":"https://api.github.com/repos/ubccr/xdmod/milestones{/number}","notifications_url":"https://api.github.com/repos/ubccr/xdmod/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/ubccr/xdmod/labels{/name}","releases_url":"https://api.github.com/repos/ubccr/xdmod/releases{/id}","deployments_url":"https://api.github.com/repos/ubccr/xdmod/deployments","created_at":"2016-10-28T18:41:25Z","updated_at":"2018-05-08T11:29:28Z","pushed_at":"2018-05-08T12:59:56Z","git_url":"git://github.com/ubccr/xdmod.git","ssh_url":"git@github.com:ubccr/xdmod.git","clone_url":"https://github.com/ubccr/xdmod.git","svn_url":"https://github.com/ubccr/xdmod","homepage":"https://open.xdmod.org","size":6639,"stargazers_count":27,"watchers_count":27,"language":"PHP","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":true,"forks_count":26,"mirror_url":null,"archived":false,"open_issues_count":8,"license":{"key":"lgpl-3.0","name":"GNU Lesser General Public License v3.0","spdx_id":"LGPL-3.0","url":"https://api.github.com/licenses/lgpl-3.0"},"forks":26,"open_issues":8,"watchers":27,"default_branch":"xdmod8.0"}},"_links":{"self":{"href":"https://api.github.com/repos/ubccr/xdmod/pulls/511"},"html":{"href":"https://github.com/ubccr/xdmod/pull/511"},"issue":{"href":"https://api.github.com/repos/ubccr/xdmod/issues/511"},"comments":{"href":"https://api.github.com/repos/ubccr/xdmod/issues/511/comments"},"review_comments":{"href":"https://api.github.com/repos/ubccr/xdmod/pulls/511/comments"},"review_comment":{"href":"https://api.github.com/repos/ubccr/xdmod/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/ubccr/xdmod/pulls/511/commits"},"statuses":{"href":"https://api.github.com/repos/ubccr/xdmod/statuses/ced094ec08b597dfef54148c4762c2c602944613"}},"author_association":"CONTRIBUTOR","merged":true,"mergeable":null,"rebaseable":null,"mergeable_state":"unknown","merged_by":{"login":"plessbd","id":683012,"avatar_url":"https://avatars2.githubusercontent.com/u/683012?v=4","gravatar_id":"","url":"https://api.github.com/users/plessbd","html_url":"https://github.com/plessbd","followers_url":"https://api.github.com/users/plessbd/followers","following_url":"https://api.github.com/users/plessbd/following{/other_user}","gists_url":"https://api.github.com/users/plessbd/gists{/gist_id}","starred_url":"https://api.github.com/users/plessbd/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/plessbd/subscriptions","organizations_url":"https://api.github.com/users/plessbd/orgs","repos_url":"https://api.github.com/users/plessbd/repos","events_url":"https://api.github.com/users/plessbd/events{/privacy}","received_events_url":"https://api.github.com/users/plessbd/received_events","type":"User","site_admin":false},"comments":32,"review_comments":1,"maintainer_can_modify":false,"commits":7,"additions":266,"deletions":18,"changed_files":13}}
{"actor":{"display_login":"plessbd"}}