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

DB_TAB_PARTITIONS

DB_TAB_PARTITIONS displays information about level-1 partitions (including level-2 partitioned tables) accessible to the current user. It is accessible to all users. This view exists in both PG_CATALOG and SYS schema. The distributed system does not support level-2 partitions. Therefore, this view does not store level-1 partition information of level-2 partitioned tables.

Table 1 DB_TAB_PARTITIONS columns

Name

Type

Description

table_owner

character varying(64)

Table owner.

table_name

character varying(64)

Relational table name.

partition_name

character varying(64)

Partition name.

high_value

text

Limit of a partition.
  • For range partitioning and interval partitioning, the upper limit of each partition is displayed.
  • For list partitioning, the value list of each partition is displayed.
  • For hash partitioning, the number of each partition is displayed.

tablespace_name

name

Tablespace name of the partitioned table.

schema

character varying(64)

Name of a namespace.

composite

character varying(3)

Specifies whether the table is a level-2 partitioned table.

subpartition_count

numeric

Not supported. Its value is NULL.

high_value_length

integer

Length of the binding value expression in a partition.

partition_position

numeric

Position of the partition in the table.

pct_free

numeric

Minimum percentage of available space in a block.

pct_used

numeric

Not supported. Its value is NULL.

ini_trans

numeric

Initial number of transactions. The default value is 4. The value is NULL for non-Ustore partitioned tables.

max_trans

numeric

Maximum number of transactions. The default value is 128. The value is NULL for non-Ustore partitioned tables.

initial_extent

numeric

Not supported. Its value is NULL.

next_extent

numeric

Not supported. Its value is NULL.

min_extent

numeric

Not supported. Its value is NULL.

max_extent

numeric

Not supported. Its value is NULL.

max_size

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.

logging

character varying(7)

Specifies whether changes to the table are logged.

compression

character varying(8)

Actual compression attribute of a partitioned table.

compress_for

character varying(30)

Not supported. Its value is NULL.

num_rows

numeric

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_row_len

numeric

Not supported. Its value is NULL.

sample_size

numeric

Not supported. Its value is NULL.

last_analyzed

timestamp with time zone

Last date when the partition was analyzed.

buffer_pool

character varying(7)

Buffer pool allocated to a partitioned block.

flash_cache

character varying(7)

Not supported. Its value is NULL.

cell_flash_cache

character varying(7)

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.

is_nested

character varying(3)

Specifies whether this partitioned table is a nested partitioned table.

parent_table_partition

character varying(128)

Not supported. Its value is NULL.

interval

character varying(3)

Specifies whether the partition is a partition in an interval partitioned table. The distributed system does not support interval partitioning. Therefore, the value of this parameter is NO.

segment_created

character varying(4)

Specifies whether a partitioned table has segments created or has not been created.

indexing

character varying(4)

Not supported. Its value is NULL.

read_only

character varying(4)

Not supported. Its value is NULL.

inmemory

character varying(8)

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.

cellmemory

character varying(24)

Not supported. Its value is NULL.

inmemory_service

character varying(12)

Not supported. Its value is NULL.

inmemory_service_name

character varying(100)

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.