GLOBAL_STAT_ALL_TABLES
得到各节点数据中每个表的一行(包括TOAST表)的统计信息。
openGauss=# select * from DBE_PERF.GLOBAL_STAT_ALL_TABLES;
node_name | relid | schemaname | relname | seq_scan | seq_tup_read | idx_scan | idx_tup_fetch | n_tup_ins | n_tup_upd | n_tup_del | n_tup_hot_upd | n_live_tup | n_dead_tup | last_vacuum | last_autovacuum | last_analyze | last_autoanalyze | vacuum_count | autovacuum_count | analyze_count | autoanalyze_count
-----------+-------+--------------------+-------------------------------+----------+--------------+----------+---------------+-----------+-----------+-----------+---------------+------------+------------+-------------+-----------------+--------------+------------------+--------------+------------------+---------------+-------------------
表 1 GLOBAL_STAT_ALL_TABLES字段
意见反馈