pg_stat_activity

The view pg_stat_activity shows one row per server process and details about it 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.

Table 1. pg_catalog.pg_stat_activity

column type references description
datid oid pg_database.oid Database OID
datname name   Database name
procpid integer   Process ID of the server process
sess_id integer   Session ID
usesysid oid pg_authid.oid Role OID
usename name   Role name
current_query text   Current query that process is running
waiting boolean   True if waiting on a lock, false if not waiting
query_start timestamp with time zone   Time query began execution
backend_start timestamp with time zone   Time backend process was started
client_addr inet   Client address
client_port integer   Client port
application_name text   Client application name
xact_start timestamp with time zone   Transaction start time
waiting_resource boolean   True if waiting for resource allocation, false if not waiting