Django Query Inspector

https://github.com/dobarkod/django-queryinspect

by senko • 12 years ago

82 21 12 years ago

aweb• 12 years ago

This is a nice tool, although I really like the Django Debug Toolbar, which does that and a bit more: https://github.com/django-debug-toolbar/django-debug-toolbar

senko• 12 years ago

I love DjDT, but it doesn't detect duplicate queries and can't be used for non-HTML responses (eg JSON APIs).

abhn2• 12 years ago

Yes I use Django Rest Framework in places and that's where the bulk of my SQL happens.

leetrout• 12 years ago

I have a hack for that!

https://gist.github.com/leetrout/ab136dbfb97f8ee1d309

;)

Edit: After install appending `?dbg=1` to a JSON returning view will inject the html wrapper. e.g. http://foo.com/bar.json?dbg=1

nwenzel2• 12 years ago

I think some of the aggregation of query counts here would be helpful. I'm also a django debug tool bar user. I typically scan the SQL and can visually identify the repeats. My wish there would be aggregating the counts, sum'ing time, and sorting by time rather than execution order.

epicserver2• 12 years ago

https://github.com/mtford90/silk doesn't do aggregates but you can sort etc.

andrewsomething• 12 years ago

I'm also fan of Django Debug Toolbar, enough so that I adopted the package in Debian. Unfortunately, there isn't an active upstream maintainer right now. As the README file says:

"There's no active maintainer at this time. You're welcome to file issues and pull requests but you may receive no answer until a new maintainer steps up."

jlafon3• 12 years ago

For those interested, here are a couple of differences between this and django-debug-toolbar (an excellent, widely used utility that also provides SQL inspection).

1. django-debug-toolbar can be difficult to enable if you aren't serving from localhost (for security reasons, because your settings are included in the UI). This project looks much simpler to enable, as you just set DEBUG=True in your settings.

2. django-debug-toolbar provides its information through a UI component embedded in your own UIs, but it doesn't help you with profiling HTTP APIs that don't have a UI. In contrast, this project puts some profiling information in the response headers, and SQL logs are sent to a logger. I think this use case is where Django Query Inspector shows a lot of utility.

nwenzel2• 12 years ago

"but it doesn't help you with profiling HTTP APIs that don't have a UI"

That's been my only complaint about an otherwise fantastic debug tool.

Anyone have any thoughts on running multiple debug tools like these together? I think mostly you would get comfortable with one and stick with it.

jlafon3• 12 years ago

I end up using Django Rest Framework (http://www.django-rest-framework.org/) generated UIs along with the debug toolbar, and then disabling the generated UIs when I'm done profiling.

StavrosK• 12 years ago

I don't understand #1. You can have DjDT show up only on a condition, e.g. when someone is a superuser. Isn't it the same as this project?

dalore• 12 years ago

Checking for a user will break caching though.

jlafon3• 12 years ago

What I meant is that getting the toolbar to show up when you aren't serving from localhost isn't as trivial as setting DEBUG=True. It requires other settings (https://github.com/django-debug-toolbar/django-debug-toolbar...) which can be annoying to configure.

googletron• 12 years ago

This is very cool and light, I also love not having to bob, back and forth between terminal and browser.

epicserver2• 12 years ago

Theres also silk (https://github.com/mtford90/silk) which was posted recently. It doesnt seem to do the duplicate detection as yours does but does provide a UI and works with APIs. Also gives you a history.

abhn2• 12 years ago

Looks good, Debug Toolbar stopped displaying for me recently (not been able to work out why) and this looks useful for standalone SQL debugging.

mjs7231• 12 years ago

Shameless self promotion: Here is a decorator I wrote to help me inspect performance issues using Django's DOM. The nice thing about this over Django-Debug-Toolbar is that it runs single function rather than the whole view helping you narrow down an issue. You can also add filters to remove unwanted noise during your analysis.

http://pushingkarma.com/notebook/django-decorator-print-sql-...

Joeri• 12 years ago

I love tools like these.

The developer probably wasn't aware of it but there's an opensource project which is trying to get a standardized profiler going for all web dev platforms: http://miniprofiler.com

It would be good to see projects like this done on top of the miniprofiler base.

shabble• 12 years ago

Always nice to see more tools, and the X- headers idea is pretty neat. I've been using a mix of django-debug-toolbar (mentioned repeatedly in this thread), and django-devserver[1], which is more useful when writing non-html serving APIs and suchlike where a toolbar doesn't make sense.

[1] https://github.com/dcramer/django-devserver

noise• 12 years ago

Probably nobody is looking at this thread now, but just in case... I've had similar code I use in Flask apps for awhile now and this project inspired me to turn it into a legit Flask Extension:

https://github.com/noise/flask-queryinspect

Django Query Inspector

Related Stories