Database Postgresql Query Optimization Deep Fundamentals

---
name: database-postgresql-query-optimization-deep-fundamentals
description: "Use when applying postgresql query optimization fundamen."
version: 1.0.0
author: Hermes Agent
license: MIT
platforms: [linux, macos, windows]
metadata:
  hermes:
    tags: [data, postgres]
    related_skills: ['postgresql-query-optimization']
---

## Overview
Optimize PostgreSQL queries.

## When to Use
- Apply domain best practices

## Key Approaches
1. Define requirements
2. Choose tools
3. Implement
4. Test
5. Document
6. Monitor

## Common Pitfalls
1. Ignoring constraints
2. Skipping standards
3. Poor alignment

## Verification Checklist
- [ ] Requirements validated
- [ ] Standards applied
- [ ] Design reviewed