[ https://issues.apache.org/jira/browse/IGNITE-10688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yury Gerzhedovich updated IGNITE-10688: --------------------------------------- Description: As of now no such way to get IO statistics through SQL. Need to expose system SQL views to be able view statistics for cache group caches. CACHE_GROUPS_IO {quote}group_id - Cache group id group_name - Name of cache group physical_read - Number of physical read of pages logical_read - Number of logical read of pages {quote} was: As of now no such way to get IO statistics through SQL. Need to expose two system SQL views to be able view statistics for indexes and cache group caches. 1) STATIO_CACHE_GRP {quote}cache_grp_name - Name of cache group physical_read - Number of physical read of pages logical_read - Number of logical read of pages{quote} 2) STATIO_IDX {quote}cache_grp_name - Name of cache group{quote} {quote}idx_name - Name of index physical_read - Common number of physical reads of pages for the index logical_read - Common number of logical reads of pages for the index{quote} {quote}leaf_logical_read - Number of logical reads of index leaf pages{quote} {quote}leaf_physical_read - Number of physical reads of index leaf pages{quote} {quote}inner_logical_read - Number of logical reads of index inner pages{quote} {quote}inner_physical_read - Number of physical reads of index leaf pages{quote} > Expose SQL views for IO statistics > ---------------------------------- > > Key: IGNITE-10688 > URL: https://issues.apache.org/jira/browse/IGNITE-10688 > Project: Ignite > Issue Type: Task > Components: persistence, sql > Reporter: Yury Gerzhedovich > Assignee: Yury Gerzhedovich > Priority: Major > Labels: iep-27 > Fix For: 2.8 > > Time Spent: 10m > Remaining Estimate: 0h > > As of now no such way to get IO statistics through SQL. > Need to expose system SQL views to be able view statistics for cache group > caches. > > CACHE_GROUPS_IO > {quote}group_id - Cache group id > group_name - Name of cache group > physical_read - Number of physical read of pages > logical_read - Number of logical read of pages > {quote} > -- This message was sent by Atlassian JIRA (v7.6.3#76005)