MY_TAB_PARTITIONS

MY_TAB_PARTITIONS displays all level-1 partitions accessible to the current user. 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 schema.

**Table 1** MY_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.
subpartition_count	bigint	Number of level-2 partitions.
high_value_length	integer	Length of the binding value expression in a partition.
composite	character varying(3)	Specifies whether the table is a level-2 partitioned table.
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	Number of rows in a partition.
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.
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.