Executive Dashboard
3 Critical Issues Detected
Replication lag: 45s • Connection pool: 95% • Disk I/O: High
Overall Health Score
Loading...
Calculating...
Database Uptime
Loading...
Calculating...
Total Tables
Loading...
Loading...
Active Connections
Loading...
Loading...
Key Performance Indicators
Queries/Second
Loading...
Calculating...
Avg Response
Loading...
Calculating...
Cache Hit
Loading...
Calculating...
Transactions
Loading...
Calculating...
AI-Generated Insights (0)
Quick Actions
Database Connections
Active Connections
Total Connections
12
8 active, 4 idle
Active Databases
8
All healthy
Total Size
3.2 TB
Across all DBs
Avg Response
23ms
↓ 8ms improvement
Connection List
Connection Groups
SQL Editor
Query Editor
Status
Ready
Execution Time
-
Rows Returned
-
Columns
-
Database
-
Query Results
No results
Vantage Dashboard - 120+ Metrics
Dashboard Overview
Real-time vantage of 120+ metrics across 12 categories with AI-powered insights and automated alerting.
Executive Overview
Health score, critical alerts, AI insights, quick
actions
Performance Deep Dive
TPS, latency, slow queries, transaction analysis
Resource Utilization
CPU, memory, disk I/O, buffer management
Query Analysis
Query patterns, optimization, execution plans
Key Metrics Categories (120+ Metrics)
Refresh
Rate:
Last: Never
Performance (25)
TPS, QPS, latency, throughput,
response times
Connections (15)
Active, idle, waiting, max, pool
status
Queries (20)
Slow queries, types, plans,
optimization
Memory (15)
Shared buffers, work mem, cache hit
ratio
Disk I/O (15)
Read/write rates, IOPS, latency,
usage
Replication (10)
Lag, sync status, WAL, standby
health
Omni Scan Dashboard
Scan Results
Last Scan
2 hours ago
Duration
12 minutes
Issues Found
47
Critical
8
Auto Healable
32
Issue Categories (2000+ Patterns)
Category Issues
Critical Issues (0)
Query IQ - 1050+ Optimization Patterns
Query Analysis & Auto-Tuning
Execution Time
-
Rows Scanned
-
Issues Found
-
Potential Speedup
-
Optimization Recommendations (3)
Missing Index on orders.created_at
High Impact
Creating an index on this column could reduce execution time by ~70%.
CREATE INDEX idx_orders_created_at ON orders(created_at DESC);
Pattern Categories (1050+ Patterns)
Index Optimization (200)
Missing, unused, duplicate indexes
JOIN Optimization (180)
Join order, type selection,
conditions
Subquery Rewrite (150)
Convert to JOINs, CTEs, EXISTS
Aggregate Optimization (120)
GROUP BY, HAVING, window functions
Auto Heal
Auto Heal Framework Features
Pre-Validation
Safety checks before execution
Transaction-Based
Automatic rollback on failure
Post-Verification
Confirms fix effectiveness
Risk Assessment
LOW/MEDIUM/HIGH tiers
Pending Fixes (32)
Increase max_connections to 150
LOW RISK
Current: 100 | Recommended: 150 | Success Rate: 99.9%
FIX STEPS:
1. Pre-check: Verify current connections < 80
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
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
Create Index on orders.customer_id
MEDIUM
RISK
Impact: 234 queries/day | Speedup: ~60% | Success Rate: 98%
Recent Fix History (15)
Increased shared_buffers to 4GB
2 hours ago • Duration: 45s
Created index on products.category_id
5 hours ago • Duration: 2m 15s
Log Analysis - 240+ Pattern Detection
Log Pattern Categories
Errors (80)
Connection, query, system errors
Warnings (60)
Performance, config warnings
Performance (50)
Slow queries, checkpoints
Security (50)
Auth failures, permission issues
Recent Log Events (Last 24 Hours)
[ERROR] 2024-01-20
15:30:45 - Connection timeout from 192.168.1.100
[WARN] 2024-01-20
15:28:12 - Checkpoint taking longer than expected (45s)
[INFO] 2024-01-20
15:25:33 - VACUUM completed on table orders (2.3GB reclaimed)
[ERROR] 2024-01-20
15:20:15 - Deadlock detected: Process 12345 waiting for ShareLock
[WARN] 2024-01-20
15:15:08 - Replication lag increased to 45 seconds
[INFO] 2024-01-20
15:10:22 - Autovacuum started on table users
[DEBUG] 2024-01-20
15:05:45 - Query execution plan cached
Detected Patterns
ERROR: Deadlock detected (3 occurrences)
Last: 2 hours ago • Pattern: Lock
acquisition timeout
WARNING: Checkpoint occurring too frequently
Count: 45 in last hour •
Recommendation: Increase checkpoint_timeout
Reports & Analytics
Generate Report
Performance Report
Query performance, slow queries,
optimization recommendations
Health Report
Overall health score, critical
issues, recommendations
Security Audit
Permissions, encryption,
authentication issues
Capacity Planning
Storage trends, growth projections,
recommendations
Recent Reports
Weekly Performance Report
Generated: Jan 20, 2024 • 15
pages
Monthly Health Report
Generated: Jan 15, 2024 • 22
pages
Security Audit Report
Generated: Jan 10, 2024 • 18
pages
Scheduled Reports
Daily Health Check
Every day at 8:00 AM •
Email to: admin@company.com
Weekly Performance Summary
Every Monday at 9:00 AM •
Email to: team@company.com
Demo Mode - Issue Creation & Testing
Demo Mode Information
This mode allows you to create realistic database issues for testing IntelliDB Enterprise's
detection and auto-fix capabilities. All changes can be rolled back safely.
Demo Status
Active Demo Issues
0
Created by demo mode
Rollback Available
No
Can restore to clean state
Last Demo Action
None
-
Quick Demo Scenarios
Critical Issues
Create 5 critical issues: missing indexes, bloat,
connection pool
Performance Issues
Create slow queries, sequential scans, outdated
statistics
Security Issues
Create weak permissions, missing SSL, superuser issues
Full Demo
Create comprehensive set of 15+ issues across all
categories
Query IQ Demo
Create demo tables with poorly written queries for
Query IQ analysis
Audit Demo
Generate audit events with anomalies for Audit
Dashboard
testing
Create Individual Issues
Missing Index on Foreign
Key
Creates a table with foreign
key but no index
Table Bloat
Creates bloated table with
dead tuples
Outdated Statistics
Creates table with stale
statistics
Unused Index
Creates index that is never
used
Long Running Transaction
Starts a transaction that runs
for extended time
Duplicate Index
Creates redundant indexes on
same columns
Demo Action History
No demo actions yet. Create issues to see history here.
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
Intelligent Database Expert
Ask questions about your database, get query recommendations, troubleshoot issues, and
receive expert advice powered by offline AI models.
AI Model Status
Checking...
Active Model
-
Initializing...
Conversations
0
Total chats
Messages Today
0
Queries answered
Avg Response Time
-
Model inference
Chat with Cortex
AI
AI
Database Assistant
Hello! I'm your intelligent database assistant. I can help you with:
- 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
Tip: Try asking "Show me slow queries" or "How can I
optimize my database?"
0/2000 characters
Press Ctrl+Enter
to send
Quick Actions:
AI Agents:
Cortex Capabilities
Query Analysis
Analyze SQL queries,
identify bottlenecks, and suggest optimizations
Smart Recommendations
Get intelligent
suggestions for indexes, configurations, and best practices
🔧
Issue Resolution
Troubleshoot problems
and get step-by-step solutions
📚
Knowledge Base
Access PostgreSQL
expertise and best practices
Example Questions You Can Ask
Performance Analysis
- "Which queries are running slowly?"
- "How can I improve query performance?"
- "Show me tables with high bloat"
Index Optimization
- "What indexes should I create?"
- "Find unused indexes"
- "Analyze index usage patterns"
Query Generation
- "Generate a query to find duplicates"
- "Create a report of table sizes"
- "Write a query to analyze connections"
Troubleshooting
- "Why is my database slow?"
- "How do I fix connection pool issues?"
- "Explain this error message"
Alert Management Dashboard
Critical Alerts
0
Requires immediate
attention
High Priority
0
Needs quick
response
Medium Priority
0
Monitor closely
Low Priority
0
For information
Total Alerts
0
All time
Filter & Search
Recent Alerts
⏳
Loading alerts...
🔍 Audit Dashboard
Total Events
0
All time
Events Today
0
Last 24 hours
Anomalies Detected
0
Suspicious activity
Active Users
0
Unique users
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.
Real-time Monitoring
Track all database operations
as they happen
Anomaly Detection
AI-powered detection of
suspicious activities
Compliance Ready
Meet regulatory requirements
with detailed logs
Export Capabilities
Export audit logs for analysis
and reporting
Unified Audit
Unified Audit System Active
Capturing ALL database operations (DML, DDL, DCL, SELECT) from ANY source without
requiring pgAudit.
System Status: Checking...
Total Events
0
All operations
DML Operations
0
INSERT/UPDATE/DELETE
DDL Operations
0
CREATE/ALTER/DROP
DCL Operations
0
GRANT/REVOKE
SELECT Queries
0
Read operations
Active Users
0
Unique users
Tables Modified
0
Affected tables
Active Sessions
0
Unique sessions
Operations by Type
Loading operations summary...
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.
🎯 Complete Coverage
Captures DML, DDL, DCL, and
SELECT operations
🔍 Source Agnostic
Works with psql, pgAdmin,
Python, and any client
📊 Rich Metadata
Captures user, client IP,
session, and data changes
⚡ Auto-Trigger Creation
Automatically creates
triggers for new tables
Intelli Log IQ
AI-Powered Log Analysis
Upload PostgreSQL log files for comprehensive analysis. Our AI assistant
will detect patterns, identify issues, and provide actionable
recommendations.
Total Log Files
0
Uploaded files
Analyzed
0
Completed analyses
Processing
0
In progress
Critical Issues
0
Found in logs
Upload Log File
📁
Drop PostgreSQL log file here or click to browse
Supports .log, .txt, .csv files (max 100MB)
Uploading...
0%
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.
Last Scan: Never
📊 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
💡 Tip: For best results, upload recent log files that
contain error messages or performance issues you want to investigate.