PostgreSQL

PostgreSQL

Running Queries and Lock Status

Get Running Queries and Lock Status on PostgreSQL

Read more →

Get Database size

Get the size of each Database on your PostgreSQL Server

Read more →

Get a list of active queries and runtime on PostgreSQL

Get a list of active queries and runtime on PostgreSQL

Read more →

Show Active Users connected to PostgreSQL

Show Active Users connected to PostgreSQL

Read more →

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 →