displayName
Database Connection Pool Tuning
workflowKind
development
triggerType
on-demand
typicalCadence
per-regression
complexity
single-team
description
Analyzes and optimizes database connection pool configurations -- profiling
connection checkout latency, identifying pool exhaustion events, measuring
connection idle timeout effectiveness, evaluating pool size against
concurrent query load, analyzing connection leak patterns via stack trace
attribution, testing pool warm-up strategies, validating
PgBouncer/ProxySQL intermediate pooler settings, and recommending pool
parameter changes with load-test validation. Excludes query optimization
and schema migration.