Common Error Messages

Database Errors

"permission denied for relation pg_stat_statements"

The monitoring user needs the pg_monitor role:

sql
GRANT pg_monitor TO dbabrain_monitor;

"extension pg_stat_statements is not installed"

Install the extension (requires superuser):

sql
CREATE EXTENSION IF NOT EXISTS pg_stat_statements;
-- For RDS: modify parameter group to add pg_stat_statements to shared_preload_libraries

"could not connect to server: No such file or directory"

PostgreSQL is not running or the socket file is not at the expected location. Check that PostgreSQL is running and you are using the correct host/port.

Dashboard Errors

"Metrics not loading"

• -Check that the API server is running
• -Verify your authentication token is valid (try logging out and back in)
• -Check browser console for network errors
• -Ensure the database connection is active in Settings

"Health score shows 0"

This usually means metrics are not being collected. Check your database connection status and ensure the monitoring user has the correct permissions.