The view pg_stat_activity shows one row per server process with details about the associated user session and query. The columns that report data on the current query are available unless the parameter stats_command_string has been turned off. Furthermore, these columns are only visible if the user examining the view is a superuser or the same as the user owning the process being reported on.
The maximum length of the query text string stored in the column query can be controlled with the server configuration parameter track_activity_query_size.
|pid||integer||Process ID of this backend|
|usesysid||oid||pg_authid.oid||OID of the user logged into this backend|
|usename||name||Name of the user logged into this backend|
|application_name||text||Name of the application that is connected to this backend|
|client_addr||inet||IP 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_hostname||text||Host 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_port||integer||TCP port number that the client is using for communication with this backend, or -1 if a Unix socket is used|
|backend_start||timestamptz||Time backend process was started|
|xact_start||timestamptz||Transaction start time|
|query_start||timestamptz||Time query began execution|
|state_change||timestampz||Time when the state was last changed|
|waiting||boolean||True if waiting on a lock, false if not waiting|
|state||text||Current overall state of this backend. Possible values are:
|query||text||Text 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.|
|waiting_reason||text||Reason the server process is waiting. The value can be:
lock, replication, or resgroup
|rsgid||oid||pg_resgroup.oid||Resource group OID or 0.
|rsgname||text||pg_resgroup.rsgname||Resource group name or unknown.
|rsgqueueduration||interval||For a queued query, the total time the query has been queued.|