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 PG_PARTITION system catalog.
Name |
Type |
Description |
||
---|---|---|---|---|
relname |
name |
Names of the partitioned tables, table partitions, TOAST tables on table partitions, and index partitions |
||
parttype |
"char" |
Object type
|
||
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 field. |
||
intervalnum |
integer |
Reserved field. |
||
partstrategy |
"char" |
Partition policy of the partitioned table. The following policies are supported: r indicates the range partition. v indicates the numeric partition. l: indicates the list 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, 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 a keyword=value string. |
||
relfrozenxid64 |
xid |
Frozen transaction ID |
||
boundexprs |
pg_node_tree |
Partition boundary expression.
The pg_node_tree data is not readable. You can use the expression pg_get_expr to translate the current column into readable information.
|
Example
Query the partition information of the partitioned table web_returns_p2.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 |
CREATE TABLE web_returns_p2 ( wr_returned_date_sk integer, wr_returned_time_sk integer, wr_item_sk integer NOT NULL, wr_refunded_customer_sk integer ) WITH (orientation = column) DISTRIBUTE BY HASH (wr_item_sk) PARTITION BY RANGE(wr_returned_date_sk) ( PARTITION p2016 START(20161231) END(20191231) EVERY(10000), PARTITION p0 END(maxvalue) ); SELECT oid FROM pg_class WHERE relname ='web_returns_p2'; oid ------- 97628 SELECT relname,parttype,parentid,boundaries FROM pg_partition WHERE parentid = '97628'; relname | parttype | parentid | boundaries ----------------+----------+----------+------------ web_returns_p2 | r | 97628 | p2016_0 | p | 97628 | {20161231} p2016_1 | p | 97628 | {20171231} p2016_2 | p | 97628 | {20181231} p2016_3 | p | 97628 | {20191231} p0 | p | 97628 | {NULL} (6 rows) |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot