MONITOR_LOAD

Definition

This monitor system table MONITOR_LOAD contains information about executed SQL statements and access methods.

Structure

DESCRIPTION Column

Value

Explanation

SQL commands

Number of executed SQL statements

PREPAREs

Number of parsed SQL statements

PREPAREs repeated

Number of SQL statements that were parsed again after metadata was changed

EXECUTEs

Number of executions of previously parsed SQL statements

COMMITs

Number of executed COMMIT statements

ROLLBACKs

Number of executed ROLLBACK statements

LOCKs and UNLOCKs

Number of executed LOCK and UNLOCK statements

SUBTRANS BEGINs

Number of SQL statements for opening a subtransaction

SUBTRANS ENDs

Number of SQL statements for closing a subtransaction

SUBTRANS ROLLBACKs

Number of SQL statements for rolling back a subtransaction

CREATEs

Number of executed SQL statements for creating database objects

ALTERs

Number of executed SQL statements for altering database objects

DROPs

Number of executed SQL statements for dropping database objects

SELECTs and FETCHes

Number of executed SQL statements for accessing data

SELECTs and FETCHes, rows read

Number of rows read when accessing data

SELECTs and FETCHes, rows qual

Number of rows that were read when accessing data and that satisfied conditions

INSERTs

Number of executed SQL statement for inserting rows

INSERTs, rows inserted

Number of rows inserted

UPDATEs

Number of executed SQL statements for updating rows

UPDATEs, rows read

Number of rows read when updating data

UPDATEs, rows updated

Number of rows updated

DELETEs

Number of executed SQL statements for deleting rows

DELETEs, rows read

Number of rows read when deleting data

DELETEs, rows deleted

Number of rows deleted

Internal DBPROC calls

Number of database procedures executed

External DBPROC calls

Number of external database procedure calls

Internal trigger calls

Number of triggers executed

External trigger calls

Number of external trigger calls

Primary key accesses

Number of search operations with direct access via the key

Primary key accesses (IN strategy)

Number of search operations with access via the key and IN search conditions

Primary key accesses (SUBQ strategy)

Number of search operations with access via the key and subqueries

Primary key accesses, rows read

Number of rows read by direct access via the key

Primary key accesses, rows qual

Number of rows that were read by direct access using the key and that satisfied conditions

Primary key range accesses

Number of search operations with accesses within a range of keys

Primary key range accesses, rows read

Number of rows read within a range of keys

Primary key range accesses, rows qual

Number of rows read within a range of keys that satisfied the condition

Index accesses

Number of search operations with accesses to an index

Index accesses (IN strategy)

Number of search operations with access to an index and IN search conditions

Index accesses (SUBQ strategy)

Number of search operations with accesses to an index and subqueries

Index scan

Number of index searches

Index accesses, rows read

Number of rows directly accessed using an index

Index accesses, rows qual

Number of rows indirectly that were accessed using an index and that satisfied the condition

Index range accesses

Number of search operations using an index range

Index range accesses, rows read

Number of rows indirectly accessed using an index range

Index range accesses, rows qual

Number of rows that satisfied the condition that were indirectly accessed via an index using an index range

Isolated index accesses

Number of search operations completely or partially satisfied by an index without accessing the corresponding base table rows

Isolated index accesses (IN strategy)

Number of search operations with an IN strategy completely or partially satisfied by an index without accessing the corresponding base table rows

Isolated index accesses (SUBQU strategy)

Number of search operations with a subquery strategy completely or partially satisfied by an index without accessing the corresponding base table rows

Isolated index accesses, rows read

Number of keys accessed within the search operations denoted in ISOLATED INDEX ACCESSES

Isolated index accesses, rows qual

Number of keys that were accessed within the search operations denoted in ISOLATED INDEX ACCESSES and that satisfied the condition

Isolated index range accesses

Number of search operations using a part of an index with values within a range without accessing the rows of the base table

Isolated index range accesses, rows read

Number of primary/secondary keys accessed within the search operations denoted by ISOLATED INDEX RANGE ACCESSES

Isolated index range accesses, rows qual

Number of primary/secondary keys that were accessed within the search operations denoted by ISOLATED INDEX RANGE ACCESSES and that satisfied the condition

Table scans

Number of search operations through the whole base table

Table scans, rows read

Number of rows accessed within search operations through the whole base table

Table scans, rows qual

Number of rows that were accessed within search operations through the whole base table and that satisfied the condition

Isolated index scans

Number of search operations for which a complete index was accessed without accessing rows of the base table

Isolated index scans, rows read

Number of index rows accessed within the search operations described under ISOLATED INDEX SCANS

Isolated index scans, rows qual

Number of index rows that were accessed within the search operations described under ISOLATED INDEX SCANS that satisfied the condition

Memory sorts / sort&merge

Number of sorting operations in the main memory to build temporary indexes

Memory sorts / sort&merge, rows read

Number of rows read to build temporary indexes

Sorts by insertion

Number of sorting operations by inserts

Sorts by insertion, rows inserted

Number of rows inserted during the sorting operation

See also:

MONITOR

Concepts of the Database System, SQL Optimizer

Search Conditions for Key Columns, Search Conditions for Indexed Columns

SUBQ CONDITION FOR KEY, SUBQ CONDITION FOR INDEX