How to troubleshoot very slow performance?

[Ramblurr]

I've installed InvenTree locally using docker-compose (prod version) using the stable docker tag on a beefy bare metal server.

In both cases I am seeing incredibly long load times for most page loads and API endpoints. The static assets are loading fast in the sub 10 ms range.

These are fresh instances with no parts, stock, or locations.

I'm using the standard setup with postgresql running next to the application. Both my desktop and the server have fast NVME SSDs, the CPU load of the django app and postgres during this barely registers.

The user experience is very bad as nearly every button press requires a round trip API call, and each API call is taking >5 seconds.

Any advice on what could causing the application to be so slow?

[SchrodingersGat]

@Ramblurr this is certainly not expected behaviour.

• Are you running on the development or production docker setup?
• What version?

It might be that the docker system itself is being resource constrained? Can you share the logs from the inventree-server container?

[matmair]

Also, what database backend are you using?

[Ramblurr]

I'm using the out of the box production docker-compose. So postgres is the database. Log level is set to warning, and debug mode is off.

I booted up a temporary virtual machine in the cloud and ran the production docker-compose, and am not experiencing this issue. But on the bare metal server and my desktop I am experiencing it.

I tested with log level set to DEBUG and debug mode on, just to see if there was anything interesting in the logs, but even with this the only log lines I see (after the application starts) is the HTTP request logs. Are there other knobs to tweak?

[matmair]

I am sorry to say but this sounds like an issue with your docker host. Have you tried to run other stuff on there? It could be the database performance, from the waterfall it seems almost all database-reliant functions are hit.
With the current amount of info, I do not think we can do more for you.

[Ramblurr]

Thanks @matmair I'll do some more troubleshooting below the app layer. Much appreciated.

[SchrodingersGat]

@Ramblurr please do let us know if you find anything that points to an InvenTree issue that we can fix. Best of luck!