Trafodion中SQL语法”get region stats”可以用于查看表或索引对应的region的详细信息， 基本语法如下，
get region stats for table <TABLE_NAME>; get region stats for index <INDEX_NAME>; get region stats for table <TABLE_NAME>,summary; get region stats for index <INDEX_NAME>,summary;这里以查看一个有16个分区的表的region信息为列，
>>get region stats for table ry_hcyxx, summary; Stats Summary ============= ObjectName: TRAFODION.DSJCS_TJ.RY_HCYXX NumRegions: 16 RegionsLocation: /hbase/data/default TotalNumStores: 32 TotalNumStoreFiles: 25 TotalUncompressedSize: 26128416768 TotalStoreFileSize: 14747172864 TotalMemStoreSize: 0 TotalReadRequestsCount: 30283164 TotalWriteRequestsCount: 0 --- SQL operation complete. >>get region stats for table ry_hcyxx; Stats Summary ============= ObjectName: TRAFODION.DSJCS_TJ.RY_HCYXX NumRegions: 16 RegionsLocation: /hbase/data/default TotalNumStores: 32 TotalNumStoreFiles: 25 TotalUncompressedSize: 26128416768 TotalStoreFileSize: 14747172864 TotalMemStoreSize: 0 TotalReadRequestsCount: 30284764 TotalWriteRequestsCount: 0 Stats Details ============= RegionServer: esg11:60020 RegionNum: 1 RegionName: TRAFODION.DSJCS_TJ.RY_HCYXX/1493169020533 NumStores: 2 NumStoreFiles: 2 UncompressedSize: 1635778560 Bytes StoreFileSize: 922746880 Bytes MemStoreSize: 0 (less than 1MB) ReadRequestsCount: 1892892 WriteRequestsCount: 0 RegionServer: esg15:60020 RegionNum: 2 RegionName: TRAFODION.DSJCS_TJ.RY_HCYXX/1493169020533 NumStores: 2 NumStoreFiles: 2 UncompressedSize: 1635778560 Bytes StoreFileSize: 923795456 Bytes MemStoreSize: 0 (less than 1MB) ReadRequestsCount: 1893185 WriteRequestsCount: 0 RegionServer: esg12:60020 RegionNum: 3 RegionName: TRAFODION.DSJCS_TJ.RY_HCYXX/1493169020533 NumStores: 2 NumStoreFiles: 1 UncompressedSize: 1630535680 Bytes StoreFileSize: 920649728 Bytes MemStoreSize: 0 (less than 1MB) ReadRequestsCount: 1893663 WriteRequestsCount: 0 RegionServer: esg14:60020 RegionNum: 4 RegionName: TRAFODION.DSJCS_TJ.RY_HCYXX/1493169020533 NumStores: 2 NumStoreFiles: 2 UncompressedSize: 1635778560 Bytes StoreFileSize: 923795456 Bytes MemStoreSize: 0 (less than 1MB) ReadRequestsCount: 1893414 WriteRequestsCount: 0 RegionServer: esg15:60020 RegionNum: 5 RegionName: TRAFODION.DSJCS_TJ.RY_HCYXX/1493169020533 NumStores: 2 NumStoreFiles: 2 UncompressedSize: 1634729984 Bytes StoreFileSize: 922746880 Bytes MemStoreSize: 0 (less than 1MB) ReadRequestsCount: 1892920 WriteRequestsCount: 0 RegionServer: esg10:60020 RegionNum: 6 RegionName: TRAFODION.DSJCS_TJ.RY_HCYXX/1493169020533 NumStores: 2 NumStoreFiles: 2 UncompressedSize: 1635778560 Bytes StoreFileSize: 923795456 Bytes MemStoreSize: 0 (less than 1MB) ReadRequestsCount: 1892451 WriteRequestsCount: 0 RegionServer: esg10:60020 RegionNum: 7 RegionName: TRAFODION.DSJCS_TJ.RY_HCYXX/1493169020533 NumStores: 2 NumStoreFiles: 2 UncompressedSize: 1634729984 Bytes StoreFileSize: 922746880 Bytes MemStoreSize: 0 (less than 1MB) ReadRequestsCount: 1891924 WriteRequestsCount: 0 RegionServer: esg13:60020 RegionNum: 8 RegionName: TRAFODION.DSJCS_TJ.RY_HCYXX/1493169020533 NumStores: 2 NumStoreFiles: 1 UncompressedSize: 1629487104 Bytes StoreFileSize: 918552576 Bytes MemStoreSize: 0 (less than 1MB) ReadRequestsCount: 1892446 WriteRequestsCount: 0 RegionServer: esg10:60020 RegionNum: 9 RegionName: TRAFODION.DSJCS_TJ.RY_HCYXX/1493169020533 NumStores: 2 NumStoreFiles: 1 UncompressedSize: 1629487104 Bytes StoreFileSize: 918552576 Bytes MemStoreSize: 0 (less than 1MB) ReadRequestsCount: 1891414 WriteRequestsCount: 0 RegionServer: esg11:60020 RegionNum: 10 RegionName: TRAFODION.DSJCS_TJ.RY_HCYXX/1493169020533 NumStores: 2 NumStoreFiles: 2 UncompressedSize: 1634729984 Bytes StoreFileSize: 922746880 Bytes MemStoreSize: 0 (less than 1MB) ReadRequestsCount: 1891931 WriteRequestsCount: 0 RegionServer: esg10:60020 RegionNum: 11 RegionName: TRAFODION.DSJCS_TJ.RY_HCYXX/1493169020533 NumStores: 2 NumStoreFiles: 1 UncompressedSize: 1629487104 Bytes StoreFileSize: 920649728 Bytes MemStoreSize: 0 (less than 1MB) ReadRequestsCount: 1892455 WriteRequestsCount: 0 RegionServer: esg14:60020 RegionNum: 12 RegionName: TRAFODION.DSJCS_TJ.RY_HCYXX/1493169020533 NumStores: 2 NumStoreFiles: 2 UncompressedSize: 1634729984 Bytes StoreFileSize: 922746880 Bytes MemStoreSize: 0 (less than 1MB) ReadRequestsCount: 1891892 WriteRequestsCount: 0 RegionServer: esg12:60020 RegionNum: 13 RegionName: TRAFODION.DSJCS_TJ.RY_HCYXX/1493169020533 NumStores: 2 NumStoreFiles: 1 UncompressedSize: 1630535680 Bytes StoreFileSize: 919601152 Bytes MemStoreSize: 0 (less than 1MB) ReadRequestsCount: 1893410 WriteRequestsCount: 0 RegionServer: esg11:60020 RegionNum: 14 RegionName: TRAFODION.DSJCS_TJ.RY_HCYXX/1493169020533 NumStores: 2 NumStoreFiles: 1 UncompressedSize: 1630535680 Bytes StoreFileSize: 920649728 Bytes MemStoreSize: 0 (less than 1MB) ReadRequestsCount: 1893666 WriteRequestsCount: 0 RegionServer: esg11:60020 RegionNum: 15 RegionName: TRAFODION.DSJCS_TJ.RY_HCYXX/1493169020533 NumStores: 2 NumStoreFiles: 2 UncompressedSize: 1635778560 Bytes StoreFileSize: 923795456 Bytes MemStoreSize: 0 (less than 1MB) ReadRequestsCount: 1893193 WriteRequestsCount: 0 RegionServer: esg13:60020 RegionNum: 16 RegionName: TRAFODION.DSJCS_TJ.RY_HCYXX/1493169020533 NumStores: 2 NumStoreFiles: 1 UncompressedSize: 1630535680 Bytes StoreFileSize: 919601152 Bytes MemStoreSize: 0 (less than 1MB) ReadRequestsCount: 1893908 WriteRequestsCount: 0 --- SQL operation complete.