Matteo Redaelli matteoredaelli

I like programming ;-) For more info look at - https://gitlab.com/matteoredaelli/ - http://www.redaelli.org/matteo/

adamantnz / RedshiftQueries.sql

Last active November 26, 2020 18:20

Useful AWS Redshift Queries

	/* show running queries */
	select pid, user_name, starttime, query
	from stv_recents
	where lower(status) = 'running';

	/* show recent completed queries */
	select pid, user_name, starttime, query
	from stv_recents
	where lower(status) = 'done'
	order by starttime desc;