beautypg.com

HP Neoview Release 2.5 Software User Manual

Page 86

background image

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