/BCV/D_QSTAT - Query Statistics
Query Statistics information is stored in SAP table /BCV/D_QSTAT.
It is part of development package /BCV/QRM in software component CA-EPT-BCV. This development package consists of objects that can be grouped under "".
It is part of development package /BCV/QRM in software component CA-EPT-BCV. This development package consists of objects that can be grouped under "".
Fields for table /BCV/D_QSTAT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
MANDT | Client | X | MANDT | CLNT | 3 | * |
QUERY_ID | Query ID | X | /BCV/QRM_QUERY_ID | CHAR | 32 | /BCV/C_QHEAD |
EXCTIME_MIN | Minimum Processing Time of the Query | /BCV/QRM_ST_EXCTIME_MIN | DEC | 8 | ||
EXCTIME_MAX | Maximum Processing Time of the Query | /BCV/QRM_ST_EXCTIME_MAX | DEC | 8 | ||
EXCTIME_AVG | Average Processing Time of the Query | /BCV/QRM_ST_EXCTIME_AVG | DEC | 8 | ||
EXCTIME_LAST | Last Processing Time of the Query | /BCV/QRM_ST_EXCTIME_LAST | DEC | 8 | ||
EXCDATE_FIRST | First Processing Date of the Query | /BCV/QRM_ST_EXCDATE_FIRST | DATS | 8 | ||
EXCDATE_LAST | Last Processing Date of the Query | /BCV/QRM_ST_EXCDATE_LAST | DATS | 8 | ||
EXC_COUNT | Number of Query Executions | /BCV/QRM_ST_EXC_COUNT | INT4 | 4 | ||
ERROR_COUNT | Number of Erroneous Query Executions | /BCV/QRM_ST_ERROR_COUNT | INT4 | 4 | ||
CACHE_HIT_COUNT | Number of Successful Reads from Results Cache | /BCV/QRM_ST_CACHE_HIT_COUNT | INT4 | 4 | ||
RECORDS_MIN | Minimum Number of Retrieved Result Records | /BCV/QRM_ST_RECORDS_MIN | INT4 | 4 | ||
RECORDS_MAX | Maximum Number of Retrieved Result Records | /BCV/QRM_ST_RECORDS_MAX | INT4 | 4 | ||
RECORDS_AVG | Average Number of Retrieved Result Records | /BCV/QRM_ST_RECORDS_AVG | INT4 | 4 | ||
RECORDS_LAST | Last Number of Retrieved Result Records | /BCV/QRM_ST_RECORDS_LAST | INT4 | 4 | ||
TIMEPERREC_MIN | Minimum Processing Time per Results Record (in Milliseconds) | /BCV/QRM_ST_TIMEPERREC_MIN | DEC | 8 | ||
TIMEPERREC_MAX | Maximum Processing Time per Results Record (in Milliseconds) | /BCV/QRM_ST_TIMEPERREC_MAX | DEC | 8 | ||
TIMEPERREC_AVG | Average Processing Time per Results Record (in Milliseconds) | /BCV/QRM_ST_TIMEPERREC_AVG | DEC | 8 | ||
TIMEPERREC_LAST | Last Processing Time per Results Record (in Milliseconds) | /BCV/QRM_ST_TIMEPERREC_LAST | DEC | 8 |