django-postgresql-performance

Analyze EXPLAIN ANALYZE output and generate optimal PostgreSQL indexes for Django.

1|Updated Mar 17, 2025

Search Tags:#query optimization #indexing #backend #PostgreSQL #Django #database performance #EXPLAIN ANALYZE

Ready to run

npx skills add https://github.com/MaciWP/CV_Astro --skill django-postgresql-performance

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: django-postgresql-performance
Source: https://github.com/MaciWP/CV_Astro/tree/main/.claude/skills/django-postgresql-performance
Command: npx skills add https://github.com/MaciWP/CV_Astro --skill django-postgresql-performance

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires Django, PostgreSQL, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides advanced strategies to optimize Django applications using PostgreSQL, focusing on database-level performance tuning, efficient indexing, and query analysis to eliminate bottlenecks.

Core Features & Use Cases

Indexing Patterns: Generate optimal indexes (B-tree, GIN, partial, composite) for complex queries, ensuring faster data retrieval.
Query Analysis: Interpret EXPLAIN ANALYZE output to pinpoint slow query components and suggest targeted optimizations.
Use Case: Analyze a slow Django endpoint that queries a large dataset in PostgreSQL, then suggest and generate a migration for a composite index to speed it up.

Quick Start

Analyze the EXPLAIN ANALYZE output for a PostgreSQL query and suggest an optimal index to improve its performance.