pg_table_def, stl_query, stl_querytext, stl_tr_conflict, stl_explain, stl_alert_event_log, stl_ddltext, stl_scan, stl_save, stl_hashjoin, stl_hash, stl_plan_info, stl_return, and information_schema.table_constraints.
select (endtime - starttime) as execution_time_in_ms
from stl_query
where query = QUERY_ID;
| #!/usr/bin/env bash | |
| # lists all unused AWS security groups. | |
| # a group is considered unused if it's not attached to any network interface. | |
| # requires aws-cli and jq. | |
| # all groups | |
| aws ec2 describe-security-groups \ | |
| | jq --raw-output '.SecurityGroups[] | [.GroupName, .GroupId] | @tsv' \ | |
| | sort > /tmp/sg.all |
| # Lambda function to subscribe all new cloudwatch log groups to a log shipper function | |
| # Used in conjunction with https://github.com/SumoLogic/sumologic-aws-lambda | |
| import os | |
| import logging | |
| import json | |
| import uuid | |
| import boto3 | |
| from botocore.exceptions import ClientError |