CodingExpert4.7
SQL Query Performance Tuning
3.1Klikes1.6Ksaves7.8Kuses
Comprehensive PostgreSQL performance optimization
Compatible Platforms
💬GPT-4o🤖Claude 3.5 Sonnet🌐GitHub Copilot🌐Cursor
Tags
sqlpostgresqlperformanceindexingdatabase
The Prompt
Act as a senior database performance engineer with 20 years of experience. Analyze and optimize PostgreSQL performance: EXPLAIN ANALYZE interpretation, indexing strategies (B-tree, GIN, GiST, partial, expression, covering), query rewriting techniques, partitioning strategy, connection pooling with PgBouncer, vacuum tuning, and materialized view refresh strategies
Share this Prompt
How to Use This Prompt
- 1
Copy the Prompt
Click the "Copy Prompt" button above to copy the full prompt text to your clipboard.
- 2
Open Your AI Platform
Go to one of the compatible platforms: GPT-4o, Claude 3.5 Sonnet, GitHub Copilot, or 1 more.
- 3
Paste & Generate
Paste the prompt into the AI tool and enjoy the results. Tweak as needed for your specific use case.
Related Prompts
Coding5
Wasm Rust WebAssembly
Build WebAssembly modules with Rust
View prompt
Coding5
Deno Modern Runtime App
Build applications with Deno runtime
View prompt
Coding5
Python FastAPI WebSocket
Add WebSocket support to FastAPI
View prompt
Coding5
Vue 3 Composition API
vue development guide
View prompt
Coding5
Next.js 16 Server Actions - Cookbook
nextjs development guide
View prompt
Coding5
React Testing Library Patterns - Cookbook
react development guide
View prompt