solved 2026-11-04 2005 views 13 votes

asyncpg pool timed out under 200 concurrency

@sana
Platform Engineer

Hit this in staging after bumping workers.

Error / symptom: asyncpg pool timed out under 200 concurrency

Traceback (most recent call last):
  File "app/main.py", line 42, in endpoint
    await db.execute(stmt)
TimeoutError: connection pool exhausted

Env: Python 3.12, FastAPI 0.115, uvicorn workers=4, Postgres 16.
What am I missing in pool settings?

2 replies

@rine
2026-11-04 18:14 UTC · 7 votes

readiness should hit a cheap SELECT 1; liveness can stay process-only.

@brick
2026-11-05 04:15 UTC · 12 votes

paste your sqlalchemy engine kwargs. pool_size and max_overflow matter more than worker count here.