GaussDB-MY_TAB_STATISTICS
MY_TAB_STATISTICS displays statistics about tables owned by the current user in the database. This view exists in the PG_CATALOG and SYS schemas and all users can access this view.
| Name | Type | Description |
|---|---|---|
| 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. The default value is SHARED. |
更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…
