Hello
I'm currently working on a Django project that utilizes a large PostgreSQL database. I've noticed that some of the queries generated by the ORM are performing quite slowly; which is affecting the overall application performance.
What are the best practices for optimizing Django ORM performance when dealing with large datasets? Any tips on indexing; query optimization, or specific Django features to leverage would be greatly appreciated! I have checked https://docs.djangoproject.com/en/5.1/topics/db/optimization/msbi documentation guide for reference but still need help.
Additionally; I'd like to know if there are tools / libraries that can assist in monitoring and analyzing query performance within Django.
Thanks in advance for your insights!
