GaussDB-MY_TAB_MODIFICATIONS
MY_TAB_MODIFICATIONS displays statistics about modifications to tables owned by the current user since the last statistics collection on the tables. Currently, this view displays only tables on which INSERT, DELETE, and UPDATE operations have been performed. All users can access this view. This view exists in the PG_CATALOG and SYS schemas.
| Name | Type | Description |
|---|---|---|
| table_name | character varying(128) | Table name. |
| partition_name | character varying(128) | Partition name. |
| subpartition_name | character varying(128) | Subpartition name. |
| inserts | numeric | Approximate number of insertions since the last statistics collection. |
| updates | numeric | Approximate number of updates since the last statistics collection. |
| deletes | numeric | Approximate number of deletions since the last statistics collection. |
| timestamp | date | Last modification time.Currently, the modification time of a partitioned table is not supported. Set this parameter to NULL. |
| truncated | character varying(3) | Not supported. Set it to NULL. |
| drop_segments | numeric | Not supported. Set it to NULL. |
| schema_name | character varying(128) | Name of the schema to which the table belongs. |
更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…
