Skip to content

Instantly share code, notes, and snippets.

@diogoaurelio

diogoaurelio/redshift_in_flight_queries.sql

Created September 25, 2018 15:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save diogoaurelio/0b93c2e4323256c5989a6379ed6ae633 to your computer and use it in GitHub Desktop.
Save diogoaurelio/0b93c2e4323256c5989a6379ed6ae633 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
redshift_in_flight_queries.sql
# Redshift - check currently running queries; useful for misbehaving queries;
SELECT
userid
, query
, pid
, starttime
, left(text, 100) as query
FROM stv_inflight;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment