jhjwind / postgres_queries_and_commands.sql

Created September 26, 2017 21:54 — 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%'

jhjwind / gist:543d3a7c19369c257054d3216a9572e2

Created March 21, 2017 03:52 — forked from voidfiles/gist:2860137

Get Pocket Bookmarklet

	// The Bookmarklet
	javascript: (function() %
	7BISRIL_H = '8e7a';
	PKT_D = 'getpocket.com';
	ISRIL_SCRIPT = document.createElement('SCRIPT');
	ISRIL_SCRIPT.type = 'text/javascript';
	ISRIL_SCRIPT.src = 'http://' + PKT_D + '/b/r.js';
	document.getElementsByTagName('head') % 5B0 % 5D.appendChild(ISRIL_SCRIPT) % 7D)();

jhjwind / gist:c25be1993fc2e17c48c5e51aa341b6be

Created March 21, 2017 03:52 — forked from voidfiles/gist:2860137

Get Pocket Bookmarklet

	// The Bookmarklet
	javascript: (function() %
	7BISRIL_H = '8e7a';
	PKT_D = 'getpocket.com';
	ISRIL_SCRIPT = document.createElement('SCRIPT');
	ISRIL_SCRIPT.type = 'text/javascript';
	ISRIL_SCRIPT.src = 'http://' + PKT_D + '/b/r.js';
	document.getElementsByTagName('head') % 5B0 % 5D.appendChild(ISRIL_SCRIPT) % 7D)();

jhjwind / ladder.md

Created January 17, 2017 23:10 — forked from jamtur01/ladder.md

Kickstarter Engineering Ladder

These are the Kickstarter Engineering and Data role definitions for both teams.

jhjwind / Readm.md

Created November 30, 2016 04:54 — forked from jeroenvandijk/Readm.md

Instructions to test Logstash with Kafka

Test Logstash with Kafka

Setup Kafka

Download Kafka from:

https://www.apache.org/dyn/closer.cgi/incubator/kafka/kafka-0.7.2-incubating/kafka-0.7.2-incubating-src.tgz

Install Kafka

jhjwind / rvm2rbenv.txt

Created November 19, 2016 22:48 — forked from brentertz/rvm2rbenv.txt

Switch from RVM to RBENV

	## Prepare ###################################################################

	# Remove RVM
	rvm implode

	# Ensure your homebrew is working properly and up to date
	brew doctor
	brew update

	## Install ###################################################################

jhjwind / gist:7b62e06f174bb329bb0e0ec6c8af396f

Created October 24, 2016 15:27 — forked from j3j5/gist:8b3e48ccad746b90a54a

Adyen Test Card Numbers

	Adyen Test Card Numbers
	These cards are only valid on our TEST system and they will never involve any actual transaction or transfer of funds. The TEST card numbers will not work on the Adyen LIVE Platform.

	For all cards use the following expiration and CVV2/CVC2/or CID for Amex.

	For all cards:

	Expiration Dates CVV2 / CVC3 CID (American Express)
	06/2016 OR 08/2018 737 7373

jhjwind / script

Last active August 29, 2015 14:22

Profile model deprecation plan

	#Step 1
	heroku run rake db:migrate

	#step 2
	heroku run rake profiles_to_companies:move_active
	heroku run rake profiles_to_companies:move_inactive
	heroku run rake remove_profile:migrate_profile

	#step 3
	heroku run rake remove_profile:migrate_seats

jhjwind / gist:c3ee55a38fc90cd953c2

Created April 1, 2015 20:05

postgres finding missing index

	SELECT relname, seq_scan-idx_scan AS too_much_seq, case when seq_scan-idx_scan>0 THEN 'Missing Index?' ELSE 'OK' END, pg_relation_size(relname::regclass) AS rel_size, seq_scan, idx_scan
	FROM pg_stat_all_tables
	WHERE schemaname='public' AND pg_relation_size(relname::regclass)>80000 ORDER BY too_much_seq DESC;

jhjwind / spree_backend_install.md

Last active August 29, 2015 14:06 — forked from huoxito/spree_backend_install.md

rails new store-backend

gem 'spree_backend', github: 'spree/spree'