SAP HANA SQL Statistics
| SQL statistic name | Description | DBmarlin collects? | Doc Link |
|---|---|---|---|
DURATION | Derived Field = TOTAL_CURSOR_DURATION / 1000 | Yes - Derived | N/A |
EXECUTIONS | Derived Field = EXECUTION_COUNT | Yes - Derived | N/A |
CPU_TIME_MILLISECONDS | Derived Field = TOTAL_EXECUTION_CPU_TIME / 1000 | Yes - Derived | N/A |
PHYSICAL_READS | Derived Field = TOTAL_BUFFER_CACHE_PAGE_MISS_COUNT | Yes - Derived | N/A |
LOGICAL_READS | Derived Field = TOTAL_BUFFER_CACHE_PAGE_MISS_COUNT + TOTAL_BUFFER_CACHE_PAGE_HIT_COUNT | Yes - Derived | N/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 | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
APPLICATION_NAME | Displays the application name information. | No | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
APPLICATION_SOURCE | Displays the application source information. | No | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
ACCESSED_TABLES | Displays the relevant base table ID list accessed in the plan. | No | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
ACCESSED_TABLE_NAMES | Displays the relevant base table name list accessed in the plan. | No | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
ACCESSED_OBJECTS | Displays the relevant table object ID list accessed in the plan. | No | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
ACCESSED_OBJECT_NAMES | Displays the relevant schema object name list accessed in the plan. | No | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TABLE_LOCATIONS | Displays the relevant table locations for the plan. | No | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TABLE_TYPES | Displays whether the plan refers Column store only, Row store only or mixed. | No | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
PLAN_SHARING_TYPE | Displays the plan sharing type. | No | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
OWNER_CONNECTION_ID | Displays the connection owning the plan. The possible values are: XXXXXXXXX | No | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
PLAN_ID | Displays the logical plan ID, which is a non-negative value. If the plan is evicted, -1 is shown. | No | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
PLAN_MEMORY_SIZE | Displays the memory size used by the plan in bytes. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
EVICTION_COUNT | Displays the number of evictions that have occurred for the plan. | No | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
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 | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
REFERENCE_COUNT | Displays the number of statements using the plan. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
PARAMETER_COUNT | Displays the number of parameters to be assigned for the execution. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
UPDATED_TABLE_OID | Displays the object ID of the table changed by the plan. | No | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
LOGICAL_CONNECTION_VOLUME_ID | Displays the volume ID of the logical connection. This value is 0 if there is no session context. | No | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
EXECUTION_COUNT | Displays the accumulated count of plan execution for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
EXECUTION_COUNT_BY_ROUTING | Displays the accumulated count of plan execution by client-routed connection in statement routing for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
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 | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
AVG_CURSOR_DURATION | Displays the average time, in microseconds, of the plan execution, including communication time with clients for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MIN_CURSOR_DURATION | Displays the minimum time, in microseconds, of the plan execution, including communication time with clients for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MAX_CURSOR_DURATION | Displays the maximum time, in microseconds, of the plan execution, including communication time with clients for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_EXECUTION_TIME | Displays the sum of time, in microseconds, of the plan execution for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
AVG_EXECUTION_TIME | Displays the average time of the plan execution. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MIN_EXECUTION_TIME | Displays the minimum time of the plan execution. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MAX_EXECUTION_TIME | Displays the maximum time of the plan execution. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_EXECUTION_OPEN_TIME | Displays the sum of time in microseconds for cursor open for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
AVG_EXECUTION_OPEN_TIME | Displays the average time in microseconds for cursor open for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MIN_EXECUTION_OPEN_TIME | Displays the minimum time in microseconds for cursor open for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MAX_EXECUTION_OPEN_TIME | Displays the maximum time in microseconds for cursor open for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_EXECUTION_FETCH_TIME | Displays the sum of time in microseconds for cursor fetch for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
AVG_EXECUTION_FETCH_TIME | Displays the average time in microseconds for cursor fetch for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MIN_EXECUTION_FETCH_TIME | Displays the minimum time in microseconds for cursor fetch for valid and evicted plans | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MAX_EXECUTION_FETCH_TIME | Displays the maximum time in microseconds for cursor fetch for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_EXECUTION_CLOSE_TIME | Displays the sum of time in microseconds for cursor close for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
AVG_EXECUTION_CLOSE_TIME | Displays the average time in microseconds for cursor close for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MIN_EXECUTION_CLOSE_TIME | Displays the minimum time in microseconds for cursor close for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MAX_EXECUTION_CLOSE_TIME | Displays the maximum time in microseconds for cursor close for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_METADATA_CACHE_MISS_COUNT | Deprecated. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_TABLE_LOAD_TIME_DURING_PREPARATION | Displays the sum of table loading time during plan preparation for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
AVG_TABLE_LOAD_TIME_DURING_PREPARATION | Displays the average table loading time in microseconds during plan preparation for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MIN_TABLE_LOAD_TIME_DURING_PREPARATION | Displays the minimum table loading time during plan preparation for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MAX_TABLE_LOAD_TIME_DURING_PREPARATION | Displays the maximum table loading time in microseconds during plan preparation for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
PREPARATION_COUNT | Displays the count of plan preparations for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_PREPARATION_TIME | Displays the sum of time in microseconds of plan preparation for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
AVG_PREPARATION_TIME | Displays the average time in microseconds of plan preparation for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MIN_PREPARATION_TIME | Displays the minimum time in microseconds of plan preparation for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MAX_PREPARATION_TIME | Displays the maximum time in microseconds of plan preparation for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_RESULT_RECORD_COUNT | Displays the accumulated number of records during plan execution for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_LOCK_WAIT_COUNT | Displays the accumulated lock wait count for the plan for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_LOCK_WAIT_DURATION | Displays the accumulated lock wait duration in microseconds for the plan for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
LAST_CONNECTION_ID | Displays the last connection ID that executed the plan. | No | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
LAST_EXECUTION_TIMESTAMP | Displays the timestamp when the plan was executed for the last time. | No | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
LAST_PREPARATION_TIMESTAMP | Displays the timestamp when the plan was compiled for the last time. | No | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_EXECUTION_MEMORY_SIZE | With memory tracking, displays the average size in bytes of tracked actual memory consumption for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
AVG_EXECUTION_MEMORY_SIZE | With memory tracking, displays the maximum size in bytes of tracked actual memory consumption for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MIN_EXECUTION_MEMORY_SIZE | With memory tracking, displays the minimum size in bytes of tracked actual memory consumption for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MAX_EXECUTION_MEMORY_SIZE | With memory tracking, displays the total size in bytes of tracked actual memory consumption for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_SERVICE_NETWORK_REQUEST_COUNT | Displays the total count of service network requests during plan execution for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
AVG_SERVICE_NETWORK_REQUEST_COUNT | Displays the average count of service network requests during plan execution for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MAX_SERVICE_NETWORK_REQUEST_COUNT | Displays the maximum count of service network requests during plan execution for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_CALLED_THREAD_COUNT | Displays the total count of called threads used during plan execution for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
AVG_CALLED_THREAD_COUNT | Displays the average count of called threads used during plan execution for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MAX_CALLED_THREAD_COUNT | Displays the average count of called threads used during plan execution for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_BATCH_EXECUTION_COUNT | Displays a total batch count per one execution for cached DML plans for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
AVG_BATCH_EXECUTION_COUNT | Displays an average batch count per one execution for cached DML plans for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MIN_BATCH_EXECUTION_COUNT | Displays a minimum batch count per one execution for cached DML plans for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MAX_BATCH_EXECUTION_COUNT | Displays a maximum batch count per one execution for cached DML plans for valid and evicted plans. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_SERVICE_NETWORK_REQUEST_DURATION | Displays the total time of the service network requests during plan execution. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
AVG_SERVICE_NETWORK_REQUEST_DURATION | Displays the average time of the service network requests during plan execution. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MAX_SERVICE_NETWORK_REQUEST_DURATION | Displays the maximum time of the service network requests during plan execution. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_SERVICE_NETWORK_REQUEST_SIZE | Displays the total amount of service network requests during plan execution in bytes. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
AVG_SERVICE_NETWORK_REQUEST_SIZE | Displays the average data amount of service network requests during plan execution in bytes. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MAX_SERVICE_NETWORK_REQUEST_SIZE | Displays the maximum amount of service network requests during plan execution in bytes. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_EXECUTION_CPU_TIME | Displays the total amount of tracked CPU time. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
AVG_EXECUTION_CPU_TIME | Displays the average amount of tracked CPU time. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MIN_EXECUTION_CPU_TIME | Displays the minimum amount of tracked CPU time. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MAX_EXECUTION_CPU_TIME | Displays the maximum amount of tracked CPU time. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_BUFFER_CACHE_PAGE_HIT_COUNT | Displays the total number of times an NSE page was found in buffer cache memory. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
AVG_BUFFER_CACHE_PAGE_HIT_COUNT | Displays the average number of times an NSE page was found in buffer cache memory. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MIN_BUFFER_CACHE_PAGE_HIT_COUNT | Displays the minimum number of times an NSE page was found in buffer cache memory. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MAX_BUFFER_CACHE_PAGE_HIT_COUNT | Displays the maximum number of times an NSE page was found in buffer cache memory. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_BUFFER_CACHE_PAGE_MISS_COUNT | Displays the total number of times an NSE page was read from disk into the buffer cache. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
AVG_BUFFER_CACHE_PAGE_MISS_COUNT | Displays the average number of times an NSE page was read from disk into the buffer cache. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MIN_BUFFER_CACHE_PAGE_MISS_COUNT | Displays the minimum number of times an NSE page was read from disk into the buffer cache. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MAX_BUFFER_CACHE_PAGE_MISS_COUNT | Displays the maximum number of times an NSE page was read from disk into the buffer cache. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_BUFFER_CACHE_PINNED_MEMORY_SIZE | Displays the total size of pinned NSE page memory in the buffer cache in bytes. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
AVG_BUFFER_CACHE_PINNED_MEMORY_SIZE | Displays the average size of pinned NSE page memory in the buffer cache in bytes. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MIN_BUFFER_CACHE_PINNED_MEMORY_SIZE | Displays the minimum size of pinned NSE page memory in the buffer cache in bytes. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MAX_BUFFER_CACHE_PINNED_MEMORY_SIZE | Displays the maximum size of pinned NSE page memory in the buffer cache in bytes. | YesΛ | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
TOTAL_BUFFER_CACHE_IO_READ_SIZE | Displays the total size of NSE pages read from disk into the buffer cache. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
AVG_BUFFER_CACHE_IO_READ_SIZE | Displays the average size of NSE pages read from disk into the buffer cache. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MIN_BUFFER_CACHE_IO_READ_SIZE | Displays the minimum size of NSE pages read from disk into the buffer cache. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
MAX_BUFFER_CACHE_IO_READ_SIZE | Displays the maximum size of NSE pages read from disk into the buffer cache. | Yes | https://help.sap.com/docs/hana-cloud-database/sap-hana-cloud-sap-hana-database-sql-reference-guide/m-sql-plan-statistics-system-view |
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.