Jay Zeng jayzeng

Slow queries:

SELECT (SELECT datname FROM pg_database WHERE dbid = oid), query, calls,  (total_time / 1000 / 60) as total_minutes, (total_time/calls) as average_time FROM pg_stat_statements ORDER BY total_time DESC limit 5;

Missing indexes

SELECT relname, seq_scan, seq_tup_read, idx_scan, seq_tup_read / seq_scan as ratio from pg_stat_user_tables where seq_scan > 0 order by seq_tup_read desc limit 10;

create table mytable_clone (like mytable including defaults including constraints including indexes);

How to recover lost Python source code if it's still resident in-memory

I screwed up using git ("git checkout --" on the wrong file) and managed to delete the code I had just written... but it was still running in a process in a docker container. Here's how I got it back, using https://pypi.python.org/pypi/pyrasite/ and https://pypi.python.org/pypi/uncompyle6

Attach a shell to the docker container

Install GDB (needed by pyrasite)

apt-get update && apt-get install gdb

	This is an example how to perform multi-select faceting in ElasticSearch.

	Selecting multiple values from the same facet will result in an OR filter between each of the values:
	(facet1.value1 OR facet1.value2)

	Faceting on more than one facet will result in an AND filter between each facet:
	(facet1.value1 OR facet1.value2) AND (facet2.value1)

	I have chosen to update the counts for each facet the selected value DOES NOT belong to since we are performing an AND between each facet. I have included an example that shows how to keep the counts if you don't want to do this (filter0.sh).

	/jshint globalstrict:true /
	/global angular:true /
	'use strict';

	angular.module('demo', [
	'demo.controllers',
	'demo.directives',
	'elasticjs.service'
	]);

	import subprocess
	import json
	import os, errno
	import argparse

	def mkdir_p(path):
	try:
	os.makedirs(path)
	except OSError as exc:
	if exc.errno == errno.EEXIST and os.path.isdir(path):

	import boto
	import json
	from boto.sqs.message import Message

	sqs = boto.connect_sqs()
	queue = sqs.get_queue('queue')

	mess = {
	"test":"hello world"
	}

	import subprocess
	import json
	import os, errno
	import argparse

	def mkdir_p(path):
	try:
	os.makedirs(path)
	except OSError as exc:
	if exc.errno == errno.EEXIST and os.path.isdir(path):

	from app import app
	from werkzeug.contrib.profiler import ProfilerMiddleware

	if __name__ == '__main__':
	app.config['PROFILE'] = True
	app.wsgi_app = ProfilerMiddleware(app.wsgi_app, restrictions=[30])
	app.run()

	---
	# ^^^ YAML documents must begin with the document separator "---"
	#
	#### Example docblock, I like to put a descriptive comment at the top of my
	#### playbooks.
	#
	# Overview: Playbook to bootstrap a new host for configuration management.
	# Applies to: production
	# Description:
	# Ensures that a host is configured for management with Ansible.