Help Center/ GaussDB/ Distributed_3.x/ System Catalogs and System Views/ System Views/ MY_TAB_STATS_HISTORY
Updated on 2024-05-07 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 PG_CATALOG and SYS schema.

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