PG_STAT_XACT_ALL_TABLES
PG_STAT_XACT_ALL_TABLES视图显示命名空间中所有普通表和toast表的事务状态信息。
示例:
openGauss=# select * from PG_STAT_XACT_ALL_TABLES;
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
-------+--------------------+-------------------------------+----------+--------------+----------+---------------+-----------+-----------+-----------+---------------
表 1 PG_STAT_XACT_ALL_TABLES字段
意见反馈