SELECT
    procpid,
    START,
    now() - START AS lap,
    current_query
FROM
    (
    SELECT
        backendid,
        pg_stat_get_backend_pid (S.backendid) AS procpid,
        pg_stat_get_backend_activity_start (S.backendid) AS START,
        pg_stat_get_backend_activity (S.backendid) AS current_query
    FROM
        (SELECT pg_stat_get_backend_idset() AS backendid) AS S
    ) AS S
WHERE current_query <> '<IDLE>'
ORDER BY lap DESC;