PostgreSQL

PostgreSQL

PostgreSQL Table sizes

SELECT relname AS "relation", pg_size_pretty ( pg_total_relation_size (C .oid) ) AS "total_size"

Read more →

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_

Read more →

Do you have any question to us?

Contact us and we'll get back to you as soon as possible.