Hi all,
I’ve been working on a tool that tracks all your queries and gives hints on ways to optimize them, GitHub - Tijani-Dia/dj-tracker: A Django app that tracks your queries to help optimize them
- It can show how much time each field has been accessed for a model instance
- It provides hints on when to use
.values,.values_list,.iterator… - It shows related all related queries in the same tab making it easy to debug and solve N+1 queries
- Everything is persisted in a database, so you can keep track of the performance of your application over time
- Optimised for both speed and memory
- And many more features to help improve your application’s database access
This is still in alpha phase (especially, since the UI is not terrible). I’d be grateful if you could try it in some of your projects and let me know what you think of it, report bugs you’ll find and tell me how it could be improved.
Thanks.