Skip to content

Instantly share code, notes, and snippets.

View Dkendal's full-sized avatar

Dylan C. Kendal Dkendal

View GitHub Profile
@Dkendal
Dkendal / italics.vim
Created January 10, 2018 20:21 — forked from fmoralesc/italics.vim
vim + italics
" cd to the folder where you have xterm-256color.terminfo, run
" $ tic xterm-256color.terminfo
" and add the following to your vimrc.
set t_ZH=
set t_ZR=
@Dkendal
Dkendal / postgres_queries_and_commands.sql
Created November 17, 2016 23:03 — 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%'