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

PG_PARTITION

PG_PARTITION records all partitioned tables, table partitions, TOAST tables on table partitions, and index partitions in the database. Partitioned index information is not stored in the system catalog PG_PARTITION.

Table 1 PG_PARTITION columns

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified).

relname

name

Names of the partitioned tables, table partitions, TOAST tables on table partitions, and index partitions

parttype

"char"

Object type
  • r: partitioned table
  • p: table partition
  • s: table subpartition
  • x: index partition
  • t: TOAST table

parentid

oid

OID of the partitioned table in PG_CLASS when the object is a partitioned table or table partition

OID of the partitioned index when the object is an index partition

rangenum

integer

Reserved

intervalnum

integer

Reserved

partstrategy

"char"

Partition policy of the partitioned table
  • r: range partition
  • v: numeric partition
  • i: interval partition
  • l: list partition
  • h: hash partition
  • n: invalid partition

relfilenode

oid

Physical storage locations of the table partition, index partition, and TOAST table on the table partition

reltablespace

oid

OID of the tablespace containing the table partition, index partition, and TOAST table on the table partition

relpages

double precision

Statistics: numbers of data pages of the table partition and index partition

reltuples

double precision

Statistics: numbers of tuples of the table partition and index partition

relallvisible

integer

Statistics: number of visible data pages of the table partition and index partition

reltoastrelid

oid

OID of the TOAST table corresponding to the table partition

reltoastidxid

oid

OID of the TOAST table index corresponding to the table partition

indextblid

oid

OID of the table partition corresponding to the index partition

indisusable

boolean

Whether the index partition is available

reldeltarelid

oid

OID of a Delta table

reldeltaidx

oid

OID of the index for a Delta table

relcudescrelid

oid

OID of a CU description table

relcudescidx

oid

OID of the index for a CU description table

relfrozenxid

xid32

Frozen transaction ID

To ensure forward compatibility, this column is reserved. The relfrozenxid64 column is added to record the information.

intspnum

integer

Number of tablespaces that the interval partition belongs to

partkey

int2vector

Column number of the partition key

intervaltablespace

oidvector

Tablespace that the interval partition belongs to. Interval partitions fall in the tablespaces in the round-robin manner.

interval

text[]

Interval value of the interval partition

boundaries

text[]

Upper boundary of the range partition and interval partition

transit

text[]

Transit of the interval partition

reloptions

text[]

Storage property of a partition used for collecting online scale-out information. Same as pg_class.reloptions, it is expressed in a string in the format of keyword=value.

relfrozenxid64

xid

Frozen transaction ID

relminmxid

xid

Frozen multi-transaction ID