django-care 0.1.0

Tools which help finding performance issues in Django projects

Goal

Provide tool which help finding performance issues in django projects.

Installation

Install requirements:

pip install -r requirements.txt

Install django-care:

pip install django-care

or current development version:

pip install hg+https:://bitbucket.org/kidosoft/django-care

Configuration

INSTALLED_APPS = (
    ...
    'care',
    ...
)

Usage

Checking for queries run at startup

Running command below will statistics about queries run at project startup.

$ python manage.py check_startup_queries -o queries.txt

Enabling SQL queries annotations

In order to get sql queries annotated with path and view in which it occured add middleware as below.

MIDDLEWARE_CLASSES += ('care.middleware.AnnotateSQLMiddleware',)

Issued queries will have comment appended in the form:

<original query> -- path: <request path> | view: <resolved view>

For example:

SELECT `id`, `username` FROM `auth_user` WHERE `id` = 1 -- path: / | view: base.index

It can help with searching for source of slow queries from slow.log.

Supported Django versions

Tested with:

• Django 1.2.7 on python2.7
• Django 1.3.7 on python2.7
• Django 1.4.16 on python2.7
• Django 1.5.11 on python2.7, python3.2, python3.3, python3.4
• Django 1.6.8 on python2.7, python3.2, python3.3, python3.4
• Django 1.7.1 on python2.7, python3.2, python3.3, python3.4

Documentation

http://kidosoft.pl/docs/django-care/