StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
17777539
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
10
CommunityOwnedDate
CreationDate
2013-07-21T22:19:19.493
FavoriteCount
0
LastActivityDate
2014-05-05T18:29:43.820
LastEditDate
2014-05-05T18:29:43.820
LastEditorUserId
2527433
OwnerUserId
2527433
ParentId
17751163
PostTypeId
2
Score
64
ViewCount
0
LastEditorDisplayName
text
Body
<p>You can create a custom <a href="https://docs.djangoproject.com/en/dev/topics/http/middleware/">middleware</a> to log this. Here is how I create a middleware to achieve this purpose base on <a href="http://djangosnippets.org/snippets/358/">http://djangosnippets.org/snippets/358/</a> (I modified the code a bit).</p> <p>Firstly, assuming your project has a name: <code>test_project</code>, create a file name <code>middlewares.py</code>, I place it in the same folder as <code>settings.py</code>:</p> <pre><code>from django.db import connection from time import time from operator import add import re class StatsMiddleware(object): def process_view(self, request, view_func, view_args, view_kwargs): ''' In your base template, put this: <div id="stats">  </div> ''' # Uncomment the following if you want to get stats on DEBUG=True only #if not settings.DEBUG: # return None # get number of db queries before we do anything n = len(connection.queries) # time the view start = time() response = view_func(request, *view_args, **view_kwargs) total_time = time() - start # compute the db time for the queries just run db_queries = len(connection.queries) - n if db_queries: db_time = reduce(add, [float(q['time']) for q in connection.queries[n:]]) else: db_time = 0.0 # and backout python time python_time = total_time - db_time stats = { 'total_time': total_time, 'python_time': python_time, 'db_time': db_time, 'db_queries': db_queries, } # replace the comment if found if response and response.content: s = response.content regexp = re.compile(r'(?P<cmt>)') match = regexp.search(s) if match: s = (s[:match.start('cmt')] + match.group('fmt') % stats + s[match.end('cmt'):]) response.content = s return response </code></pre> <p>Secondly, modify <code>settings.py</code> to add your middleware:</p> <pre><code>MIDDLEWARE_CLASSES = ( 'django.middleware.common.CommonMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', # ... your existing middlewares ... # your custom middleware here 'test_project.middlewares.StatsMiddleware', ) </code></pre> <p>Note: you have to add the full path to your middleware class like above, the format is:</p> <pre><code><project_name>.<middleware_file_name>.<middleware_class_name> </code></pre> <p>A second note is I added this middleware to the end of the list because I just want to log the template load time alone. If you want to log the load time of templates + all middlewares, please put it in the beginning of <code>MIDDLEWARE_CLASSES</code> list (credits to @Symmitchry).</p> <p>Back to the main topic, the next step is to modify your <code>base.html</code> or whatever pages you want to log load time, add this:</p> <pre><code><div id="stats">  </div> </code></pre> <p>Note: you can name the <code><div id="stats"></code> and use CSS for that div however you want, but DON'T change the comment <code></code>. If you want to change it, be sure that you test it against the regex pattern in the created <code>middlewares.py</code>.</p> <p>Voila, enjoy the statistics.</p> <p><strong>EDIT:</strong></p> <p>For those who use CBVs (Class Based Views) a lot, you might have encountered the error <code>ContentNotRenderedError</code> with above solution. Have no fear, here is the fix in <code>middlewares.py</code>:</p> <pre><code> # replace the comment if found if response: try: # detects TemplateResponse which are not yet rendered if response.is_rendered: rendered_content = response.content else: rendered_content = response.rendered_content except AttributeError: # django < 1.5 rendered_content = response.content if rendered_content: s = rendered_content regexp = re.compile( r'(?P<cmt>)' ) match = regexp.search(s) if match: s = (s[:match.start('cmt')] + match.group('fmt') % stats + s[match.end('cmt'):]) response.content = s return response </code></pre> <p>I got it working with Django 1.6.x, if you have problem with other version of Django, please ping me in comment section.</p>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. PODjango: display time it took to load a page on every page
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USHieu Nguyen
UserOwnerUserId
1. USHieu Nguyen
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. PODjango: display time it took to load a page on every page
  singulars
  PostTypePostTypeId
  PTQuestion
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
3. VO
  singulars
  PostPostId
  PO
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.