ADM_TAB_STATISTICS

ADM_TAB_STATISTICS displays optimizer statistics for all tables in the database. This view exists in both PG_CATALOG and SYS schema. By default, only the system administrator can access this view. Common users can access the view only after being authorized.

**Table 1** ADM_TAB_STATISTICS columns
Name	Type	Description
owner	character varying(128)	Object owner.
table_name	character varying(128)	Table name.
partition_name	character varying(128)	Not supported. Its value is NULL.
partition_position	numeric	Not supported. Its value is NULL.
subpartition_name	character varying(128)	Not supported. Its value is NULL.
subpartition_position	numeric	Not supported. Its value is NULL.
object_type	character varying(12)	Object type. TABLE PARTITION SUBPARTITION
num_rows	numeric	Number of rows in an object.
blocks	numeric	Not supported. Its value is NULL.
empty_blocks	numeric	Not supported. Its value is NULL.
avg_space	numeric	Not supported. Its value is NULL.
chain_cnt	numeric	Not supported. Its value is NULL.
avg_row_len	numeric	Average row length, including the row overhead.
avg_space_freelist_blocks	numeric	Not supported. Its value is NULL.
num_freelist_blocks	numeric	Not supported. Its value is NULL.
avg_cached_blocks	numeric	Not supported. Its value is NULL.
avg_cache_hit_ratio	numeric	Not supported. Its value is NULL.
im_imcu_count	numeric	Not supported. Its value is NULL.
im_block_count	numeric	Not supported. Its value is NULL.
im_stat_update_time	timestamp(9) without time zone	Not supported. Its value is NULL.
scan_rate	numeric	Not supported. Its value is NULL.
sample_size	numeric	Number of samples used for analyzing a table.
last_analyzed	timestamp with time zone	Date when a table was last analyzed. Database restart is not supported. Otherwise, data loss will occur.
global_stats	character varying(3)	Not supported. Its value is NULL.
user_stats	character varying(3)	Not supported. Its value is NULL.
stattype_locked	character varying(5)	Not supported. Its value is NULL.
stale_stats	character varying(7)	Not supported. Its value is NULL.
notes	character varying(25)	Not supported. Its value is NULL.
scope	character varying(7)	Not supported. The default value is SHARED.