Updated on 2024-06-03 GMT+08:00

ADM_TAB_STATISTICS

ADM_TAB_STATISTICS displays optimizer statistics for all tables in the database. This view exists in the PG_CATALOG and SYS schemas. 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. Set it to NULL.

partition_position

numeric

Not supported. Set it to NULL.

subpartition_name

character varying(128)

Not supported. Set it to NULL.

subpartition_position

numeric

Not supported. Set it to NULL.

object_type

character varying(12)

Object type.
  • TABLE
  • PARTITION
  • SUBPARTITION

num_rows

numeric

Number of rows in an object.

blocks

numeric

Not supported. Set it to NULL.

empty_blocks

numeric

Not supported. Set it to NULL.

avg_space

numeric

Not supported. Set it to NULL.

chain_cnt

numeric

Not supported. Set it to NULL.

avg_row_len

integer

Average row length, including the row overhead.

avg_space_freelist_blocks

numeric

Not supported. Set it to NULL.

num_freelist_blocks

numeric

Not supported. Set it to NULL.

avg_cached_blocks

numeric

Not supported. Set it to NULL.

avg_cache_hit_ratio

numeric

Not supported. Set it to NULL.

im_imcu_count

numeric

Not supported. Set it to NULL.

im_block_count

numeric

Not supported. Set it to NULL.

im_stat_update_time

timestamp(6) without time zone

Not supported. Set it to NULL.

scan_rate

numeric

Not supported. Set it to 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. Set it to NULL.

user_stats

character varying(3)

Not supported. Set it to NULL.

stattype_locked

character varying(5)

Not supported. Set it to NULL.

stale_stats

character varying(7)

Not supported. Set it to NULL.

notes

character varying(25)

Not supported. Set it to NULL.

scope

character varying(7)

Not supported. Set it to SHARED.