Skip to content

Instantly share code, notes, and snippets.

View mswain's full-sized avatar

Matthew Swain mswain

  • Literati
  • Austin, TX
View GitHub Profile

Keybase proof

I hereby claim:

  • I am mswain on github.
  • I am mswain (https://keybase.io/mswain) on keybase.
  • I have a public key ASC5XX2dMWf4w_6KFeXINITDdVZ5aPKhvp-0d90yScOEiAo

To claim this, I am signing this object:

@mswain
mswain / postgres_queries_and_commands.sql
Created October 10, 2017 15:17 — 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%'

Keybase proof

I hereby claim:

  • I am mswain on github.
  • I am mswain (https://keybase.io/mswain) on keybase.
  • I have a public key whose fingerprint is 6DF1 7524 E717 2FE3 357A 805E ED69 88DA 052A 2544

To claim this, I am signing this object:

@mswain
mswain / gist:8498197
Created January 18, 2014 23:23
Redis Client monkeypatch.
class Redis
def keys(pattern = "*")
raise "I hate you."
end
end
redis 127.0.0.1:9999> iamafuckinmoronwhodoesntlistenandwantstocrashredis
(error) ERR wrong number of arguments for 'iamafuckinmoronwhodoesntlistenandwantstocrashredis' command
redis 127.0.0.1:9999> iamafuckinmoronwhodoesntlistenandwantstocrashredis *
(empty list or set)
redis 127.0.0.1:9999> exit