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

ADM_IND_PARTITIONS

ADM_IND_PARTITIONS displays information about all index partitions in the database (excluding global indexes on partitioned tables). Each index partition of a partitioned table in the database, if present, has a row of records in ADM_IND_PARTITIONS. By default, only the SYSADMIN can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schemas.

Table 1 ADM_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

Limit of the partition corresponding to the 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

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.
Parent topic: System Views