Individual skill

django-query-plan-reading

Read and compare Django/PostgreSQL query execution plans using QuerySet.explain(), EXPLAIN, EXPLAIN ANALYZE, scan types, joins, estimates, actual timing, buffers, and row counts. Use when one SQL query dominates Django latency or when an index, ORM rewrite, pagination change, or materialized view needs proof from a query plan.

plugins/LVTD-LLC/skills/skills/django-query-plan-reading/SKILL.md

Read pinned source

Source commit d780783eba4ecc7c8b9429f95c9362df95f07c61

What was checked

Matches the observed repository HEAD: Yes
Scanner rules are current: Yes
Repository scan complete: No
Skill scan complete: No
Observed behavior: Network or broad shell
Last checked: Nov 4, 2026

These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.

Install this skill

Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.

An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.

Repository context

Repository stars (not skill ratings): 1,532
Repository last updated: Nov 6, 2026
License: Apache-2.0

Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.

ai-coding Repository topic
awesome Repository topic
awesome-list Repository topic
codex Repository topic
codex-plugins Repository topic
openai Repository topic
codex-skill Repository topic
codex-skills Repository topic
marketplace Repository topic
codex-marketplace Repository topic
django,database,query-plans,postgres,performance Declared skill tag
data Derived category
engineering Derived category
data-databases Derived category
engineering-web Derived category

Files and excerpt

File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.

Browse files

SKILL.mdcore · 2,638 bytes
SKILL.mdcore · 2,638 bytes
SKILL.mdcore · 2,638 bytes
references/explain-checklist.mddoc · 2,522 bytes

Read excerpt


# Django Query Plan Reading

Use this skill when the expensive unit is a specific SQL statement or queryset. The goal is to explain why the database is doing work, not to guess from the ORM code.

## Workflow

1. Get the exact query.
   - Prefer the queryset that produced it.
   - If starting from logged SQL, include bound parameters or representative literals.

2. Generate a plan.
   - Use `queryset.explain()` for ORM-owned SQL.
   - Use database `EXPLAIN` for raw SQL, views, materialized views, or SQL copied from logs.
   - Use `analyze=True` only in a safe environment because the database executes the query.