Redshift

Currently running queries ordered by longest running first:

SELECT * FROM STV_RECENTS
WHERE status='Running'
ORDER BY duration DESC;

Slowest queries in last 24 hours

SELECT *, endtime-starttime AS duration
FROM STL_QUERY
WHERE starttime>(GETDATE() - INTERVAL '24 HOUR')
ORDER BY (endtime-starttime) DESC;

Looking up a query by transaction ID:

SELECT * FROM STL_QUERY
WHERE xid IN (54059683,54182974,54085206);

Looking up FULL sql text for long queries (split into multiple lines):

SELECT * FROM STL_QUERYTEXT
WHERE xid IN (54059683,54182974,54085206)
ORDER BY query,sequence;

Lookup all statements (including system and DDL) from a transaction:

SELECT * FROM SVL_STATEMENTTEXT
WHERE xid IN (54059683,54182974,54085206)
AND sequence=0
ORDER BY xid,starttime,sequence;