bryaneaton · July 6, 2021 18:08
diff --git a/long_running_queries.sh b/long_running_queries.sh
 #!/bin/bash


 export PGPASSWORD='SparklyBannana86' && psql -h gistnebula -p 5501 -d wstamp_staging -U worker -c "SELECT
  pid,
  now() - pg_stat_activity.query_start AS duration,
  query,
  state
 FROM pg_stat_activity
 WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes';
 "
	#!/bin/bash


	export PGPASSWORD='SparklyBannana86' && psql -h gistnebula -p 5501 -d wstamp_staging -U worker -c "SELECT
	pid,
	now() - pg_stat_activity.query_start AS duration,
	query,
	state
	FROM pg_stat_activity
	WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes';
	"