Skip to main content

SAP HANA SQL Statistics

SQL statistic nameDescriptionDBmarlin collects?Doc Link
**DURATION**Derived Field = TOTAL_CURSOR_DURATION / 1000 Yes - DerivedN/A
**EXECUTIONS**Derived Field = EXECUTION_COUNT Yes - DerivedN/A
**CPU_TIME_MILLISECONDS**Derived Field = TOTAL_EXECUTION_CPU_TIME / 1000 Yes - DerivedN/A
**PHYSICAL_READS**Derived Field = TOTAL_BUFFER_CACHE_PAGE_MISS_COUNT Yes - DerivedN/A
**LOGICAL_READS**Derived Field = TOTAL_BUFFER_CACHE_PAGE_MISS_COUNT + TOTAL_BUFFER_CACHE_PAGE_HIT_COUNT Yes - DerivedN/A
**STATEMENT_STRING**Displays the statement string. No Not a SQL Statistic
**STATEMENT_HASH**Displays the MD5 hash value for STATEMENT_STRING. No Not a SQL Statistic
**USER_NAME**Displays the user name who prepared the plan. No Not a SQL Statistic
**SESSION_USER_NAME**Displays the SESSION_USER name who prepared the plan. The same value as M_CONNECTIONS.USER_NAME. No Not a SQL Statistic
**SCHEMA_NAME**Displays the schema name that the SQL plan belongs to. No Not a SQL Statistic
**SESSION_PROPERTIES**Displays the composed variables that can be changed by session context. No Not a SQL Statistic
**IS_VALID**Displays whether the plan is currently valid: TRUE/FALSE. No Not a SQL Statistic
**IS_EVICTED**Displays whether the plan has already been evicted: TRUE/FALSE. No Not a SQL Statistic
**LAST_INVALIDATION_REASON**Displays the last plan invalidation reason. No Not a SQL Statistic
**IS_INTERNAL**Displays whether the plan is executed from a database internal connection (TRUE) or from a remote connection (FALSE). No Not a SQL Statistic
**IS_DISTRIBUTED_EXECUTION**Displays whether the tables are located in multiple nodes: TRUE/FALSE. No Not a SQL Statistic
**COMPILATION_OPTIONS**Displays the compilation options that are used by the SQL Query Optimizer when it generates cached execution plans: XXXXXXXXXXX No Not a SQL Statistic
**IS_PINNED_PLAN**Displays whether the plan is explicitly stored by PlanViz utility: TRUE/FALSE. No Not a SQL Statistic
**PINNED_PLAN_ID**If this plan is pinned, dispalys the same value as PINNED_SQL_PLANS.ID. No Not a SQL Statistic
**ABAP_VARCHAR_MODE**Displays whether ABAP NVARCHAR mode is enabled: TRUE/FALSE. No SAP Docs
**APPLICATION_NAME**Displays the application name information. No SAP Docs
**APPLICATION_SOURCE**Displays the application source information. No SAP Docs
**ACCESSED_TABLES**Displays the relevant base table ID list accessed in the plan. No SAP Docs
**ACCESSED_TABLE_NAMES**Displays the relevant base table name list accessed in the plan. No SAP Docs
**ACCESSED_OBJECTS**Displays the relevant table object ID list accessed in the plan. No SAP Docs
**ACCESSED_OBJECT_NAMES**Displays the relevant schema object name list accessed in the plan. No SAP Docs
**TABLE_LOCATIONS**Displays the relevant table locations for the plan. No SAP Docs
**TABLE_TYPES**Displays whether the plan refers Column store only, Row store only or mixed. No SAP Docs
**PLAN_SHARING_TYPE**Displays the plan sharing type. No SAP Docs
**OWNER_CONNECTION_ID**Displays the connection owning the plan. The possible values are: XXXXXXXXX No SAP Docs
**PLAN_ID**Displays the logical plan ID, which is a non-negative value. If the plan is evicted, -1 is shown. No SAP Docs
**PLAN_MEMORY_SIZE**Displays the memory size used by the plan in bytes. Yes SAP Docs
**EVICTION_COUNT**Displays the number of evictions that have occurred for the plan. No SAP Docs
**LAST_EVICTION_TIMESTAMP**Displays the timestamp when the plan was evicted for the last time. Returns zero if the plan has never been evicted. No SAP Docs
**REFERENCE_COUNT**Displays the number of statements using the plan. Yes SAP Docs
**PARAMETER_COUNT**Displays the number of parameters to be assigned for the execution. Yes SAP Docs
**UPDATED_TABLE_OID**Displays the object ID of the table changed by the plan. No SAP Docs
**LOGICAL_CONNECTION_VOLUME_ID**Displays the volume ID of the logical connection. This value is 0 if there is no session context. No SAP Docs
**EXECUTION_COUNT**Displays the accumulated count of plan execution for valid and evicted plans. Yes SAP Docs
**EXECUTION_COUNT_BY_ROUTING**Displays the accumulated count of plan execution by client-routed connection in statement routing for valid and evicted plans. Yes SAP Docs
**TOTAL_CURSOR_DURATION**Displays the sum of time, in microseconds, that cursors were opened. This includes plan execution and communication time with clients for valid and evicted plans. Yes SAP Docs
**AVG_CURSOR_DURATION**Displays the average time, in microseconds, of the plan execution, including communication time with clients for valid and evicted plans. Yes SAP Docs
**MIN_CURSOR_DURATION**Displays the minimum time, in microseconds, of the plan execution, including communication time with clients for valid and evicted plans. Yes SAP Docs
**MAX_CURSOR_DURATION**Displays the maximum time, in microseconds, of the plan execution, including communication time with clients for valid and evicted plans. Yes SAP Docs
**TOTAL_EXECUTION_TIME**Displays the sum of time, in microseconds, of the plan execution for valid and evicted plans. Yes SAP Docs
**AVG_EXECUTION_TIME**Displays the average time of the plan execution. Yes SAP Docs
**MIN_EXECUTION_TIME**Displays the minimum time of the plan execution. Yes SAP Docs
**MAX_EXECUTION_TIME**Displays the maximum time of the plan execution. Yes SAP Docs
**TOTAL_EXECUTION_OPEN_TIME**Displays the sum of time in microseconds for cursor open for valid and evicted plans. Yes SAP Docs
**AVG_EXECUTION_OPEN_TIME**Displays the average time in microseconds for cursor open for valid and evicted plans. Yes SAP Docs
**MIN_EXECUTION_OPEN_TIME**Displays the minimum time in microseconds for cursor open for valid and evicted plans. Yes SAP Docs
**MAX_EXECUTION_OPEN_TIME**Displays the maximum time in microseconds for cursor open for valid and evicted plans. Yes SAP Docs
**TOTAL_EXECUTION_FETCH_TIME**Displays the sum of time in microseconds for cursor fetch for valid and evicted plans. Yes SAP Docs
**AVG_EXECUTION_FETCH_TIME**Displays the average time in microseconds for cursor fetch for valid and evicted plans. Yes SAP Docs
**MIN_EXECUTION_FETCH_TIME**Displays the minimum time in microseconds for cursor fetch for valid and evicted plans Yes SAP Docs
**MAX_EXECUTION_FETCH_TIME**Displays the maximum time in microseconds for cursor fetch for valid and evicted plans. Yes SAP Docs
**TOTAL_EXECUTION_CLOSE_TIME**Displays the sum of time in microseconds for cursor close for valid and evicted plans. Yes SAP Docs
**AVG_EXECUTION_CLOSE_TIME**Displays the average time in microseconds for cursor close for valid and evicted plans. Yes SAP Docs
**MIN_EXECUTION_CLOSE_TIME**Displays the minimum time in microseconds for cursor close for valid and evicted plans. Yes SAP Docs
**MAX_EXECUTION_CLOSE_TIME**Displays the maximum time in microseconds for cursor close for valid and evicted plans. Yes SAP Docs
**TOTAL_METADATA_CACHE_MISS_COUNT**Deprecated. Yes SAP Docs
**TOTAL_TABLE_LOAD_TIME_DURING_PREPARATION**Displays the sum of table loading time during plan preparation for valid and evicted plans. Yes SAP Docs
**AVG_TABLE_LOAD_TIME_DURING_PREPARATION**Displays the average table loading time in microseconds during plan preparation for valid and evicted plans. Yes SAP Docs
**MIN_TABLE_LOAD_TIME_DURING_PREPARATION**Displays the minimum table loading time during plan preparation for valid and evicted plans. Yes SAP Docs
**MAX_TABLE_LOAD_TIME_DURING_PREPARATION**Displays the maximum table loading time in microseconds during plan preparation for valid and evicted plans. Yes SAP Docs
**PREPARATION_COUNT**Displays the count of plan preparations for valid and evicted plans. Yes SAP Docs
**TOTAL_PREPARATION_TIME**Displays the sum of time in microseconds of plan preparation for valid and evicted plans. Yes SAP Docs
**AVG_PREPARATION_TIME**Displays the average time in microseconds of plan preparation for valid and evicted plans. Yes SAP Docs
**MIN_PREPARATION_TIME**Displays the minimum time in microseconds of plan preparation for valid and evicted plans. Yes SAP Docs
**MAX_PREPARATION_TIME**Displays the maximum time in microseconds of plan preparation for valid and evicted plans. Yes SAP Docs
**TOTAL_RESULT_RECORD_COUNT**Displays the accumulated number of records during plan execution for valid and evicted plans. Yes SAP Docs
**TOTAL_LOCK_WAIT_COUNT**Displays the accumulated lock wait count for the plan for valid and evicted plans. Yes SAP Docs
**TOTAL_LOCK_WAIT_DURATION**Displays the accumulated lock wait duration in microseconds for the plan for valid and evicted plans. Yes SAP Docs
**LAST_CONNECTION_ID**Displays the last connection ID that executed the plan. No SAP Docs
**LAST_EXECUTION_TIMESTAMP**Displays the timestamp when the plan was executed for the last time. No SAP Docs
**LAST_PREPARATION_TIMESTAMP**Displays the timestamp when the plan was compiled for the last time. No SAP Docs
**TOTAL_EXECUTION_MEMORY_SIZE**With memory tracking, displays the average size in bytes of tracked actual memory consumption for valid and evicted plans. Yes SAP Docs
**AVG_EXECUTION_MEMORY_SIZE**With memory tracking, displays the maximum size in bytes of tracked actual memory consumption for valid and evicted plans. Yes SAP Docs
**MIN_EXECUTION_MEMORY_SIZE**With memory tracking, displays the minimum size in bytes of tracked actual memory consumption for valid and evicted plans. Yes SAP Docs
**MAX_EXECUTION_MEMORY_SIZE**With memory tracking, displays the total size in bytes of tracked actual memory consumption for valid and evicted plans. Yes SAP Docs
**TOTAL_SERVICE_NETWORK_REQUEST_COUNT**Displays the total count of service network requests during plan execution for valid and evicted plans. Yes SAP Docs
**AVG_SERVICE_NETWORK_REQUEST_COUNT**Displays the average count of service network requests during plan execution for valid and evicted plans. Yes SAP Docs
**MAX_SERVICE_NETWORK_REQUEST_COUNT**Displays the maximum count of service network requests during plan execution for valid and evicted plans. Yes SAP Docs
**TOTAL_CALLED_THREAD_COUNT**Displays the total count of called threads used during plan execution for valid and evicted plans. Yes SAP Docs
**AVG_CALLED_THREAD_COUNT**Displays the average count of called threads used during plan execution for valid and evicted plans. Yes SAP Docs
**MAX_CALLED_THREAD_COUNT**Displays the average count of called threads used during plan execution for valid and evicted plans. Yes SAP Docs
**TOTAL_BATCH_EXECUTION_COUNT**Displays a total batch count per one execution for cached DML plans for valid and evicted plans. Yes SAP Docs
**AVG_BATCH_EXECUTION_COUNT**Displays an average batch count per one execution for cached DML plans for valid and evicted plans. Yes SAP Docs
**MIN_BATCH_EXECUTION_COUNT**Displays a minimum batch count per one execution for cached DML plans for valid and evicted plans. Yes SAP Docs
**MAX_BATCH_EXECUTION_COUNT**Displays a maximum batch count per one execution for cached DML plans for valid and evicted plans. Yes SAP Docs
**TOTAL_SERVICE_NETWORK_REQUEST_DURATION**Displays the total time of the service network requests during plan execution. Yes SAP Docs
**AVG_SERVICE_NETWORK_REQUEST_DURATION**Displays the average time of the service network requests during plan execution. Yes SAP Docs
**MAX_SERVICE_NETWORK_REQUEST_DURATION**Displays the maximum time of the service network requests during plan execution. Yes SAP Docs
**TOTAL_SERVICE_NETWORK_REQUEST_SIZE**Displays the total amount of service network requests during plan execution in bytes. Yes SAP Docs
**AVG_SERVICE_NETWORK_REQUEST_SIZE**Displays the average data amount of service network requests during plan execution in bytes. Yes SAP Docs
**MAX_SERVICE_NETWORK_REQUEST_SIZE**Displays the maximum amount of service network requests during plan execution in bytes. Yes SAP Docs
**TOTAL_EXECUTION_CPU_TIME**Displays the total amount of tracked CPU time. Yes SAP Docs
**AVG_EXECUTION_CPU_TIME**Displays the average amount of tracked CPU time. Yes SAP Docs
**MIN_EXECUTION_CPU_TIME**Displays the minimum amount of tracked CPU time. Yes SAP Docs
**MAX_EXECUTION_CPU_TIME**Displays the maximum amount of tracked CPU time. Yes SAP Docs
**TOTAL_BUFFER_CACHE_PAGE_HIT_COUNT**Displays the total number of times an NSE page was found in buffer cache memory. Yes SAP Docs
**AVG_BUFFER_CACHE_PAGE_HIT_COUNT**Displays the average number of times an NSE page was found in buffer cache memory. Yes SAP Docs
**MIN_BUFFER_CACHE_PAGE_HIT_COUNT**Displays the minimum number of times an NSE page was found in buffer cache memory. Yes SAP Docs
**MAX_BUFFER_CACHE_PAGE_HIT_COUNT**Displays the maximum number of times an NSE page was found in buffer cache memory. Yes SAP Docs
**TOTAL_BUFFER_CACHE_PAGE_MISS_COUNT**Displays the total number of times an NSE page was read from disk into the buffer cache. Yes SAP Docs
**AVG_BUFFER_CACHE_PAGE_MISS_COUNT**Displays the average number of times an NSE page was read from disk into the buffer cache. Yes SAP Docs
**MIN_BUFFER_CACHE_PAGE_MISS_COUNT**Displays the minimum number of times an NSE page was read from disk into the buffer cache. Yes SAP Docs
**MAX_BUFFER_CACHE_PAGE_MISS_COUNT**Displays the maximum number of times an NSE page was read from disk into the buffer cache. Yes SAP Docs
**TOTAL_BUFFER_CACHE_PINNED_MEMORY_SIZE**Displays the total size of pinned NSE page memory in the buffer cache in bytes. Yes SAP Docs
**AVG_BUFFER_CACHE_PINNED_MEMORY_SIZE**Displays the average size of pinned NSE page memory in the buffer cache in bytes. Yes SAP Docs
**MIN_BUFFER_CACHE_PINNED_MEMORY_SIZE**Displays the minimum size of pinned NSE page memory in the buffer cache in bytes. Yes SAP Docs
**MAX_BUFFER_CACHE_PINNED_MEMORY_SIZE**Displays the maximum size of pinned NSE page memory in the buffer cache in bytes.YesΛ™SAP Docs
**TOTAL_BUFFER_CACHE_IO_READ_SIZE**Displays the total size of NSE pages read from disk into the buffer cache. Yes SAP Docs
**AVG_BUFFER_CACHE_IO_READ_SIZE**Displays the average size of NSE pages read from disk into the buffer cache. Yes SAP Docs
**MIN_BUFFER_CACHE_IO_READ_SIZE**Displays the minimum size of NSE pages read from disk into the buffer cache. Yes SAP Docs
**MAX_BUFFER_CACHE_IO_READ_SIZE**Displays the maximum size of NSE pages read from disk into the buffer cache. Yes SAP Docs

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.