PostgreSQL - The Manual

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