PostgreSQL - The Manual

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