Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-3.x)/ System Catalogs and System Views/ System Views/ MY_TAB_STATS_HISTORY
Updated on 2025-08-19 GMT+08:00
View PDF

MY_TAB_STATS_HISTORY

MY_TAB_STATS_HISTORY provides the table statistics history of the tables owned by the current user. All users can access this view. This view exists in both the PG_CATALOG and SYS schemas.

Table 1 MY_TAB_STATS_HISTORY columns

Name

Type

Description

table_name

character varying(128)

Table name.

partition_name

character varying(128)

Not supported. Its value is NULL.

subpartition_name

character varying(128)

Not supported. Its value is NULL.

stats_update_time

timestamp(6) with time zone

Time when statistics are updated. Database restart is not supported. Otherwise, data loss will occur.
Parent topic: System Views