p95 query time tripled after our last enterprise customer. Index strategy, partitioning advice, and the worst queries fixed hands-on.