如何在OceanBase中查看租户的IOPS使用情况？

[没落的星辰]

如何在OceanBase中查看租户的IOPS使用情况？有没有直观的方法，或者好点的命令。

[Sunshining]

是不是有个视图是GV$OB_SERVERS，这个视图好像有IOPS

[Sunshining]

要不就是GV$OB_TENANTS

[目标OBCP]

AI给的命令：
– 查看所有租户的实时 IOPS 统计
SELECT
tenant_id,
SUM(io_read_count) AS total_read_iops,
SUM(io_write_count) AS total_write_iops,
SUM(io_read_size) / 1024 / 1024 AS read_throughput_mb,
SUM(io_write_size) / 1024 / 1024 AS write_throughput_mb
FROM
__all_virtual_io_quota
GROUP BY
tenant_id
ORDER BY
total_read_iops + total_write_iops DESC;

[AntTech_NUHWAW]

@一下助手