| Card | Tier | Category | Chart |
|---|---|---|---|
| Active Parts (Top 10 Tables) | Key Metrics | Ingest & Merges | table |
| ClickHouse Event Ingest vs Ecom Orders | Key Metrics | Cross-Platform: Revenue at Risk | dual_axis |
| ClickHouse Health Score | Key Metrics | Executive Overview | gauge |
| ClickHouse Pool Saturation vs Traffic Burst | Key Metrics | Cross-Platform: Revenue at Risk | table |
| ClickHouse QPS Spike vs Ecom Order Rate | Key Metrics | Cross-Platform: Revenue at Risk | dual_axis |
| Connection Pool Saturation % | Key Metrics | Capacity | gauge |
| Connection Pool at >90% Saturation | Key Metrics | Nerve Centre | alert_list |
| Database Disk Usage % | Key Metrics | Executive Overview | gauge |
| Failed Queries (24h) | Key Metrics | Performance | kpi |
| Inserts per Second (live) | Key Metrics | Ingest & Merges | kpi |
| Last Successful Backup (hours ago) | Key Metrics | Backup | kpi |
| Queries per Second (live) | Key Metrics | Executive Overview | kpi |
| Query Error Rate % | Key Metrics | Errors | gauge |
| Query Error Rate Spike (>1% in 5m) | Key Metrics | Nerve Centre | alert_list |
| Query Latency p95 (ms) | Key Metrics | Performance | kpi |
| Query Latency p99 (ms) | Key Metrics | Performance | kpi |
| Replication Lag (absolute_delay) | Key Metrics | Replication | kpi |
| Slow Analytics Queries During Checkout Window | Key Metrics | Cross-Platform: Revenue at Risk | table |
| Slow-Query Rate % | Key Metrics | Performance | gauge |
| Too Many Parts Error or Parts Count >1000 on Any Table | Key Metrics | Nerve Centre | alert_list |
| Too Many Parts Errors (24h) | Key Metrics | Ingest & Merges | kpi |
| UncompressedCache Hit Rate % | Key Metrics | Capacity | gauge |
| Active Replicas | Standard | Replication | kpi |
| Connections In Use | Standard | Capacity | kpi |
| Instance Uptime | Standard | Executive Overview | kpi |
| MEMORY_LIMIT_EXCEEDED (24h) | Standard | Errors | kpi |
| Memory Usage % | Standard | Capacity | gauge |
| Merges In Progress | Standard | Ingest & Merges | kpi |
| Partition Count (Top 10 Tables) | Standard | Ingest & Merges | table |
| Query Latency p50 (ms) | Standard | Performance | kpi |
| Replication Queue Size (Top Tables) | Standard | Replication | table |
| Top 10 Slowest Queries | Standard | Performance | table |
Clickhouse KPIs, Vortex IQ Nerve Centre
Every Clickhouse KPI Vortex IQ Nerve Centre tracks, with its audit profile and sentiment benchmarks.
Nerve Centre KPIs · Audit Profile · Sentiment Settings
Vortex IQ Nerve Centre tracks 32 KPI pulses for Clickhouse. Each metric has its own page; the Audit and Sentiment tabs above cover the health checks and benchmark bands.