Skip to content

Instantly share code, notes, and snippets.

@yujihamaguchi

yujihamaguchi/list_running_pid.sql

Created July 14, 2014 06:53
Show Gist options
  • Save yujihamaguchi/6e42e33f16847a570a71 to your computer and use it in GitHub Desktop.
Save yujihamaguchi/6e42e33f16847a570a71 to your computer and use it in GitHub Desktop.
Download ZIP
[Redshift] 実行中のプロセスをリスト
Raw
list_running_pid.sql
select pid, starttime, duration,
trim(user_name) as user,
trim (query) as querytxt
from stv_recents
where status = 'Running';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment