SUMMARY_STAT_XACT_SYS_TABLES
SUMMARY_STAT_XACT_SYS_TABLES displays transaction status information about the system catalogs in namespaces in openGauss.
Table 1 SUMMARY_STAT_XACT_SYS_TABLES columns
| Name | Type | Description | 
|---|
| schemaname | name | Name of the schema that contains the table | 
| relname | name | Table name | 
| seq_scan | numeric | Number of sequential scans initiated on this table | 
| seq_tup_read | numeric | Number of live rows fetched by sequential scans | 
| idx_scan | numeric | Number of index scans initiated on the table | 
| idx_tup_fetch | numeric | Number of live rows fetched by index scans | 
| n_tup_ins | numeric | Number of rows inserted | 
| n_tup_upd | numeric | Number of rows updated | 
| n_tup_del | numeric | Number of rows deleted | 
| n_tup_hot_upd | numeric | Number of rows HOT updated (with no separate index update required) | 
openGauss 2025-10-31 07:42:18