blocks|key|1535484|text|您还可以使用python日志记录Django生成的所有查询。只需将此文件添加到您的设置文件中。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1535485|LOGGING+=+{
++++'disable_existing_loggers':+False,
++++'version':+1,
++++'handlers':+{
++++++++'console':+{
++++++++++++#+logging+handler+that+outputs+log+messages+to+terminal
++++++++++++'class':+'logging.StreamHandler',
++++++++++++'level':+'DEBUG',+#+message+level+to+be+written+to+console
++++++++},
++++},
++++'loggers':+{
++++++++'':+{
++++++++++++#+this+sets+root+level+logger+to+log+debug+and+higher+level
++++++++++++#+logs+to+console.+All+other+loggers+inherit+settings+from
++++++++++++#+root+level+logger.
++++++++++++'handlers':+['console'],
++++++++++++'level':+'DEBUG',
++++++++++++'propagate':+False,+#+this+tells+logger+to+send+logging+message
++++++++++++++++++++++++++++++++#+to+its+parent+(will+send+if+set+to+True)
++++++++},
++++++++'django.db':+{
++++++++++++#+django+also+has+database+level+logging
++++++++++++'level':+'DEBUG'
++++++++},
++++},
}|code-block|syntax|javascript|1535486|在应用程序生成html输出的情况下的另一种方法-可以使用django+debug+toolbar。|offset|length|1535487|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/django-debug-toolbar/django-debug-toolbar^0|0|0|S|K|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

<p>You also can use python logging to log all queries generated by Django. Just add this to your settings file.</p>
<pre><code>LOGGING = {
    'disable_existing_loggers': False,
    'version': 1,
    'handlers': {
        'console': {
            # logging handler that outputs log messages to terminal
            'class': 'logging.StreamHandler',
            'level': 'DEBUG', # message level to be written to console
        },
    },
    'loggers': {
        '': {
            # this sets root level logger to log debug and higher level
            # logs to console. All other loggers inherit settings from
            # root level logger.
            'handlers': ['console'],
            'level': 'DEBUG',
            'propagate': False, # this tells logger to send logging message
                                # to its parent (will send if set to True)
        },
        'django.db': {
            # django also has database level logging
            'level': 'DEBUG'
        },
    },
}
</code></pre>
<p>Another method in case application is generating html output - <a href="https://github.com/django-debug-toolbar/django-debug-toolbar" rel="nofollow noreferrer">django debug toolbar</a> can be used.</p>


blocks|key|1320305|text|您可以将以下代码粘贴到您的shell上，它将显示所有SQL查询：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1320306|#+To+get+all+sql+queries+sent+by+Django+from+py+shell
import+logging
l+=+logging.getLogger('django.db.backends')
l.setLevel(logging.DEBUG)
l.addHandler(logging.StreamHandler())|code-block|syntax|javascript|1320307|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

<p>You can paste this code on your shell which will display all the SQL queries:</p>

<pre><code># To get all sql queries sent by Django from py shell
import logging
l = logging.getLogger('django.db.backends')
l.setLevel(logging.DEBUG)
l.addHandler(logging.StreamHandler())
</code></pre>


blocks|key|1535344|text|只要DEBUG处于打开状态：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1535345|from+django.db+import+connection
print(connection.queries)|code-block|syntax|javascript|1535346|对于单个查询，您可以执行以下操作：|1535347|print(Model.objects.filter(name='test').query)|1535348|entityMap^0|2|5|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|P|$]]

<p>As long as <code>DEBUG</code> is on:</p>

<pre><code>from django.db import connection
print(connection.queries)
</code></pre>

<p>For an individual query, you can do:</p>

<pre><code>print(Model.objects.filter(name='test').query)
</code></pre>


blocks|key|1535412|text|也许你应该看看django-debug-toolbar应用程序，它会为你记录所有的查询，显示他们的分析信息等等。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1535413|entityMap^0|7|K|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

<p>Maybe you should take a look at <code>django-debug-toolbar</code> application, it will log all queries for you, display profiling information for them and much more.</p>


blocks|key|1320413|text|一种可靠的解决方案是将数据库服务器记录到一个文件中，然后|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1320414|tail+-f+/path/to/the/log/file.log|code-block|syntax|javascript|1320415|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

<p>A robust solution would be to have your database server log to a file and then</p>

<pre><code>tail -f /path/to/the/log/file.log
</code></pre>


blocks|key|1320591|text|如果使用数据库路由，则可能有多个数据库连接。这样的代码可以让您看到会话中的连接。您可以使用与单个连接相同的方式重置统计信息：reset_queries()|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|1320592|from+django.db+import+connections,connection,reset_queries
...
reset_queries()++#+resets+data+collection,+call+whenever+it+makes+sense|code-block|syntax|javascript|1320593|..。|1320594|def+query_all():
++++for+c+in+connections.all():
++++++++print(f"Queries+per+connection:+Database:+{c.settings_dict['NAME']}+{c.queries}")

#+and+if+you+just+want+to+count+the+number+of+queries
def+query_count_all()->int:
++++return+sum(len(c.queries)+for+c+in+connections.all()+)|1320595|entityMap^0|1Q|F|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@$9|R|A|S|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|T|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|V|8|@]|D|@]|E|$I|J]]|$1|O|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|P|$]]

<p>If you are using database routing, you probably have more than one database connection. 
Code like this lets you see connections in a session.
You can reset the stats the same way as with a single connection: <code>reset_queries()</code></p>

<pre><code>from django.db import connections,connection,reset_queries
...
reset_queries()  # resets data collection, call whenever it makes sense
</code></pre>

<p>...</p>

<pre><code>def query_all():
    for c in connections.all():
        print(f"Queries per connection: Database: {c.settings_dict['NAME']} {c.queries}")

# and if you just want to count the number of queries
def query_count_all()-&gt;int:
    return sum(len(c.queries) for c in connections.all() )
</code></pre>


blocks|key|1535776|text|您可以使用Django+debug_toolbar来查看SQL查询。debug_toolbar用法分步指南：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1535777|安装Debug_toolbar|1535778|pip+install+django-debug-toolbar|code-block|syntax|javascript|1535779|编辑settings.py文件并将debug_toolbar添加到已安装的应用程序，这应该添加到下面的‘django.contri.staticfiles’中。还要将debug_toolbar添加到中间件中。|1535780|Settings.py=>|1535781|INSTALLED_APPS=+[+'debug_toolbar']+

MIDDLEWARE+=+['debug_toolbar.middleware.DebugToolbarMiddleware']|1535782|在settings.py文件中创建一个名为INTERNAL_IPS的新列表|1535783|Settings.py=>在settings.py文件末尾创建新列表，并添加以下列表：|1535784|INTERNAL_IPS=+[127.0.0.1']|1535785|这将允许调试程序仅在内部开发服务器上运行|1535786|编辑#项目的urls.py文件并添加以下代码：|1535787|if+settings.DEBUG:
++++import+debug_toolbar
++++urlpatterns+=+[
++++url(r'%5E__debug__/',+include(debug_toolbar.urls))+++++++
++++]+%2B+urlpatterns|1535788|再次应用迁移并运行服务器|1535789|你会在127.0.0.1的网页上看到一个插件&如果你点击SQL+Query复选框，你也可以实际看到查询的运行时间。|1535790|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|17|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|18|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|19|8|@]|9|@]|A|$]]|$1|K|3|L|5|6|7|1A|8|@]|9|@]|A|$]]|$1|M|3|N|5|F|7|1B|8|@]|9|@]|A|$G|H]]|$1|O|3|P|5|6|7|1C|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|1D|8|@]|9|@]|A|$]]|$1|S|3|T|5|F|7|1E|8|@]|9|@]|A|$G|H]]|$1|U|3|V|5|6|7|1F|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1G|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|F|7|1H|8|@]|9|@]|A|$G|H]]|$1|10|3|11|5|6|7|1I|8|@]|9|@]|A|$]]|$1|12|3|13|5|6|7|1J|8|@]|9|@]|A|$]]|$1|14|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|15|$]]

<p>You can use a Django debug_toolbar to view the SQL query. 
Step by step guide for debug_toolbar usage :</p>

<h3>Install the Debug_toolbar</h3>

<pre><code>pip install django-debug-toolbar
</code></pre>

<h3>Edit settings.py file &amp; add debug_toolbar to Installed apps, this should be added below to 'django.contrib.staticfiles'. Also add debug_toolbar to Middleware.</h3>

<p>Settings.py=> </p>

<pre><code>INSTALLED_APPS= [ 'debug_toolbar'] 

MIDDLEWARE = ['debug_toolbar.middleware.DebugToolbarMiddleware']
</code></pre>

<h3>create a new list named INTERNAL_IPS in settings.py file</h3>

<p>Settings.py=> create new list at the end of settings.py file &amp; add below list:</p>

<pre><code>INTERNAL_IPS= [127.0.0.1']
</code></pre>

<p>This will allow the debug to run only on internal developement server</p>

<h3>Edit urls.py file of #Project &amp; add below code:</h3>

<pre><code>if settings.DEBUG:
    import debug_toolbar
    urlpatterns = [
    url(r'^__debug__/', include(debug_toolbar.urls))       
    ] + urlpatterns
</code></pre>

<h3>apply migrate &amp; run server again</h3>

<p>You will see an add-on on your web page at 127.0.0.1 &amp; if you click on SQL Query check box, you can actually see the run time of query as well.</p>


<p>Is there a way I can print the query the Django ORM is generating?</p>

<p>Say I execute the following statement: <code>Model.objects.filter(name='test')</code></p>

<p>How do I get to see the generated SQL query?</p>


How to view corresponding SQL query of the Django ORM's queryset?

中间件

数据库

服务器

路由

Django

有没有办法打印Django ORM生成的查询？假设我执行以下语句：Model.objects.filter(name='test')如何查看生成的SQL查询？

问如何查看Django ORM的查询集对应的SQL查询？
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何查看Django ORM的查询集对应的SQL查询？EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何查看Django ORM的查询集对应的SQL查询？
EN