Query Postgres activity

check-pg-activity.sql

select
    datname,
    state,
    usename || ':' || application_name as user_app,
    to_char(query_start, 'YYYY-MM-DD HH24:MI') as query_start,
    to_char(age(now(), query_start), 'HH24:MI') as "age",
    wait_event_type || ':' || wait_event as wait_event,
    left(query, 50) as "query",
    pid
from pg_stat_activity
where pid != pg_backend_pid()
order by datname, state, user_app, query_start;