Hp Neoview Release 2.3 Software Manuel d'utilisateur télécharger pdf (Page 31)

Table 3-4 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)

DescriptionData Type

Field Name (* means available only in

this view)

Number of bytes written to disk.LARGEINT SIGNED NO DEFAULTMESSAGE_BYTES_TO_DISK

Number of messages sent to disk.LARGEINT SIGNED NO DEFAULTMESSAGES_TO_DISK

Number of records accessed by the

disk process or the file system to

evaluate the statement.

LARGEINT SIGNED NO DEFAULTROWS_ACCESSED

Cumulative number of rows retrieved.LARGEINT SIGNED NO DEFAULTROWS_RETRIEVED

Number of rows

updated/inserted/deleted. This value

is NULL for queries in process or for

which the Repository did not receive

end statistics. It is 0 for SELECT

queries for which the Repository

received end statistics and >0 for UID

queries for which the Repository

received end statistics.

LARGEINT SIGNED NO DEFAULTNUM_ROWS_UID

Time, in microseconds, that the query

spent in the Workload Management

queue before it started executing.

INTERVAL SECOND(12,6) NO

DEFAULT

QUE_TIME*

Number of OPEN calls performed by

the Executor on behalf of this query.

LARGEINT SIGNED NO DEFAULTOPENS*

An approximation of the total node

time spend in master and ESPs

involved in the query. The node time

is expressed in microseconds.

INTERVAL SECOND(12,6) NO

DEFAULT

SQL_PROCESS_BUSY_TIME*

Number of new processes created by

the Executor on behalf of this process.

INTEGER SIGNED NO DEFAULTNUM_PROCESSES_CREATED*

Estimated number of rows to be

accessed from Disk Process at runtime

by EID (Executor in Disk Process). This

value is meaningful for SELECT, not

for Insert/Update/Delete. For

Insert/Update/Delete, the value is

reported as 0.0.

DOUBLE PRECISION NO DEFAULTEST_ACCESSED_ROWS*

Estimated number of rows to be

returned by EID after applying

selection predicates

DOUBLE PRECISION NO DEFAULTEST_USED_ROWS*

Estimated cost (time in seconds) of the

SQL operations in the Master Executor.

The estimate occurs at the time the

query is prepared.

DOUBLE PRECISION NO DEFAULTEST_COST*

Estimate of the number of seconds of

I/O time (seeks plus data transfer) to

perform the I/O for this query. The

estimate occurs at the time the query

is prepared.

DOUBLE PRECISION NO DEFAULTEST_IO_TIME*

Estimate of the number of seconds

required for the messaging for this

query, including local and remote

messages, and the amount of data sent.

The estimate occurs at the time the

query is prepared.

DOUBLE PRECISION NO DEFAULTEST_MESSAGE_TIME*

Query Statistics 31

1 2 ... 26 27 28 29 30 31 32 33 34 35 36 ... 73 74

Commentaires sur ces manuels

Pas de commentaire

Hp Neoview Release 2.3 Software Manuel d'utilisateur Page 31

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel Hp Neoview Release 2.3 Software