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.

**Table 1** MY_TAB_MODIFICATIONS columns
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	timestamp(0) without time zone	Last modification time. Currently, the modification time of a partitioned table is not supported. The value is NULL.
truncated	character varying(3)	Not supported. The value is NULL.
drop_segments	numeric	Not supported. The value is NULL.
schema_name	character varying(128)	Name of the schema to which the table belongs.