AGENT SKILL

django-query-profiling

Find the Django ORM code and request path responsible for slow SQL by using APM traces, slow query logs, Django Debug Toolbar, query logging, and local reproduction. Use when a Django database performance issue is suspected but the exact queryset, view, serializer, template, or job causing it is not yet proven.

License 许可
MIT
最近更新
2026-11-14
Stars
★ 1.6k
Forks
491

01 前言 Front Matter

name
django-query-profiling
license
MIT
metadata
{ "tags": "django,database,profiling,apm,debug-toolbar", "version": "0.1.0", "category": "Django", "displayName": "Django Query Profiling" }
description
Find the Django ORM code and request path responsible for slow SQL by using APM traces, slow query logs, Django Debug Toolbar, query logging, and local reproduction. Use when a Django database performance issue is suspected but the exact queryset, view, serializer, template, or job causing it is not yet proven.
compatibility
Codex, Claude Code, and other Agent Skills-compatible clients.

02 资源文件 1

03 SKILL.md 正文

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.
  3. Map SQL back to Django code.

    • Search model table names and column names.
    • Inspect view get_queryset(), serializer fields, template loops, managers, model properties, and signal handlers.
    • Check whether related-object access happens after the initial queryset was evaluated.
  4. Reproduce locally or in a safe shell.

    • Use production-like row counts when possible.
    • Disable unrelated instrumentation and debug-only middleware when measuring.
    • Keep a repeatable script, test, or shell snippet that exercises the slow path.
  5. Route the fix.

    • Query count issue: use django-orm-query-optimization.
    • One slow SQL statement: use django-query-plan-reading.
    • Large loops or writes: use django-queryset-batch-processing.

See tooling-and-reproduction.md for concrete profiling snippets and pitfalls.

Good Evidence

  • Query count before/after for the specific path.
  • The slow SQL or normalized SQL fingerprint.
  • Stack or code pointer that explains where the SQL originates.
  • Timing from the same environment and representative data shape.

Verification

Do not finish profiling with only a hunch. Finish with a named queryset, code path, and command or request that another agent can re-run.

04 同仓库更多 Skills

hashgraph-online
hashgraph-online/awesome-codex-plugins

worktable-review-with-annotations

Create, inspect, reply to, update, or resolve situated Worktable annotations. Use when feedback belongs to a Doc section, block, text range, or HTML Doc, or when the user asks to address existing review feedback and coordinate a requested artifact edit.

★ 1.6k
hashgraph-online
hashgraph-online/awesome-codex-plugins

worktable-find-and-synthesize-context

Find, assess, and synthesize context from Worktable Docs and Records. Use when the user asks what a workspace contains, wants workspace-backed research, needs current facts reconciled across artifacts, or requests a cited synthesis without changing workspace state.

★ 1.6k
hashgraph-online
hashgraph-online/awesome-codex-plugins

worktable-create-or-update-docs

Create, edit, rename, or maintain narrative Worktable Docs. Use for plans, decisions, briefs, notes, research syntheses, and other durable prose when the user requests a new artifact or a safe update to an existing one.

★ 1.6k
hashgraph-online
hashgraph-online/awesome-codex-plugins

worktable-create-or-manage-records

Organize repeated structured information as durable Worktable Records. Use for research datasets, inventories, directories, pipelines, trackers, and other collections whose items need identity, fields, filtering, links, validation, or individual updates.

★ 1.6k
hashgraph-online
hashgraph-online/awesome-codex-plugins

worktable-create-or-manage-interactive-html

Create or improve durable visual and interactive artifacts in Worktable. Use for dashboards, trackers, calculators, mini apps, slide presentations, and other requests that benefit from a polished HTML Doc.

★ 1.6k
hashgraph-online
hashgraph-online/awesome-codex-plugins

worktable-collaborate-threads

Read, answer, and hand off messages through durable Worktable threads with users or other authenticated participants. Use when the user asks to check addressed messages, reply to a participant, continue a thread, request another agent's help, wait briefly for a response, or watch for comments and messages sent to the agent.

★ 1.6k