How to get all the currently running queries in Redshift

Use the below query to identify all the queries currently in process.

select userid , query , pid , starttime , text from stv_inflight order by starttime desc;
See also  How to drop a column from a table in Redshift database