Paste your execution plan JSON below and get optimization recommendations
To generate the execution plan JSON that this tool can analyze, run your query with:
EXPLAIN (ANALYZE, COSTS, FORMAT JSON) YOUR_QUERY_HERE;
Copy the entire JSON array output and paste it above for analysis. The tool focuses on execution time, costs, and operation types for optimization recommendations.
The PostgreSQL Query Analyzer is a tool designed to analyze PostgreSQL execution plans and provide optimization recommendations. It helps users understand query performance and identify potential improvements.
Note: This tool is a best-effort support tool that we provide to help users optimize their PostgreSQL queries.
Is the data being stored? We do not store any data from the execution plans you analyze. The tool processes the JSON input in memory and does not retain any information after the analysis is complete. Currently is not connected to any database or external storage.