Skip to end of metadata
Go to start of metadata

HANA_SQL_SQLCache

 Can be used during performance issues to see what queries ran during a set time frame (specify begin and end time).

Input Parameters

BEGIN_TIME
END_TIME
HOST
SQL_PATTERN
DATA_SOURCE
AGGREGATE_BY
ORDER_BY
RESULT_ROWS

Output Parameters

STATEMENT_HASH:    Hash value of SQL statement
HOST:              Host of statement execution ('various' if several hosts executed the command)
STORE:             ROW for row store tables, COLUMN for column store tables
EXECUTIONS:        Number of executions
ELAPSED_MS:        Elapsed time (ms)
ELA_PER_EXEC_MS:   Elapsed time per execution (ms)
RECORDS:           Number of records
REC_PER_EXEC:      Number of records per execution (ms)
CURSOR_MS:         Cursor execution time (ms), includes network and client activities
CUR_PER_EXEC_MS:   Cursor execution time per execution (ms)
OPEN_MS:           Open time (ms), often contains the actual data collection
OPEN_PER_EXEC_MS:  Open time per execution (ms)
FETCH_MS:          Fetch time (ms), can sometimes contain times related to the actual data collection (row store, late materialization)
FETCH_MS_PER_EXEC: Fetch time per execution (ms)
LOCK_WAIT_MS:      Lock wait time (ms)
LOCK_PER_EXEC_MS:  Lock wait time per execution (ms)

  • No labels