Skip to content

Instantly share code, notes, and snippets.

View hotsyk's full-sized avatar

Volodymyr Hotsyk hotsyk

112 followers · 120 following
View GitHub Profile
@hotsyk
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
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
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
hotsyk / keybase.md
Last active September 9, 2019 20:35

Keybase proof

I hereby claim:

  • I am hotsyk on github.
  • I am hotsyk (https://keybase.io/hotsyk) on keybase.
  • I have a public key whose fingerprint is C89F 6A44 3E9B E20B 1EA7 7763 4064 F790 B2A6 B2A6

To claim this, I am signing this object: