mawaldne

The Phoenix Project

Meditations

Ego Is the Enemy

Smarter Faster Better

Flash Boys: A Wall Street Revolt

mawaldne

package yourpackage

import org.scalatra.auth.strategy.BasicAuthSupport
import org.scalatra.auth.{ScentryConfig, ScentryStrategy, ScentrySupport}
import org.scalatra.{ScalatraBase, Unauthorized}
import javax.servlet.http.{HttpServletRequest, HttpServletResponse}
import java.util.Locale

class TokenAuthRequest(r: HttpServletRequest) {

mawaldne

-- show running queries (9.2)
SELECT pid, client_addr, age(clock_timestamp(), query_start), usename, query, state 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- kill running query
SELECT pg_cancel_backend(procpid);

-- kill idle query

mawaldne

package main

import (	
	"log"
	"os/exec"
	"syscall"
	"time"
)

type Process struct {