HP Neoview Release 2.5 Software User Manual
Page 86
•
Type: Time
Description
Field
Indicates the time when the query was submitted into the
Neoview system.
Start Time
Indicates the time when the query completed execution.
End Time
Cumulative node busy time in seconds for all disk processes
involved in executing the query.
Disk Process Busy Time Sec
Node processing time, in seconds, from the time the execution
starts to the time the results are returned. It does not include CPU
time consumed by SQL executor child processes (ESPs) or disk
processes for the query.
Master Execution Time Sec
Time when the query compilation started (or when PREPARE
for this query).
Compilation Start Time
Time when the query compilation ended (or when PREPARE for
this query).
Compilation End Time
Indicates estimated total amount of messaging time.
Msg Time Estimate
Indicates estimated total amount of IO time.
Io Time Estimate
Indicates estimated idle time.
Idle Time Estimate
Indicates estimated total amount of processor (CPU) time.
Cpu Time Estimate
Total time estimate.
Estimated Total Time
Time when the query started running (or executing).
Execution Start Time
Indicates how long a query waited before it started execution
(time from entry into the system until the time the query actually
started its execution).
Wait Time
Indicates how long a query was in a hold state.
Hold Time
Amount of time used by Neoview SQL to execute the query.
Query Elapsed Time
Processor (CPU) utilization by Neoview SQL.
Sql Cpu Time
Processor (CPU) utilization by the disk process.
Disk Process Busytime
Time the fetch started.
Fetch Start Time
Time when query execution ended.When a query is executing,
Execute End Time is –1.
Execution End Time
Node processing time, in microseconds, from the time the
execution starts to the time the results are returned. It does not
include CPU time consumed by SQL executor child processes
(ESPs) or disk processes for the query.
Master Executor Time
Time in microseconds this process spent doing file OPENs.
Open Busy Time
Amount of time to create Executor Server Processes (ESPs).
Process Creation Time
Time when query entered the Neoview system.
Entry Time
Total time it took for the query to run.
Elapsed Time
Total time it took for the query to run.
Total Elapsed Time
Time it took for the Neoview platform to execute the query.
Total Execution Time
Current system time.
Current System Time
86
Use the Triage Space Pane