Executive Dashboard
Key Performance Indicators
AI-Generated Insights (0)
Quick Actions
Database Connections
Active Connections
Connection List
Connection Groups
SQL Editor
Query Editor
Query Results
Vantage Dashboard - 120+ Metrics
Dashboard Overview
Real-time vantage of 120+ metrics across 12 categories with AI-powered insights and automated alerting.
Key Metrics Categories (120+ Metrics)
Omni Scan Dashboard
Scan Results
Issue Categories (2000+ Patterns)
Category Issues
Critical Issues (0)
Query IQ - 1050+ Optimization Patterns
Query Analysis & Auto-Tuning
Optimization Recommendations (3)
Pattern Categories (1050+ Patterns)
Auto Heal
Auto Heal Framework Features
Pending Fixes (32)
2. Execute: ALTER SYSTEM SET max_connections = 150
3. Reload: pg_reload_conf()
4. Verify: Check new setting applied
5. Monitor: Track connection usage for 5 minutes
Recent Fix History (15)
Log Analysis - 240+ Pattern Detection
Log Pattern Categories
Recent Log Events (Last 24 Hours)
Detected Patterns
Reports & Analytics
Generate Report
Recent Reports
Scheduled Reports
Demo Mode - Issue Creation & Testing
Demo Status
Quick Demo Scenarios
Create Individual Issues
Demo Action History
Recommended Testing Workflow
- Step 1: Create demo issues using quick scenarios or individual issues
- Step 2: Navigate to Omni Scan tab and run a full scan
- Step 3: Review detected issues in scan results and category views
- Step 4: Go to Auto Heal tab and apply fixes to resolve issues
- Step 5: Verify fixes in Monitoring and Query IQ tabs
- Step 6: Return to Demo Mode and rollback all changes for next demo
Cortex
AI Model Status
Chat with Cortex
- Analyzing and optimizing SQL queries
- Troubleshooting database issues
- Providing recommendations for performance improvements
- Explaining database concepts and best practices
- Generating SQL queries based on your requirements
Cortex Capabilities
Example Questions You Can Ask
- "Which queries are running slowly?"
- "How can I improve query performance?"
- "Show me tables with high bloat"
- "What indexes should I create?"
- "Find unused indexes"
- "Analyze index usage patterns"
- "Generate a query to find duplicates"
- "Create a report of table sizes"
- "Write a query to analyze connections"
- "Why is my database slow?"
- "How do I fix connection pool issues?"
- "Explain this error message"
Alert Management Dashboard
Filter & Search
Recent Alerts
Loading alerts...
🔍 Audit Dashboard
Filter & Search
Audit Events
Loading audit events...
About Audit Dashboard
The Audit Dashboard provides comprehensive tracking of all database activities using PostgreSQL's pgAudit extension. It monitors and logs all database operations including queries, schema changes, and permission modifications.
Unified Audit
Operations by Type
Filter & Search
Audit Events
Loading audit events...
About Unified Audit System
The Unified Audit System captures ALL database operations from ANY source without requiring pgAudit. It uses database triggers, event triggers, and pg_stat_statements to provide comprehensive audit coverage.
Intelli Log IQ
Upload Log File
Uploaded Log Files
No log files uploaded yet. Upload a file to get started.
Analysis Results
Detected Patterns
Critical Issues
AI Recommendations
Recent Log Events (Last 24 Hours)
Loading recent log events...
No recent log events found in the last 24 hours.
📊 Advanced Log Analytics
🔍 Advanced Filters
Filtered Results
📈 Log Trends
🔴 Top Errors
📊 Error Distribution
⚡ Error Rate Over Time
How to Use Log IQ
- Upload Log File: Drag and drop or click to select a PostgreSQL log file (.log, .txt, .csv)
- Automatic Analysis: The system will automatically parse and analyze the log file
- View Results: Review detected patterns, critical issues, and statistics
- AI Recommendations: Get intelligent suggestions powered by AI models
- Ask Follow-up Questions: Click "Ask Cortex" to dive deeper into specific issues
- Export Reports: Download analysis results as PDF or CSV for documentation