Document Type | Technical Information
Category | Monitoring/Inspection
Document Number | TMOTI020
Overview
This provides guidance on the Tibero execution plan.
This explains the execution plan and statistical information items of queries output in the SQL TRACE result file.
Method
Execution Stages
These are the statistical items by SQL execution stage.
Execution Stage | Description |
|---|---|
PARSE | Converts the SQL statement into an execution plan, including checking table, column, and referenced object permissions. |
EXECUTE | Processes INSERT, UPDATE, DELETE operations that cause data changes according to the execution plan. For SELECT statements, indicates the number of rows selected. |
FETCH | Indicates the number of rows returned by the query result. Fetch is performed only during SELECT statement processing. |
Interpreting SQL Plan Statistical Information
You can check resource consumption details during SQL execution.
Execution Stage | Description |
|---|---|
cpu | CPU usage time (in seconds) |
elapsed | Elapsed time for SQL execution |
current | Number of Current blocks fetched |
query | Number of Consistent read blocks fetched |
disk | Number of blocks read from disk |
rows | Number of result rows processed |
Statistics Information within Execution Plan
You can check detailed statistical information for each node of the Execution Plan.
Execution Stage | Description |
|---|---|
rows | Number of result rows processed |
et | Elapsed time |
cr | Number of Consistent read blocks |
cu | Number of Current blocks |
co | Cost of the node calculated by the optimizer |
cpu | CPU proportion of the total Cost |
ro | Number of rows predicted by the optimizer for the node |