rgreenjr

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

davidfowl

$/
  artifacts/
  build/
  docs/
  lib/
  packages/
  samples/
  src/
 tests/

crissupb

yum update
yum upgrade

yum install -y gcc make cmake git zip
yum install -y python27-devel python27-pip make cmake 
yum install -y libcurl-devel wget zlib-devel openssl-static libffi-devel

wget https://www.libssh2.org/download/libssh2-1.8.0.tar.gz
tar xvf libssh2-1.8.0.tar.gz
cd libssh2-1.8.0

cfbarbero

search sns subscriptions by endpoint

aws sns list-subscriptions --query 'Subscriptions[?contains(Endpoint,`dev`) == \`true\` ][Endpoint, TopicArn]' --output table

search alarms by sns topic

aws cloudwatch describe-alarms --query 'MetricAlarms[?contains(AlarmActions, `something`) == `true`][AlarmName, AlarmActions]' --output table --max-items 10

Get stack outputs

aws cloudformation describe-stacks --query 'Stacks[0].Outputs' --output table --stack-name $stackname --profile $profile

Get stack outputs from multiple stacks

noamsdahan