{"action":"created","comment":{"url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/comments/129473280","pull_request_review_id":52248814,"id":129473280,"diff_hunk":"@@ -9,4 +9,8 @@ these columns are only visible if the user examining the view is a superuser\n or the same as the user owning the process being reported on.</p><p>The maximum length of the query text sting stored in the column <codeph>current_query</codeph>\n can be controlled with the server configuration parameter <codeph>pgstat_track_activity_query_size</codeph>.\n </p><table id=\"hq141982\"><title>pg_catalog.pg_stat_activity</title><tgroup cols=\"4\"><colspec colnum=\"1\" colname=\"col1\" colwidth=\"131pt\"/><colspec colnum=\"2\" colname=\"col2\" colwidth=\"86pt\"/><colspec colnum=\"3\" colname=\"col3\" colwidth=\"85pt\"/><colspec colnum=\"4\" colname=\"col4\" colwidth=\"147pt\"/><thead><row><entry colname=\"col1\">column</entry><entry colname=\"col2\">type</entry><entry colname=\"col3\">references</entry><entry colname=\"col4\">description</entry></row></thead><tbody><row><entry colname=\"col1\"><codeph>datid</codeph></entry><entry colname=\"col2\">oid</entry><entry colname=\"col3\">pg_database.oid</entry><entry colname=\"col4\">Database OID</entry></row><row><entry colname=\"col1\"><codeph>datname</codeph></entry><entry colname=\"col2\">name</entry><entry colname=\"col3\"/><entry colname=\"col4\">Database name</entry></row><row><entry colname=\"col1\"><codeph>procpid</codeph></entry><entry colname=\"col2\">integer</entry><entry colname=\"col3\"/><entry colname=\"col4\">Process ID of the server process</entry></row><row><entry colname=\"col1\"><codeph>sess_id</codeph></entry><entry colname=\"col2\">integer</entry><entry colname=\"col3\"/><entry colname=\"col4\">Session ID</entry></row><row><entry colname=\"col1\"><codeph>usesysid</codeph></entry><entry colname=\"col2\">oid</entry><entry colname=\"col3\">pg_authid.oid</entry><entry colname=\"col4\">Role OID</entry></row><row><entry colname=\"col1\"><codeph>usename</codeph></entry><entry colname=\"col2\">name</entry><entry colname=\"col3\"/><entry colname=\"col4\">Role name</entry></row><row><entry colname=\"col1\"><codeph>current_query</codeph></entry><entry colname=\"col2\">text</entry><entry colname=\"col3\"/><entry colname=\"col4\">Current query that process is running</entry></row><row><entry colname=\"col1\"><codeph>waiting</codeph></entry><entry colname=\"col2\">boolean</entry><entry colname=\"col3\"/><entry colname=\"col4\">True if waiting on a lock, false if not waiting</entry></row><row><entry colname=\"col1\"><codeph>query_start</codeph></entry><entry colname=\"col2\">timestamptz</entry><entry colname=\"col3\"/><entry colname=\"col4\">Time query began execution</entry></row><row><entry colname=\"col1\"><codeph>backend_start</codeph></entry><entry colname=\"col2\">timestamptz</entry><entry colname=\"col3\"/><entry colname=\"col4\">Time backend process was started</entry></row><row><entry colname=\"col1\"><codeph>client_addr</codeph></entry><entry colname=\"col2\">inet</entry><entry colname=\"col3\"/><entry colname=\"col4\">Client address</entry></row><row><entry colname=\"col1\"><codeph>client_port</codeph></entry><entry colname=\"col2\">integer</entry><entry colname=\"col3\"/><entry colname=\"col4\">Client port</entry></row><row><entry colname=\"col1\"><codeph>application_name</codeph></entry><entry colname=\"col2\">text</entry><entry colname=\"col3\"/><entry colname=\"col4\">Client application name</entry></row><row><entry colname=\"col1\"><codeph>xact_start</codeph></entry><entry colname=\"col2\">timestamptz</entry><entry colname=\"col3\"/><entry colname=\"col4\">Transaction start time</entry></row><row><entry colname=\"col1\"><codeph>waiting_reason</codeph></entry><entry colname=\"col2\">text</entry><entry colname=\"col3\"/><entry colname=\"col4\">Reason the server process is waiting. The value\n-can be:<p>lock replication</p></entry></row></tbody></tgroup></table></body></topic>\n\\ No newline at end of file\n+can be:<p>lock replication</p></entry></row>","path":"gpdb-doc/dita/ref_guide/system_catalogs/pg_stat_activity.xml","position":6,"original_position":6,"commit_id":"cec094f213a23f00c8b184a0448146e7f9b36017","original_commit_id":"cec094f213a23f00c8b184a0448146e7f9b36017","user":{"login":"xiong-gang","id":14144434,"avatar_url":"https://avatars0.githubusercontent.com/u/14144434?v=4","gravatar_id":"","url":"https://api.github.com/users/xiong-gang","html_url":"https://github.com/xiong-gang","followers_url":"https://api.github.com/users/xiong-gang/followers","following_url":"https://api.github.com/users/xiong-gang/following{/other_user}","gists_url":"https://api.github.com/users/xiong-gang/gists{/gist_id}","starred_url":"https://api.github.com/users/xiong-gang/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/xiong-gang/subscriptions","organizations_url":"https://api.github.com/users/xiong-gang/orgs","repos_url":"https://api.github.com/users/xiong-gang/repos","events_url":"https://api.github.com/users/xiong-gang/events{/privacy}","received_events_url":"https://api.github.com/users/xiong-gang/received_events","type":"User","site_admin":false},"body":"we added a new 'reason' `g` represent resource group","created_at":"2017-07-26T03:03:38Z","updated_at":"2017-07-26T03:03:38Z","html_url":"https://github.com/greenplum-db/gpdb/pull/2825#discussion_r129473280","pull_request_url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/2825","_links":{"self":{"href":"https://api.github.com/repos/greenplum-db/gpdb/pulls/comments/129473280"},"html":{"href":"https://github.com/greenplum-db/gpdb/pull/2825#discussion_r129473280"},"pull_request":{"href":"https://api.github.com/repos/greenplum-db/gpdb/pulls/2825"}}},"pull_request":{"url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/2825","id":132336314,"html_url":"https://github.com/greenplum-db/gpdb/pull/2825","diff_url":"https://github.com/greenplum-db/gpdb/pull/2825.diff","patch_url":"https://github.com/greenplum-db/gpdb/pull/2825.patch","issue_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/2825","number":2825,"state":"open","locked":false,"title":"docs - resource groups catalog table additions/updates","user":{"login":"lisakowen","id":19785845,"avatar_url":"https://avatars2.githubusercontent.com/u/19785845?v=4","gravatar_id":"","url":"https://api.github.com/users/lisakowen","html_url":"https://github.com/lisakowen","followers_url":"https://api.github.com/users/lisakowen/followers","following_url":"https://api.github.com/users/lisakowen/following{/other_user}","gists_url":"https://api.github.com/users/lisakowen/gists{/gist_id}","starred_url":"https://api.github.com/users/lisakowen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lisakowen/subscriptions","organizations_url":"https://api.github.com/users/lisakowen/orgs","repos_url":"https://api.github.com/users/lisakowen/repos","events_url":"https://api.github.com/users/lisakowen/events{/privacy}","received_events_url":"https://api.github.com/users/lisakowen/received_events","type":"User","site_admin":false},"body":"create 2 new, update 3 existing, system catalog tables for resource group support:\r\n- pg_authid - add rolresgroup column\r\n- pg_resgroup - new catalog table\r\n- pg_resgroupcapability - new catalog table\r\n- pg_roles - add rolresgroup column\r\n- pg_stat_activity - add rsgid, rsgname, rsgqueueduration","created_at":"2017-07-25T17:25:09Z","updated_at":"2017-07-26T03:03:38Z","closed_at":null,"merged_at":null,"merge_commit_sha":"6b828290d2efc5ef990fc0cd98ce3ebf024e5e2f","assignee":null,"assignees":[],"requested_reviewers":[{"login":"gaos1","id":1188196,"avatar_url":"https://avatars0.githubusercontent.com/u/1188196?v=4","gravatar_id":"","url":"https://api.github.com/users/gaos1","html_url":"https://github.com/gaos1","followers_url":"https://api.github.com/users/gaos1/followers","following_url":"https://api.github.com/users/gaos1/following{/other_user}","gists_url":"https://api.github.com/users/gaos1/gists{/gist_id}","starred_url":"https://api.github.com/users/gaos1/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/gaos1/subscriptions","organizations_url":"https://api.github.com/users/gaos1/orgs","repos_url":"https://api.github.com/users/gaos1/repos","events_url":"https://api.github.com/users/gaos1/events{/privacy}","received_events_url":"https://api.github.com/users/gaos1/received_events","type":"User","site_admin":false},{"login":"dyozie","id":5695830,"avatar_url":"https://avatars0.githubusercontent.com/u/5695830?v=4","gravatar_id":"","url":"https://api.github.com/users/dyozie","html_url":"https://github.com/dyozie","followers_url":"https://api.github.com/users/dyozie/followers","following_url":"https://api.github.com/users/dyozie/following{/other_user}","gists_url":"https://api.github.com/users/dyozie/gists{/gist_id}","starred_url":"https://api.github.com/users/dyozie/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dyozie/subscriptions","organizations_url":"https://api.github.com/users/dyozie/orgs","repos_url":"https://api.github.com/users/dyozie/repos","events_url":"https://api.github.com/users/dyozie/events{/privacy}","received_events_url":"https://api.github.com/users/dyozie/received_events","type":"User","site_admin":false}],"milestone":null,"commits_url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/2825/commits","review_comments_url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/2825/comments","review_comment_url":"https://api.github.com/repos/greenplum-db/gpdb/pulls/comments{/number}","comments_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/2825/comments","statuses_url":"https://api.github.com/repos/greenplum-db/gpdb/statuses/cec094f213a23f00c8b184a0448146e7f9b36017","head":{"label":"lisakowen:feature/resgroup-catalog","ref":"feature/resgroup-catalog","sha":"cec094f213a23f00c8b184a0448146e7f9b36017","user":{"login":"lisakowen","id":19785845,"avatar_url":"https://avatars2.githubusercontent.com/u/19785845?v=4","gravatar_id":"","url":"https://api.github.com/users/lisakowen","html_url":"https://github.com/lisakowen","followers_url":"https://api.github.com/users/lisakowen/followers","following_url":"https://api.github.com/users/lisakowen/following{/other_user}","gists_url":"https://api.github.com/users/lisakowen/gists{/gist_id}","starred_url":"https://api.github.com/users/lisakowen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lisakowen/subscriptions","organizations_url":"https://api.github.com/users/lisakowen/orgs","repos_url":"https://api.github.com/users/lisakowen/repos","events_url":"https://api.github.com/users/lisakowen/events{/privacy}","received_events_url":"https://api.github.com/users/lisakowen/received_events","type":"User","site_admin":false},"repo":{"id":80570844,"name":"gpdb","full_name":"lisakowen/gpdb","owner":{"login":"lisakowen","id":19785845,"avatar_url":"https://avatars2.githubusercontent.com/u/19785845?v=4","gravatar_id":"","url":"https://api.github.com/users/lisakowen","html_url":"https://github.com/lisakowen","followers_url":"https://api.github.com/users/lisakowen/followers","following_url":"https://api.github.com/users/lisakowen/following{/other_user}","gists_url":"https://api.github.com/users/lisakowen/gists{/gist_id}","starred_url":"https://api.github.com/users/lisakowen/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/lisakowen/subscriptions","organizations_url":"https://api.github.com/users/lisakowen/orgs","repos_url":"https://api.github.com/users/lisakowen/repos","events_url":"https://api.github.com/users/lisakowen/events{/privacy}","received_events_url":"https://api.github.com/users/lisakowen/received_events","type":"User","site_admin":false},"private":false,"html_url":"https://github.com/lisakowen/gpdb","description":"Greenplum Database","fork":true,"url":"https://api.github.com/repos/lisakowen/gpdb","forks_url":"https://api.github.com/repos/lisakowen/gpdb/forks","keys_url":"https://api.github.com/repos/lisakowen/gpdb/keys{/key_id}","collaborators_url":"https://api.github.com/repos/lisakowen/gpdb/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/lisakowen/gpdb/teams","hooks_url":"https://api.github.com/repos/lisakowen/gpdb/hooks","issue_events_url":"https://api.github.com/repos/lisakowen/gpdb/issues/events{/number}","events_url":"https://api.github.com/repos/lisakowen/gpdb/events","assignees_url":"https://api.github.com/repos/lisakowen/gpdb/assignees{/user}","branches_url":"https://api.github.com/repos/lisakowen/gpdb/branches{/branch}","tags_url":"https://api.github.com/repos/lisakowen/gpdb/tags","blobs_url":"https://api.github.com/repos/lisakowen/gpdb/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/lisakowen/gpdb/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/lisakowen/gpdb/git/refs{/sha}","trees_url":"https://api.github.com/repos/lisakowen/gpdb/git/trees{/sha}","statuses_url":"https://api.github.com/repos/lisakowen/gpdb/statuses/{sha}","languages_url":"https://api.github.com/repos/lisakowen/gpdb/languages","stargazers_url":"https://api.github.com/repos/lisakowen/gpdb/stargazers","contributors_url":"https://api.github.com/repos/lisakowen/gpdb/contributors","subscribers_url":"https://api.github.com/repos/lisakowen/gpdb/subscribers","subscription_url":"https://api.github.com/repos/lisakowen/gpdb/subscription","commits_url":"https://api.github.com/repos/lisakowen/gpdb/commits{/sha}","git_commits_url":"https://api.github.com/repos/lisakowen/gpdb/git/commits{/sha}","comments_url":"https://api.github.com/repos/lisakowen/gpdb/comments{/number}","issue_comment_url":"https://api.github.com/repos/lisakowen/gpdb/issues/comments{/number}","contents_url":"https://api.github.com/repos/lisakowen/gpdb/contents/{+path}","compare_url":"https://api.github.com/repos/lisakowen/gpdb/compare/{base}...{head}","merges_url":"https://api.github.com/repos/lisakowen/gpdb/merges","archive_url":"https://api.github.com/repos/lisakowen/gpdb/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/lisakowen/gpdb/downloads","issues_url":"https://api.github.com/repos/lisakowen/gpdb/issues{/number}","pulls_url":"https://api.github.com/repos/lisakowen/gpdb/pulls{/number}","milestones_url":"https://api.github.com/repos/lisakowen/gpdb/milestones{/number}","notifications_url":"https://api.github.com/repos/lisakowen/gpdb/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/lisakowen/gpdb/labels{/name}","releases_url":"https://api.github.com/repos/lisakowen/gpdb/releases{/id}","deployments_url":"https://api.github.com/repos/lisakowen/gpdb/deployments","created_at":"2017-01-31T22:56:53Z","updated_at":"2017-01-31T22:58:27Z","pushed_at":"2017-07-26T02:00:38Z","git_url":"git://github.com/lisakowen/gpdb.git","ssh_url":"git@github.com:lisakowen/gpdb.git","clone_url":"https://github.com/lisakowen/gpdb.git","svn_url":"https://github.com/lisakowen/gpdb","homepage":"http://greenplum.org","size":214746,"stargazers_count":0,"watchers_count":0,"language":"C","has_issues":false,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":0,"mirror_url":null,"open_issues_count":0,"forks":0,"open_issues":0,"watchers":0,"default_branch":"master"}},"base":{"label":"greenplum-db:master","ref":"master","sha":"684fe68f8350f722b34cd408abdcc2b903c6cdb0","user":{"login":"greenplum-db","id":14097842,"avatar_url":"https://avatars2.githubusercontent.com/u/14097842?v=4","gravatar_id":"","url":"https://api.github.com/users/greenplum-db","html_url":"https://github.com/greenplum-db","followers_url":"https://api.github.com/users/greenplum-db/followers","following_url":"https://api.github.com/users/greenplum-db/following{/other_user}","gists_url":"https://api.github.com/users/greenplum-db/gists{/gist_id}","starred_url":"https://api.github.com/users/greenplum-db/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/greenplum-db/subscriptions","organizations_url":"https://api.github.com/users/greenplum-db/orgs","repos_url":"https://api.github.com/users/greenplum-db/repos","events_url":"https://api.github.com/users/greenplum-db/events{/privacy}","received_events_url":"https://api.github.com/users/greenplum-db/received_events","type":"Organization","site_admin":false},"repo":{"id":44781140,"name":"gpdb","full_name":"greenplum-db/gpdb","owner":{"login":"greenplum-db","id":14097842,"avatar_url":"https://avatars2.githubusercontent.com/u/14097842?v=4","gravatar_id":"","url":"https://api.github.com/users/greenplum-db","html_url":"https://github.com/greenplum-db","followers_url":"https://api.github.com/users/greenplum-db/followers","following_url":"https://api.github.com/users/greenplum-db/following{/other_user}","gists_url":"https://api.github.com/users/greenplum-db/gists{/gist_id}","starred_url":"https://api.github.com/users/greenplum-db/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/greenplum-db/subscriptions","organizations_url":"https://api.github.com/users/greenplum-db/orgs","repos_url":"https://api.github.com/users/greenplum-db/repos","events_url":"https://api.github.com/users/greenplum-db/events{/privacy}","received_events_url":"https://api.github.com/users/greenplum-db/received_events","type":"Organization","site_admin":false},"private":false,"html_url":"https://github.com/greenplum-db/gpdb","description":"Greenplum Database","fork":false,"url":"https://api.github.com/repos/greenplum-db/gpdb","forks_url":"https://api.github.com/repos/greenplum-db/gpdb/forks","keys_url":"https://api.github.com/repos/greenplum-db/gpdb/keys{/key_id}","collaborators_url":"https://api.github.com/repos/greenplum-db/gpdb/collaborators{/collaborator}","teams_url":"https://api.github.com/repos/greenplum-db/gpdb/teams","hooks_url":"https://api.github.com/repos/greenplum-db/gpdb/hooks","issue_events_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/events{/number}","events_url":"https://api.github.com/repos/greenplum-db/gpdb/events","assignees_url":"https://api.github.com/repos/greenplum-db/gpdb/assignees{/user}","branches_url":"https://api.github.com/repos/greenplum-db/gpdb/branches{/branch}","tags_url":"https://api.github.com/repos/greenplum-db/gpdb/tags","blobs_url":"https://api.github.com/repos/greenplum-db/gpdb/git/blobs{/sha}","git_tags_url":"https://api.github.com/repos/greenplum-db/gpdb/git/tags{/sha}","git_refs_url":"https://api.github.com/repos/greenplum-db/gpdb/git/refs{/sha}","trees_url":"https://api.github.com/repos/greenplum-db/gpdb/git/trees{/sha}","statuses_url":"https://api.github.com/repos/greenplum-db/gpdb/statuses/{sha}","languages_url":"https://api.github.com/repos/greenplum-db/gpdb/languages","stargazers_url":"https://api.github.com/repos/greenplum-db/gpdb/stargazers","contributors_url":"https://api.github.com/repos/greenplum-db/gpdb/contributors","subscribers_url":"https://api.github.com/repos/greenplum-db/gpdb/subscribers","subscription_url":"https://api.github.com/repos/greenplum-db/gpdb/subscription","commits_url":"https://api.github.com/repos/greenplum-db/gpdb/commits{/sha}","git_commits_url":"https://api.github.com/repos/greenplum-db/gpdb/git/commits{/sha}","comments_url":"https://api.github.com/repos/greenplum-db/gpdb/comments{/number}","issue_comment_url":"https://api.github.com/repos/greenplum-db/gpdb/issues/comments{/number}","contents_url":"https://api.github.com/repos/greenplum-db/gpdb/contents/{+path}","compare_url":"https://api.github.com/repos/greenplum-db/gpdb/compare/{base}...{head}","merges_url":"https://api.github.com/repos/greenplum-db/gpdb/merges","archive_url":"https://api.github.com/repos/greenplum-db/gpdb/{archive_format}{/ref}","downloads_url":"https://api.github.com/repos/greenplum-db/gpdb/downloads","issues_url":"https://api.github.com/repos/greenplum-db/gpdb/issues{/number}","pulls_url":"https://api.github.com/repos/greenplum-db/gpdb/pulls{/number}","milestones_url":"https://api.github.com/repos/greenplum-db/gpdb/milestones{/number}","notifications_url":"https://api.github.com/repos/greenplum-db/gpdb/notifications{?since,all,participating}","labels_url":"https://api.github.com/repos/greenplum-db/gpdb/labels{/name}","releases_url":"https://api.github.com/repos/greenplum-db/gpdb/releases{/id}","deployments_url":"https://api.github.com/repos/greenplum-db/gpdb/deployments","created_at":"2015-10-23T00:25:17Z","updated_at":"2017-07-24T06:00:32Z","pushed_at":"2017-07-26T02:28:45Z","git_url":"git://github.com/greenplum-db/gpdb.git","ssh_url":"git@github.com:greenplum-db/gpdb.git","clone_url":"https://github.com/greenplum-db/gpdb.git","svn_url":"https://github.com/greenplum-db/gpdb","homepage":"http://greenplum.org","size":214953,"stargazers_count":2011,"watchers_count":2011,"language":"C","has_issues":true,"has_projects":true,"has_downloads":true,"has_wiki":true,"has_pages":false,"forks_count":624,"mirror_url":null,"open_issues_count":139,"forks":624,"open_issues":139,"watchers":2011,"default_branch":"master"}},"_links":{"self":{"href":"https://api.github.com/repos/greenplum-db/gpdb/pulls/2825"},"html":{"href":"https://github.com/greenplum-db/gpdb/pull/2825"},"issue":{"href":"https://api.github.com/repos/greenplum-db/gpdb/issues/2825"},"comments":{"href":"https://api.github.com/repos/greenplum-db/gpdb/issues/2825/comments"},"review_comments":{"href":"https://api.github.com/repos/greenplum-db/gpdb/pulls/2825/comments"},"review_comment":{"href":"https://api.github.com/repos/greenplum-db/gpdb/pulls/comments{/number}"},"commits":{"href":"https://api.github.com/repos/greenplum-db/gpdb/pulls/2825/commits"},"statuses":{"href":"https://api.github.com/repos/greenplum-db/gpdb/statuses/cec094f213a23f00c8b184a0448146e7f9b36017"}}}}
{"actor":{"display_login":"xiong-gang"}}