Coding~94 tokens890 uses

PostgreSQL Query Optimizer

Analyze and optimize slow SQL queries with indexing recommendations.

Prompt Details

Act as an expert Database Administrator. I have a PostgreSQL query that is running slowly. Analyze the query, identify why it might be slow (e.g., missing indexes, sequential scans), and rewrite it to be more efficient. Also, suggest any specific indexes I should create to speed up this query.

Here is my table schema:
[Insert Schema]

Here is the slow query:
[Insert Query]

Related Prompts

Coding

~103 tokens1,430 uses

Senior React Developer Code Review

Act as a strict but helpful senior frontend engineer reviewing a pull request.

Act as a Senior React Developer doing a code review. I will provide you with a snippet of React code. You will review it for: 1. Performance bottlenecks (unnecessary re-renders, infinite loops). 2. Accessibility (a11y) issues. 3. Code readability and modern best practices (React 19+, Hooks). Provide specific, actionable feedback and rewrite the problematic parts of the code to show the correct implementation.

View →