SupExplain

An AI Postgres Query Plan Explainer

About SupExplain
SupExplain is an AI Postgres Explain Visualizer. It uses the PEV library to visualize the query plan of your queries

The tool also uses GPT-4o to analyze your query plan and suggest recommendations

Use this tool to identify inefficiencies in your queries and improve performance
Run your query with EXPLAIN ANALYZE
Open the SQL editor of your supabase project

Append the following statement to the start of the query and run it
EXPLAIN (ANALYZE, COSTS, VERBOSE, BUFFERS, FORMAT JSON)
Paste the output on the RHS
Paste the query plan in the top box, and the query in the bottom box.
Click on Analyze Query Plan
This tool does not store your query or send it to any remote servers. All visualizations are rendered locally
Analyze query with AI (this will send the plan to OpenAI)