Volodymyr Hotsyk hotsyk

hotsyk / elasticsearch-cheatsheet.txt

Created May 24, 2018 23:49 — forked from stephen-puiszis/elasticsearch-cheatsheet.txt

Elasticsearch Cheatsheet - An Overview of Commonly Used Elasticsearch API Endpoints and What They Do

	# Elasticsearch Cheatsheet - an overview of commonly used Elasticsearch API commands

	# cat paths
	/_cat/allocation
	/_cat/shards
	/_cat/shards/{index}
	/_cat/master
	/_cat/nodes
	/_cat/indices
	/_cat/indices/{index}

hotsyk / postgres_queries_and_commands.sql

Last active April 26, 2017 19:59 — 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%'

hotsyk / tree.md

Created May 26, 2012 19:32 — forked from hrldcpr/tree.md

one-line tree in python

One-line Tree in Python

Using Python's built-in defaultdict we can easily define a tree data structure:

def tree(): return defaultdict(tree)

That's it!

hotsyk / mongolyze.py

Created February 22, 2012 13:41 — forked from sergray/mongolyze.py

Python script for automated analysis of slow queries in mongodb

	"""
	Script for automated analysis of profiling data in MongoDB,
	gathered by Mongo with db.setProfilingLevel(1).

	See <http://www.mongodb.org/display/DOCS/Database+Profiler>

	TODO: pass collection and database with profiling data in arguments
	TODO: make thread-safe
	"""
	from collections import defaultdict

hotsyk / gist:1885208

Created February 22, 2012 13:41

Sublime Text 2 - Useful Shortcuts

Loosely ordered with the commands I use most towards the top. Sublime also offer full documentation.

hotsyk / fabric script

Created July 23, 2010 10:41 — forked from eugenepyvovarov/fabric script

	"""

	This fabric file makes setting up and deploying a django application much
	easier, but it does make a few assumptions. Namely that you're using Git,
	Apache and mod_wsgi and your using Debian or Ubuntu. Also you should have
	Django installed on your local machine and SSH installed on both the local
	machine and any servers you want to deploy to.

	_note that I've used the name project_name throughout this example. Replace
	this with whatever your project is called._