Skip to content

Instantly share code, notes, and snippets.

@p5k6

p5k6/cursor_query.sql

Created February 28, 2020 20:54
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 p5k6/68528482233d90a4d36b7e548b88c624 to your computer and use it in GitHub Desktop.
Save p5k6/68528482233d90a4d36b7e548b88c624 to your computer and use it in GitHub Desktop.
Download ZIP
gives information behind active cursors in redshift
Raw
cursor_query.sql
select stv_active_cursors.userid, left("name", 23), sequence, "text" from stv_active_cursors join stl_utilitytext on stl_utilitytext.pid=stv_active_cursors.pid order by stv_active_cursors.name, stv_active_cursors.pid, stl_utilitytext.starttime, sequence;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment