Nick DeSteffen nick-desteffen

Postgres EXPLAIN Lunch & Learn @ BenchPrep

EXPLAIN Explained video on YouTube

What EXPLAIN doesn't do

Tell you why a particular index isn't used
Explain how to rewrite your queries
Show what other factors make the DB slow
Tell you how much time the request took outside the DB

Setting up a SSL Cert from Comodo

I use Namecheap.com as a registrar, and they resale SSL Certs from a number of other companies, including Comodo.

These are the steps I went through to set up an SSL cert.

Purchase the cert

Benchmark Bundler

Because loading gems can take longer than you think

$ curl -fsSL https://gist.github.com/raw/5022636/benchmark.rb | ruby
............................................................[DONE]

Gem                            Time(sec)     Pct %
--------------------------------------------------

	#!/usr/bin/env python

	import socket
	import ssl
	import sys
	from urlparse import urlparse

	'''Crude test client to a HTTP(S) server listening for proxy protocol
	connections. Takes a HTTP(S) url as an argument and prints out the raw
	response.

	# NOTICE: to get Nginx+Unicorn best-practices configuration see the gist https://gist.github.com/3052776

	$ cd /usr/src
	$ wget http://nginx.org/download/nginx-1.2.1.tar.gz
	$ tar xzvf ./nginx-1.2.1.tar.gz && rm -f ./nginx-1.2.1.tar.gz

	$ wget ftp://ftp.csx.cam.ac.uk/pub/software/programming/pcre/pcre-8.30.tar.gz
	$ tar xzvf pcre-8.30.tar.gz && rm -f ./pcre-8.30.tar.gz

	$ wget http://www.openssl.org/source/openssl-1.0.1c.tar.gz

	#!/bin/sh

	# Some things taken from here
	# https://github.com/mathiasbynens/dotfiles/blob/master/.osx

	# Set the colours you can use
	black='\033[0;30m'
	white='\033[0;37m'
	red='\033[0;31m'
	green='\033[0;32m'

	#! /bin/sh
	### BEGIN INIT INFO
	# Provides: redis-server
	# Required-Start: $syslog
	# Required-Stop: $syslog
	# Should-Start: $local_fs
	# Should-Stop: $local_fs
	# Default-Start: 2 3 4 5
	# Default-Stop: 0 1 6
	# Short-Description: redis-server - Persistent key-value db

	.idea/*
	*.pyc