nmccready

SELECT  pg_terminate_backend(pid) FROM pg_stat_activity
WHERE
  usename = 'USERNAME' AND
  client_addr ='IP_ADDRESS';

nmccready

SELECT * FROM pg_stat_activity WHERE usename = 'USERNAME' limit 50;

nmccready

select pg_size_pretty(sum(p.total_bytes)) from (SELECT *, pg_size_pretty(total_bytes) AS total
    , pg_size_pretty(index_bytes) AS INDEX
    , pg_size_pretty(toast_bytes) AS toast
    , pg_size_pretty(table_bytes) AS TABLE
  FROM (
  SELECT *, total_bytes-index_bytes-COALESCE(toast_bytes,0) AS table_bytes FROM (
      SELECT c.oid,nspname AS table_schema, relname AS TABLE_NAME
              , c.reltuples AS row_estimate
              , pg_total_relation_size(c.oid) AS total_bytes
              , pg_indexes_size(c.oid) AS index_bytes

nmccready

import { dirname } from 'path';
import { fileURLToPath } from 'url';

// this is rediculous, node 14 / 12 breaking backwards compat

export const __filename = fileURLToPath(import.meta.url);
export const __dirname = dirname(__filename);

global.__filename = __filename;
global.__dirname = __dirname;

nmccready

NEED_ARG=${1? required}
DEFAULT_ARG=${2:-DEFINED}
echo DEFAULT_ARG: $DEFAULT_ARG

nmccready

MY_DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" >/dev/null 2>&1 && pwd )"

cd "$MY_DIR"
cd ../ # normalize to a known working directory could be ../../

nmccready

#!/usr/bin/env sh

##
# This is script with usefull tips taken from:
#   https://github.com/mathiasbynens/dotfiles/blob/master/.osx
#
# install it:
#   curl -sL https://raw.github.com/gist/2357277/hack.sh | sh
#

nmccready

const defer = <T>() => {
  let resolve, reject;
  const promise = new Promise<T>((_resolve, _reject) => {
    resolve = _resolve;
    reject = _reject;
  });
  return {
    promise,
    resolve,
    reject,

nmccready

#!/usr/bin/env bash

function ohHi(){
 echo "Hi"
}


(return 0 2>/dev/null) && return || echo "Script is a subshell"

# self invoke if not sourced

nmccready

Disable vim automatic visual mode on mouse select

issue: :set mouse-=a
add to ~/.vimrc: set mouse-=a