Explain PostgreSQL

Analyzes EXPLAIN plan from PostgreSQL and related (Greenplum, Citus, TimescaleDB and Amazon RedShift).

Shows plan and node details and visualizations with piechart, flowchart and tilemap, also gives smart recommendations to improve query.

Learn more

Usage:

• Plan analyze - open "Explain PostgreSQL" tool window and paste the plan to site
• Format query - right-click the current query and in context menu choose "SQL Format" or press "Ctrl+Q F"
  (uses the public api from the https://explain.tensor.ru , the site can be changed in Settings | Tools | Explain PostgreSQL)
  
• Run query and analyze plan - right-click the query in "Query console" and in context menu choose "Explain Plan | Explain Analyze (Tensor)"
  (Webstorm requires installation of Database Tools and SQL plugin)