SUMMARY_STATIO_ALL_TABLES
SUMMARY_STATIO_ALL_TABLES视图将包含openGauss内汇聚的数据库中每个表(包括TOAST表)的I/O的统计。
示例:
openGauss=# select * from DBE_PERF.SUMMARY_STATIO_ALL_TABLES;
schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit
--------------------+-------------------------------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+---------------
表 1 SUMMARY_STATIO_ALL_TABLES字段
意见反馈