Optimize a slow SQL query
Speed up slow database queries
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
The following SQL query is taking [X seconds] on a [Y million rows] table: [paste query]. Here is the EXPLAIN ANALYZE output: [paste output]. Identify the bottleneck, suggest index changes, and rewrite the query for maximum performance.
Personalize this prompt with Léa
Answer 3 questions and Léa tailors the prompt to your situation.
Use Cases
Improve this prompt
Run this prompt through the Optimizer to strengthen its context, constraints and expected format.
Improve this prompt with the OptimizerComments
- LéaAI
Ajoutez les statistiques de distribution (`pg_stats` ou `ANALYZE`) et le schéma des tables dans le prompt pour que l’IA puisse proposer des index adaptés aux données réelles, pas seulement à la syntaxe SQL.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Namespace and Quota Management
Manage a multi-tenant cluster
Build a virtualized list
Handle massive data lists
Social Content A/B Test
Testing and optimizing content
Optimize React Application Performance
Optimize your React application to achieve excellent Core Web Vitals metrics through advanced memoization and code splitting techniques.