alexloginov

-- 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%' 

alexloginov

docker rmi $(docker images | grep "^<none>" | awk "{print $3}")

alexloginov

pg_dump -U {PG_USERNAME} -C {SOURCE_DB_NAME} | bzip2 | ssh {SSH_USER}@{HOSTNAME} -i interserv "bunzip2 | psql -U {PG_USERNAME} {TARGET_DB_NAME}"

alexloginov

SELECT relname AS "relation", pg_size_pretty(pg_relation_size(C.oid)) AS "size"
  FROM pg_class C LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
  WHERE nspname NOT IN ('pg_catalog', 'information_schema')
  ORDER BY pg_relation_size(C.oid) DESC
  LIMIT 20;

alexloginov

#!/usr/bin/env bash
# You should run under sudo
tcpdump -w dump.pcap -vv -A -T snmp "(dst port 162) or (src port 161) or (dst port 161) and (host IP-ADDRESS)"