Cluster Throughput
48,250 QPS
Peak load: 62,000 QPS
Avg Execution Latency
97.0 ms
99th percentile: 18ms
Global Cache Hit Ratio
74%
Redis L2 Buffer Active
Unindexed Slow Queries
2 Queries
Requires Index Tuning
Query Latency & Concurrency Spectrum
Real-time database node execution time analysis
12ms
18ms
14ms
28ms
45ms
22ms
19ms
8ms
11ms
35ms
14ms
9ms
Active Nodes: 12 InstancesReplication Lag: 0.8ms
Execute Ad-Hoc Query
Run live SQL telemetry query across database nodes
Query Execution Ledger
Live query profiling & index diagnostic records
| Query ID | SQL Snippet | Cluster Node | Latency | Scanned Rows | Cache Hit % | Diagnostic Status |
|---|---|---|---|---|---|---|
| QRY-5001 | SELECT * FROM analytics_ledger WHERE tenant_id = 'T-902' ORDER BY timestamp DESC | AP-South-1 | 4.2 ms | 12,500 | 99.4% | ● Optimized |
| QRY-5002 | SELECT JOIN users u ON u.id = o.user_id GROUP BY u.country HAVING SUM(o.total) > 50000 | US-East-1 | 142.8 ms | 840,000 | 42.1% | ● Slow Query |
| QRY-5003 | EXPLAIN ANALYZE SELECT count(*) FROM event_stream WHERE event_type = 'CLICK' | EU-Central-1 | 1.8 ms | 450 | 100% | ● Indexed |
| QRY-5004 | UPDATE subscription_plans SET status = 'ACTIVE' WHERE renew_date < NOW() | AP-South-1 | 8.9 ms | 3,200 | 92.5% | ● Optimized |
| QRY-5005 | SELECT * FROM raw_logs WHERE log_level = 'FATAL' AND build_version = 'v2.4.1' | SA-East-1 | 412 ms | 3,100,000 | 12% | ● Slow Query |
| QRY-5006 | CREATE INDEX idx_user_tenant ON user_credentials (tenant_uuid, active_status) | US-East-1 | 12.4 ms | 0 | 100% | ● Indexed |