[ https://issues.apache.org/jira/browse/IGNITE-10688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16748741#comment-16748741 ]
Yury Gerzhedovich commented on IGNITE-10688: -------------------------------------------- [~vozerov], # Yes, 'statio' prefix used by postgres. But I've changed name of the view to suggested by you CACHE_GROUPS_IO. # Rename CACHE_GRP_NAME column to GROUP_NAME and add new GROUP_ID. # Yes, it is so. Added corresponded test. # Ok, removed view for indexes. If I right understood your note, you mean GROUP_ID name for column instead of GROUP_NAME. > 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 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} > -- This message was sent by Atlassian JIRA (v7.6.3#76005)