Debug a Slow SQL Query
Optimizing Database Query Performance
Paste in your AI
Paste this prompt in ChatGPT, Claude or Gemini and customize the variables in brackets.
This SQL query takes [X SECONDS] to run on a table with [N MILLION] rows. Analyze the following execution plan and suggest optimizations: [paste the EXPLAIN ANALYZE plan]. Consider: missing indexes, N+1 query issues, inefficient joins, and alternatives using CTEs or subqueries. Provide the optimized query.
Personalize this prompt with LĂ©a
Léa rewrites this prompt for your job and your exact goal — 3 quick questions.
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
Pour un diagnostic plus précis, ajoutez les statistiques de colonnes (`pg_stats`) et la version de votre SGBD : les stratégies d'optimisation diffèrent entre PostgreSQL 12 et 16 (ex : CTE matérialisation). Indiquez aussi si la table est partitionnée.
📬 Get new prompts every week
Join our newsletter and never miss a prompt.
Go further
Similar Prompts
Write an ORM query
Write efficient ORM queries
Stable Diffusion Prompt to Generate JavaScript Code
Stable Diffusion is an AI image generation model, not a proper code generation tool. However, it can be used creatively in the context of JavaScript development. Stable Diffusion excels at creating code-related visuals: stylized screenshots of JavaScript snippets, illustrations of programming concepts, software architecture diagrams, or educational images for tutorials and technical documentation. By combining well-crafted prompts, you can generate visual representations of JavaScript code on screen, infographics explaining algorithms, or illustrations for your technical blog posts. This approach is particularly useful for tech content creators, web development instructors, and marketing teams who need professional visuals around JavaScript programming. In this guide, we offer optimized prompts for achieving high-quality visual renderings featuring JavaScript code in various visual contexts.
Implement property-based testing
Add property-based tests
Implement rate limiting
Protect APIs from abuse