Python package for query analysis and monitoring in Django
Project description
Django Query Analyzer
Django Query Analyzer is a Django app that allows you to monitor and analyze the database queries executed by your Django application.
Installation
-
Install the
django-query-analyzer
package using pip:pip install django-query-analyzer
-
Add "django_query_analyzer" to your
INSTALLED_APPS
setting in your Django project'ssettings.py
:INSTALLED_APPS = [ ... 'django_query_analyzer', ]
-
Add "django_query_analyzer.middleware.QueryAnalyzerMiddleware" to your project's
MIDDLEWARE
list insettings.py
:MIDDLEWARE = [ ... "django_query_analyzer.middleware.QueryAnalyzerMiddleware", ]
-
Register the query analyzer URL patterns in your project's
urls.py
:from django.urls import path, include urlpatterns = [ ... path("query-analyzer/", include("django_query_analyzer.urls")), ]
-
Run the following command to create the necessary database tables for the "django_query_analyzer" package:
python manage.py migrate
Usage
-
Start your Django development server:
python manage.py runserver
-
Visit the query analyzer dashboard at http://127.0.0.1:8000/query-analyzer/ in your web browser.
Configuration
By default, the query analyzer stores the last 50 executed queries. If you want to control this number, you can add the MAX_QUERY_ANALYZER_RECORDS
setting to your project's settings.py
. For example, to store the last 100 queries, add the following line to your settings.py:
MAX_QUERY_ANALYZER_RECORDS = 100
Logging to Terminal
You can control logging to the terminal by adding the ENABLE_LOGGING_TO_TERMINAL
setting to your project's settings.py
. If set to True
, query analysis details will be printed to the terminal. To disable terminal logging, set it to `False.
Example configuration in settings.py:
ENABLE_LOGGING_TO_TERMINAL = True
Excluded Paths
You can configure excluded path by configuring the PATHS_TO_EXCLUDE
on the settings.py
.
by adding the list of path prefixes, you can ignore the execution of query analyzer on the paths. By default query analyzer execute on every paths.
Example configuration in settings.py:
PATHS_TO_EXCLUDE = ['/admin/','/swagger/']
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for django_query_analyzer-0.0.14.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | ab040df372173eab95e52266e2a007b7f476124db1d681b812f9a85d1961eb61 |
|
MD5 | 96b346be34aee575b7d590275d4f2574 |
|
BLAKE2b-256 | b535dbc961aa754571286b5e34d5def43646c078dee3890f70699dfad5ad5d02 |
Hashes for django_query_analyzer-0.0.14-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 42bbb00b60cb036080aa9b4f4da7145af71cf79cc8a5761636145ee22b7c78e4 |
|
MD5 | 64ddea5009d030702f62339fafe371da |
|
BLAKE2b-256 | 8bde6dd0dbea60e545ab04d9eedc4094193aad52081b8691c6e473bf1431b34a |