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

라이트비전 주식회사 1

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

Your answer