select pid as process_id, usename as username, datname as database_name, client_addr as client_address, application_name, backend_
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