Django query count in terminal for debugging

In this article, we'll use the django-querycount library to monitor database queries in Django applications. This debugging tool displays a detailed report of database query counts in the terminal, helping developers identify performance bottlenecks by tracking every database hit on model objects.

Installation

First, install the django-querycount package using pip ?

pip install django-querycount

Configuration

Add the QueryCountMiddleware to your Django project's middleware in settings.py ?

MIDDLEWARE += [
    'querycount.middleware.QueryCountMiddleware',
]

This middleware will automatically monitor all database queries when DEBUG = True in your Django settings.

How It Works

The django-querycount library provides the following features ?

• Query Tracking − Monitors both read and write operations on database models
• Response Time − Calculates request and response processing times
• Tabular Report − Displays organized query statistics in the terminal
• Debug Mode Only − Only functions when DEBUG = True for security

Example Output

When you make requests to your Django application, you'll see output similar to this in your terminal ?

Key Features

Best Practices

When using django-querycount for debugging ?

• Only enable in development environments with DEBUG = True
• Monitor for excessive query counts that indicate N+1 problems
• Use select_related() and prefetch_related() to optimize queries
• Remove the middleware in production for security and performance

Conclusion

Django-querycount is an essential debugging tool that provides real-time database query monitoring in your terminal. It helps identify performance issues by showing query counts, execution times, and operation types for each database interaction.