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

MY_TABLES

MY_TABLES displays information about the tables owned by the current user. This view exists in both PG_CATALOG and SYS schema.

Table 1 MY_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.

dropped

character varying

Specifies whether the current record 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 record is valid.
  • valid: valid.

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.

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.

compression

character varying(8)

Specifies whether to enable a table compression.

duration

character varying(15)

Time elapsed when a temporary table is processed.

logical_replication

character varying(8)

Specifies whether logical replication is enabled for a table.

external

character varying(3)

Specifies whether the table is an external table.

logging

character varying(3)

Specifies whether changes to a table are logged.

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.

nested

character varying(3)

Specifies whether a table is 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.

has_identity

character varying(3)

Specifies whether a table has an identifier column.

segment_created

character varying(3)

Specifies whether a table segment has been created.

monitoring

character varying(3)

Specifies whether to monitor the modification of a table.

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.