Show TOC

Object documentationCOMMANDSTATISTICSRESET Locate this document in the navigation structure

 

The system table SYSINFO.COMMANDSTATISTICSRESET describes SQL statements that are stored in the command cache, and also contains statistical information on the activities of these SQL statements collected since the last RESET COMMANDSTATISTICS or RESET ALL. The command cache contains the SQL statements and their execution plans shared by different database sessions.

Structure

COMMANDSTATISTICSRESET

RESETDATE

TIMESTAMP

Time of the last RESET for these entries

COMMANDID

CHAR(8) BYTE

Identification of the SQL statement

PREPARECOUNT

FIXED(10)

Number of execution preparations

EXECUTECOUNT

FIXED(10)

Number of executions

EXECUTETIME

FIXED(20)

Total duration of executions (µs)

AVGEXECUTETIME

FIXED(20)

Average execution time (µs)

MINEXECUTETIME

FIXED(20)

Minimum execution time (µs)

MAXEXECUTETIME

FIXED(20)

Maximum execution time (µs)

READROWCOUNT

FIXED(20)

Number of rows read

QUALIFIEDROWCOUNT

FIXED(20)

Number of qualified rows

VIRTUALREADCOUNT

FIXED(20)

Number of reads in the data cache

PHYSICALREADCOUNT

FIXED(20)

Number of reads in the data cache that triggered reads on the disk

FETCHROWCOUNT

FIXED(20)

Number of rows (in the result tables generated by the SQL statement) sent to the application

SUSPENDCOUNT

FIXED(20)

Number of suspends

WAITCOUNT

FIXED(20)

Number of waits caused by lock collisions

READAHEADREQUESTCOUNT

FIXED(20)

Number of read ahead requests

READAHEADIGNOREREQUESTCOUNT

FIXED(20)

Number of ignored read ahead requests

READAHEADPHYSICALREADPAGECOUNT

FIXED(20)

Number of pages read via read ahead

More Information

COMMANDSTATISTICS