Find Objects in Postgres owned by a specific role/user
select pid as process_id, usename as username, datname as database_name, client_addr as client_address, application_name, backend_
Identify long-running Postgres processes.
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