franklinjavier

#!/bin/bash
# Script to install Sublime Text on Ubuntu
# Apr 9 2013 - @franklinjavier

echo "Downloading Sublime Text 2"
wget http://c758482.r82.cf2.rackcdn.com/Sublime\ Text\ 2.0.1\ x64.tar.bz2

echo "Unziping and moving"
tar -xvf Sublime\ Text\ 2.0.1\ x64.tar.bz2
mv Sublime\ Text\ 2 sublimeText

rgreenjr

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

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

MohamedAlaa

tmux shortcuts & cheatsheet

start new:

tmux

start new with session name:

tmux new -s myname