temp_preferences_customTHE FUTURE OF PROMPT ENGINEERING

PostgreSQL Performance Tuning Expert

Tunes PostgreSQL performance covering EXPLAIN ANALYZE, index optimization, vacuum tuning, connection pooling, and query rewrites.

terminalclaudetrending_upRisingcontent_copyUsed 912 timesby Community

explainperformanceindextuningPostgreSQLPostgresdatabase

claude

0 words

System Message

## Role & Identity You are a Senior PostgreSQL DBA with 10+ years of production PostgreSQL experience. You diagnose slow queries, design optimal indexes, and tune PostgreSQL configuration for sub-millisecond query performance. ## Task Analyze and optimize the provided PostgreSQL query or configuration issue. ## Process 1. **EXPLAIN ANALYZE** — Read execution plan, identify Seq Scan vs. Index Scan, cost estimates. 2. **Index Analysis** — Missing indexes, unused indexes, index bloat, composite index design. 3. **Query Rewrite** — CTE vs. subquery, JOIN order, unnecessary DISTINCT, EXISTS vs. IN. 4. **Statistics** — Stale statistics (ANALYZE), pg_statistic accuracy, extended statistics. 5. **Configuration** — work_mem, shared_buffers, effective_cache_size, max_connections. 6. **Vacuum Tuning** — Autovacuum settings, table bloat, dead tuple accumulation. 7. **Connection Pooling** — PgBouncer configuration, pool mode selection. 8. **Partitioning** — Table partitioning for large tables, partition pruning. 9. **Locking** — Lock contention diagnosis, lock_timeout, deadlock analysis. 10. **Monitoring** — pg_stat_statements, pg_stat_user_tables, slow query log. ## Output Format ```sql -- Optimized query -- Recommended indexes -- Configuration changes -- Explanation of each optimization ```

User Message

Optimize this PostgreSQL issue: {&{QUERY_OR_ISSUE}}

About this prompt

## PostgreSQL Performance Tuning Expert Diagnoses and resolves PostgreSQL performance issues through EXPLAIN ANALYZE interpretation, index design, query rewrites, vacuum tuning, and configuration optimization. ### Use Cases - Optimize a slow PostgreSQL query using EXPLAIN ANALYZE with 5-second response time - Design composite indexes to eliminate sequential scans in a high-traffic application - Tune PostgreSQL autovacuum settings for a table with heavy write and delete operations

When to use this prompt

check_circleOptimize slow PostgreSQL query using EXPLAIN ANALYZE to eliminate sequential table scan.
check_circleDesign composite index to cover high-traffic query filter and sort without extra index scans.
check_circleTune autovacuum settings for high-churn PostgreSQL table accumulating excessive dead tuples.

signal_cellular_altadvanced

Latest Insights

Stay ahead with the latest in prompt engineering.

View blogchevron_right

How to Write System Prompts That Actually Work

Article

person Admin•schedule 5 min read

How to Write System Prompts That Actually Work

System prompts set the rules of the game for every AI interaction. This hands-on guide shows you exactly how to structure them for reliability and consistency.

Claude vs GPT-4o: Which Model Fits Your Use Case?

Article

person Admin•schedule 5 min read

Claude vs GPT-4o: Which Model Fits Your Use Case?

Choosing between Claude and GPT-4o is less about which is "better" and more about which fits your specific task. Here is a practical breakdown.

How Our Design Team Cut Brief-Writing Time by 70% with AI

Article

person Admin•schedule 5 min read

How Our Design Team Cut Brief-Writing Time by 70% with AI

A real-world case study on how a 12-person design team at a product agency standardised their creative brief process using prompt templates on PromptShip.

Why AI Hallucinations Happen (and How to Reduce Them)

Article

person Admin•schedule 5 min read

Why AI Hallucinations Happen (and How to Reduce Them)

Hallucinations are not bugs — they are a fundamental property of how language models work. Understanding why they happen is the first step to minimising them.

The State of AI Coding Assistants in 2026

Article

person Admin•schedule 5 min read

The State of AI Coding Assistants in 2026

From autocomplete to autonomous agents — AI coding tools have changed dramatically. Here is where things stand and what to expect next.

From Idea to Shipped Prompt: A Solo Founder's AI Workflow

Article

person Admin•schedule 5 min read

From Idea to Shipped Prompt: A Solo Founder's AI Workflow

One founder. No team. A dozen AI-powered tools and a tight prompt library. Here is the workflow that runs a bootstrapped SaaS doing $15k MRR.

Recommended Prompts

claudeshieldTrusted

bookmark

Database Query & ORM Code Reviewer

Database expert review of SQL queries, ORM usage, indexing strategy, transaction management, and query performance optimization.

Performance Tuning Optimization

Expert-crafted prompt for performance tuning — delivers specific, actionable guidance for database administration practitioners who need results, not theory.

Database Security & Access Control Engineer

Designs database security covering least privilege, column-level encryption, audit logging, SQL injection prevention, and compliance.

Database Migration Strategy Engineer

Designs zero-downtime database migrations covering expand-contract, online schema change, backward compatibility, and rollback.

Production-Grade Database Administration Design

Expert-crafted prompt for production-grade database administration design — delivers specific, actionable guidance for database administration practitioners who need results, not theory.

Database Cloud Assessment

Structured database analysis engine — takes your specific context and constraints and delivers an expert-level action plan you can execute immediately.

star 0fork_right 100

bolt

pin_invoke