Find Objects in Postgres owned by a specific role/user

Find Objects in Postgres owned by a specific role/user

PostgreSQL: show active users

select pid as process_id, usename as username, datname as database_name, client_addr as client_address, application_name, backend_start, state, state_change from pg_stat_activity;

Postgres Long-Running Processes

Identify long-running Postgres processes.

Postgres, find missing indexes.

SELECT relname, seq_scan-idx_scan AS too_much_seq, CASE WHEN seq_scan-idx_scan>0 THEN 'Missing Index?' ELSE 'OK' END, pg_relation_size(relname::regclass) AS rel_size, seq_scan, idx_scan FROM pg_stat_all_tables WHERE schemaname='public' AND pg_

Download RDS logs

The easer way to grab your RDS logs db_instance="awesome_db_identifier" aws_profile="corp_aws_profile" for logfile in $(aws --profile=${aws_profile} rds describe-db-log-files --db-instance-identifier ${db_instance} --query "DescribeDBLogFiles[].LogFileName" |jq -r '.|@sh'); do echo $logfile name=$(echo $logfile|