User Guide > Performance Tuning > Working with the SQL Execution Plan > Execution Plan Node Attributes in the Details Panel
 
Execution Plan Node Attributes in the Details Panel
The following table lists attributes that can appear in the Details Panel. This panel is displayed at the bottom right of the Studio Modeler pane when you click Show Execution Plan, or of the Studio Manager pane when you click Show Query Plan. When you select a node in the Tree Panel on the left, its attributes are displayed.
The following table lists attributes that can appear in the Details Panel when a node is highlighted in the Tree Panel. This panel is displayed at the bottom right of the Studio Modeler pane when you click Show Execution Plan, or of the Studio Manager pane when you click Show Query Plan.
Note: See Execution Plan Nodes in the Tree Panel, for a list of nodes.
These attributes can also be found in the logged execution plan, although some of them are estimates before execution and actual run-time values after execution.
Field
Description
Algorithm
Name of the algorithm used by the node; for example HASH JOIN or SORT/MERGE JOIN.
Algorithm notes
More details about the algorithm used.
Background data source read time
For SCAN or PROCEDURE: how much time the child thread spent on reading from the data source.
Background node processing time
For nodes other than SCAN, PROCEDURE, INSERT, UPDATE, DELETE, or MERGE: time spent processing this node by a background thread. This time is zero if the node was processed by a foreground thread.
Base DN
For SCAN.
Candidate keys
For SELECT.
Connection ID
For SCAN.
Criteria
Shows the criteria used by a JOIN, FILTER, GROUP BY, or ORDER BY node. Condition or predicate applied during an operation
Data ship notes
For SCAN or SELECT. A report of the estimated number of rows to be shipped, and the amount of time consumed to get the cost estimate. When a condition blocks the use of data ship, this field usually describes the condition, case, or option that blocked optimization.
Data ship SQL
For SCAN.
Data ship target
For SCAN. Shows where the results of SQL execution will be sent. The presence of Data ship target indicates that data ship will be performed.
Data ship transfer time
For SCAN.
Data source driver name
For SCAN or PROCEDURE.
Data source path
For SCAN or PROCEDURE.
Data source type
For SCAN or PROCEDURE.
Data source write time
For INSERT, UPDATE, DELETE or MERGE.
Estimated left cardinality
Estimated cardinality for the left input in a binary join. Pre-execution (Show Execution Plan button) Details Panel only
Estimated right cardinality
Estimated cardinality for the right input in a binary join. Pre-execution (Show Execution Plan button) Details Panel only
Estimated rows returned
Pre-execution (Show Execution Plan button) Details Panel only. Logged execution plan records actual Rows Returned.
Execution status
If the operation for the node is still running, status can be PARTIAL RESULTS or NOT EXECUTED.
Fetch rows
For SELECT.
Foreground data source read time
For SCAN or PROCEDURE. Fraction of the Elapsed execution time that the main thread used to read data from the data sources. By comparing this time with Foreground server processing time, you can determine how much time was spent by the server vs. the time spent in the data sources.
Foreground node processing time
For nodes other than SCAN, PROCEDURE, INSERT, UPDATE, DELETE, or MERGE: fraction of the elapsed time used by the node. This time is zero if the node was processed by a background thread.
Name
 
No push reason
Why the node was not pushed to the data source.
Offset rows
For SELECT.
Peak memory reserved
Peak memory reserved for current node.
Peak memory used
Peak memory used for current node.
Procedure join number of invokes
For PROCEDURE.
Procedure type
For PROCEDURE.
Projection
Set of output columns in a SELECT node.
Rows deleted
 
Rows inserted
 
Rows merged
 
Rows returned
 
Rows updated
 
Runtime notes
 
Semi-join criteria
For SCAN.
Semi-join partition count
For SCAN.
SQL
SQL text executed by the node. In a FETCH or PROCEDURE node, this field contains the actual data-source-specific query that was pushed.
UniqueIndex
For SELECT.