show_waiting_queries.sql

SELECT
    client_addr,
    query_start,
    state_change,
    wait_event,
    state,
    EXTRACT(epoch FROM (state_change - query_start)) AS execution_duration,
    EXTRACT(epoch FROM (CURRENT_TIMESTAMP - query_start)) AS total_duration,
    query
FROM
    pg_stat_activity
WHERE
    wait_event IS NOT NULL
    AND application_name = ''
    AND client_addr NOT IN ('10.0.0.247', '127.0.0.1')
    AND backend_type = 'client backend';