This is an English translation of a Japanese blog. Some content may not be fully translated.

Cancelling Queries in Redshift

Published on 2021/07/06 📖 1 min read

AWS

Redshift

select pid, trim(starttime) as start, duration, trim(user_name) as user,substring (query,1,40) as querytxt
from stv_recents
where status = 'Running';

select pg_cancel_backend(16749);

Or:

cancel 16749;

An error message is output on the client side:

client 2 aborted in command 16 (SQL) of script 0; ERROR:  Query (570) cancelled on user's request

https://docs.aws.amazon.com/redshift/latest/dg/r_CANCEL.html https://docs.aws.amazon.com/redshift/latest/dg/PG_CANCEL_BACKEND.html

Suggest an edit on GitHub

AWS

Related articles