PostgreSQL

PostgreSQL

Find Objects in Postgres owned by a specific role/user

Find Objects in Postgres owned by a specific role/user

Read more →

PostgreSQL: show active users

select pid as process_id, usename as username, datname as database_name, client_addr as client_address, application_name, backend_

Read more →

Postgres Long-Running Processes

Identify long-running Postgres processes.

Read more →

Postgres, find missing indexes.

SELECT relname, seq_scan-idx_scan AS too_much_seq, CASE WHEN seq_scan-idx_scan>0 THEN 'Missing Index?'

Read more →

Download RDS logs

The easer way to grab your RDS logs db_instance="awesome_db_identifier" aws_profile="corp_aws_profile" for logfile

Read more →

Copy/Duplicate an entire Postgres database on the same server.

Stolen from TablePlus Blog, Cool product check it out here! First, lets check to see if the database has active

Read more →

Create a read-only role & user in PostgreSQL

Create the role for exampledb.... Note, make sure to connect to the db you want to effect privileges for... \c

Read more →