Get Running Queries and Lock Status on PostgreSQL
Get the size of each Database on your PostgreSQL Server
Get a list of active queries and runtime on PostgreSQL
Show Active Users connected to PostgreSQL
Find Objects in Postgres owned by a specific role/user
select pid as process_id, usename as username, datname as database_name, client_addr as client_address, application_name, backend_
Identify long-running Postgres processes.
SELECT relname, seq_scan-idx_scan AS too_much_seq, CASE WHEN seq_scan-idx_scan>0 THEN 'Missing Index?'
The easer way to grab your RDS logs db_instance="awesome_db_identifier" aws_profile="corp_aws_profile" for logfile
Stolen from TablePlus Blog, Cool product check it out here! First, lets check to see if the database has active