AWS RDS / Aurora

Prerequisites

• -An RDS PostgreSQL or Aurora PostgreSQL instance
• -The master username and password (or create a monitoring user)
• -Security group that allows inbound connections from dbaBrain

Step 1: Create a monitoring user

Connect to your RDS instance and create a dedicated monitoring user:

sql
CREATE USER dbabrain_monitor WITH PASSWORD 'your-secure-password';
GRANT pg_monitor TO dbabrain_monitor;
GRANT USAGE ON SCHEMA public TO dbabrain_monitor;

-- Enable pg_stat_statements (if not already)
-- Requires modifying the RDS parameter group:
-- shared_preload_libraries = 'pg_stat_statements'
CREATE EXTENSION IF NOT EXISTS pg_stat_statements;

Step 2: Update Security Group

Add an inbound rule to your RDS security group allowing TCP on port 5432 from dbaBrain IP ranges. You can find the security group in the RDS console under your instance's "Connectivity & security" tab.

Step 3: Enable Performance Insights (Optional)

For deeper query analysis, enable Performance Insights on your RDS instance. This provides wait event analysis and query-level metrics that complement pg_stat_statements data.

Step 4: Connect in dbaBrain

Use your RDS endpoint as the host:

text
Host: your-instance.xxxxxxxxxxxx.us-east-1.rds.amazonaws.com
Port: 5432
Database: your_database
Username: dbabrain_monitor
Password: your-secure-password
SSL Mode: require

CloudWatch Integration (Optional)

For OS-level metrics (CPU, memory, disk IOPS), you can optionally connect your AWS CloudWatch. This requires an IAM user or role with cloudwatch:GetMetricData permissions. Configure this in the Integrations section of your dbaBrain dashboard.