Find Objects in Postgres owned by a specific role/user
Read more →select pid as process_id, usename as username, datname as database_name, client_addr as client_address, application_name, backend_
Read more →SELECT relname, seq_scan-idx_scan AS too_much_seq, CASE WHEN seq_scan-idx_scan>0 THEN 'Missing Index?'
Read more →The easer way to grab your RDS logs db_instance="awesome_db_identifier" aws_profile="corp_aws_profile" for logfile
Read more →Stolen from TablePlus Blog, Cool product check it out here! First, lets check to see if the database has active
Read more →Create the role for exampledb.... Note, make sure to connect to the db you want to effect privileges for... \c
Read more →