Data Analytics
Real-time database performance and query observability
Loading...
Active Connections
power
42
trending_up +3 from last hr
Query Latency P50
speed
12ms
-2ms vs yesterday
Query Latency P99
timer
247ms
+18ms vs yesterday
Error Rate
error_outline
0.03%
Within threshold
Cache Hit Rate
cached
94.7%
+1.2% this week
pool Database Pool
Active: 24
Idle: 14
Waiting: 4
Connection usage over time (last 24h)
settings_suggest Pool Config
Max Pool Size50
Min Pool Size5
Idle Timeout30s
Acquire Timeout10s
Max Waiting Clients8
query_stats Query Performance
Top 10 slowest queries in the last hour
| Query Preview | Avg Time | Max Time | Calls | Rows | % of Total |
|---|---|---|---|---|---|
| SELECT p.*, m.name FROM properties p JOIN markets m ON p.market_id = m.id WHERE p.status = 'active' AND p... | 1,842ms | 3,410ms | 247 | 12,450 | 22.4% |
| INSERT INTO analytics_events (property_id, event_type, metadata) VALUES ($1, $2, $3) RETURNING id | 1,210ms | 2,890ms | 8,412 | 8,412 | 18.7% |
| SELECT AVG(r.price), COUNT(r.id) FROM rentals r WHERE r.property_id IN (SELECT id FROM properties WHERE... | 845ms | 1,204ms | 156 | 1 | 12.1% |
| WITH feed_data AS (SELECT p.id, p.title, i.url FROM properties p LEFT JOIN images i ON i.property_id = p... | 720ms | 980ms | 89 | 2,340 | 8.9% |
| UPDATE properties SET last_seen = NOW() WHERE id = $1 | 540ms | 1,100ms | 14,203 | 14,203 | 7.3% |
| SELECT COUNT(*) FROM search_queries WHERE created_at > NOW() - INTERVAL '1 day' | 510ms | 630ms | 42 | 1 | 6.2% |
| SELECT DISTINCT ON (p.id) p.*, i.url AS primary_image FROM properties p LEFT JOIN LATERAL (SELECT url... | 340ms | 480ms | 312 | 312 | 4.8% |
| SELECT json_agg(json_build_object('id', id, 'title', title)) FROM properties WHERE updated_at > $1 | 290ms | 410ms | 78 | 15 | 3.5% |
| SELECT * FROM cache_invalidation_log WHERE created_at > NOW() - INTERVAL '1 hour' ORDER BY created_at DESC | 180ms | 260ms | 24 | 89 | 2.1% |
| SELECT COUNT(DISTINCT user_id) FROM active_sessions WHERE last_keepalive > NOW() - INTERVAL '5 minutes' | 95ms | 150ms | 1,204 | 1 | 1.4% |
storage Cache Performance
Market Overview97.2%
Top Properties92.8%
Property Detail88.4%
Search81.5%
Memory Used2.4 GB
Keys Count48.2K
Invalidation Rate14/s
warning_amber Error Rates
Last 24 hours breakdown
4xx Errors187
5xx Errors42
Error rate trend (last 12 intervals)
| Timestamp | Endpoint | Status | Message |
|---|---|---|---|
| 23:14:52 | /api/v1/properties/search | 429 | Rate limit exceeded |
| 23:08:14 | /api/v1/deals | 500 | Internal server error: null pointer |
| 22:55:03 | /api/v1/auth/login | 401 | Invalid token |
| 22:41:37 | /api/v1/images/upload | 503 | CDN upload service unavailable |
| 22:18:09 | /api/v1/properties/214 | 404 | Property not found |
sync
Auto-refresh: every 30s