Online Documentation for SQL Manager for PostgreSQL
Viewing query plan
Using SQL Manager for PostgreSQL, you can view the plan for each of the queries created and executed in the application. The query plan is available within the corresponding Plan tab.
The Plan tab allows you to view the sequence of actions performed by the database server in the process of the query execution, and the amount of system resources used for the query execution.
The Operation panel below displays the operations as a tree list with the following columns: Operation Info, Operation, Start-up Cost, Total Cost, Number of Rows, Row Width, Startup Time, Total Time, Real Number of Rows, Loops.
The area at the bottom displays the execution plan as text.