Updated on 2023-10-23 GMT+08:00

MY_IND_PARTITIONS

MY_IND_PARTITIONS displays the partition information of indexes (excluding global indexes of partitioned tables) accessible to the current user. This view exists in the PG_CATALOG and SYS schemas.

Table 1 MY_IND_PARTITIONS columns

Name

Type

Description

index_owner

character varying(64)

Owner name of the partitioned table index to which an index partition belongs

index_name

character varying(64)

Index name of the partitioned table index to which an index partition belongs

partition_name

character varying(64)

Name of an index partition

def_tablespace_name

name

Tablespace name of an index partition

high_value

text

Limit of the partition corresponding to an index partition

NOTE:
  • 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

Whether an index partition is available

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

schema

character varying(64)

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

high_value_length

integer

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