Explain PostgreSQL IntelliJ plugin

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

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

Learn more

Usage:

• Run query and analyze plan
  
  • IntelliJ Ultimate: right-click the query in Database Console and choose "Explain Plan | Explain Analyze (Tensor)"
    (Webstorm requires installation of Database Tools and SQL plugin) Explain Analyze results: Explain results:
  • IntelliJ Community: requires Database Navigator (DBN) plugin. Then you can either right-click the query in the editor and select "Explain Analyze (Tensor)", or use the corresponding action on the DBN toolbar.
  
• Format query – right-click the current query and in context menu choose "SQL Format" or press "Ctrl+Q F" (uses the public api from https://explain.tensor.ru , the site can be changed in Settings | Tools | Explain PostgreSQL)
• Plan analyze manually – open "Explain PostgreSQL" tool window and paste the plan from any source

Support