Neoview Management Dashboard Client Guide for Database Administrators (R2.4)

Table 6-5 QueryRTS Entity Attributes (continued)
Default Attribute
for Grid?
Default Attribute
for Graph?
DescriptionAttribute
YesNoEstimated time, in seconds, required to perform
i/o for this query, including seeks and data
transfers. Estimated at the time the query is
prepared.
EstIoTime
YesNoEstimated time, in seconds, required for
messaging. Estimated at the time the query is
prepared.
EstMsgTime
YesNoEstimated total CPU time, in seconds. For the
Master Executor, this value includes idle time,
i/o time, messaging time, and processor time.
Estimated at the time the query was prepared.
EstTotalTime
YesNoProcessing node of the Master Executor.MstrCpuNum
YesNoCumulative processor busy time for all disk
processes involved in the query.
DiskProcBsyTime
YesNoNumber of OPEN calls performed by the
Master Executor on behalf of the query.
Opens
YesNoTime, in seconds, that the Master Executor
spent doing OPENs.
OpenTime
YesNoProcess identification number of the Master
Executor.
MstrPin
YesNoTime the Master Executor spent creating new
processes, in seconds.
ProcCreateTime
YesNoNumber of new processes created by the
Master Executor on behalf of this query.
ProcsCreated
YesNoProcess name of the Master Executor.ProcessName
YesNoLocal civil time of last data refresh by WMS.RefreshTS
YesNoUnique ID generated by the connection server
when the Prepare command was received.
StatementID
YesNoUnique ID generated by the connection server
at time of connection.
SessionID
YesNoAlphanumeric string that uniquely identifies
the query. Returned by the Neoview SQL
compiler.
QueryID
YesNoSequential number of the query in WMS.QueryIndex
YesNoUser assigned alias for the query name.QueryName
YesNoSequential number of the service name in the
WMS manager.
ServiceIndex
YesNoName of the service, as registered in WMS,
under which this query is running.
ServiceName
YesNoNumber of bytes returned for statistics counts.StatsBytes
YesNoNumeric ID of the user.UserID
YesNoTime (in local civil time) the query entered the
queue.
EntryTS
YesNoAmount of time, in minutes, the query spent
on the queue.
QueueTime
QueryRTS Entity 97