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

MY_IND_PARTITIONS

MY_IND_PARTITIONS displays the partition information about local indexes of level-1 partitioned table accessible to the current user (excluding global indexes of partitioned tables). It is accessible to all users. This view exists in both PG_CATALOG and SYS schema.

Table 1 MY_IND_PARTITIONS columns

Name

Type

Description

index_owner

character varying(64)

Name of the owner of the partitioned table index to which an index partition belongs.

index_name

character varying(64)

Name of the partitioned table index to which the index partition belongs.

partition_name

character varying(64)

Name of the index partition.

def_tablespace_name

name

Tablespace name of the index partition.

high_value

text
Upper limit of the partition corresponding to the index 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.

index_partition_usable

Boolean

Specifies whether the index partition is available.

  • t (true): yes.
  • f (false): no.

schema

character varying(64)

Schema of the partitioned table index to which the index partition belongs.

high_value_length

integer

Character length of the limit of the partition corresponding to an index partition.

composite

character varying(3)

Specifies whether the index is a local index on the level-2 partitioned table. This table does not store level-2 partition information. Therefore, the value is NO.

subpartition_count

numeric

Number of level-2 partitions in a partition. This table does not store level-2 partition information. Therefore, the value is 0.

partition_position

numeric

Position of an index partition in the index.

status

character varying(8)

Specifies whether the index partition is available.

tablespace_name

name

Name of the tablespace that contains the partition.

pct_free

numeric

Percentage of minimum available space in a block.

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 an index are logged.

compression

character varying(13)

Specifies whether an index compression is enabled for a partitioned index.

blevel

numeric

Not supported. Its value is NULL.

leaf_blocks

numeric

Not supported. Its value is NULL.

distinct_keys

numeric

Not supported. Its value is NULL.

avg_leaf_blocks_per_key

numeric

Not supported. Its value is NULL.

avg_data_blocks_per_key

numeric

Not supported. Its value is NULL.

clustering_factor

numeric

Sequence of a row in the table based on the value of the index. You need to run the analyze command to collect statistics.

num_rows

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. Database restart is not supported. Otherwise, data loss will occur.

buffer_pool

character varying(7)

Actual buffer pool of a partition.

flash_cache

character varying(7)

Not supported. Its value is NULL.

cell_flash_cache

character varying(7)

Not supported. Its value is NULL.

user_stats

character varying(3)

Not supported. Its value is NULL.

pct_direct_access

numeric

Not supported. Its value is NULL.

global_stats

character varying(3)

Not supported. Its value is NULL.

domidx_opstatus

character varying(6)

Not supported. Its value is NULL.

parameters

character varying(1000)

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(3)

Specifies whether an index partition segment has been created.

orphaned_entries

character varying(3)

Not supported. Its value is NULL.
Parent topic: System Views