Magento 2.4.6 rest api get order slowly

[khoinguyen]

I just updated my staging instance to 2.4.6 p2, the rest api to get orders takes 33s with page size 50 and it returns 504 when the page size is larger than 50.
Do we have any way to check if the database query slowly or code?

 

[steverd]

There's good extension called Ghost Unicorns where you can monitor the backend response times.

GitHub - ghostunicorns/module-webapi-logs: This module allows you to analyze all the webapi rest done call toward your adobe commerce.

This module allows you to analyze all the webapi rest done call toward your adobe commerce. - ghostunicorns/module-webapi-logs

github.com

composer require ghostunicorns/module-webapi-logs

You can view everything under the REPORTS > WEBAPI LOGS tab.