PostgreSQL

PostgreSQL

Long-Running Processes

Thanks Chandler Thompson for this! Identify Long Running ProcessesSELECT pg_stat_activity.pid, pg_class.relname, pg_locks.transactionid, pg_

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 →