heroku postgresql waiting connections

waitiing_connections.sh

waiter_list() {
  hk psql -a r101-cedar -c "SELECT * FROM pg_stat_activity WHERE extract(epoch from now() - xact_start) > 60 * 10 AND state = 'idle in transaction'"
}

waiter_cancel() {
  hk psql -a r101-cedar -c "SELECT pid, pg_cancel_backend(pid) FROM pg_stat_activity WHERE extract(epoch from now() - xact_start) > 60 * 10 AND state = 'idle in transaction'"
}

waiter_terminate() {
  hk psql -a r101-cedar -c "SELECT pid, pg_terminate_backend(pid) FROM pg_stat_activity WHERE extract(epoch from now() - xact_start) > 60 * 30 AND state = 'idle in transaction'"
}