Dustin Smith dustinsmith1024

🏀

⛹️

dustinsmith1024 / postgres_queries_and_commands.sql

Last active March 28, 2018 14:58 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	https://www.postgresql.org/docs/9.4/static/monitoring-stats.html
	https://www.postgresql.org/docs/9.4/static/functions-admin.html

	-- show blocking pids in a nice tree
	-- query as blocked_query
	-- 9.6++
	select pid, usename,
	age(query_start, clock_timestamp()),
	pg_blocking_pids(pid) as blocked_by,
	query

dustinsmith1024 / product.js

Last active December 19, 2015 17:09 — forked from jamonholmgren/products.js.coffee

	$(document).on("page:change", function(){
	window.prevPageYOffset = window.pageYOffset;
	window.prevPageXOffset = window.pageXOffset;
	});

	//fix-scroll want needed for me
	$(document).on("page:load", function(){
	window.scrollTo(window.prevPageXOffset, window.prevPageYOffset);
	});