# 系统读写热点查询 (B)

+ 统计当前读写热点 STORE:
```
SELECT p.store_id,
       sum(FLOW_BYTES), 
       count(1) 
FROM TIDB_HOT_REGIONS h
JOIN tikv_region_peers p ON h.region_id = p.region_id
AND p.IS_LEADER=1
GROUP BY p.store_id
ORDER BY 2 DESC;
```
-------------------------------------------------------------
统计当前读写热点 STORE
```
SELECT p.store_id,
       sum(FLOW_BYTES), -- sotre 总流量
       count(1) -- region 数量
FROM TIDB_HOT_REGIONS h
JOIN tikv_region_peers p ON h.region_id = p.region_id
AND p.IS_LEADER=1
GROUP BY p.store_id
ORDER BY 2 DESC;
+----------+-----------------+----------+
| store_id | sum(FLOW_BYTES) | count(1) |
+----------+-----------------+----------+
| 61800009 |         2240622 |       33 |
| 37548527 |         2220168 |       26 |
|        1 |         1877412 |       31 |
|       15 |         1862802 |       26 |
|        6 |         1209432 |       47 |
|       16 |          828690 |       39 |
|        4 |          814080 |       34 |
|       11 |          468402 |       38 |
| 37548526 |          453792 |       33 |
| 61798959 |          154866 |       53 |
|        9 |          134412 |       46 |
+—————+-----------------+----------+
```