DEVOPS2 Multi-file Components

PostgreSQL Query Tuning, EXPLAIN ANALYZE & Indexing

Techniques for accelerating multi-million row PostgreSQL queries from seconds to single-digit milliseconds.

Author: TRIHEX Architecture Lab

•

License: MIT

•

Version: 2.1.0

Inert Code Verified · Heuristic Static Security ScannerHeuristic Scanner: LOW Risk

Heuristic static security scanner audited 2 files (2520 bytes). External code. Review before execution.

v2.1.0

Skill Files (2)

Compatible Runtimes

AntigravityClaude CodeCursor

SKILL.md·markdown

# PostgreSQL Query Tuning, EXPLAIN ANALYZE & Indexing

Diagnosing slow queries with EXPLAIN ANALYZE, B-tree vs GIN indexes, partial indexes, and vacuuming.

## Core Invariants & Rules
1. Create composite indexes in order of equality columns first, then range/sort columns.
2. Verify input validation and security boundaries on all executions.
3. Keep configurations modular, typed, and auditable.

## Operational Workflow
1. Analyze requirements against existing codebase patterns.
2. Apply standardized implementation templates.
3. Execute verification suites before deployment.