PostgreSQL enables you to quick check last query executed by each session. To do this you need only one query.

Query

select pid,
       usename as username,
       datname as database_name,
       query,
       application_name,
       backend_start,
       state,
       state_change
from pg_stat_activity
where pid = 'chosen_session';

Columns

• pid - process ID of chosen session
• username - name of the user logged into this backend
• database_name - name of the database this backend is connected to
• query - most recent query
• application_name - name of the application that is connected to this backend
• backend_start - time when this process was started. For client backends, this is the time the client connected to the server.
• state - current overall state of this backend. Possible values are:
  • active
  • idle
  • idle in transaction
  • idle in transaction (aborted)
  • fastpath function call
  • disabled
• state_change - time when the state was last changed

Rows

• Query returns just one row

Sample results