Thanks Chandler Thompson for this! Identify Long Running ProcessesSELECT pg_stat_activity.pid, pg_class.relname, pg_locks.transactionid, pg_
SELECT relname, seq_scan-idx_scan AS too_much_seq, CASE WHEN seq_scan-idx_scan>0 THEN 'Missing Index?'
The easer way to grab your RDS logs db_instance="awesome_db_identifier" aws_profile="corp_aws_profile" for logfile
Stolen from TablePlus Blog, Cool product check it out here! First, lets check to see if the database has active
Create the role for exampledb.... Note, make sure to connect to the db you want to effect privileges for... \c