Optimize slow dashboard queries (P95 > 2s)

sess-008

Success

perf-optimizer

9m 27s

2 tools

5/5

P95 reduced from 2.3s to 340ms. Added 3 indexes.

Event Timeline

Performance optimization triggered by alert

start

Identified 4 slow queries via pg_stat_statements

analysis

Added composite index on (tenant_id, created_at)

fix

Added partial index on sessions WHERE status = 'active'

fix

Added covering index on learnings (agent_id, confidence)

fix

Setting up Redis cache for dashboard aggregates

tool call

All queries now under 400ms at P95

complete

pg-queryredis-cache

Index migration/migrations/20260303_add_indexes.sql

Huge improvement! Dashboard feels instant now.