long-running-queries-redshift
SELECT i.pid, s.user_name, i.query AS query_id, substring(s.query_text,1,100) AS short_query, s.elapsed_time/1000000 AS duration_sec FROM stv_inflight i JOIN sys_query_history s ON i.query = s.query_id ORDER BY duration_sec DESC; ========================================== SELECT i.pid, s.user_name, s.query_id, substring(s.query_text,1,100) AS short_query, s.elapsed_time/1000000 AS duration_sec FROM stv_inflight i JOIN sys_query_history s ON i.query = s.query_id WHERE s.status = 'running' ORDER BY duration_sec DESC; ============================================= SELECT i.pid, u.usename AS user_name, s.query_id, substring(s.query_text, 1, 100) AS short_query, s.elapsed_time / 1000000 AS duration_sec FROM stv_inflight i JOIN sys_query_history s ...