Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Views/ Partitioned Table/ MY_TAB_PARTITIONS
Updated on 2025-08-19 GMT+08:00
View PDF

MY_TAB_PARTITIONS

MY_TAB_PARTITIONS displays information about level-1 table partitions accessible to the current user (including level-2 partitioned tables). Each level-1 table partition of a partitioned table accessible to the current user has one record in MY_TAB_PARTITIONS. It is accessible to all users. This view exists in both PG_CATALOG and SYS schemas. 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 MY_TAB_PARTITIONS columns

Name

Type

Description

table_owner

character varying(64)

Table owner.

table_name

character varying(64)

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 a 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 partition boundary value expression.

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 a 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 table partition has segments 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.
Parent topic: Partitioned Table