Help Center> GaussDB> Distributed_8.x> System Catalogs and System Views> System Views> Partitioned Table> ADM_TAB_PARTITIONS
Updated on 2024-06-03 GMT+08:00
View PDF

ADM_TAB_PARTITIONS

ADM_TAB_PARTITIONS displays information about level-1 partitions (including level-2 partitioned tables) in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. 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 ADM_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 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