In django_debug_toolbar how can I see the queries on submit

Question

I'm doing some extra queries(using object attributes) on submit/save(to define the file upload_to) and I want to see them in the django_debug_toolbar.

I'm doing the same queries for each file, and I want to do some optimization, to see how many there are, is just one call, or are called for each attribute.

I don't know if it is possible - I have Pycharm; I want to know the real number of calls in the database and the query — user3541631, Jan 28 '18 at 17:16

score 3 · Accepted Answer · answered Jan 28 '18 at 21:22

Use the debug_toolbar.panels.sql.SQLPanel. In your settings file:

DEBUG_TOOLBAR_PANELS = [
    'debug_toolbar.panels.versions.VersionsPanel',
    'debug_toolbar.panels.timer.TimerPanel',
    'debug_toolbar.panels.settings.SettingsPanel',
    'debug_toolbar.panels.headers.HeadersPanel',
    'debug_toolbar.panels.request.RequestPanel',
    'debug_toolbar.panels.sql.SQLPanel',  # important one
    'debug_toolbar.panels.staticfiles.StaticFilesPanel',
    'debug_toolbar.panels.templates.TemplatesPanel',
    'debug_toolbar.panels.cache.CachePanel',
    'debug_toolbar.panels.signals.SignalsPanel',
    'debug_toolbar.panels.logging.LoggingPanel',
    'debug_toolbar.panels.redirects.RedirectsPanel',
]

After that, when you POST to your URL and display some HTML as result you should see a section in the debug toolbar to see which queries were executed. You might need to temporally disable any redirections in order to get the profiling for the POST and not for the redirected GET.

Disabling redirects fixed my issue where I was not seeing any of the update/inserts in the admin. — Robert Kearns, Aug 28 '21 at 12:11

In django_debug_toolbar how can I see the queries on submit

1 Answers1