Skip to main content
Version: Next

gp_stat_activity

The pg_stat_activity view is a cluster-wide view that displays the pg_stat_activity information from every primary segment.

columntypereferencesdescription
gp_segment_idintegerUnique identifier of a segment (or coordinator) instance.
datidoidpg_database.oidDatabase OID
datnamenameDatabase name
pidintegerProcess ID of this backend
sess_idintegerSession ID
leader_pidintegerProcess ID of the leader of the session.
usesysidoidpg_authid.oidOID of the user logged into this backend
usenamenameName of the user logged into this backend
application_nametextName of the application that is connected to this backend
client_addrinetIP address of the client connected to this backend. If this field is null, it indicates either that the client is connected via a Unix socket on the server machine or that this is an internal process such as autovacuum.
client_hostnametextHost name of the connected client, as reported by a reverse DNS lookup of client_addr. This field will only be non-null for IP connections, and only when log_hostname is enabled.
client_portintegerTCP port number that the client is using for communication with this backend, or -1 if a Unix socket is used
backend_starttimestamptzTime backend process was started
xact_starttimestamptzTransaction start time
query_starttimestamptzTime query began execution
state_changetimestampzTime when the state was last changed
wait_event_typetextType of event for which the backend is waiting
wait_eventtextWait event name if backend is currently waiting
statetextCurrent overall state of this backend. Possible values are:

- active: The backend is running a query.

- idle: The backend is waiting for a new client command.

- idle in transaction: The backend is in a transaction, but is not currently running a query.

- idle in transaction (aborted): This state is similar to idle in transaction, except one of the statements in the transaction caused an error.

- fastpath function call: The backend is running a fast-path function.

- disabled: This state is reported if track_activities is deactivated in this backend.
backend_xidxidThe current transaction ID (XID) being executed by this backend, if any.
backend_xminxidThe minimum transaction ID that this backend needs to retain.
query_idbigintThe query ID of the currently executing query.
querytextText of this backend's most recent query. If state is active this field shows the currently running query. In all other states, it shows the last query that was run.
backend_typetextDescribes the type of backend process (for example, "client backend", "worker process", "autovacuum worker").
rsgidoidpg_resgroup.oidResource group OID or 0.
rsgnametextpg_resgroup.rsgnameResource group name or unknown.