GaussDB-DB_TABLES

jerrywang1983
15 阅读4分钟

GaussDB-DB_TABLES

DB_TABLES displays all tables accessible to the current user. This view exists in the PG_CATALOG and SYS schemas.

NameTypeDescription
ownercharacter varying(64)Table owner.
table_namecharacter varying(64)Table name.
tablespace_namecharacter varying(64)Tablespace name of the table.
droppedcharacter varyingSpecifies whether the current table is deleted.- YES: deleted.
  • NO: not deleted. | | num_rows | numeric | Estimated number of rows in the table. | | status | character varying(8) | Specifies whether the current table is valid.- VALID: The current table is valid.
  • UNUSABLE: The current table is unavailable. | | sample_size | numeric | Number of samples used for analyzing the table. | | temporary | character(1) | Specifies whether the table is a temporary table.- Y: The table is a temporary table.
  • N: The table is not a temporary table. | | pct_free | numeric | Minimum percentage of free space in a block. | | ini_trans | numeric | Initial number of transactions. | | max_trans | numeric | Maximum number of transactions. | | avg_row_len | integer | Average number of bytes in each row. | | partitioned | character varying(3) | Specifies whether a table is a partitioned table.- YES: The table is a partitioned table.
  • NO: The table is not a partitioned table. | | last_analyzed | timestamp with time zone | Last time when the table was analyzed. Database restart is not supported. Otherwise, data loss will occur. | | row_movement | character varying(8) | Specifies whether to allow partition row movement.- ENABLED: The partition row movement is allowed.
  • DISABLED: The partition row movement is not allowed. | | compression | character varying(8) | Specifies whether to enable a table compression.- ENABLED: A table compression is enabled.
  • DISABLED: A table compression is disabled. | | duration | character varying(15) | Time elapsed when a temporary table is processed.- NULL: The table is not a temporary table.
  • sys$session: The table is a temporary session table.
  • sys$transaction: The table is a temporary transaction table. | | logical_replication | character varying(8) | Specifies whether logical replication is enabled for a table.- ENABLED: Logical replication is enabled.
  • DISABLED: Logical replication is disabled. | | external | character varying(3) | Specifies whether the table is an external table.- YES: The table is an external table.
  • NO: The table is not an external table. | | logging | character varying(3) | Specifies whether to record logs for table changes.- YES: Logs are recorded for table changes.
  • NO: Logs are not recorded for table changes. | | default_collation | character varying(100) | Default collation of a table. | | degree | character varying(10) | Number of instances in a scanned table. | | table_lock | character varying(8) | Specifies whether to enable a table lock.- ENABLED: The table lock is enabled.
  • DISABLED: The table lock is disabled. | | nested | character varying(3) | Specifies whether a table is a nested table.- YES: The table is a nested table.
  • NO: The table is not a nested table. | | buffer_pool | character varying(7) | Default buffer pool of a table. | | flash_cache | character varying(7) | Smart flash cache hint in database for a table block. | | cell_flash_cache | character varying(7) | Cell flash cache hint for a table block. | | skip_corrupt | character varying(8) | Specifies whether to skip corrupted blocks during table scanning.- ENABLED: The corrupted block is skipped.
  • DISABLED: The corrupted block is not skipped. | | has_identity | character varying(3) | Specifies whether a table has an identifier column.- YES: There is an identifier column.
  • NO: There is no identifier column. | | segment_created | character varying(3) | Specifies whether a table segment has been created.- YES: The table segment has been created.
  • NO: The table segment is not created. | | monitoring | character varying(3) | Specifies whether to monitor the modification of a table.- YES: The modification of the table is monitored.
  • NO: The modification of the table is not monitored. | | cluster_name | character varying(128) | Not supported. Its value is NULL. | | iot_name | character varying(128) | Not supported. Its value is NULL. | | pct_used | numeric | Not supported. Its value is NULL. | | initial_extent | numeric | Not supported. Its value is NULL. | | next_extent | numeric | Not supported. Its value is NULL. | | min_extents | numeric | Not supported. Its value is NULL. | | max_extents | numeric | Not supported. Its value is NULL. | | pct_increase | numeric | Not supported. Its value is NULL. | | freelists | numeric | Not supported. Its value is NULL. | | freelist_groups | numeric | Not supported. Its value is NULL. | | backed_up | character varying(1) | Not supported. Its value is NULL. | | 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_space_freelist_blocks | numeric | Not supported. Its value is NULL. | | num_freelist_blocks | numeric | Not supported. Its value is NULL. | | instances | character varying(10) | Not supported. Its value is NULL. | | cache | character varying(5) | Not supported. Its value is NULL. | | iot_type | character varying(12) | Not supported. Its value is NULL. | | secondary | character varying(1) | Not supported. Its value is NULL. | | global_stats | character varying(3) | Not supported. Its value is NULL. | | user_stats | character varying(3) | Not supported. Its value is NULL. | | cluster_owner | character varying(30) | Not supported. Its value is NULL. | | dependencies | character varying(8) | Not supported. Its value is NULL. | | compression_for | character varying(30) | Not supported. Its value is NULL. | | read_only | character varying(3) | Not supported. Its value is NULL. | | result_cache | character varying(7) | Not supported. Its value is NULL. | | clustering | character varying(3) | Not supported. Its value is NULL. | | activity_tracking | character varying(23) | Not supported. Its value is NULL. | | dml_timestamp | character varying(25) | Not supported. Its value is NULL. | | container_data | character varying(3) | Not supported. Its value is NULL. | | inmemory_priority | character varying(8) | Not supported. Its value is NULL. | | inmemory_distribute | character varying(15) | Not supported. Its value is NULL. | | inmemory_compression | character varying(17) | Not supported. Its value is NULL. | | inmemory_duplicate | character varying(13) | Not supported. Its value is NULL. | | duplicated | character varying(1) | Not supported. Its value is NULL. | | sharded | character varying(1) | Not supported. Its value is NULL. | | hybrid | character varying(3) | Not supported. Its value is NULL. | | cellmemory | character varying(24) | Not supported. Its value is NULL. | | containers_default | character varying(3) | Not supported. Its value is NULL. | | container_map | character varying(3) | Not supported. Its value is NULL. | | extended_data_link | character varying(3) | Not supported. Its value is NULL. | | extended_data_link_map | character varying(3) | Not supported. Its value is NULL. | | inmemory_service | character varying(12) | Not supported. Its value is NULL. | | inmemory_service_name | character varying(1000) | Not supported. Its value is NULL. | | container_map_object | character varying(3) | Not supported. Its value is NULL. | | memoptimize_read | character varying(8) | Not supported. Its value is NULL. | | memoptimize_write | character varying(8) | Not supported. Its value is NULL. | | has_sensitive_column | character varying(3) | Not supported. Its value is NULL. | | admit_null | character varying(3) | Not supported. Its value is NULL. | | data_link_dml_enabled | character varying(3) | Not supported. Its value is NULL. | | object_id_type | character varying(16) | Not supported. Its value is NULL. | | table_type_owner | character varying(128) | Not supported. Its value is NULL. | | table_type | character varying(128) | Not supported. Its value is NULL. | | compress_for | character varying(30) | Not supported. Its value is NULL. |

更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…

avatar
文章
阅读
粉丝