Prompt · Developer Tools

SQL Slow Query Fix

Diagnoses a slow query and returns an optimized rewrite plus the indexes it needs.

Have ready: Paste the query and EXPLAIN output if you have it

Fill in · 5 fields

PASTE THE QUERYPOSTGRESQL / MYSQL / ETC. + VERSIONROW COUNTS AND EXISTING INDEXES, OR "UNKNOWN"PASTE EXPLAIN / EXPLAIN ANALYZE OUTPUTHOW SLOW, AND TARGET

Your prompt

This query is too slow. Diagnose it and give me a fixed version.

Query:
[PASTE THE QUERY]
Database: [POSTGRESQL / MYSQL / ETC. + VERSION]
Table sizes and indexes: [ROW COUNTS AND EXISTING INDEXES, OR "UNKNOWN"]
EXPLAIN output (if you have it):
[PASTE EXPLAIN / EXPLAIN ANALYZE OUTPUT]
Current runtime: [HOW SLOW, AND TARGET]

Deliver:
1. What you believe the bottleneck is, in one paragraph, citing the query structure.
2. The rewritten query, semantically identical, no behavior change.
3. The exact CREATE INDEX statements needed, and which part of the query each one serves.
4. What to measure after deploying to confirm the fix, with the query to measure it.

If the schema or data distribution is needed to be sure, say what is missing instead of guessing.

Paste it into Muse or any assistant. Blank fields stay as [brackets].

More like this

API Contract Design

Regex Builder

Docstring Writer

Commit Message Writer

Test Generator

Merge Conflict Resolver