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.
The maximum length of the query text sting stored in the column current_query can be controlled with the server configuration parameter pgstat_track_activity_query_size.
| 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 | timestampz | Time query began execution | |
| backend_start | timestampz | Time backend process was started | |
| client_addr | inet | Client address | |
| client_port | integer | Client port | |
| application_name | text | Client application name | |
| xact_start | timestampz | Transaction start time | |
| waiting_reason | text | Reason the server process is waiting. The value
can be: lock replication |