Kill long queries or idle sessions

run every few minutes in crontab:

kill -9 `ps aux | awk '/postgres/ && /idle/ && $10 ~ /^1:/ {print $2}'`