{"action":"created","issue":{"url":"https://api.github.com/repos/heroku/heroku-pg/issues/80","repository_url":"https://api.github.com/repos/heroku/heroku-pg","labels_url":"https://api.github.com/repos/heroku/heroku-pg/issues/80/labels{/name}","comments_url":"https://api.github.com/repos/heroku/heroku-pg/issues/80/comments","events_url":"https://api.github.com/repos/heroku/heroku-pg/issues/80/events","html_url":"https://github.com/heroku/heroku-pg/pull/80","id":196163112,"number":80,"title":"Show load properly for pg:diagnose","user":{"login":"keiko713","id":911433,"avatar_url":"https://avatars.githubusercontent.com/u/911433?v=3","gravatar_id":"","url":"https://api.github.com/users/keiko713","html_url":"https://github.com/keiko713","followers_url":"https://api.github.com/users/keiko713/followers","following_url":"https://api.github.com/users/keiko713/following{/other_user}","gists_url":"https://api.github.com/users/keiko713/gists{/gist_id}","starred_url":"https://api.github.com/users/keiko713/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/keiko713/subscriptions","organizations_url":"https://api.github.com/users/keiko713/orgs","repos_url":"https://api.github.com/users/keiko713/repos","events_url":"https://api.github.com/users/keiko713/events{/privacy}","received_events_url":"https://api.github.com/users/keiko713/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":{"login":"ransombriggs","id":62452,"avatar_url":"https://avatars.githubusercontent.com/u/62452?v=3","gravatar_id":"","url":"https://api.github.com/users/ransombriggs","html_url":"https://github.com/ransombriggs","followers_url":"https://api.github.com/users/ransombriggs/followers","following_url":"https://api.github.com/users/ransombriggs/following{/other_user}","gists_url":"https://api.github.com/users/ransombriggs/gists{/gist_id}","starred_url":"https://api.github.com/users/ransombriggs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ransombriggs/subscriptions","organizations_url":"https://api.github.com/users/ransombriggs/orgs","repos_url":"https://api.github.com/users/ransombriggs/repos","events_url":"https://api.github.com/users/ransombriggs/events{/privacy}","received_events_url":"https://api.github.com/users/ransombriggs/received_events","type":"User","site_admin":false},"assignees":[{"login":"ransombriggs","id":62452,"avatar_url":"https://avatars.githubusercontent.com/u/62452?v=3","gravatar_id":"","url":"https://api.github.com/users/ransombriggs","html_url":"https://github.com/ransombriggs","followers_url":"https://api.github.com/users/ransombriggs/followers","following_url":"https://api.github.com/users/ransombriggs/following{/other_user}","gists_url":"https://api.github.com/users/ransombriggs/gists{/gist_id}","starred_url":"https://api.github.com/users/ransombriggs/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/ransombriggs/subscriptions","organizations_url":"https://api.github.com/users/ransombriggs/orgs","repos_url":"https://api.github.com/users/ransombriggs/repos","events_url":"https://api.github.com/users/ransombriggs/events{/privacy}","received_events_url":"https://api.github.com/users/ransombriggs/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2016-12-16T21:58:10Z","updated_at":"2016-12-17T00:33:50Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/heroku/heroku-pg/pulls/80","html_url":"https://github.com/heroku/heroku-pg/pull/80","diff_url":"https://github.com/heroku/heroku-pg/pull/80.diff","patch_url":"https://github.com/heroku/heroku-pg/pull/80.patch"},"body":"Seems like showing the certain value (only `Load`, I believe) that you get from pgdiagnose is not working properly. Here is expected response json examples (it's in the test as well):\r\n\r\n```\r\n  {\r\n    \"name\": \"Hit Rate\",\r\n    \"status\": \"red\",\r\n    \"results\": [\r\n      {\r\n        \"name\": \"overall index hit rate\",\r\n        \"ratio\": 0.9861242393582039\r\n      },\r\n      {\r\n        \"name\": \"overall cache hit rate\",\r\n        \"ratio\": 0.9637371701579502\r\n      }\r\n    ]\r\n  },\r\n  {\r\n    \"name\": \"Blocking Queries\",\r\n    \"status\": \"green\",\r\n    \"results\": null\r\n  },\r\n  {\r\n    \"name\": \"Sequences\",\r\n    \"status\": \"green\",\r\n    \"results\": null\r\n  },\r\n  {\r\n    \"name\": \"Load\",\r\n    \"status\": \"red\",\r\n    \"results\": {\r\n      \"load\": \"15.36\"\r\n    }\r\n  }\r\n```\r\n\r\nPreviously, in Ruby version, [it was taken care of this way](https://github.com/heroku/legacy-cli/blob/d7e9718079b9936ffd264529bdd03a6734fd64cc/lib/heroku/helpers/pg_diagnose.rb#L92-L100), which wasn't converted to Node properly.\r\n\r\nIdeally, it'll be like;\r\n\r\n```\r\nRED: Load\r\nLoad 100\r\n```\r\n\r\ninstead of;\r\n\r\n```\r\nRED: Load\r\nload 100\r\n```\r\n\r\nbut seems like Node doesn't have any easy way to capitalize the first letter so...\r\n\r\nCan you please review @ransombriggs ? Thanks!"},"comment":{"url":"https://api.github.com/repos/heroku/heroku-pg/issues/comments/267728806","html_url":"https://github.com/heroku/heroku-pg/pull/80#issuecomment-267728806","issue_url":"https://api.github.com/repos/heroku/heroku-pg/issues/80","id":267728806,"user":{"login":"keiko713","id":911433,"avatar_url":"https://avatars.githubusercontent.com/u/911433?v=3","gravatar_id":"","url":"https://api.github.com/users/keiko713","html_url":"https://github.com/keiko713","followers_url":"https://api.github.com/users/keiko713/followers","following_url":"https://api.github.com/users/keiko713/following{/other_user}","gists_url":"https://api.github.com/users/keiko713/gists{/gist_id}","starred_url":"https://api.github.com/users/keiko713/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/keiko713/subscriptions","organizations_url":"https://api.github.com/users/keiko713/orgs","repos_url":"https://api.github.com/users/keiko713/repos","events_url":"https://api.github.com/users/keiko713/events{/privacy}","received_events_url":"https://api.github.com/users/keiko713/received_events","type":"User","site_admin":false},"created_at":"2016-12-17T00:33:50Z","updated_at":"2016-12-17T00:33:50Z","body":"@ransombriggs your part lgtm ! and nice to have more tests!"}}
{"actor":{"display_login":"keiko713"}}