Skip to content

Instantly share code, notes, and snippets.

View jackofseattle's full-sized avatar

Jack Morgan jackofseattle

View GitHub Profile
@jackofseattle
jackofseattle / postgres_queries_and_commands.sql
Created August 27, 2019 18:46 — forked from rgreenjr/postgres_queries_and_commands.sql
Useful PostgreSQL Queries and Commands
-- 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%'
@jackofseattle
jackofseattle / Update remote repo
Last active February 7, 2018 13:50 — forked from mandiwise/Update remote repo
Transfer repo from Bitbucket to Github
git remote rename origin bitbucket
git remote add origin {new repo url}
git push origin --all
$ git remote rm bitbucket