find long running queries from the stl_query log

redshift_long_running_queries.sql

select u.usename, 
    q.userid, 
    q.query, 
    q.pid, 
    q.database, 
    q.querytxt, 
    listagg(q2.text, ' ') within group (order by q2.sequence) as querytxt2, 
    q.starttime, 
    q.endtime, 
    aborted, 
    datediff('second', q.starttime, q.endtime) as elapsed_sec
from stl_query q 
join pg_user u on u.usesysid = q.userid
    and datediff('second', q.starttime, q.endtime) > 60
left join stl_querytext q2 on q.query = q2.query
group by u.usename, q.userid, q.query, q.pid, q.database, q.querytxt, q.starttime, q.endtime, aborted
order by datediff('second', q.starttime, q.endtime) desc;