Deep Dive: PostgreSQL on AWS

When loading data

pinnokio / postgres_queries_and_commands.sql

Created March 11, 2016 20:17 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(query_start, clock_timestamp()), 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(query_start, clock_timestamp()), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

pinnokio / nginx.conf

Created January 5, 2016 09:09 — forked from plentz/nginx.conf

Best nginx configuration for improved security(and performance). Complete blog post here http://tautt.com/best-nginx-configuration-for-security/

	# to generate your dhparam.pem file, run in the terminal
	openssl dhparam -out /etc/nginx/ssl/dhparam.pem 2048

pinnokio / tmux.conf

Created December 8, 2015 17:10 — forked from spicycode/tmux.conf

The best and greatest tmux.conf ever

	# 0 is too far from ` ;)
	set -g base-index 1

	# Automatically set window title
	set-window-option -g automatic-rename on
	set-option -g set-titles on

	#set -g default-terminal screen-256color
	set -g status-keys vi
	set -g history-limit 10000

pinnokio / gist:ca173c5738ae29488ece

Created November 13, 2015 15:18 — forked from davidmh/gist:6228319

iTerm Tab & Window Titles with zsh and git. original: http://timbabwe.com/2012/05/iterm_tab_and_window_titles_with_zsh

	function precmd() {
	if command git rev-parse --git-dir > /dev/null 2>&1; then
	window_label=$(git rev-parse --show-toplevel)
	tab_label=$(echo $window_label \| awk -F\/ '{print "[git] " $NF}')
	else
	window_label=${PWD/${HOME}/\~}
	tab_label=$window_label
	fi
	echo -ne "\e]2;${window_label}\a"
	echo -ne "\e]1;${tab_label: -24}\a"

pinnokio / gist:6ecb6c4136f638a5ea78

Last active August 29, 2015 14:18 — forked from dedy-purwanto/gist:11312110

	# There was a day where I have too many color schemes in iTerm2 and I want to remove them all.
	# iTerm2 doesn't have "bulk remove" and it was literally painful to delete them one-by-one.

	# iTerm2 save it's preference in ~/Library/Preferences/com.googlecode.iterm2.plist in a binary format
	# What you need to do is basically copy that somewhere, convert to xml and remove color schemes in the xml files.

	$ cd /tmp/
	$ cp ~/Library/Preferences/com.googlecode.iterm2.plist .
	$ plutil -convert xml1 com.googlecode.iterm2.plist
	$ vi com.googlecode.iterm2.plist

pinnokio / Common_django_deploy

Last active August 29, 2015 14:17

	*BACKEND PART*
	sudo apt-get install -y --no-install-recommends \
	bzr \
	git \
	mercurial \
	subversion \
	ca-certificates \
	curl \
	wget

pinnokio / Logstash.json

Created January 20, 2015 10:55

pinnokio / Kibana_test_db

Created January 20, 2015 10:35

pinnokio / gist:63232e572400ee94fd73

Last active August 29, 2015 14:13 — forked from nside/gist:8078726

	filter {
	grok {
	match => [ "message", "%{TIMESTAMP_ISO8601:ts} \[%{USERNAME:spider}\] %{LOGLEVEL:level}: Crawled %{NUMBER:pages2:int} pages $at %{NUMBER:pages_rate2:int%} pages/min$, scraped %{NUMBER:items2:int} items $at %{NUMBER:items_rate2:int%} items/min$" ]
	}
	}