PostgreSQL

PostgreSQL

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 →

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 →