Wispic Admin

A

Admin

admin@wispic.app

Dashboard

Performance Monitoring

Real-time API response times, error rates, and database query performance

Total Requests
0
Last 1h
Avg Response Time
0ms
Target: <200ms
Error Rate
0%
Target: <1%
P95 Response Time
0ms
95th percentile
P99 Response Time
0ms
99th percentile

📊 Endpoint Performance Breakdown

📈 Response Time Trend

Time (last 20 data points)

🐢 Database Slow Queries

SELECT * FROM users JOIN matches ON users.id = matches.user1_id WHERE users.city = $1
Avg Time: 2340ms
Calls: 1,523
Total Time: 3563.8s
SELECT COUNT(*) FROM messages WHERE created_at > $1 GROUP BY user_id
Avg Time: 1890ms
Calls: 892
Total Time: 1685.9s
UPDATE users SET last_active = NOW() WHERE id = $1
Avg Time: 45ms
Calls: 45,234
Total Time: 2035.5s

💡 Performance Optimization Tips

  • Target: P95 <500ms, P99 <1000ms, Error rate <1%
  • Database: Add indexes to frequently queried columns (city, created_at)
  • Caching: Use Redis for hot data (user profiles, active matches)
  • CDN: Serve static assets (photos) via CloudFront/Cloudflare
  • Query Optimization: Avoid SELECT *, use LIMIT, add WHERE clauses
  • Monitoring: Set up alerts for response time >1s or error rate >5%