Django Query Profiling

Use this skill to turn a vague slow-Django report into a specific queryset, SQL statement, and reproducible scenario.

Workflow

1. Start from the user-visible slow path.

   • Record the URL, API action, background task, management command, or report.
   • Capture request parameters, user or tenant shape, pagination state, and data volume.

2. Collect production or staging evidence.

   • Prefer APM transaction traces when available.
   • Use database slow-query logs for SQL that is slow independent of Python.
   • Use Django Debug Toolbar for server-rendered pages in local development.
   • For APIs or jobs, add targeted query logging around the suspicious block.