Skip to content

Instantly share code, notes, and snippets.

View an2nb2's full-sized avatar

Anton Borodavchenko an2nb2

  • Frankfurt am Main
View GitHub Profile
@an2nb2
an2nb2 / postgres_queries_and_commands.sql
Created July 24, 2023 13:15 — 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%'

tmux cheatsheet

As configured in my dotfiles.

start new:

tmux

start new with session name:

@an2nb2
an2nb2 / .bash_prompt
Last active August 29, 2015 14:23 — forked from letmein/.bash_prompt
#!/bin/bash
# Add this to the end of .bashrc
# prompt with ruby version
# rbenv version | sed -e 's/ .*//'
__rbenv_ps1 ()
{
rbenv_ruby_version=`rbenv version | sed -e 's/ .*//'`
printf $rbenv_ruby_version
}