My sql query starts too slow. What happend in my service?

라이트비전 주식회사 1 Reputation point
2022-04-20T03:43:56.59+00:00

I use app service in azure.

I use django and postgresql to build the system. And I deployed it with azure app service.

In my local development system looks ok. It just took 20ms to complete the same request.

But in the azure It looks serious.

It starts the database query after 300ms.

I don't know what is the problem.

Couldn't Gunicorn start the process? or Couldn't it get the connection from the postgresql?

or Did web service delay my service? (Wasn't ASGI Or WSGI supported in azure web server?)

Is there any specific information to analyze this problem?

Insights is very nice tool but I couldn't get any further information.

194463-%E1%84%89%E1%85%B5%E1%86%AF%E1%84%92%E1%85%A2%E1%86%BC%E1%84%8B%E1%85%B5%E1%84%86%E1%85%B5%E1%84%8C%E1%85%B5.png

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
435 questions
Azure Database for PostgreSQL
Azure Static Web Apps
Azure Static Web Apps
An Azure service that provides streamlined full-stack web app development.
751 questions
{count} votes