pg_stat_activity_global

The pg_stat_activity_global system view provides information of the queries runing in the cluster.

Table 1. pg_catalog.pg_stat_activity_global

column	type	references	description
datid	oid		database oid
datname	name		database name
host	text		host of main node that run the query
procpid	integer		process ID
sess_id	integer		session ID
usesysid	oid		user OID
usename	name		user name
current_query	text		current query
waiting	boolean		query’s waiting status
query_start	timestamp with time zone		time at which the current query began execution
backend_start	timestamp with time zone		time at which he process was started
client_addr	inet		client’s address number
client_port	integer		client’s port number
application_name	text		the name of backend process connect to server
xact_start	timestamp with time zone		time at which the current transaction started. Null when the process is without transaction.
waiting_resource	boolean		status of waiting for resource manager.