Updated on 2024-05-07 GMT+08:00

MY_TAB_STATISTICS

MY_TAB_STATISTICS displays statistics about tables owned by the current user in the database. This view exists in both PG_CATALOG and SYS schema and all users can access this view.

Table 1 MY_TAB_STATISTICS columns

Name

Type

Description

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.