Useful queries for working with AWS Redshift

aws_redshift_queries.sql

-- find recent queries that hit disk
SELECT query, substring
FROM svl_qlog join svl_query_summary using(query)
WHERE starttime > date(getdate()) - interval '1 day'
  AND is_diskbased = 't';
                   
-- see query execution details
SELECT query, step, rows, workmem, label, is_diskbased
FROM svl_query_summary
WHERE query = 321925
ORDER BY workmem DESC;