This generates a public/private keypair.
$ gpg --gen-key
$ gpg --list-secret-keys
-- 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%' |
package main | |
import ( | |
"fmt" | |
"time" | |
"github.com/aws/aws-sdk-go/aws" | |
"github.com/aws/aws-sdk-go/aws/session" | |
"github.com/aws/aws-sdk-go/service/athena" | |
) |
FROM alpine:3.14 | |
ENV AWSCLI_VERSION "1.20.7" | |
RUN apk add --update \ | |
python3 \ | |
python3-dev \ | |
py-pip \ | |
build-base \ | |
&& pip install awscli==$AWSCLI_VERSION --upgrade --user \ |
``` | |
filter eventName="ConsoleLogin" | |
| stats count(*) as eventCount by userIdentity.userName, sourceIPAddress | |
| sort eventCount desc | |
filter not sourceIPAddress =~ /^(?i)123.123.123.123/ and userIdentity.userName =~/^(?i)\w/ | |
| stats count(*) as eventCount by eventName, userIdentity.userName, sourceIPAddress | |
| sort eventCount desc | |
filter eventName="ConsoleLogin" |
account:DisableRegion | |
account:EnableRegion | |
account:ListRegions | |
activate:CreateForm | |
activate:GetAccountContact | |
activate:GetContentInfo | |
activate:GetCosts | |
activate:GetCredits | |
activate:GetMemberInfo | |
activate:GetProgram |