Help Center/ GaussDB/ Developer Guide(Centralized_3.x)/ System Catalogs and System Views/ System Views/ DB_TABLES
Updated on 2024-05-07 GMT+08:00
View PDF
Share

DB_TABLES

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

Table 1 DB_TABLES columns

Name

Type

Description

owner

character varying(64)

Table owner.

table_name

character varying(64)

Table name.

tablespace_name

character varying(64)

Tablespace name of the table.

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.

dropped

character varying
Specifies whether the current table is deleted.
  • YES: It is deleted.
  • NO: It is not deleted.

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.

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 changes to a table are logged.

  • 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.

  • default

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)

Not supported. Its value is NULL.

cell_flash_cache

character varying(7)

Not supported. Its value is NULL.

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.
Parent topic: System Views