Skip to content

Instantly share code, notes, and snippets.

jordelver / postgres_queries_and_commands.sql
Created February 27, 2020 13:38 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
View postgres_queries_and_commands.sql
-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), 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(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

Keybase proof

I hereby claim:

  • I am jordelver on github.
  • I am jordelver ( on keybase.
  • I have a public key whose fingerprint is FCF1 85F0 6DBF 112D 8F8E DEEC CAE8 72D7 E87D 5AFF

To claim this, I am signing this object:



  :FNAME => attributes.contact_first_name,
  :LNAME => attributes.contact_last_name,
  :LEVEL => attributes.level,
  :COUNTRY =>,
  :TWITTER => attributes.twitter,
 :JOIN_DATE =&gt; attributes.join_date,
jordelver /
Created August 13, 2015 16:11
Fish shell tab completions favour Git branches?

In the root of my project I have a directory called features. I also have a Git branch called origin/feature-add-coupon-code-to-report.

When I do git co fe<TAB> the Git branch is matched and completed to git co origin/feature-add-coupon-code-to-report which seems strange to me.

Shouldn't the local directory be matched before the branch give that feature is not present at the start of the branch name?

If I type 3 or more characters then it completes to git co features/.

What is the expected behaviour?

jordelver / gist:bdf6c7e91c3f4f6eedba
Last active April 8, 2018 02:01
Get all movies in your Letterboxd watchlist
View gist:bdf6c7e91c3f4f6eedba
require "mechanize"
puts "Letterboxd USERNAME environment variable must be supplied"
agent =
View gist:d39abe44adbb56ac1004
if !isdirectory(expand("~/.vim/bundle/Vundle.vim/.git"))
silent !git clone ~/.vim/bundle/Vundle.vim
silent !vim +PluginInstall +qall
View gist:9521a3bb8f2d1f2dbd2c
Person =, :age)

peeps = ["Jordan", 33),"Bob", 19),"Frank", 55)
jordelver / gist:6a375a1bf27c63cb0b5a
Created October 8, 2014 16:22
Ruby yield as a default parameter
View gist:6a375a1bf27c63cb0b5a

Learnt this from Avdi Grimm's Ruby Tapas

def content_for(tag, content = yield)
  "<%s>%s</%s>" % [tag, content, tag]

content_for("p", "hi")
=> "<p>hi</p>"
View gist:0cc4daf20843cfa3902c

Idea from @sferik's talk at Baruco 2014

Implicit blocks with yield are faster than explicit blocks with #call.

require 'benchmark/ips'

def explicit(&block)
jordelver / gist:71ef7394383ab36e4b7e
Last active April 8, 2018 02:01
RestfulGit examples
View gist:71ef7394383ab36e4b7e

RestfulGit examples

Things we need to get from the API

(Install jq for these examples

Single commits

curl '' | jq '.'